Skip to main content

Microsoft Dynamics GP 4 Tips and Tricks for Month End Closing

Having lost don't know whether you have completed all the task in Dynamics GP during month end closing? Follow the top 5 tricks below to counter check all your account is in order.

    1.     Has all the batches in Purchasing Module, Sales Module, Fixed Asset and last by not least, Financial Module posted? You may have a quick check using "Master Posting". This screen allows to post multiple batches from different modules.

 Path: MSDGP > Tools > Routines > Master Posting



   2.     Have you make sure all the sub-ledgers tally to GL control account? You can print out the Historical Aged Trial Balance from Purchasing or Sales to match against the GL control account in Financial Trial Balance. Alternatively, you may use the "Reconcile To GL" tools which available in Dynamics GP all version. Just enter the parameter and the modules that you are comparing, Dynamics GP will match the document automatically and generate the result in Excel. For more info on how to use it you may refer to my previous post regarding this topic:-

Looking where to print out Sales or Purchasing Aging Report? You may refer to the link below:-


   3.     Do you have documents transact in foreign currency? Don't forget to perform Multi-Currency Revaluation. Performing Multi-Currency Revaluation will revalue the outstanding transactions or Balance Sheet item with Current Rate (some they call Closing Rate) to get the Unrealised value. Read more at:-


   4.     Once the month end process is done, don't forget to lock the period from user accidentally posting transaction to closed month. You can prevent this by closing the period using "Fiscal Periods Setup". Once you’ve completed period-end procedures, you can prevent future posting to that period.

 Path: MSDGP > Tools > Setup > Company > Fiscal Period 


Do you have any question regarding Dynamics GP? Feel free to drop me an email, I will reply one of your question.

Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sal...
Post a Comment
Read more

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...
1 comment
Read more

Fixed Asset Retirement, Write-off, Disposal in Dynamics GP

User able to perform Fixed Asset Retirement, write-off or even disposal using "Retirement Maintenance". Path: Transaction > Fixed Assets > Retire 1.   Select the Asset that need to retire. 2.   The date of retire. 3.   Select "Like-Kind Exchange". The double entry for this will be Accounting entries for write-off:       Dr. Non-Recognized gain/loss (FA written-off)       Dr. Accumulated Depreciation                  Cr. Asset Cost User may select "Sale" in Retirement Type and "Disposal" in Retirement Code for disposal of asset. 4.   Select Retirement Code "WRITEOFF". If the code is not present, user can create it by going to Retirement Setup.  Path:  MSDGP > Tools > Setup > Fixed Assets > Retirement 5.  There are 3 ways how the asset can be retired. Quantity, Cost, or Percentage. In...
Post a Comment
Read more