Some body please help
Please help us..
Go to: Posting Setup (Tools-->Serup-->Posting-->Posing) window and check the Posting posting option as below.
If the option selected as "Post Through General Ledger Files", the reverse transaction for the voided payable transactions was created and automatically posted to GL. For this case you no need to create the reverse entry for voided transaction.
Hope this helps!!!
Somakarpagamoorthy K | MS Dynamics GP - Developer
Dear Mr Soma,
Thank you very much for your response. Your replay is very much helpful. But,
Only the last few voided a Differed Payables transaction not created a reverse entry in JV automatically. Many entries had are gone correctly And my "Post Through General Ledger Files" is unchecked for purchase>>Void Open Trx ! ,...Why it will be? And please give me a solution to rectify those entires.
Once again thanks for your response.
Waiting for your replay..
Was this document voided properly? Go to Inquiry-->Purchasing-->Transaction by Document and check whether the document status show "HIST* or not.
Your reply is much appreciated.
Thanks for your response.
The document status shows HIST* and if we open the document the status shows ‘VOID’ with voided date.
Is there any way to rectify those transactions? I tried reverse entry manually back out from JV correct menu.
But the Originating TRX type shows “Standard” instead of “reversing' .. Kindly advice
Thanks in advance
Waiting for your replay
Run the blow code in SQL against company DB to check whether any reverse entries was made in JV while voided the transactions.
SELECT *FROM GL20000 WHERE ORDOCNUM='ENTER VOIDED DOC NUMBER' AND SOURCDOC='PMVVR'
If these query returns any values, the reverse entry was made while voided the same.
Dear Soma ,
Thanks again for your nice replay...
That query not returns the same amount which we differed.
Please see below mention pictures in drill down order..
The above mentioned is one of the Voided Differed Invoice which is not created a Reverse entry in JV.
note..12 periods reverse JV created successfully for some other Voided Differed Purchasing invoice .
Please help me..
Is there any way to rectify those reverse entry from SQL tables?
Can you show the result returned by above sql code?
please find the above attached query result file.
The document was voided properly and JV also created correctly. Your document amount is 47843. But the above screen shot show the amount 95686 in distribution window. If you voided a transaction, the reverse distribution will create. So, after voided, the distribution window will show both original distribution amount 47843 as well as reverse distribution 47843. So, the total amount will show as 95686.
No need to create reverse entry for this document.
Thank you very much your response.It is appreciable .
But its but that particular differed transaction(see in old posted picture,amount KD216.792)amount not listed in smart list drill down view?
The below added picture shows the the smart list selection for one year differed voided transactions for that customer.
And the below added is the smart list view in excel..
The yellow colored field shows one of the correct voided deferred transaction (KD 177.375)details that we have done for another entry.There you can see the original and reverse entry of that differed translations done correctly.
But ,The red colored field shows the issues(KD216.792), the original entry and differed transaction details not reversed the same amount.?
Originating Master ID
Originating TRX Type
This is rare situation. Did any changes made in posting account setup in GP before voided the document?
no changes done in posting set up. But client said, the voiding time the GP was very slow and hang for more than 5 minute. Our clients are far from data servers.
It is much appreciable that ,if you can give a solution to rectify this .
Is there any way to solve the issue from SQL table its self?
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics