316
Hi All,
I have another functional question.
I'm asking where can i find the Open vendor credits? (name of table, form).
Example: vendor giving money back, in case of damaged products.
And if it's related to Open Vendor Invoices or not ?
Thanks in advance
*This post is locked for comments
The difference is the status of the invoices.
VendTrans would show *all* transactions, even those that have been paid/fully settled and have a balance of 0.
VendTransOpen only shows open transactions that have a balance remaining and have not been fully settled.
Yes, that is correct.
I would expect the same posting profile to be used for both credits and debits, it wouldn't have to be different.
You can use the RefRecID from VendTransOpen and link to the OffsetRecID in VendTrans to get additional detail on the credit transactions (E.g. invoice number, voucher etc.)
Hi Taran,
Thank for your answer, yes i need only credit for Open Invoices.
can your correct to me if i'm wrong please > so in this case to get credit for only Open invoice, i need also to check "AmountCur" in VendTransOpen if it's negative ? if your answer is YES
What about the posting profile ledger account used in case of credits, it's must be different ?
Hi Adnane,
To add to Crispin, it also depends if you want open vendor invoices which have a credit value or credit lines on purchase orders.
For open invoices, you could use VendTransOpen.
For open PO lines, you could use PurchLine.
Look for records with a negative AmountCur in VendTrans table. This will tell you all that is returned form the Vendor.
You can make a very simple query on it, and use in a View/Form.
for relation with invoice, I am sure it works in the other direction.. Because the same table VendTrans has the field "Invoice", which is filled for each Vendor invoice.
But I am not positive if it is set for (all cases of) Returns as well..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (