The posted purchase receipts subtotal are not matching with line items total (extdcost). So the PM and GL is not matching.
How to resolve this issue?.
Hello again Loganathan
Would you please provide further details ?
Your feedback is highly appreciated,
Mahmoud M. AlSaadi
Dynamics GP Essentials | mahmoudsaadi.blogspot.com
Are you saying your open payable total is not matching to your Payable GL. Have you checked whether you have posted all financial batch related to payable. You may check reconcile to GL under financial.
Microsoft Dynamics GP menu >> Tools >> Routines >> Financial >> Reconcile to GL
Use the Reconcile to GL window to generate a Microsoft Excel spreadsheet that can help you match transactions in General Ledger with the originating transactions in Payables Management and Receivables Management. The reconcile routine doesn’t change data automatically, even if unmatched transactions are identified.
Financial Systems Manager
Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.
User had created few PO receiving transactions (RCT) with 3.5 exchange rate and changed the exchange rate to 3.4913. But after posting those RCTs , the header level the total (subtotal) is showing with 3.5 rate and the line items total (extended cost) is showing with 3.4913. So, there is a difference in PM Historical Aged TB and GL.
Please find attached the screen shot for your reference.
Thanks for your support and how to fix this issue.
I have found the difference between PM and GL. Please check my reply above.
Thanks for your response.
I would appreciate that if you could provide me the solution for this issue?
Is the receipt and invoice done on different period or same period.
The RCT type is "Shipment/Invoice". And the date of RCT and GL TRX is same.
Regardless of the cause of the problem. How about correcting the GL based on the correct exchange rate ?
So you will have to record a corrective journal entry to either debit or credit the associated amount. Since it is only one transaction, I don't think it would be possible to consider a revaluation.
Let us know if you need any further assistance,
The exchange rate in GL entry is correct. And also the exchange rate in RCT line items are correct. But only the RCT subtotal has taken different exchange rate. This is due to network connectivity issue. So the correction entry has to be done in sub ledger not in GL.
It is not in one RCT, there are nearly about 25 RCTs are having same issue.
Currency revaluation has been done already. The above scenario is occurred after the currency revaluation.
Since PM HATB report is taking the subtotal amounts, there is still difference b/w PM & GL.
So I am planning to create a payable invoice in PM module.
AP payable Account will be credited and Exchange Gain/Loss will be debited.
Since GL balance is correct, then I will reverse the above journal in GL.
What is your suggestion?
Okay, that clear now
Since the sub Ledger needs to be corrected, posting a payable transaction as you mentioned is the best approach. Now to prevent this from posting to GL (instead of a doing a reversal entry on the GL), change the posting setup before posting the transactions
Go to Microsoft Dynamics GP > Tools > Setup > Posting > Posting
Choose the "Purchasing" series, and click on the "Payable Transaction Entry" origin.
Uncheck the Post through General Ledger.
Now after posting the payable transaction, the journal entry will be saved only in the GL, check it and delete it. This way you ensure that both modules balances are tied and correct.
Please feel free to close the case if it is settled, otherwise, never hesitate to share any further inquiries,
Anyhow I need to post the GL entry as the delete and void button in GL entry is disabled due to some security reason as it is customized.
Anyway, thanks for your suggestion and quick reply.
You can uncheck the "Post to GL", it will not create a journal entry.
Anyways, is this case closed ?
You may kindly close the case by verifying the proper answer.
Your feedback is highly appreciated,