Single source AP transaction integration error

(0) Share

Report

Posted on by AwalshGA

389

I'm using a single text source AP transaction integration using Integration Manager the standard adapter (not eConnect). Since my source file only has the debit (expense) amount and account, I set the distribution source rule to 'Default Non-Imported' which should force the credit account. The integration runs but with the warning that the distributions do not balance.

I have confirmed there is a default AP account set up in the Posting Accounts Setup. I also added the same account to the default accounts for the vendors in the source data. Any ideas on what else I should check? I feel like it's right under my nose but there just don't seem to be any other moving parts. Relevant screenshots below. Thanks in advance for any assistance.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

agaber Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello-

Thank you for posting your question on the Forums. Do you have this account defaulted on the individual Vendor card(s)? If not, does adding that still generate the warning message?

Adam G.

Microsoft Dynamics GP

Was this reply helpful? Yes No
AwalshGA 389 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Adam, thanks for your response. Yes, the vendors have the AP account defaulted in addition to the overall Posting Setup. That's what makes this so maddening...seems like all the moving parts have been accounted for right? I welcome any other thoughts you may have. Thanks again!

Was this reply helpful? Yes No
Verified answer

Gerald Buenafe BTP 280 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Put a constant on the Distribution Type. Set it to PURCH

Was this reply helpful? Yes No
Suggested answer

AwalshGA 389 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked! Wow, such a small but important detail. Thank you Gerald! I hope to return the favor someday.

Was this reply helpful? Yes No
Gerald Buenafe BTP 280 on at

Like
a
(0)

Report
Copy link

Link copied!

you are welcome!

Was this reply helpful? Yes No
sandipdjadhav 18,335 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Gerald,

I have singe source AP Transaction which has Expense Account and I have Set PURCH in IM Distribution. Expected that IM will create difference of Amount as 'Accounts Payable' Entry. Am I missing something?

Please advice.

Thanks much

Sandip

Was this reply helpful? Yes No