Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Create a distribution/...

Create a distribution/account code

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi everyone,

I have a question that I am really unsure of. Is there any way to set up a table in Dynamics GP where you create Distributions codes. These distribution codes would be used to define what specific accounts would be debited and credited when they are selected.

We are trying to integrate with another program that uses distribution codes. I have encouraged them to just import the accounts, but this has quickly become complicated. Is there any way to set up these distribution codes in GP, so that when they are imported these transactions will point to the correct account?

Please help! Even a "I don't think this is possible and this is why" would be very helpful.

Thanks!

RM82

*This post is locked for comments

All responses (1)

Answers (0)

Mariano Gomez 26,225 on at

Like (0)

Report

RE: Create a distribution/account code

There's a simple way to do this. If you build the integration with Integration Manager, you can use the Translation table available with the Accounts collection for the specific Destination Adapter. You can then create a mapping between distribution codes in the source query to accounts in Microsoft Dynamics GP.

Your second option is to use the Account Alias field in the Account Maintenance window in Dynamics GP to capture the distribution code for each account then use a tool like SmartConnect to do a lookup on the Account Alias to get the corresponding account number. Note that you can do this with ADO and VBScript in Integration Manager as well.