Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Customizing the fields listed in Customer Maintenance/Inquiry Invoices Tab

Posted By GWendelin over 5 years ago

I would like to know how to add a custom field that is listed on our sales order entry screen to the Customer Maintenance/Customer Inquiry tab 6. Invoices screen as a column next to the Customer PO No. column. Is there an easy way to do this myself?

0 BigLouie over 5 years ago

Tab 6 reads the Open Invoice file so first you must map the field to the Open Invoice file and then you can add to the grid. This means you can only see the result after the sales order is invoiced
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago

If the custom field is not already flowing through the invoice into the AR_OpenInvoice table you'll have to set that up. Only then will you be able to use Customizer to add it to the grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 GWendelin over 5 years ago in reply to Kevin M

Hey Kevin, the screen shot above, where are you accessing this open invoice table?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 5 years ago in reply to GWendelin

When you go into Custom Office and access the Tab 6 panel and you want to add a field, that is the field selection box that comes up.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Customizing the fields listed in Customer Maintenance/Inquiry Invoices Tab

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING