Skip to main content

Posts

Showing posts from November, 2018

Dynamics GP Fixed Asset Mass Change - Account Code

You can change the account code that assigned in Fixed Asset Account Group in bulk using "Mass Change".    1. Select Assets that need to change         Path: Transaction > Fixed Assets > Select Assets    2. Name the Group    3. Select the new group that created in “Current Group”, then select the asset ID which need to include in the group. Then select “OK” to save the setting for the group.    4. Go to Fixed Asset Mass Change.         Path: Transaction > Fixed Assets > Mass Change               i. Select the “Account” Tab               ii. Enter the Asset Group ID which just created               iii. Select the type account that need to change, and enter the new account code iv.           Select OK to proceed  v.       ...

GP How to Reconcile Payable/ Receivable Ledger to General Ledger Control Account using "Reconcile to GL"

The “Reconcile to GL” tool helps you find differences between Payables Management (and GL) and Receivables Management (and GL) automatically by coming out a report. The Rule of Thumb, GL balance for the AP Control Account should match up with the total on the Payable Ledger report and the GL balance for the AR Control Account should match the total on the Receivables Ledger report.  "Reconcile to GL" will match each transaction between GL and Sub-ledger based on the setup account and posting date.  Any transactions that don’t match and users have to start digging through detailed transactions to see what went wrong, “Reconcile to GL” can be helpful in this scenario. To perform Payable/Receivable Reconciliation Path: Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL     1.       Type in your date range.     2.       Select “Module”, either Payable Management or Receivable Management. ...

Amount is different when reconcile to General Ledger to Payable or to Receivable

I have come to many reported case where clients not able to find their transactions in GL although they have posted and the sub-ledger has been updated with the record (AP/AR Aging, Bank Recon). Below shows the TOP MOST possible reason for this problem to happen, yes, TOP MOST, which is due to the the transaction posted to Payable or Receivable, but it is not posted to General Ledger. Try check to the batch in Financial Module, you will notice the batch is still sitting in the batch. From the prefix of the batch ID, you would be able to know the source of the transaction. Or you may refer below for the definition of the most common transaction source in Microsoft Dynamics GP.   Source Document Description    CMTRX                Bank Transactions    CMXFR                Bank Transfer    CRJ                     Cash Rece...

Changing Purchase Order Details after partial receiving

User may allow to change the Purchase Order detail provided the item has not been received or there are still outstanding to the PO. This can be done on "Purchase Order Entry" screen. Path: Transaction > Purchasing > Purchase Order    a.     Changing Unit Cost/Quantity To change the unit cost or quantity from the existing PO, user just need to enter the new unit cost or quantity field. Click "Save" to apply the changes to the PO.    b.     Changing Tax Code User may also change the existing tax code assuming the tax code that being assigned is wrong. Just proceed to the Purchasing Item Detail Entry screen and change the tax code. Take note that this might impact the Tax Amount which causing the PO value to be affected as well.    c.     Cancelling or Reducing Quantity Ordered Enter the quantity that need to cancel or reduce in the "Quantity Canceled" field. During receiving, the quantity remaining to receiv...