Child Items Acumatica
Budget: $750 – $1,750 USD
1. Create on the inventory preferences screen (IN101000) a “Default Child Item Class” directly below the Default Non-Stock Item Class, with the same functionality as the Default Non-Stock Item Class field
2. Update the RELATED ITEMS table on the stock items (IN202500) and non-stock items (IN202000) screen, to include a new relation called "Child"
2. The InventoryID selection should be for all products (stock, non-stock, charges, etc.)
3. A Button will be created on stock items (IN202500) and non-stock items (IN202000) screen on the related items tab called “Create Child Item”
4. That button will create a pop up to create a nonstock item, the pop-up will have
• Item Class (which will default from the newly created Default Child Item Class from step 1)
• InventoryID
• Item Description
• UOM
• OK button
5. After Clicking “Create” button those fields will be used to create and save a new non-stock item with those parameters
6. Then that item will be added to the Related Items table of the initial product with the “Child” relation
7 Add “Child Qty on Hand” on the warehouse details tab grid on stock items (IN202500) screen, which will go and look everywhere that item is a child account for another item/s and calculate the amount of the parent qty on hand and divide it by the quantity of that child item on the related items tab.
7. Qty Available, Qty on Hand, Qty on PO, columns need to be added to the RELATED ITEMS grid and correspond to the InventoryID
2. Update the RELATED ITEMS table on the stock items (IN202500) and non-stock items (IN202000) screen, to include a new relation called "Child"
2. The InventoryID selection should be for all products (stock, non-stock, charges, etc.)
3. A Button will be created on stock items (IN202500) and non-stock items (IN202000) screen on the related items tab called “Create Child Item”
4. That button will create a pop up to create a nonstock item, the pop-up will have
• Item Class (which will default from the newly created Default Child Item Class from step 1)
• InventoryID
• Item Description
• UOM
• OK button
5. After Clicking “Create” button those fields will be used to create and save a new non-stock item with those parameters
6. Then that item will be added to the Related Items table of the initial product with the “Child” relation
7 Add “Child Qty on Hand” on the warehouse details tab grid on stock items (IN202500) screen, which will go and look everywhere that item is a child account for another item/s and calculate the amount of the parent qty on hand and divide it by the quantity of that child item on the related items tab.
7. Qty Available, Qty on Hand, Qty on PO, columns need to be added to the RELATED ITEMS grid and correspond to the InventoryID