A/P Vendor auto-numbering
BUSINESS REQUIREMENT
A company wants to auto-number A/P Vendors in Sage 300.
KEY LEARNINGS
Module includes a View script attached to A/P Vendor View (AP0015).
It also includes a UI subclassed script to default the value to ***NEW*** when no vendor is selected.
Custom tables to store the configuration parameters (prefix, next number and length)
Use a module for ease of deployment.
Requirement! The sample module is available for Sage 300 business partners to download on the Orchid website.
EXTENDER KEY STEPS
Install the latest product update for Extender.
In Extender Setup > Modules, import the downloaded file.
Restart the Sage desktop.
You can view the script in Extender Setup > Scripts
APVEND.AUTONUMBER.AP1200 = UI script
APVEND.AUTONUMBER.APVendor = View script saving the number
VARIATIONS
- Auto-number by Vendor Group - Change the configuration table to use Vendor Group field as the primary key
- Auto-number other records not auto-numbered in Sage 300 (A/R Customers / Multiple contacts)
- Enhance auto-numbering of documents (e.g. auto-number orders based on user entering transactions, or customer group)
TESTING THE MODULE
Configure auto-numbering rule
Use Extender Setup > Custom Table to enter the configuration record
Restart the Sage desktop
In A/P Vendor, the Vendor number defaults to ***NEW***
When you Add the record, the number is generated and the next number is updated.
