Skip to content
  • There are no suggestions because the search field is empty.

Configuring Physical Inventory

This job aid contains instructions related to configuration of physical inventory in MYOB Acumatica.

Creating a PI Type for Full Count

  1. Open the Physical Inventory Types (IN208900) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Type ID box of the Summary area, type the unique identifier for the new physical inventory type.
  4. In the Description box, type a brief description indicating that this is the full count.
  5. In the Generation Method box, select Full Physical Inventory.
  6. If needed, select the Hide Book Qty. on PI Count check box to hide the Book Qty. column on the Physical Inventory Count (IN305010) form.
  7. If needed, on the Warehouse/Location Selection tab, specify the warehouse where the full count should be performed.
  8. On the Assignment Order tab, do the following:
    1. In the numerated boxes, select entities to use for the assignment order on the count sheets.
    2. If needed, in the Blank Lines to Append box, specify the number of blank lines to add to the count sheets.
  9. On the form toolbar, click Save.

 

Creating PI Cycles

  1. Open the Physical Inventory Cycles (IN208700) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add Row.
  3. In the Cycle ID column, type the unique identifier for the new cycle.
  4. In the Description column, type a brief description.
  5. In the Counts Per Year column, enter the integer that indicates how many times in a year the system should count the items of the cycle.
  6. On the form toolbar, click Save.
  7. Repeat the previous five steps for each cycle you want to create.

 

Assigning Stock Items to PI Cycles

  1. Open the Stock Items (IN202500) form.
  2. Select the stock item by its inventory ID.
  3. In the Physical Inventory section of the General tab, in the PI Cycle box, select the appropriate physical inventory cycle.
  4. On the form toolbar, click Save.

 

Creating PI Types for Cycles

  1. Open the Physical Inventory Types (IN208900) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Type ID box of the Summary area, type the unique identifier for the new physical inventory type.
  4. In the Description box, type a brief description.
  5. In the Generation Method box, select By Cycle. The PI Cycle Selection tab appears on the form.
  6. If needed, select the Include Items with Zero Book Quantity in PI check box to include items with a zero-book quantity in the count.
  7. If needed, select the Hide Book Qty. on PI Count check box to hide the Book Qty. column on the Physical Inventory Count (IN305010) form.
  8. In the Cycle ID box of the PI Cycle Selection tab, select an appropriate PI cycle.
  9. On the Assignment Order tab, specify the following:
    1. In the numerated boxes, select the entities for the assignment order to be used on the count sheets. Specify the number of blank lines to add to the count sheets in the Blank Lines to Append box if needed.
    2. On the form toolbar, click Save.

 

Creating a PI Type for Cycle Counts by Frequency

  1. Open the Physical Inventory Types (IN208900) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Type ID box, type the unique identifier for the new physical inventory type.
  4. In the Description box, type a brief description.
  5. In the Generation Method box, select By Cycle. The PI Cycle Selection tab appears on the form.
  6. If needed, select the Include Items with Zero Book Quantity in PI check box to include items with a zero-book quantity in the count.
  7. If needed, select the Hide Book Qty. on PI Count check box to hide the Book Qty. column on the Physical Inventory Count (IN305010) form.
  8. On the PI Cycle Selection tab, select the By Frequency check box.
  9. On the Assignment Order tab, do the following:
    1. In the numerated boxes, select entities for the assignment order to be used on the count sheets.
    2. Specify the number of blank lines to add to the count sheets in the Blank Lines to Append box if needed.
  10. On the form toolbar, click Save.

 

Creating ABC Codes

  1. Open the ABC Codes (IN208500) form.
  2. On the table toolbar, click Add Row.
  3. In the ABC Code column, specify the code identifier.
  4. In the Description column, specify a brief description of the code.
  5. In the Counts per Year column, specify the number of physical inventory counts during the year.
  6. Specify the threshold value (%) of the criteria in the ABC Code % column to assign the inventory items to this code.
  7. On the form toolbar, click Save.
  8. Repeat the previous steps for each ABC code you want to create in the system. In the Total ABC Code % column, make sure that the threshold for all ABC codes adds up to 100%.

 

Assigning ABC Codes to Stock Items

  1. Open the Stock Items (IN202500) form.
  2. In the Inventory ID box, select the stock item to which you are assigning the ABC code.
  3. In the Physical Inventory section of the General tab, do the following:
    1. In the ABC Code box, select the ABC code that will be assigned to the selected stock item.
    2. Select the Fixed ABC Code check box if needed to indicate that the system should not update the ABC code automatically.
  4. On the form toolbar, click Save.

 

Creating PI Types for ABC Codes

  1. Open the Physical Inventory Types (IN208900) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Type ID box, type the unique identifier for the new physical inventory type.
  4. In the Description box, type a brief description.
  5. In the Generation Method box, select By ABC Code. The ABC Code Selection tab appears on the form.
  6. If needed, select the Include Items with Zero Book Quantity in PI check box to include items with a zero-book quantity in the count.
  7. If needed, select the Hide Book Qty. on PI Count check box to hide the Book Qty. column on the Physical Inventory Count (IN305010) form.
  8. On the ABC Code Selection tab, select the appropriate ABC code in the ABC Code box.
  9. On the Assignment Order tab, do the following:
    1. In the numerated boxes, select entities to use for the assignment order on the count sheets.
    2. Specify the number of blank lines to add to the count sheets in the Blank Lines to Append box if needed.
  10. On the form toolbar, click Save.

 

Creating a PI Type for Counts by Frequency in ABC Code

  1. Open the Physical Inventory Types (IN208900) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Type ID box, type the unique identifier for the new physical inventory type.
  4. In the Description box, type a brief description.
  5. In the Generation Method box, select By ABC Code. The ABC Code Selection tab appears on the form.
  6. If needed, select the Include Items with Zero Book Quantity in PI check box to include items with a zero-book quantity in the count.
  7. If needed, select the Hide Book Qty. on PI Count check box to hide the Book Qty. column on the Physical Inventory Count (IN305010) form.
  8. On the ABC Code Selection tab, select the By Frequency check box.
  9. On the Assignment Order tab, do the following:
    1. In the numerated boxes, select entities to use for the assignment order on the count sheets.
    2. Specify the number of blank lines to add to the count sheets in the Blank Lines to Append box, if needed.
  10. On the form toolbar, click Save.