Is anyone well versed with the link properties for all tables within RMS. I would like to created a report that tells me payment amounts posted to transactions that were On Account. this is racking my brain!
Table Links
Apr 02, 2007
1 Replies
Well Chris, you have asked about whole entity relationship however for the below queries here are the tables and link
Payment Table Link
------------------------ Payment.CustomerID= Customer.ID Payment.CashierIDÊshier.ID TenderEntry.PaymentID=Payment.ID (The mode of payment link) AccountsRecievableHistory.AccountRecievableID¬countReceivable.ID (This tell you which receivable get clear or pending is) AccountReceivable.OriginalAmount (This tell you what was the due amount) AccountReceivable.Balance (Balance of Particular Transaction) AccountReceivableHistory.Amount (tell you what amount you received, if negative you received and clear the invoice, if postive mean nothing clear) AccountReceivableHistory.PaymentID = Payment.ID
Actual Transaction Link
-------------------------- AccountReceivable.TransactionNumber> Transaction.TransactionNumber AccountReceivable.CustomerID > Customer.ID
Chris, I will see that If I get any entity relati> Is anyone well versed with the link properties for all tables within RMS. I
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required