Question Status

Suggested Answer
Uma Loganathan asked a question on 2 Mar 2015 1:40 PM

Hi,

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

Regards,

Uma.

Reply
Mahmoud M. AlSaadi responded on 2 Mar 2015 1:49 PM

Hello again Loganathan

Would you please provide further details ?

Your feedback is highly appreciated,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
BABU BASKARAN responded on 2 Mar 2015 3:33 PM

Uma,

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.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Uma Loganathan responded on 2 Mar 2015 10:15 PM

Hi Mahmoud,

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.

Regards,

Uma.

 

Reply
Uma Loganathan responded on 2 Mar 2015 10:17 PM

Hi Babu,

I have found the difference between PM and GL. Please check my reply above.

Thanks for your response.

Regards,

Uma

Reply
Uma Loganathan responded on 4 Mar 2015 12:18 AM

Hi Mahmoud,

I would appreciate that if you could provide me the solution for this issue?

Thanks,

Uma.

Reply
BABU BASKARAN responded on 4 Mar 2015 3:27 AM

Uma,

Is the receipt and invoice done on different period or same period.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Uma Loganathan responded on 4 Mar 2015 3:54 AM

Hi Babu,

The RCT type is "Shipment/Invoice".  And the date of RCT and GL TRX is same.

Regards,

Uma.

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 4 Mar 2015 9:04 AM

Hello again Loganathan

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Uma Loganathan responded on 5 Mar 2015 4:45 AM

Hi Mahmoud,

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?

Regards,

Uma Loganath.

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 5 Mar 2015 4:52 AM

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Uma Loganathan responded on 5 Mar 2015 6:55 AM

Hi Mahmoud,

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.

Regards,

Uma Loganath.

Reply
Mahmoud M. AlSaadi responded on 5 Mar 2015 7:00 AM

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
BABU BASKARAN responded on 2 Mar 2015 3:33 PM

Uma,

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.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 4 Mar 2015 9:04 AM

Hello again Loganathan

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 5 Mar 2015 4:52 AM

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply