Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

New GP Implement need to again post into GL ( Account Receivables & Payables )

(0) ShareShare
ReportReport
Posted on by

Hi All,
Actually i am implementing a new Dynamics GP now i have some confusion is that
1.) I have data of GL open including (General Ledger, Account Receivables & Account Payables ).
So i just want to know that is need to import our last closed year data and after import it necessary to post in our new system through GL.
2.) If i post then it reflect duplicates because of we have already GL data of AR & AP & GJ so please guide me how can i solve this problem.

3.) One more thing what about unapplied amount & paid amount , should be there or any other thing?

Please guide me for implement.

Regards,

M.Chi

*This post is locked for comments

  • RE: New GP Implement need to again post into GL ( Account Receivables & Payables )

    Mehtab & Sandip both are thanks for quick response, Now Sandip can you please confirm me one thing suppose i have post the AP & AR trx not to GL ok now suppose  i delete the batch from GL.

    Now my question is that suppose we want to drill back for particular transaction from the inquiry window / track particular transaction through journal number. then how can we do that ?

    Please help me out i very confused about that , to track our transaction in inquiry window.

    One more question please should i import only AR & AP unpaid / unapply  transaction or all transaction.

    Thanks !

    M.Chi

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: New GP Implement need to again post into GL ( Account Receivables & Payables )

    Hi Chi,

    1) When you enter opening Balance for your Accounts Receivables, Payable and Inventory - You want to update only subsidiary balance i.e. your Customers, Vendors or Inventory. 

    Before you post any opening balance from subsidiary module i.e. AP Transaction or AR please make sure you have marked Pot To General Ledger check mark in  Tools>Setup>Posting>Posting.  This way it will create Journal Entry in Journal General and you can safely delete it

    Deleting Journal entry is safe because already you have opening balance for your AR and AP & Inventory Account in your opening Trial Balance i.e. you General Ledger

     

     

    2) I will bring only Open Transactions which is fully paid will not consider.

     

    I hope this help you to understand.

    Thanks Much
    Sandip Jadhav

     

     

     

     

  • Mehtab Hassan Profile Picture
    Mehtab Hassan 80 on at
    RE: New GP Implement need to again post into GL ( Account Receivables & Payables )

    Hi Malee,

    you have 3 segments in one question.

    1-Opening of GL ,AP,AR

    2-Posting of Balances

    3-Unapplied and Paid amounts

    look the thing is

    1-i am supposing that your closing year is 31-DEC-2015 so you should have to take the balances as of 31-Dec-2015 and paste into JV and post it in 31dec2015

    and your GL balances should include(all the BS and PL account values)

    it will be your BBF for 1-jan-2016

    2-please read 1.

    3-and in implementing phase the best practice for subsidiary modules are to come up with vendor or customers Net balances,it will be in the form of invoice or credit memo for vendors or customers.

    i hope this answer will be beneficial for you.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans