Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AP Vendor report with yearly opening balance.

Status
Not open for further replies.
ZABARVAN

ZABARVAN

IS-IT--Management
Joined
May 24, 2003
Messages
186
Location
SA

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
 
Sort by date Sort by votes

Does any field contain total outstanding balance.... or we have to sum these fields.....
 
Upvote 0 Downvote
APVEN

Sage 300 Certified Consultant
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Thank you all
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Microiz
  • Locked
  • Question Question
web screen report
Replies
0
Views
274
Microiz
Microiz
Microiz
  • Locked
  • Question Question
user activity report
Replies
1
Views
489
NKOS13
NKOS13
vbdbcoder
  • Locked
  • Question Question
Can VB6 screen with OCX look like Sage 300 native screen with color theme and flat text box ?
Replies
3
Views
989
vbdbcoder
vbdbcoder
vbdbcoder
  • Locked
  • Question Question
Is there a good way to complete an order line with qty backordered?
Replies
2
Views
781
vbdbcoder
vbdbcoder
Raphyy
  • Locked
  • Question Question
Sage 300 2019 Error Printing Completed PO with popor01.rpt file
Replies
1
Views
811
ettienne
ettienne

Part and Inventory Search

Sponsor

Back
Top