AP Vendor report with yearly opening balance.

[ZABARVAN]

I need to print an AP Transaction report as following :- for example

Report from : 01/01/2018 to 31/12/2018

Supplier : ABC

Last Year Closing Balance : 2000/-

Date Doc. Type Doc. No. Debit Credit Balance
---------------------------------------------------------------------------
01/01/2018 IN 012345 1000.00 3000.00 (opening + IN)
03/01/2018 PY CHK 3 500.00 2500.00

can we get yearly opening from any Table & field.
Which table can I use
Appreciate your help.
Thank you

 

[Jay Converse]

APVSM

Sage 300 Whisperer

 

[ZABARVAN]

Does any field contain total outstanding balance.... or we have to sum these fields.....

 

[ettienne]

APVEN

Sage 300 Certified Consultant

 

[Jay Converse]

You have to do the math, sum from day 1 to the cutoff. And if you ever cleared history, you're screwed.

Sage 300 Whisperer

 

[aan09]

I usually use APOBL (AP Invoice History) and APOBP (AP Payment History) to make AP Aging report, maybe you can use them for your report.

 

[ZABARVAN]

Thank you all