Skip to main content
Solved

How to freeze Inventory module for stock take purpose?

  • 4 November 2022
  • 6 replies
  • 464 views

Forum|alt.badge.img

Good day. How do we freeze Inventory module in Acumatica 2021 R2 for stock take purpose?

Best answer by Laura02

Hello @chenwm ,

Please ignore numbering in this answer…. copying from my Word document to Community… does not keep the proper numbering; starts over with #1 every time I paste...

Create Count & Freeze Transactions

Inventory --> Physical Inventory --> Prepare Physical Count

  1. Select Inventory Count Type. 

 

  1. Upon choosing the inventory count Type ID, the system will display items whose count tags will be printed.
  2. Review the lines to make sure the needed items are selected for counting, and the order is as expected.  (The book quantity included on each line is quantity on hand as of this moment.)
  3. Populate Blank Lines to Append with a figure, to accommodate unexpected items (that are located in the wrong place) during a count.
  4. Click Generate PI to begin the counting process.  Transactions for the items included in the PI Type will be frozen at this time, and the system will advance to the Physical Inventory Review screen.

Physical Inventory Review

Inventory --> Physical Inventory --> Physical Inventory Review

To count Inventory:

  1. Print Physical Count Tags, or Physical Count Sheets.  Either report can be used to record the actual quantities of each item that are on hand in the warehouse.  Choose the format that you prefer; examples of both are shown on next page.

 

  1. After the counting is complete, click Finish Counting on the Actions […] tab of Physical Inventory Review.  At this point, warehouse activities are resumed, and the release of inventory transactions is resumed in the system.  
  2. Record the count results:  The counted items can be entered (or imported using Load from File button) on the Physical Inventory Details tab of  Physical Inventory Review:
  1. Each line should have a quantity entered, even if the Physical quantity matches the book quantity, or if the physical quantity is 0.  The […] Actions menu contains two related options that will expedite the process of completing those items that were skipped or have 0 on hand.

 

  1. Click Complete PI to generate inventory adjustments for any items whose book count does not match shelf count.

You have completed the physical inventory process and adjusted the book quantity of items in the system according to the count result.  Depending on the options selected in IN Preferences, you may need to use Release IN Documents screen to release inventory adjustments that were created by Completing the Physical Inventory.

View original
Did this topic help you find an answer to your question?

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 4, 2022

Hello @chenwm ,

Please ignore numbering in this answer…. copying from my Word document to Community… does not keep the proper numbering; starts over with #1 every time I paste...

Create Count & Freeze Transactions

Inventory --> Physical Inventory --> Prepare Physical Count

  1. Select Inventory Count Type. 

 

  1. Upon choosing the inventory count Type ID, the system will display items whose count tags will be printed.
  2. Review the lines to make sure the needed items are selected for counting, and the order is as expected.  (The book quantity included on each line is quantity on hand as of this moment.)
  3. Populate Blank Lines to Append with a figure, to accommodate unexpected items (that are located in the wrong place) during a count.
  4. Click Generate PI to begin the counting process.  Transactions for the items included in the PI Type will be frozen at this time, and the system will advance to the Physical Inventory Review screen.

Physical Inventory Review

Inventory --> Physical Inventory --> Physical Inventory Review

To count Inventory:

  1. Print Physical Count Tags, or Physical Count Sheets.  Either report can be used to record the actual quantities of each item that are on hand in the warehouse.  Choose the format that you prefer; examples of both are shown on next page.

 

  1. After the counting is complete, click Finish Counting on the Actions […] tab of Physical Inventory Review.  At this point, warehouse activities are resumed, and the release of inventory transactions is resumed in the system.  
  2. Record the count results:  The counted items can be entered (or imported using Load from File button) on the Physical Inventory Details tab of  Physical Inventory Review:
  1. Each line should have a quantity entered, even if the Physical quantity matches the book quantity, or if the physical quantity is 0.  The […] Actions menu contains two related options that will expedite the process of completing those items that were skipped or have 0 on hand.

 

  1. Click Complete PI to generate inventory adjustments for any items whose book count does not match shelf count.

You have completed the physical inventory process and adjusted the book quantity of items in the system according to the count result.  Depending on the options selected in IN Preferences, you may need to use Release IN Documents screen to release inventory adjustments that were created by Completing the Physical Inventory.


Forum|alt.badge.img
  • Jr Varsity II
  • November 4, 2022

@laura01 thanks for the guidelines. Really appreciate it. 


Forum|alt.badge.img
  • Jr Varsity II
  • November 9, 2022

@laura good day. Does the PI affect the account’s P&L?

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 9, 2022

Hello,

Yes if there are differences in physical count compared to book count, inventory quantities and costs are adjusted so that Acumatica matches the actual quantity counted. Adjustments will impact the balance sheet and P & L if Inventory posting to GL is ON in the IN Preferences screen.

Any difference becomes an adjustment transaction to increase inventory or decrease inventory.

Example 1:

Acumatica shows 100 on hand, we counted 99. Cost of item $1.

Credit Inventory Control account (Asset) $1

Debit Inventory Expense account (this account comes from Reason code - could be a Loss account, damaged inventory, or some kind of COGS) $1.

Example 2:

Acumatica shows 100 on hand, we counted 101. Cost of item $1.

Debit Inventory Control account $1

Credit Inventory Expense account (this account comes from Reason code - could be Inventory Short/Over account  or some kind of COGS) $1.


Forum|alt.badge.img
  • Jr Varsity II
  • November 10, 2022

@laura01 thank you so much for the explanation. Really appreciate it.


Forum|alt.badge.img
  • Freshman I
  • June 13, 2023

Can Inventory be back dated and frozen and how would one process that? Thank you. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings