Share
Report
220Hi all,
I’m building an integration for payable transactions (A/P). We get a file with AP transactions including GL accounts (distributions). The issue is that some vendors have payment terms setup in their cards. So, when the transaction is integrated, these terms generates a discount available amount. This amount needs to be included in the distributions. For example, my file will have an invoice for $100 and a distribution of CR $100 to 00-2000 account and a DR $100 to 00-6000 account. But due to payment terms, there will be a discount available of let’s say $2. Now the distributions should be DR $100 00-6000 and then the credit should be CR $98 to 00-2000 (“PAY” Distribution type) and CR $2 to 00-2600 (“AVAIL” Distribution type). Because I don’t know the payment terms ahead of time, Integration Manager generates a warning indicating that “This transaction will not post; it includes distributions with errors.”. I tried to use scripts to check for the discount available before document commit but was unsuccessful. Any thoughts on this?
*This post is locked for comments
All responses (
Answers (
