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.

How to Query the Month or Date an Invoice was paid in full.

Posted By Bastian over 7 years ago

Hi,

Maybe anyone has a good approach for this...

I want to query the Sage 100 AR Tables to list me the Invoice with the month (or date) the Open Balance became "0" or went negative.

Thanks for your help!

Best,

Bastian

0 BigLouie over 7 years ago

The one table that has that is the Salesperson Commission table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Bastian over 7 years ago in reply to BigLouie

Thanks Louie! Are you referring to the PayDate field in that table? Will that field reflect when the invoice was paid in full?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BigLouie over 7 years ago in reply to Bastian

That will reflect the last paid date so if invoice balance is zero that is the date it went to zero
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

How to Query the Month or Date an Invoice was paid in full.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING