Agvance ID Cheat Sheet

The following lists out the requirements/restrictions regarding IDs in Agvance.

ID

Max. Length

Notes

Example

Applicator
6
SJ1 (Steve Johnson)
Container
60
Container12345
Customer
6Cannot be updated once saved
Can be set up to auto number with optional leading zeros
SmiJoe (Joe Smith)
000100
Farm
8Same ID may be used for multiple customers. Single customer’s farms must all be unique
HomeFarm
Field
8Single Growers must have unique Field names. Names can be reused between Growers.
North40
GL Account
10
1100-01
(01 indicates Location)
Inventory Department
6
1Dry, 2Dry, 3Dry

(Numbers indicate Location)
Item Group
6
EastDD
Location
6Cannot be updated once saved
Main00
Payment Term
15
2/10 n30
Product
10Must be unique within the DepartmentFeed00
(00 indicates Location)
Profit Center
4
01, 02, 03, etc.
Salesperson
15
JonSar (Sarah Jones)
User
3
JS (James Smith)
Vehicle
10
Case700
Vendor
10Most characters allowed except apostrophe and spaceABCSeed