Questions 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...
Would you like to share the RPX file and I'd be happy to take a quick look at the joins. I've had similar issues before and typically resolved due to some minor intricacy in the joins/conditions.
Thanks for the offer - the RPX file is attached.
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.
Would anyone else be able to add invoice RPX to here that I can check out?
It's happening as the invoice is going by the line numbers of the shipment, not the line numbers of the invoice....
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.
I see, so not only is the same Item listed multiple times on your Sales Order, but the same Item and Lot Number are listed multiple times on the Sales Order because the same Lot Number is fulfilling multiple Sales Order lines.
You could add a group to the report on Item, then sum up the quantities, costs, etc. I wonder though what the end game is and whether multiple lines are truly causing a business problem.
I am relatively new to Acumatica and Report Designer, so if someone has come accross this, please can you guide me.
It relates to the section above on the same item on multiple lines, each with their own serial but when the shipment confirmation (in South Africa a delivery note) is printed, the items are printed with all the serial numbers under each item, duplicating the serial number.
How do I get the report to print one line for the same items and all serials under the one line?
Can you attach your .rpx file?
I have the same problem with random item lines doubling to the invoice. Newbie here also. Can you pls help and guide me. I have attached screenshot of the .rpx table since i cannot attach .rpx file.