Under some circumstances, an organization may need to change the unit cost for inventory that has already been added to the system. For example, an organization may want to add inventory to the system using an estimated unit cost and then adjust the inventory at a later date when the actual cost is known.
However, since users cannot modify a Product Inventory Ledger Entry (PILE) after it has been created, the organization needs to manually create adjusting PILE records to modify the existing inventory.
The process for adjusting the unit cost for inventory varies depending on whether the product uses the LIFO (Last-In First-Out) or FIFO (First-In First-Out) cost method or the Average Cost method. Refer to one of the following sections for information on a particular process:
<add a child display macro>

Adjusting Unit Cost for a LIFO or FIFO Product

In Aptify, the unit cost for individual units of LIFO (Last-In First-Out) and FIFO (First-In First-Out) products are tracked in Product Inventory Ledger Entries (PILEs). As described in Adding Inventory , an organization specifies inventory unit cost on the Purchase PILE created to add the inventory to the system so it is available for sale.
However, in some cases, an organization may need to add the inventory to the system to begin selling it without knowing the actual cost of the units. Then, at a later date once the actual cost is known, the system needs to be updated to reflect the true product cost.
The following procedure describes how to adjust the Unit Cost for LIFO or FIFO inventory that was previously added with an estimated unit cost:

1. When the units are received, create a Purchase PILE, as described in Adding Inventory using the estimated unit cost.
2. When the final cost is known and you are ready to adjust the inventory cost, open the original Purchase PILE and do the following:

• Identify how many units from the PILE have already been shipped to customers. This is the Quantity minus the Entry Qty. Balance. In the example in Figure, 10 units have shipped and 90 units remained tied to this PILE (100-90 = 10). The units that have shipped already have GL entries generated for them in the system.

Purchase PILE with Estimated Cost

1. Create an Adjustment PILE that removes the remaining units tied to the original PILE from inventory.
2. Specify the original Purchase PILE ID in the Original PILE field.
3. Enter the date from the original Purchase PILE in the Date field.
4. Change the Type to Adjustment.
5. Enter the number of units to remove as a negative Quantity.
6. Enter the original, estimated unit cost in the Unit Cost field.

Adjustment PILE

1. Create a new Purchase PILE to add the units back into inventory at the correct Unit Cost.
2. Leave the Original PILE field blank.
3. Enter the date from the original Purchase PILE in the Date field. This ensures that the units are shipped in the correct order for the product's cost method.
4. Leave the Type set to Purchase.
5. Enter the number of units to add back into inventory in the Quantity.
6. Enter the actual unit cost in the Unit Cost field.

New Purchase PILE

1. If units have already shipped units from the original PILE, create a Scheduled -Transactions record to adjust the GL entries for the units that have already shipped.
2. Click the Product Inventory Ledger Entry Transactions tab on the new Purchase PILE you created in the previous step.
3. Open a new Product Inventory Ledger Entry Transactions record and click the Scheduled Transaction link to open a new Scheduled Transactions record.
4. Enter the date and a description, and select Other as the Type.
5. Specify the Organization to which the transaction applies and the appropriate Currency Type.
6. Create counter-balancing GL entries to debit or credit the COGS and Inventory accounts used by this product in the amount of the adjustment.

• For example, if the actual unit cost is $1 higher than the expected cost, then the Cost of Goods Sold should be $10 higher for the products that have already shipped (and the inventory reduction should be $10 more as well). In this case, the COGS account would be debited an additional $10 and the Inventory account would be credited an additional $10.
• Contact a member of your accounting department if you need assistance determining the proper entries to create.

Scheduled Transactions Adjustment Record

1. Save and close the Scheduled Transactions record when finished. Also, confirm that it is properly linked to the Purchase PILE for record keeping purposes.

Adjusting Unit Cost for an Average Cost Product

Aptify modifies the Average Cost of a product only when a new Purchase Product Inventory Ledger Entries (PILE)is added for the product. This means that reversing a Purchase PILE with an Adjustment PILE does not recalculate the product's Average Cost. Therefore, the process for adjusting the unit cost for an Average Cost product is different than the process for LIFO (Last-In First-Out) and FIFO (First-In First-Out) products.
Follow these steps:

1. When units are received that have an unknown cost, do not create a Purchase PILE. Instead, create a positive quantity Adjustment PILE. This allows an organization to add the units to the inventory without impacting average cost until the actual unit cost is known.
2. If this is the first shipment of the product to be entered in the system, do not add the inventory for this product until you know its actual cost. Any units added on a positive quantity Adjustment PILE which is the product's first PILE will have a $0 average cost.
3. Be sure to change the Type to Adjustment and enter a positive quantity.

Positive -Adjustment PILE

1. When the final cost is known, calculate the expected average cost of the product. You also need to identify how many units have shipped in the interim period. This is because you will need to create a manual adjustment to the General Ledger to update the Cost of Good Sold and Inventory accounts with the correct average cost.
2. When the final cost is known, create a negative quantity Adjustment PILE to remove all of the units from the positive quantity Adjustment PILE.
3. Specify the original positive quantity Adjustment PILE ID in the Original PILE field.
4. Change the Type to Adjustment.
5. Enter the number of units to remove as a negative Quantity.

Negative Quantity Adjustment PILE

1. Create a Purchase PILE to add the units back into inventory using the actual Unit Cost.
2. Leave the Original PILE field blank.
3. Leave the Type set to Purchase.
4. Enter the number of units to add back into inventory in the Quantity.
5. Enter the actual unit cost in the Unit Cost field.

Purchase PILE with Actual Cost

1. Create a Scheduled Transactions record to adjust the COGS and Inventory accounts if any units have shipped between the time that the units were originally added to inventory and when the actual cost was known.
2. Click the Product Inventory Ledger Entry Transactions tab on the new -Purchase PILE you created in the previous step.
3. Open a new Product Inventory Ledger Entry Transactions record and click the Scheduled Transactions link to open a new Scheduled Transactions record.
4. Enter the date and description, and select Other as the Type.
5. Create counterbalancing GL entries to debit or credit the COGS and Inventory accounts used by this product in the amount of the adjustment. Contact a member of your accounting department if you need assistance and to determine the amount of the adjustment.
6. Need more here. Is this necessary? When? How? Is this even reasonable given that the average cost is a moving target?
7. See figure for a sample Scheduled Transactions record.
8. Save and close the Scheduled Transactions record when finished. Also, confirm that it is properly linked to the Purchase PILE for record keeping purposes.

Note: To identify a product's current average cost, add the CurrentAverageCost field to a list view of the Products service.