Physical Count - Display Quantity "Available" and "Available for Shipment" on Physical Count Screens

  • 15 February 2023
  • 8 replies

Userlevel 3
Badge +1

Use Case

My client runs an in-house repair shop. They are using service orders to manage in-house repairs on equipment. There are open service orders where stock items are already consumed on the repair. The service order can’t yet be closed because further work needs to happen. 


When a physical count is generated, the items already used on the service order are still considered “on-hand” by Acumatica. This causes the physical count to display higher book quantity than there actually is on the bin. This can cause stock items to be reduced too low by mistake.

 For example:

  • I have 13 stock item X on hand
  • I used 2 on an open service order
  • I generate a count, which displays 13 on hand
  • During the count, I input 11 as Physical Quantity
  • The system adjusts 13 stock items down to 11
  • I close and bill my service order
  • This process further reduces stock item X by 2 units
  • Now I have 9 in the warehouse, whereas I should have 11 in the warehouse. I have adjusted down the Item X by 2 units during the count, which shouldn’t have occurred 

I think it would be very helpful to display Available and Available for Shipment quantities on the count related screens. This would solve this issue.

I assume a similar issue can show up in a distribution environment, however, I have not tested this through a sales order/shipment process.  

I wanted to throw this out there and first of all see, am I missing something? If not, then I’ll move this to product idea. 


Best answer by umesh 16 February 2023, 19:54

View original

8 replies

Userlevel 6
Badge +3

Does your service order indicate that these items are needed for it? If yes, this solution wouldn’t work. 

Think of a scenario where you created the order with these two items but haven’t picked/used them yet. You have available QTY 11 and On Hand 13. In reality, you still have 13, so entering 11 would be wrong. 


A better solution would be where Acumatica moves out items that have been picked. This would be helpful with distribution as well. 

Userlevel 3

Hi @eshahid98  would it be practical to create a new warehouse for goods being used on service orders.  When goods are needed on a service order then first do a transfer to move the goods from the main warehouse to the service warehouse. This does add another step to the process of consuming goods for service orders but should solve the counting issue.

Userlevel 3
Badge +1

@Jeff96  - you made a fair point about service orders where items are added but not yet picked. I think if items are picked, the user can allocate these items to the service order. The allocation today reduces from “Qty Available for Shipment”. However, they are still not reduced form “On-Hand”. 

That’s why I think if Qty Available and Qty Available for Shipment columns are visible on the counting sheets, it would do the job. I think my client would find it acceptable to allocate such quantities on the service order, so the count may display accurate Qty Available for Shipment. 

We can do similar allocations on the Sales Order side too.  


Userlevel 3
Badge +1

@Dave Gutman  - good idea for lower volume environments. This wouldn’t be efficient in a high volume process. 

Userlevel 6
Badge +1

@eshahid98 let’s meet to discuss.  We’ll send you proposed meeting date/times to get together to explore your feedback and idea further.

I don’t think logical warehouses are the answer here - you will lose inventory visibility.  -Dana

Userlevel 1

Acumatica does not consider items consumed on a service order until service invoice is released. So technically items are assumed to be in stock. one of the ways is to close out all pending service orders as far as possible and freeze the inventory transactions during physical inventory counts.

Userlevel 3
Badge +1

My client is manually running totals on items on open Service Orders - hundreds could be open. Then manually adjusting the physical count to account for this variance. It seems items of Service Orders of a certain ‘status’ should be able to be excluded from a Physical count.

Userlevel 6
Badge +1

In 2023R2, a validation has been added for outstanding allocations.  To find out more, please see the release notes and the section Inventory and Order Management: Improvements in the Inventory Adjustments.




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 — 2023  Acumatica, Inc. All rights reserved