Skip to Content
0
Former Member
Jun 10, 2009 at 07:40 AM

How to calculate AP invoice and AP downpayment AR Credit Memo together?

24 Views

Dear All,

Does anyone know how to calculate AP invoice and AP downpayment AR Credit Memo together for the purchase summary, by using SQL statement?

Is it sum altogether...like AP_Invoice + AP downpayment - AP Credit Memo?

The result as shown below:

BP_Code Total

XXXXXXXX $10,000

From Samson

Edited by: samson leung on Jun 10, 2009 9:49 AM