Hi,

I would appreciate if anyone can give me an advice for the below scenario.

We had a situation whereby user had accidentally backdated the invoice date for a range of SO to March. Invoice should be posted in April. SO status are already at deleting line. Besides doing a credit note, is there an alternate way of doing this. If there is, what are the details & impact of doing so.

Btw, this is for B4c4

...We had a situation whereby user had accidentally backdated the invoice date for a range of SO to March. Invoice should be posted in April. SO status are already at deleting line. Besides doing a credit note, is there an alternate way of doing this...
Firstly, How many are you talking about. If the number is not very large is raising credit note very difficult? Depending on the order type it may be possible to use the copy function when entering the credit order.

Secondly have the invoices actually been raised? It is the date of invoice rather tha nthe date of the order / delivery that determines the invoice date.

If Invcoices have been raised have they been posted to finance ?

Please post the order steps so that we can be more specific with suggestions.

Terry

Hi Terry,

Please refer to answer below:

Firstly, How many are you talking about. If the number is not very large is raising credit note very difficult? Depending on the order type it may be possible to use the copy function when entering the credit order.
>> There are about more than 20 invoices. User find it pain to raise credit note, and re-create the SO. Yes, they can copy back to the old SO to save the time.
Secondly have the invoices actually been raised? It is the date of invoice rather tha nthe date of the order / delivery that determines the invoice date.
>> Yes, invoice has been raised.
If Invcoices have been raised have they been posted to finance ?
>> Not yet posted in finance.

The order steps used are:
1) Print Order Ack
2) Print Picking List
3) Maintain delivery
4) Print delivery Order
5) Print Sales Invoices
6) PDSO

Sorry, I can't give you an easy fix. Had the last step not been run (process delivered sales orders) then it would have been fairly easy to change the invoice date in table tdsls045 and the financial transactions would have been posted correctly.

20 credit notes and reinvoice is not a lot of work (1/2 hour) and to my mind is the correct prcess. If you were to correct this error batch I think you would spend the rest of your career correcting (careless) mistakes.

Terry

Thanks Terry for the time taken looking into this.

Customer finally give us a peace of mind. They have agreed to go with the credit note..phew

Hi,
If you have not posted the invoices... just change the period in tfgld410 for all the invoices, and transaction date (= invoice date). And then post the integration transaction for Sales and Sales invoice.

If you have posted, but not finalized, then you need to change tfgld102, tfgld018, tfgld100 also will need to be changed for fiscal period and document date.

If you have finalized then tfgld106, tfgld018, tfgld100 will need to be changed for fiscal period and document date. Then rebuild ledger histroy will have to be run for March and April.

Hope this helps.