Skip to main content
Answer

Full Inventory Including items with 0 on hand

  • August 20, 2025
  • 5 replies
  • 67 views

Hello, I am new to acumatica, I am preparing for year end inventory, I cannot seem to prepare an inventory that shows all Active inventory Items. I have found that if I do a full physical inventory it actually is not. it leaves out items with 0 on hand.  Please anyone.

Best answer by DanielRobinson

On the “Phyiscal Inventory Types” screen, you can create a new type ID, and select the tickbox for “Include Items with Zero Book Quantity in PI”. This is only avaialble for certain generation methods.

I do this with the “By Item Class” generation method, and then list all of my relevant item classes in the table below.

Then you can prepare a phsyical count against for the Type ID you created.

5 replies

mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

@tthomson 

Could you please provide a bit more about the query!


  • Author
  • Freshman I
  • August 20, 2025

@mohammadnawaz51 

when we were performing a test Fully Inventory Count we noticed that not all inventory items where on the sheets. Items with 0 on hand did not show on the list.  I am struggling to figure out why.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 25, 2025

Hi ​@tthomson were you able to find a solution? Thank you!


  • Freshman II
  • Answer
  • September 26, 2025

On the “Phyiscal Inventory Types” screen, you can create a new type ID, and select the tickbox for “Include Items with Zero Book Quantity in PI”. This is only avaialble for certain generation methods.

I do this with the “By Item Class” generation method, and then list all of my relevant item classes in the table below.

Then you can prepare a phsyical count against for the Type ID you created.


Forum|alt.badge.img

Hi I understand that the Include Items with Zero Book Quantity in PI  work  (except lot-tracked or serial-tracked items) are added to a PI.  Is there an solution to add the items that are lot-tracked to a PI document without manually adding them?