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

Announcements

No record found.

News and Announcements icon
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,631 Moderator 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans