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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Vendor Transaction Imp...
Microsoft Dynamics GP (Archived)

Vendor Transaction Import Integration Manager

(0) ShareShare
ReportReport
Posted on by NGilbert 850

Hello All,

What is the best practice for importing vendor transactions (preferably using integration manager) if the GL balance already includes the payable transactions.

I plan on using the Post To option, and then deleting the GL batch, BUT what about all of the cash management records that are created in each respective checkbook?

Any help is appreciated!

Thanks,

Nathan

*This post is locked for comments

I have the same question (0)
  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Vendor Transaction Import Integration Manager

    Hi Nathan.

    2 options available to you.

    With integration manager you can specify that the posting account for the AP Liabilty and the AP Expense are the same so they will DR and CR the same account having a zero effect on the account balance.

    Another option is to have a secondary AP account in your GL for the subledger - so the integration manager entry would be CR (AP Liability) to the new subledger account and DR (AP Expense) to the Regular AP account. IF all balances the AP account should be zero and the subledger account have the proper balance for verification purposes to the subledger.

    When payments are made it should reduce the new AP subledger Account (To validate on you Vendor Card or Posting Accounts setup)

    Hope this helps

  • NGilbert Profile Picture
    NGilbert 850 on at
    Re: Re: Vendor Transaction Import Integration Manager

    Thanks for the quick reply!

    Can I use the first option (crediting and debiting the same account) for an invoice that has already been paid?  I simply want to import the CY vendor transactions, without affecting the checkbooks, but this seems impossible considering most of the invoices are already paid.

    Thanks again!

    Nathan

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Vendor Transaction Import Integration Manager

    Importing paid transactions has other implications.  You must import the transactions themselves, import the payments, import or apply the payments to the transactions, then move everything to history.  The Apply records are in different tables but relate payments in the payables table to invoices in the same tables!  (Check out the relationship in our Information Flow and Posting manual)

    Why do you want to bring in paid transactions?  If this is an initial conversion, we usually recommend that the client maintain everything in their old system for reference for the next few months.

  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Re: Re: Vendor Transaction Import Integration Manager

    Yes you can use the first option.

    A little work around I have used to import historical data is to create a checkbook called OLD AP and the GL account for it is also the AP Account.

    When all the old invoices are entered I run a payment batch from this checkbook to clear the paid invoices.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans