Lock Report by User

Updates

Last Customisation Update : 06 Nov 2015

Criterias

Maintain User

[Tools | Maintain User...]

1. User Advanced Lock.

Types	Field Name	Data Types	Length	Usage
DIY-F	Code	String	30	Product Code, eg. EA 6035 (NA)
STD	Description	String	200	Product Name
STD	2nd Description	String	200	Aluminium size to be display in sales tax invoice, eg. 38.10 x 1.80 thk
STD	Base UOM	String	10	stock unit of measurement, usually either enter as PCS or KG or Roll
DIY	Linear Weight (Kg/M)	Float	Size :10 SubSize: 4	Linear Weight (Kg/M) value

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

See also

• Others Customisation