Solved

Sales Orders - Show Lot/ Serial Number

  • 17 August 2022
  • 7 replies
  • 508 views

HI All,

The Screen Sales Order always shows <SPLIT> on the Lot/ Serial Number Column.

There is any way that we can show the content instead of <SPLIT>?

Thank you,

Yên Chi

icon

Best answer by Kandy Beatty 17 August 2022, 14:54

View original

7 replies

Userlevel 7
Badge +15

HI @chidao 

This is standard Acumatica. It does not just happen to Lot/Serial Numbers, it also happens to locations. 

The <split> issue is common. I have found an older article in the community that you could read other suggestions. 

Allow/Disallow split inventory locations | Community (acumatica.com)

Userlevel 6
Badge +4

Hi @chidao 
The <SPLIT> will be shown if a Lot/Serial Nbr. is not selected or if more than one Lot/Serial Nbr. is selected for the same line. If only one Lot/Serial Nbr. is selected, then the content will be shown instead of the <SPLIT>. 
 



 

HI @Anacarina Calvo , the system will show Lot/ Serial Number after I save SO, and then I create Shipment, the system back to <SPLIT>. There are anyway we can set it to show the content with no matter which status

Before creating Shipment
After creating Shipment

 

Userlevel 6
Badge +4

@chidao I suggest to report it. The Lot/Serial Nbr. is not changed to <SPLIT> after saving de document with IN Order types but I see that it is happening with SO Order types 

We are evaluating Acumatica now, and had a question about line splitting. Currently we sell product with a lot number. We sell most of our products in cases and sometimes as a lot number runs out of stock our current software will split the item into two lines on the pick ticket. 

 

So if our inventory is 

Lot 123 = 46 pcs

Lot 231 = 62 pcs 

 

And we sell the product in cases of 20 pcs (ie UOM 20/ cs). 

We have a sales order with 4 cases of product requested the pick ticket will show 

Pick - Lot 123 - 2.3 cases

Pick - Lot 231 -  1.7 cases 

This is really frustrating for our pickers, is this how acumatica does it as well? Does it atleast combine when invoicing? 

 

 

 

Userlevel 3
Badge +1

I run into the same issue with splitting the lots, our sale unit is in cases but the slits are down to eaches.  

When this is not caught it causes inventory issues.

We need lot selected but it auto selects & splits the lot.  I rather be prompt to select a lot than to have my clerk ignore the split and cause me more wasted time down the line figuring out what happened.

Is there is a setting I'm missing? 

We are evaluating Acumatica now, and had a question about line splitting. Currently we sell product with a lot number. We sell most of our products in cases and sometimes as a lot number runs out of stock our current software will split the item into two lines on the pick ticket. 

 

So if our inventory is 

Lot 123 = 46 pcs

Lot 231 = 62 pcs 

 

And we sell the product in cases of 20 pcs (ie UOM 20/ cs). 

We have a sales order with 4 cases of product requested the pick ticket will show 

Pick - Lot 123 - 2.3 cases

Pick - Lot 231 -  1.7 cases 

This is really frustrating for our pickers, is this how acumatica does it as well? Does it atleast combine when invoicing? 

 

 

 

Hi @NewGuy124 ,

In your case, you should set up Base Unit = PCS, Sales Unit = Cases. On-screen Sales Order and Invoice, the system will show only 1 line with unit cases

On the Shipment, the system will show 2 lines w different Lot using Unit = Cases. If you want the Printed Form to show 2 lines using Unit = PCS, you should customize the report joint w SOShipLIneSplit table and showing UOM & QTY from this table

Hope it works for you

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved