Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[John Walter]

I am trying to import data from an expense program as journal entries into GP using Integration Manager.  The file only contains the debit (expense) side of the entry.  There may be one line or multiple lines per journal entry.  The credit side of the entry would always be the same account and the total of the debits, however that is not in the file.  Can I use a script or some other method to get the credit portion of the entry to populate with the integration?  Thank you.

John Walter

——————————
John Walter
Owner
Walter Consulting
Dubuque IA
——————————

[Jamie Evenson]

Hi John, 

Yes.  You absolutely can.  The below link has steps and screenshots.  I understand you are probably not integrating with AA but that doesn’t matter.  Step 33 shows you that if you only have one amount field, you can map both the debit and credit to the same field and but use the option for either positive or negative.  

https://support.microsoft.com/en-us/help/2687958/steps-to-set-up-a-gl-transaction-integration-with-analytical-accountin

Also, I have done integrations into AP or AR, for example, where there is only one amount field but the distributions require more work than just using the options listed in Step 33.  For these, I have had to use various scripts but it has allowed me to import the amounts and accounts, as needed for those situations.  

Depending on your specific needs, Integration Manager rules may suffice.  When they don’t, then using scripts can make it work for you. 

Good luck!

——————————
Jamie Evenson
CEO
Najaxa Software
Las Vegas, NV
——————————
——————————————-