Single source AP transaction integration error

(0) Share

Report

Posted on by AwalshGA

383

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

All responses (6)

Answers (1)

sandipdjadhav 18,297 on at

Like (0)

Report

RE: Single source AP transaction integration error

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
Gerald Buenafe BTP 280 on at

Like (0)

Report

RE: Single source AP transaction integration error

you are welcome!
Suggested answer

AwalshGA 383 on at

Like (0)

Report

RE: Single source AP transaction integration error

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

Gerald Buenafe BTP 280 on at

Like (0)

Report

RE: Single source AP transaction integration error

Hello,

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

Like (0)

Report

RE: Single source AP transaction integration error

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!
Suggested answer

agaber on at

Like (0)

Report

RE: Single source AP transaction integration error

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