Inventory Adjustments

Inventory adjustments are used to correct the discrepancies between inventory records in the TIGA database and the actual items or parts available in the warehouse. The warehouse team or the authorized employee should immediately adjust the inventory in TIGA whenever any discrepancies occur as a result of the Stock Opname process.

To adjust an inventory:

1. Open the Transactions table.

2. Click the Plus button in the top-left of the screen to open the Create New Transactions window.

3. In the Create New Transactions window, select the correct information for the following fields:

   • Date — Select the date that the inventory adjustments will be conducted.

   • Issuance Type — Select Adjustment from the Issuance Type list.

   • Adjustment Type:

     • Lost — Select this option to reduce the item’s stock in TIGA due to a shortage of that item. The shortage could occur because items have been lost, or because of other reasons. Because these items must have the appropriate duties paid on them, this adjustment type will be recorded in the Bonded Zone Reports.

     • Broken — Select this option to reduce the item’s stock in TIGA because the item is broken. This adjustment type will not be recorded in the Bonded Zone report.

     • Stolen — Select this option to reduce the item’s stock in TIGA because the item has been stolen. This adjustment type will not be recorded in the Bonded Zone report.

     • Repaired — Select this option to increase the item’s stock in TIGA because the item has been repaired. This adjustment type will not be recorded in the Bonded Zone report.

     • Initial Receiving — Obsolete; do not use.

     • Initial Issuing — Obsolete; do not use.

     • Initial Transferring — Obsolete; do not use.

     • Initial Issued In — Obsolete; do not use.

     • Committed Reduction — Select this option to release any remaining goods that belong to a closed WO, so that they can be used as available stock. This can only be done by an authorized employee. Ideally, a closed WO should have 0 Discrepancies. Note that you can always check goods discrepancies for any closed WOs in the WOLI table. This adjustment type will not be recorded in the Bonded Zone report.

     • Scrap In — Select this option to return scrap items to the warehouse. Scrap items are leftover materials from production that can be reused. This adjustment type will not be recorded in the Bonded Zone report.

     • Scrap Out — Select this option to check scrap items out for use. This adjustment type will not be recorded in the Bonded Zone report.

     • Move In — Select this option to increase the item’s stock in TIGA because stock has been transferred into the warehouse from a different warehouse within FORMULATRIX. Because these items are only being moved within the company, this adjustment type is not included in the Bonded Zone report.

       A Move In transaction will be automatically created in TIGA when you perform the warehouse transfer process in the Item Inventories table. See also, Transferring Items to Different Warehouse.

     • Move Out — Select this option to reduce the item’s stock in TIGA because stock has been transferred out of the warehouse into a different warehouse within FORMULATRIX. Because these items are only being moved within the company, this adjustment type is not included in the Bonded Zone report.

       A Move Out transaction will be automatically created in TIGA when you perform the warehouse adjustment process in the Item Inventories table. See also, Moving Parts to Different Storage.

     • Excess — Select this option to increase the item’s stock in TIGA after new items are added in the warehouse. Excess items most frequently come from shipments to FORMULATRIX where more parts were sent than what was initially ordered. Because these items must have the appropriate duties paid on them, this adjustment type will be recorded in the Bonded Zone report.

   • Warehouse — Select the specific warehouse where the items you’re adjusting are location.

   • Employee — Select the person who will perform the inventory adjustment.

4. Click Create in the lower-right corner of the Create New Transactions window.

   At this point a new transaction for the inventory adjustments has been created and added to the Transactions table.

5. Under the Main Table, select the new transaction record.

6. Open the Transaction Line Items (TALI) related table on the right, click the Record menu, and then select Add.

7. In the Create New Transactions Line Items window, type or select the appropriate information for the following fields:

   • Adjustment Notes — Type some additional notes about the items or parts that will be adjusted, if desired.

   • Item Id — Select the item’s id.

   • Storage — Select the storage location for the items that will be adjusted.

   • Quantity — Type the actual quantity of the items to be adjusted.

   • Status — Select Confirmed if you are sure all the information in the Create Transactions Line Items window is correct, or select Unconfirmed if you want to review the information later. Please note that you will not be able to edit the TALI once it’s set to Confirmed.

8. Click Create.