Inventory Adjustment

Guide

Inventory Adjustment

This function allows you to correct your stock balance if there are stock movement or stock discrepancy between the system vs physical stock count.

Before you start the inventory adjustment, you need to know the current stock balance of your product in system. You can use the Stock on Hand report to provide you an overview of your products stock balance for comparing with the actual stock count.

Record down the UPC/TPC and the stock balance for adjustment.

Inventory Adjustment

Step 1: On the left menu, look under Concessionaire Inventory. Click on Inventory Adjustment

Step 2: Click “Download Blank Template” link to download a blank template or Click "Download Template by Brand" to download template with UPCs information populated based on the brands you selected. Open the template and filled up the required data and save to your computer.
- Refer to Appendix A on guide to fill up Inventory Adjustment Template

Step 3: Select the location where the inventory is to be adjusted and click “Browse” button if you are using Internet Explorer or "Choose File" button if you are using Google Chrome Browser and a Windows file selector will pop-up.

Step 4: Using the Windows file selector, browse to the directory that contains the saved inventory adjustment template and select the file for upload. The selected file path for upload will be shown in the “Input File” field.

Step 5: Click “UPLOAD” button to proceed to upload the inventory adjustment template file.

Step 6: Take note of the status of the upload. "PENDING CONFIRMATION" status means that your upload file is free of errors, go to Step 8 to confirm your inventory adjustment. "FAILED-CHECK ERROR" status means that your upload has error, go to Step 7 to download the validation report.

Step 7: Click "VALIDATION REPORT" button to download the validation report and check for errors in the file you have uploaded.
- Refer to Appendix B on Validation Report
- Correct the errors in the uploaded file and redo the upload.

Step 8: Click "CONFIRM" button to confirm your inventory adjustment. This button will only appear when the status is "PENDING CONFIRMATION".

Step 9: After confirming the upload the status will change to "POSTED". Click "POSTED REPORT" button to download the inventory adjustment report.

Appendix A - Inventory Adjustment Template

Blank Template

Note:
- Select Location is mandatory.
- Columns in red are mandatory fields.

Step 1: Select Location, either TANGS AT TANGS PLAZA or TANGS VIVOCITY
Step 2: Enter S/No, UPC/TPC and NEW STOCK BALANCE

Sample reasons to be used:
• Damaged Item
• Customer Return
• Stocktake Adjustment
• Tester
• Discontinued
• Aged Stock

Template By Brand

Step 1: Select the location and brands you like to adjust the inventory
Step 2: Click "GENERATE TEMPLATE" button to download the template.

Step 3: Open the downloaded template to update the "NEW STOCK BALANCE" column for UPC/TPC that needs to be adjusted.
Step 4: Save the template file.

Appendix B - Validation Report

Four important columns to take note of in the validation report
1) Stock Balance - to inform you the current stock balance for the product
2) New Stock Balance - to confirm the new stock balance you have intended to adjust to.
3) Adjustment - (New Stock Balance - Stock Balance). The stock adjustment in system.
4) Error/Warning - to inform you the error encountered for the data you entered.

Note: All error/warning must be cleared before you can proceed to upload the inventory adjustment.