Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Need to Default Purcha...

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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

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

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!