Did you know you can change Void dates on Payables transactions?


I often surprise people by telling them to change the void dates when they void Payables transactions in Dynamics GP. If you’re voiding something that was just entered, leaving the defaulted dates is usually fine. However, when you are voiding an old check because you’re going to re-issue it, you typically want to void using the same date as the re-issued check (or at least in the same month), so there is a zero net change for both the subledger and the General Ledger. And if the original dates are in a closed year, it is even more important to not change prior year numbers.

The problem is that the window where you enter the void is a bit counter-intuitive and does not make it look like you can change the dates. But you can! Both the Void Date (the subledger void date) and the Posting Date (the General Ledger void date) can be changed simply by clicking on the date in the grid and changing it.

void

Now you know – don’t forget to change the void dates as needed next time.

12 Responses to “Did you know you can change Void dates on Payables transactions?”

  1. In case this helps anyone the fields are PM30200.VOIDPDATE for the GL void posting date and PM30200.DINVPDOF (date invoice paid off) for the AP subledger void date.

    Liked by 1 person

  2. if we forgot to change this when voiding is there a way to fix it after the fact?

    Like

  3. So when you have to void a check that is never going to clear for a closed period you change the void date and the posting date to the open period. Then the invoice is left open. Do you then credit memo the invoice or can you void the invoice with the same type of dating and everything will stay in balance for the closed year and the current year?

    Like

    • Hi Julie,

      Yes, if you are not going to reissue the payment, then you can either void the original invoice with the same date(s) as you used to void the payment or enter a credit memo to apply to that invoice instead. Either method works. Credit memo is better if you want to change the account numbers that will be used.

      -Victoria

      Like

  4. Hey Victoria,
    Is there a way to change a posted date on an SOP that was entered in with the wrong date?

    Like

    • Hi Chase,

      Posted Date is the actual date something was posted. I am guessing you are asking about Posting Date, with is the GL date? The short answer is no, not after something has been posted. Once something is posted that date gets used to update a lot of various related tables, both details and summary. You cannot simply change the date afterwards, as all those other tables will now be incorrect.

      If you need to, you can enter adjustments/reversals, depending on the situation.

      -Victoria

      Like

  5. One of the features of this window which I have never understood is why the Void Date and Posting Date should ever differ from one another. This is one of those places where it seems too easy to create out-of-balance issues between subledger and GL by changing the Void Date without also changing the Posting Date.

    Like

    • Darren,

      In Dynamics GP every subledger transaction has a subledger date and a GL Posting date. It’s possible for them to be different, and sometimes desired for many reasons when using accrual accounting. For example, imagine you are entering a rent invoice dated 9/30, but it is for October rent. You can have the subledger date be 9/30 to accurately reflect the invoice date and the GL date be 10/1 to accurately reflect when the expense is incurred. This does not cause anything to be out-of-balance, since you can print the Payables aging report using either the GL date (to reconcile to the GL) or the subledger date (to see true aging).

      Similarly with voids. Let’s say you made a mistake on the rent invoice from my example above and are voiding it to then re-enter. You would want the Void Date to be 9/30 and the Void Posting Date to be 10/1 to mimic exactly what was on your original entry.

      Hope that helps explain it.
      -Victoria

      Like

Trackbacks/Pingbacks

  1. Did you know you can change Void dates on Payables transactions? | Victoria Yudin - Microsoft Dynamics GP Community - September 21, 2016

    […] Victoria Yudin asks Did you know you can change Void dates on Payables transactions?  […]

    Like

  2. Did you know you can change Void dates on Payables transactions? | Victoria Yudin - DynamicAccounting.net - Dynamics GP Users - DUG - September 21, 2016

    […] Victoria Yudin asks Did you know you can change Void dates on Payables transactions?  […]

    Like

  3. DynamicAccounting.net | Did you know you can change Void dates on Payables transactions? | Victoria YudinDid you know you can change Void dates on Payables transactions? | Victoria Yudin - DynamicAccounting.net - September 21, 2016

    […] Victoria Yudin asks Did you know you can change Void dates on Payables transactions?  […]

    Like

Leave a comment