AP Vendor report with yearly opening balance.

Question

AP Vendor report with yearly opening balance.

ZABARVAN (IS/IT--Management)

(OP)

9 Jul 18 09:07

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 (Programmer) · Answer 1 · 2018-07-09 12:04:16

RE: AP Vendor report with yearly opening balance.

Jay Converse (Programmer) 9 Jul 18 12:04

APVSM

Sage 300 Whisperer

ZABARVAN (IS/IT--Management) · Answer 2 · 2018-07-09 13:06:19

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

ettienne (TechnicalUser) · Answer 3 · 2018-07-09 13:07:57

RE: AP Vendor report with yearly opening balance.

ettienne (TechnicalUser) 9 Jul 18 13:07

APVEN

Sage 300 Certified Consultant

Jay Converse (Programmer) · Answer 4 · 2018-07-09 13:08:02

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 (Programmer) · Answer 5 · 2018-07-09 13:20:04

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 (IS/IT--Management) · Answer 6 · 2018-07-09 13:39:06

RE: AP Vendor report with yearly opening balance.

ZABARVAN (IS/IT--Management)

(OP)

9 Jul 18 13:39

Thank you all

Come Join Us!

Posting Guidelines

AP Vendor report with yearly opening balance.