Skip to main content

Posts

Showing posts with the label Amount is different when reconcile to General Ledger to Payable

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...