Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optional Tables
- Thread starter ZABARVAN
- Start date
Yes but your question is too broad, can you narrow it down?
Here is an example of what you can do: you can add an optional field to AR customers to track say a tier and have GOLD, SILVER and BRONZE.
In AR customers you can then assign these tiers. The Customer table is ARCUSTOMER, the optional fields are stored in ARCUSTOMERO - note the O appended to the table name. This applies to all tables: ICITEMO, APVENDO, OEINVHO, etc.
Sage 300 ERP Certified Consultant
Here is an example of what you can do: you can add an optional field to AR customers to track say a tier and have GOLD, SILVER and BRONZE.
In AR customers you can then assign these tiers. The Customer table is ARCUSTOMER, the optional fields are stored in ARCUSTOMERO - note the O appended to the table name. This applies to all tables: ICITEMO, APVENDO, OEINVHO, etc.
Sage 300 ERP Certified Consultant
Sorry for the typo above, the AR customer table is ARCUS & ARCUSO
Lack of caffeine....
Sage 300 ERP Certified Consultant
Lack of caffeine....
Sage 300 ERP Certified Consultant
- Status
Similar threads
