Stock items lines on invoice sometimes double up randomly when there is more than one batch number
Would really love some help as to this. On our invoices, sometimes individual stock item lines double up randomly.
So for example, if a customer orders 8 x Product A, there are two lines on the invoice for 8 x Product A.
This seems to occur when more than one different batch number of the stock item is sent. However, it doesn't occur every time more than one batch number is sent.
Why does this occur? I deleted the batch number fields from the report designer, but the doubling up still occurred...
It doesn't look like your using the SOShipLineSplit anywhere on your report so I'd suggest that you remove this from your relationships and tables, it is this table that I expect is causing line duplication.
The attached form may be of interest to you and is something I've just completed earlier this week. The issue with serial numbers is displaying multiple serials for the same line. The attached is a shipment confirmation but the same concept could be easily adapted to the invoice.
Are you by any chance coming to Noosa for conference next week? It would be good to meet if you are.
@nic thanks for this and sorry for the late reply. Your attachment makes sense, thanks for this. I have been able to replicate this on our form.
However we would like to have one invoice line per product, rather than one invoice line per batch number. The batch number doesn't even have to show at all.
So is there a way to make multiple split ship line into one invoice line?
Chiming in a little late on this. Some questions:
1. Looking at your RPX file, it looks like your document (pictured here) is called Shipment Confirmation. Is this an Invoice or a Shipment Confirmation?
2. When is this document getting generated? Immediately after the Shipment goes out? After the Invoice is generated?
3. Are you intending to print Serial Number information? I agree with Nic, if this doesn't need to be printed, then I would remove the SOShipLineSplit table which is likely the reason for your duplicate lines.
Announcing AUG Courses - Click here for more info
Can I add another wrinkle to this?
I am reporting the Lot Serial Nbrs, so using the SOShipLineSplit table for that. This works great except when the order has the same line item in a sales order. This is due to the same line item receiving a different discount for variable quantities. My report is using information from the sales order line [SOLine] and the shipment [SOShipLineSplit], so this is causing duplication.
Is there a way to consolidate the line items by line number or something along those lines (pardon the pun) with the quantities summed by Item / Lot Serial Nbr? I need to maintain the ability to show multiple lot serial numbers, without duplicating lines due to pricing variances from discounts.