Dynamics Community Forum Thread Details

Daily Invoice Batch Run - Date change error

Our invoice creation batch job somehow back dated invoices from August 16^th 2017 all the way to August 14^th 2017. Once we saw that this happened, we updated a test instance with a backup of PROD that was taken just before this job ran that evening to re-create it.

Unfortunately it doesn’t look like we were able to do so – it ran correctly in our TEST environment.

Here’s a few of the invoices that were generated the night of Aug 16^th 2017 in PROD, and below that is what we got in our TEST/re-creation attempt to show the error in processing and what should have happened.

NOTE : the invoice numbers are going to different – but the Sales order numbers are the same:

PROD – incorrect date: - here is what we’re seeing, the first screen is the batch job that converted the Delivered orders into Invoices – it ran Aug 16^th 2017 which should reflect on the Date of the invoices – but some reason they don’t.

Below is the result, you can see the Date on the Invoices don’t match when the Batch job was run:

TEST – correct date : - So as I stated above we decided to try and re-create it in a TEST instance, by restoring from a backup just before the invoice job ran – unfortunately it looks to have run correctly, as you can see below.

So this one we ran in the middle of day – hence the 12:37 on Aug 17^th 2017 – but notice how the Invoice Dates actually match up with the Batch job date: