| Line 28: | Line 28: | ||
==Reporting== | ==Reporting== | ||
1. As long the reports parameter has '''Project''', '''Agent''', '''Area''', or '''Location''' | 1. As long the reports parameter has '''Project''', '''Agent''', '''Area''', or '''Location''', the reports able to lock based on user login. For instances:- | ||
::* Customer Aging | ::* Customer Aging (Agent, Area, Project) | ||
::* Sales/Purchase Document Listing | ::* Sales/Purchase Document Listing (Agent, Area, Doc Project) | ||
::* Stock Card | ::* Outstanding Sales/Purchase Document Listing (Agent, Area, Doc Project, Item Project, Location) | ||
::* Stock Card (Location) | |||
::* etc... | ::* etc... | ||
<br /> | <br /> | ||
Revision as of 01:14, 7 November 2015
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: 4Linear Weight (Kg/M) value
Reporting
1. As long the reports 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