Lock Report by User: Difference between revisions

Revision as of 01:29, 7 November 2015

Introduction

Updates

Last Customisation Update : 06 Nov 2015

Criterias

Maintain User

[Tools | Maintain User...]

1. Advanced Lock in Maintain User.

Types	Field Name	Data Types	Length	Usage
STD	Code	String	20	User ID, eg. LEE
STD	Name	String	100	User Name
DIY-F	Lock_Cust_Code	Boolean	False value: 0 True value: 1	To lock the customer code parameter in report
DIY-F	Cust_Code	String	10	Set a customer code to lock to this user
DIY-F	Agent_Lock	Boolean	False value: 0 True value: 1	To lock the agent parameter in report
DIY-F	Agent	String	10	Set an agent code to lock to this user
DIY-F	Location_Lock	Boolean	False value: 0 True value: 1	To lock the location parameter in report
DIY-F	Location	String	10	Set a location code to lock to this user

Reporting

1. As long the report parameter has Project, Agent, Area, or Location, the reports able to lock based on user login. For instances:-

Customer Aging (Agent, Area, Project)
Sales/Purchase Document Listing (Agent, Area, Doc Project)
Outstanding Sales/Purchase Document Listing (Agent, Area, Doc Project, Item Project, Location)
Stock Card (Location)
etc...

2. Insert and update the following DIY fields & Script into above mentions sales documents in Tools | DIY | SQL Control Center...
DIY Script: OnGridColumnValueChange event

@@ Line 10: / Line 10: @@
 ''[Tools | Maintain User...]''
-. User Advanced Lock.
+. Advanced Lock in Maintain User.
 ::{| class="wikitable"
 |-
 ! Types !! Field Name !! Data Types !! Length !! Usage
 |-
-| DIY-F || Code || String || 30 || Product Code, eg. EA 6035 (NA)
+| STD || Code || String || 20 || User ID, eg. LEE
 |-
-| STD ||Description || String || 200 || Product Name
+| STD || Name || String || 100 || User Name
 |-
-| STD || 2nd Description || String || 200 || Aluminium size to be display in sales tax invoice, eg. 38.10 x 1.80 thk
+| DIY-F || Lock_Cust_Code || Boolean || False value: 0 <br /> True value: 1 || To lock the customer code parameter in report
 |-
-| STD || Base UOM || String || 10 || stock unit of measurement, usually either enter as PCS or KG or Roll
+| DIY-F || Cust_Code || String || 10 || Set a customer code to lock to this user
 |-
-| DIY || Linear Weight (Kg/M) || Float || Size :10 <br /> SubSize: 4 || Linear Weight (Kg/M) value
+| DIY-F || Agent_Lock || Boolean || False value: 0 <br /> True value: 1 || To lock the agent parameter in report
+|-
+| DIY-F || Agent || String || 10 || Set an agent code to lock to this user
+|-
+| DIY-F || Location_Lock || Boolean || False value: 0 <br /> True value: 1 || To lock the location parameter in report
+|-
+| DIY-F || Location || String || 10 || Set a location code to lock to this user
 |}
 <br />