Populate a Cycle Count Upload Template | Scribe

    Populate a Cycle Count Upload Template

    • |
    • 0 step |
    • 11 seconds
    Open a blank Microsoft Excel worksheet
    Click the cell "A1"
    Insert all the values column headings exactly as they are written in step 3 in bold text
    The following are the template headings with their respective titles in bold in respect to step 3\ \ A1 : **BUSINESS_UNIT_ID**\ B1 : **WAREHOUSE_ID**\ C1 : **CYCLE_COUNT_ID**\ D1 : **BARCODE_TYPE**\ E1 : **BARCODE_ID**\ F1 : **STYLE_ID**\ G1 : **COLOR_ID**\ H1 : **SIZE_ID**\ I1 : **DIMENSION_ID**\ J1 : **BIN_LOCATION**\ K1 : **QTY_TO_TRANSFER**
    Insert "1" under the heading of BUSINESS_UNIT_ID for all the relevant rows
    Insert the warehouse ID under the heading of WAREHOUSE_ID for all the relevant rows that the template is being uploaded to
    Insert the Cycle Count IT under the heading of CYCLE_COUNT_ID for all the relevant rows that the template is being uploaded to
    If the user does not know how to create a Cycle Count in WMS, they can reference the document "Creating a Cycle Count by Location Range"\ \ [Creating a Cycle Count by Location Range](https://scribehow.com/shared/Creating_a_Cycle_Count_by_Location_Range__pvvMGsLUQiKgqo1aGWmTkw)
    Insert UPCA under the heading of BARCODE_TYPE for all the relevant rows that the template is being uploaded to
    Insert the correct UPCA barcode under the heading of BARCODE_ID for all the relevant rows that the template is being uploaded to
    Insert the correct bin location ID under the heading of BIN_LOCATION for all the relevant rows that the template is being uploaded to.
    Ensure the BARCODE_ID matches the BIN_LOCATION physically, if this incorrect the inventory will be uploaded into the wrong bin location
    Insert the quantity for each SKU under the heading of QTY_TO_TRANSFER for all the relevant rows that the template is being uploaded to.
    Ensure the QTY_TO_TRANSFER matches both the BARCODE_ID and the BIN_LOCATION physically, if this incorrect the inventory will be uploaded into the wrong bin location with the wrong quantities
    Press [[Ctrl]] + [[S]]
    Was this Scribe helpful?
    Save this document for future reference.
    click-target-circles-background
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe