Distribution Account and Integration Manager

(0) Share

Report

Posted on by painterisaac

3,015

I3660.debit.PNG"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/32/6708.warning.PNG" border="0" />

This is what the distribution accounts looks like after the integration:

This is what it looks like without the integration by default:

As you can see, the credit field is eliminated upon integration. I need both the default credit and the integrated debit distribution accounts. It will not post without unless both are there. How can I fix this? Below is how I currently have my integration setup:

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you paste in a few sample records?

Was this reply helpful? Yes No
painterisaac 3,015 on at

Like (0)

Report
Copy link

Link copied!

Could you please be specific as to what records you are referring too? I would assume that what I have posted are records. Thanks!

Was this reply helpful? Yes No
Suggested answer

Bron 4 on at

Like (0)

Report
Copy link

Link copied!

Every time I had this situation I ended up adding the credit account to the source file. My integrations always had a header file and a detail file. I think if you look at existing IM samples for payable transactions you'll find an example. The way your currently mapped - i don't see how IM would know that the account mapped is the debit account or the credit account?

In detail file you would have 2 rows for each transaction...........

Was this reply helpful? Yes No
painterisaac 3,015 on at

Like (0)

Report
Copy link

Link copied!

Yeah I have seen some examples and I am not understanding the purpose of the header file and the detail file. That might be part of the problem. Sorry, this all was just barely introduced to me.

By 2 rows for each transaction do you mean1 row for the debit and 1 row for the credit? If that is the case I am not sure how to map the distribution when there is only one spot for the distribution.

Thanks for your help so far!

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would like to see what you input file looks like. In your IM folder you will find a subfolder called samples and then a PMTRX.TXT file. If you follow that structure and your GL account in the file is your distribution account it will then default the accounts payable account. This a single AP file import. You will need to change the options on the distributions to be record source as below:

Was this reply helpful? Yes No
painterisaac 3,015 on at

Like (0)

Report
Copy link

Link copied!

B1172.reco.PNG"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/32/4466.Capture.PNG" border="0" />

Also, I don't have the option to use what you have specified as a source after selecting "use source recording". It only gives me the option of Query 6 (the name of my add source). See screenshot:

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

The name of the source is whatever you are using. Apparently in your case it is Query 6. Are you lookng at the sample PMTRX integration that comes with IM? If the two input files are structured the same then just model your integration after that one.

Was this reply helpful? Yes No
painterisaac 3,015 on at

Like (0)

Report
Copy link

Link copied!

To be honest, that sample document is so messy that I can't tell what is going on. I don't even see a distribution account. In any case, It doesn't make sense that reformatting the source document will change anything. It has to be a mapping setting that I am not aware of.

Perhaps, I should reword my concern/question to make it simple.

HOW DO I POST TO MORE THAN ONE DISTRIBUTION ACCOUNT?

Was this reply helpful? Yes No
Verified answer

painterisaac 3,015 on at

Like (0)

Report
Copy link

Link copied!

Well I figured it out. This guy here does a great explanation.

Was this reply helpful? Yes No