I wanted to share something that I found out recently...
We had an issue where we mis-billed a customer the incorrect price on two items:
My warehouse manager came to me at the end of the month, and had a strange issue where the system said we had 1000 pieces of two items less in inventory than the system said.
I back-tracked the items and found that they were both on the invoices that I had credited weeks before.
There is an enhancement for this (81003), but I feel that this should really be classified as a defect.
The reason that this should be a defect is that crediting an invoice creates a STAND ALONE credit memo, complete with inventory impact.
Copying the incorrect invoice (which is attached to a sales order) and correcting the price creates a LINKED invoice (linked to the original sales order) and DOES NOT impact inventory.
The logic in NetSuite should be one or the other:
Either both transactions (credit memo and invoice) should be linked and have NO IMPACT on inventory, OR both transactions should have inventory impact to cancel each other out. NOT BOTH WAYS.
I think that this issue may be impacting many companies using NetSuite for tracking inventory. If I hadn't asked my Warehouse Manager to come to me with any strange discrepancies in the inventory, as I feel that there is usually a simple explanation, he may have just wrote off the difference in an inventory adjustment.
There is a workaround, and it involves creating a return authorization, crediting from the RA, closing the RA, and then creating the new corrected invoice.
Thoughts anyone?
- Wes