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 Chriss Miller 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
Joined
May 24, 2003
Messages
186
Location
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
Got it ... Thanks a lot....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top