Answer

TRACKING OF NON STOCK ITEMS

Forum|Forum|2 years ago
September 27, 2023
1 reply
543 views

madeborahdelfin56
Freshman I

Hi All

Asking for advise, construction companies does not maintain a big amount of inventory so we have all of our inventory as non stock (even the construction materials) since most of the constuction companies are using just in time. At the end of the year, we need to keep track of the items that was still in our inventory for reporting purposes. These remaining inventories are bought in advance but was not yet issued for use at site. Any advise on how to track remaining inventories by the end of the year if initially, the items are part of non stock?

Best answer by Laura03

Hello @madeborahdelfin56 ,

The the Physical Inventory Count features of Acumatica will count only Stock Items. With Items set up as Non-Stock, I expect you will need to count outside the Acumatica system.

With Non-stock, there is no “Book Quantity” in Acumatica, no knowledge of how many “should be” on the shelves that we could compare to and adjust quantity to match the warehouse.

With Non-stock, we normally have no Inventory balance figures in the balance sheet. When non-Stock Items are purchased, they normally post to an Expense account (check the GL Accounts tab of your Non-stock items to see the Posting accounts). There is no asset account holding an inventory $$ amount that could be adjusted to match the warehouse count.

You might export the Non-Stock Items list to Excel, as a starting point for your physical counts.

Laura

+19

Laura03
Captain II
Answer
Forum|Forum|2 years ago
September 27, 2023

Hello @madeborahdelfin56 ,

The the Physical Inventory Count features of Acumatica will count only Stock Items. With Items set up as Non-Stock, I expect you will need to count outside the Acumatica system.

With Non-stock, there is no “Book Quantity” in Acumatica, no knowledge of how many “should be” on the shelves that we could compare to and adjust quantity to match the warehouse.

With Non-stock, we normally have no Inventory balance figures in the balance sheet. When non-Stock Items are purchased, they normally post to an Expense account (check the GL Accounts tab of your Non-stock items to see the Posting accounts). There is no asset account holding an inventory $$ amount that could be adjusted to match the warehouse count.

You might export the Non-Stock Items list to Excel, as a starting point for your physical counts.