Need to Default Purchases Amount in Integration Manager when there are multiple distribution lines

(0) Share

Report

Posted on by Community Member

The user needs to integrate credit memos with multiple distributions on the PURCH/Credit side. They do not have the document total in the source file so they want it to default in. However, nether the Purchases/Document Amount nor the AP distribution amount defaults in (We have the source rule set to default Non-imported and it works when only 1 credit distribution line is in the file).

How do they get the Purchases Amount to default in and how do they get the AP account and amount to default in?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

D'oh. Totally zoned on the fact that I should check the working Integration for scripts.

Before Integration:

SetVariable "PurchaseAmount", CCur(0.00)

Before Document Commit:

DestinationFields("Purchases") = _

GetVariable("PurchaseAmount")

SetVariable "PurchaseAmount", CCur(0.00)

On the Credit Distribution Field will be:

SetVariable "PurchaseAmount", _

CCur(GetVariable("PurchaseAmount")) + _

CCur(SourceFields("AP Credit Memo.Amount"))

CurrentField = SourceFields("AP Credit Memo.Amount")

Thanks!

Was this reply helpful? Yes No