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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Open AR and Open AP

(0) ShareShare
ReportReport
Posted on by 165

We are creating a new GP database and I will need to convert Open AR and Open AP from Sage.  Is there a best practice method on doing this?

Thanks,

Craig

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    Yes, using Integration Manager in GP, import all open AR & AP transactions.  You can either allow these transactions to post THROUGH the GL to build your AR and AP account balances, or post them TO the GL and create you AR and AP account balances via journal entry.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    This is actually part of every implementation. In each project, we request the opening balances on a specific formatted template including the open AR and AP. I mostly import them through excel-based macro generator to record Sales invoices/credit memos on customers as well as invoices and credit memos on vendors.

    The post through GL is unchecked on the RM, PM Setup level so that these transactions will not affect General Ledger. Once the trial balance is imported n the general ledger level, they should tie.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans