web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Using Integration Mgr ...
Microsoft Dynamics GP (Archived)

Using Integration Mgr for loading Unit Account Activity

(0) ShareShare
ReportReport
Posted on by Jim Strand 125
I'm trying to utilize IM to load and update unit account data, as I have 45 companies to load and maintain unit account information. I've read in the Dynamics training materials that I must write the distributions to either sales or purchasing series which are not regularly used. When trying to post to Sales Series I get hung up on the requirements for fields [Customer ID], [Batch ID], [type], [TypeID]. Is there a workaround for this? I only need to post data from fields [transaction date], [account], [amount]. Same kind of snag through the Purchasing Series with fields required which are not part of the unit account data I'm trying to load. Any tips would be appreciated. jim

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    We upload our Unit Account activity through the General ledger transactions IM destination.

  • Jim Strand Profile Picture
    Jim Strand 125 on at
    Thanks.  I tried this and I get an error on the batch ID?

    [DOC 1 ERROR: Batch '994' does not exist.]

    I assign a random batch ID to the other Journal Entry integrations I perfom and it integrates fine into the general Journal Destination.  Any thoughts?

     

     
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    In your IM definition you can configure to create batch if batch does not exist.

  • Jim Strand Profile Picture
    Jim Strand 125 on at

    Great reminder, thank you.  Now I have a new problem with posting a mixture of alpha and numeric values into the Unit  Accounts.  I'm trying to post all values into the Debit field but see why this cannot be done with Alpha values.  How/Can I post non numeric values into the unit accounts?  I may have to post a nee string for this one.  Thanks again.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Hi, I think this may be working as designed. Why do you need to post alpha characters to these currency fields? Kind regards, Leslie
  • Jim Strand Profile Picture
    Jim Strand 125 on at

    You're right Leslie, the problem is with my design.  I'm trying to determine how to design an integration where I can post alpha and numeric information.  I'd like to Integrate information in the unit accounts such as Financial Institution,Financing Terms, along with other info which I can pull into a quarterly FRX report.  Any tips would be greatly appreciated.  The current design is using the General Journal Destination, and the [debit] field as a recipient for the values I'm trying to post.  What Destination, and Field would be a good place to store this information in GP? 

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    I doubt if this will work, since unit accounts are for quantities, numeric value only I suppose.

    i am not even sure if you put such information into excel and link excel file into your frx reports.

    you may need other report writing tools.

     

  • L Vail Profile Picture
    L Vail 65,271 on at
    Sunbeam, have you considered using Analytical accounting or MDA?
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    Hi Les,

    yes I have tried, but I havent tried showing financing terms and financing institution into frx.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Boy, you've got me there Sunbeam.

    You have a couple of string fields you can import into, but I do not know of any way to pull that data into FRx in any meaningful way. If you have several fields per journal entry, Extender is an option for you. I do not know off-hand if you can import JE's simultaneously with importing matching Extender information.

    I apologize for the lame answer.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans