Duplicated invoice issue happened
Let me ask you what would be the root cause of duplicated invoice issue.
Recently, I found our system had 2 duplicated invoices which have same data except their document number.
- Their document number are sequential; Billing no#1 with account document#1 & Billing No.2 with account document No2.
- They even have same posting date & document entry date (Entry & posting date: 26th October for both billing)
(But their entry time were different from each other, about a minute gap)
This is abnormal case.
As you know, normally,
once a delivery document is fully invoiced, it can't have any further invoice.
2. Reproduction result:
Currently, I can't reproduce the same symptom due to error message "Delivery doc#xxxx is fully invoiced...".
3. New type of duplicate invoice issue:
And release # of our ERP system is #606.
So, this is not related to notes#217157 which was corrected since release# 4.7
4. Other considerable factor:
And in this situation,
one of my colleague suspects the entry date / posting date of the firstly created invoice(called No1 in the above) is not correct data.
Cause, in the middle of November, there was system down time for monthly-Service maintenance.
And sometimes duplicated invoices can be created
if there's pending invoice data in some kind of SAP-queue which is temporary memory area
(I'm not sure what exactly this mean in technical point of view)
The following is his scenario:
i) On 26th October, sales person tried to create the first billing,
but there was something wrong so that the invoice & its account document had not been stored to DB.
instead, it had been stored to the Queue of ERP system.(Let's call this 'Billing No1')
ii) At this moment, the user regarded the first trial was failed
and there was nothing new in the document flow. So the user retried to create billing and succeed.(Let's call this billing No.2)
The billing No.2 & its account document had been stored to DB as normal.
iii)With above operation history,
our monthly-closing of October had been finished as normal
(There was no data inconsistency in sales performance report at this moment)
iv) In the middle of November, our BD did the service maintenance job
so that the pending invoice No1 & its account document could be created with past-entry&posting date.
v) In the monthly closing of November,
the duplicate billing No.1 & its account doc can be found
both SD-document flow & FI-G/L account balance display(t-code FS10N).
Do you think the above scenario is possible?
If so, how could be the billing No.1 inserted to the queue?
Thnaks in advance...