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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Offset Account in Inte...
Microsoft Dynamics GP (Archived)

Offset Account in Integration Manager

(0) ShareShare
ReportReport
Posted on by john.ellis 3,530

Hello:

I'm composing a simple journal entry import through Integration Manager.  The source file does not have the offsetting account for the credit side of the journal entry.

The following is the VB script that I composed for the mapping of the Account Number for the credit side:

If SourceFields("GL Detail.Account String") = "" Then CurrentField = "230-00-00-00" else CurrentField = SourceFields("GL Detail.Account String") end if

In the mapping for the Credit Amount, I have "Use Default", so that the credit for the journal entry will simply pull in the total of the debits.

The above script compiles successfully.  But, it is not working.  The offset account for the credit of 230-00-00-00 is not being brought in.

How do I configure Integration Manager to accomplish pulling in 230-00-00-00 as the offsetting account for the default Credit Amount?

Thank you!

John

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    Sounds like you have a single line source file and you'd like it to write both distribution lines off that single read.  You can use a single file but you would need to define it as a one to many in a relationship to itself and have two lines (or more) in that file for each JE, at least that's the easiest way to do this.

    Side note, have you looked at the Excel paste button on the GL Transaction Entry window?  We use that exclusively now for end user GL entries and it's much easier to manage for end users and admins.

    Paste button

    Pastes the description, account, debit, and credit information of a journal entry in the scrolling window. The information pasted can include alias information if you are using Analytical Accounting

    This button is not available after you select an existing journal entry or enter an account in the scrolling window for a new journal entry.

  • Suggested answer
    Jambor - MSFT Profile Picture
    Jambor - MSFT on at

    test

  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    I believe you don't need the dashes in your script.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans