Hi there,
We have a unexpected issue on AR invoice unintentionally. I like to see is it a normal behaviour.
Short description:
-----
A Sales Order SO2303211 (SO) fulfill 3 times. 2 pcs of item (SL10702113) was fulfilled on first time and billed with invoice S23003488. A print copy of S23003488 show 2 pcs of SL10702113 sent to customer.
When we made 3rd fulfillment. Quantity of item SL10702113 in invoice S23003488 changed from 2 to 1 unintentionally.
The item SL10702113 was billed again (due to based on system record, only 1 pc of SL10702113 billed) with invoice S23004167 on 3rd fulfillment. So a print copy of S23004167 1 pcs of SL10702113 sent to customer.
-----
The problem is hard copy of invoice S23003488 and S23004167 consist total 3 pcs of item SL10702113. But we actually ship out 2 pcs.
In Netsuite record, S23003488 and S23004167 consist total 2 pcs of item SL10702113.
I will show the foundings we have now below:
Sales order SO2303211 related record show fulfillment record and invoices
Sales order SO2303211 system information shown at 2023-05-09 17:44, NS changed SO amount, after we dig into the detail, found the invoice S23003488 item SL10702113 from 2 to 1.
Inventory item related records of SL10702113.
It shown 2 pcs was fulfilled at 2023-04-18. But bill by two invoices. Normally it should bill by one invoice when we bill at 2023-04-20 as shown at invoice S23003488 screenshot below.
Invoice S23003488 hard copy (21 pcs total)
Invoice S23003488 NS record Item section (20 pcs total)
Item Fulfillment DN23003488 show we have 2 pcs of SL10702113 packed (and shipped)
Invoice S23003488 system information show changed at 2023-05-09 17:34 unintentionally.
Although "Set by" field is mention set by user. But our user do not have permission to change invoice quantity. And she also said doesn't change it.
============================
Invoice S23004167 hard copy (4 pcs total)
Invoice S23004167 NS record (3 pcs total)
Item fulfillment DN23004167 when we create invoice S23004167 . There is no item SL10702113 in that fulfillment.
============================
We also tried to repeat same procedure on Sandbox see if we reproduce the problem. But we cannot reproduce it.
The case is a bit complicated. I hope Netsuite expert can give me some hint.
- When we bill a partially fulfilled Sales Order, the invoice cannot change after bill by user (I know admin can change it). Is it correct?
- Can workflow, suitescript can change Invoice quantity unintended?
- Our case is a partial fulfilled sales order billed. The invoice quantity changed around 3 weeks later when user make a fulfillment due to back order item is available. Is this a normal behaviour of Netsuite? My understanding, billed invoice cannot be changed by a user.
I'm looking forward to have any advise.
Thank you in advance.
Regards, kf