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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AP Vendor Transaction History Table.... 1

Status
Not open for further replies.
ZABARVAN

ZABARVAN

IS-IT--Management
May 24, 2003
186
SA

Is there a single table holding all vendor transactions like invoices, debit notes, credit note, adjustments and payments. i need a report with

opening bal. (till date) debit credit Balance.

Appreciate your help.

 
Sort by date Sort by votes

Does it have all the debit entries (invoices, debit notes) and credit entries (payments & credit entries)
 
Upvote 0 Downvote
TXTTRXTYPE Integer 2 0 Document Type 9 EA 1
List Presentation with 6 items in the list:
1 - Invoice
2 - Debit Note
3 - Credit Note
4 - Interest
10 - Prepayment
11 - Payment


Sage 300 Whisperer
 
Upvote 0 Downvote
APOBL holds all transactions, I don't know why you can't see that.

Sage 300 Whisperer
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
Day End Error (POLINEZ table)
Replies
3
Views
501
vbdbcoder
vbdbcoder
hushman
  • Locked
  • Question
Order Entry Transaction not posted on Dayend
Replies
1
Views
136
DjangMan
DjangMan
mydcba
  • Locked
  • Question
open APPYM table with MS Access
Replies
4
Views
242
DjangMan
DjangMan
ravazz
  • Locked
  • Question
Sage300 2021 Webscreen AP lock batch
Replies
1
Views
163
DjangMan
DjangMan
johnny9864
  • Locked
  • Question
I have an issue in the .Net library AP Sage300 (Version 2019)
Replies
1
Views
86
DjangMan
DjangMan

Part and Inventory Search

Sponsor

Back
Top