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.

Get Invoice List for SalesOrder (Sage100 BOI)

Posted By Dmytro Oliinyk 6 months ago

Hi all!

Not following how to get list invoices for selected sales order. Was checking AR_InvoiceHistoryInquiry_bus - InvoiceNo is laways a part of the key... Same for SO_ARInvoiceHistoryLink_bus

Can't go with SO_InvoiceHeader because its already posted and moved to history inquiry. Probably need to use sales journal. But how to select data from it?

0 BigLouie 6 months ago

The table you want is the SO_InvoiceHistoryLink this will list the sales order and all invoices for that sales order.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 6 months ago

Invoice history header has an index for SO lookups.

Change the index and set the browse filter, then loop. (Remember to change the index back to the default when done).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Get Invoice List for SalesOrder (Sage100 BOI)

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING