Dynamic GP Defferral Payables Transaction Voiding

This question is answered
We recently voided a Payables transaction which contained a deferral entry. The original transaction hit the GL properly, however after voiding the transaction, the reversing entries did not hit the GL. We've voided similar deferral transactions in the past.Why its happening and How to rectify that entry? Please help me..
All Replies
  • 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!!!

    Best Regards,

    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.

    Best Regards,

    Somakarpagamoorthy K | MS Dynamics GP - Developer

  • Dear Mr.Soma

    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.

    Hope this helps!!!

    Best Regards,

    Somakarpagamoorthy K | MS Dynamics GP - Developer

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

    Thanks in advance

    Belraj

  • Can you show the result returned by above sql code?

    Best Regards,

    Somakarpagamoorthy K | MS Dynamics GP - Developer

  • 8741.query.txt

  • please find the above attached query result file.

  • Belraj,

    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.

    Hope this helps!!!

    Best Regards,

    Somakarpagamoorthy K | MS Dynamics GP - Developer

  • Dear Mr.Soma,

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

    Journal Entry

    Series

    TRX Date

    Account Number

    Credit Amount

    Debit Amount

    Originating Master ID

    Originating TRX Type

    38135

    Purchasing

    1/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38136

    Purchasing

    2/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38137

    Purchasing

    3/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38138

    Purchasing

    4/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38139

    Purchasing

    5/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38140

    Purchasing

    6/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38141

    Purchasing

    7/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38142

    Purchasing

    8/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38143

    Purchasing

    9/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38144

    Purchasing

    10/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38145

    Purchasing

    11/1/2014

    112209

    KD 0.000

    KD 216.792

    GUL002

    Reversing

    38146

    Purchasing

    12/1/2014

    112209

    KD 0.000

    KD 216.788

    GUL002

    Reversing

    38183

    Purchasing

    1/19/2014

    112209

    KD 0.000

    KD 258.500

    GUL002

    Reversing

    38184

    Purchasing

    1/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38185

    Purchasing

    2/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38186

    Purchasing

    3/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38187

    Purchasing

    4/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38188

    Purchasing

    5/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38189

    Purchasing

    6/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38190

    Purchasing

    7/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38191

    Purchasing

    8/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38192

    Purchasing

    9/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38193

    Purchasing

    10/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38194

    Purchasing

    11/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38195

    Purchasing

    12/1/2014

    112209

    KD 0.000

    KD 177.375

    GUL002

    Reversing

    38232

    Purchasing

    1/19/2014

    112209

    KD 0.000

    KD 211.500

    GUL002

    Reversing

    38447

    Purchasing

    1/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38448

    Purchasing

    2/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38449

    Purchasing

    3/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38450

    Purchasing

    4/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38451

    Purchasing

    5/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38452

    Purchasing

    6/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38453

    Purchasing

    7/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38454

    Purchasing

    8/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38455

    Purchasing

    9/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38456

    Purchasing

    10/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38457

    Purchasing

    11/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38458

    Purchasing

    12/1/2014

    112209

    KD 177.375

    KD 0.000

    GUL002

    Reversing

    38495

    Purchasing

    1/19/2014

    112209

    KD 258.500

    KD 0.000

    GUL002

    Reversing

    38496

    Purchasing

    1/19/2014

    112209

    KD 211.500

    KD 0.000

    GUL002

    Reversing

    38508

    Purchasing

    2/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38509

    Purchasing

    3/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38510

    Purchasing

    4/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38511

    Purchasing

    5/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38512

    Purchasing

    6/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38513

    Purchasing

    7/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38514

    Purchasing

    8/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38515

    Purchasing

    9/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38516

    Purchasing

    10/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38517

    Purchasing

    11/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38518

    Purchasing

    12/1/2014

    112209

    KD 0.000

    KD 236.500

    GUL002

    Reversing

    38552

    Purchasing

    1/19/2014

    112209

    KD 0.000

    KD 258.500

    GUL002

    Reversing

    38553

    Purchasing

    2/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38554

    Purchasing

    3/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38555

    Purchasing

    4/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38556

    Purchasing

    5/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38557

    Purchasing

    6/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38558

    Purchasing

    7/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38559

    Purchasing

    8/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38560

    Purchasing

    9/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38561

    Purchasing

    10/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38562

    Purchasing

    11/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38563

    Purchasing

    12/1/2014

    112209

    KD 0.000

    KD 193.500

    GUL002

    Reversing

    38597

    Purchasing

    1/19/2014

    112209

    KD 0.000

    KD 211.500

    GUL002

     

     

  • This is rare situation. Did any changes made in posting account setup in GP before voided the document?

    Best Regards,

    Somakarpagamoorthy K | MS Dynamics GP - Developer

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

    Thanks in advance

    Belraj