Lock Report by User

From eStream Software
Revision as of 01:15, 7 November 2015 by Csloo (talk | contribs) (→‎Reporting)

Introduction


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