Populating a Cycle Count Upload Template | Scribe

    Populating a Cycle Count Upload Template

    • MicrosoftMicrosoft
    • ExcelExcel
    1
    Open a blank Microsoft Excel worksheet
    information ordinal icon
    A new worksheet can be opened directly by right clicking the Excel from the taskbar
    2
    Click the cell "A1"
    3
    Insert all the values column headings exactly as they are written in step 3 in bold text
    alert ordinal icon
    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**
    4
    Insert "1" under the heading of BUSINESS_UNIT_ID for all the relevant rows
    5
    Insert the warehouse ID under the heading of WAREHOUSE_ID for all the relevant rows that the template is being uploaded to
    6
    Insert the Cycle Count ID under the heading of CYCLE_COUNT_ID for all the relevant rows that the template is being uploaded to
    information ordinal icon
    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)
    7
    Insert UPCA under the heading of BARCODE_TYPE for all the relevant rows that the template is being uploaded to
    8
    Insert the correct UPCA barcode under the heading of BARCODE_ID for all the relevant rows that the template is being uploaded to
    9
    Insert the correct bin location ID under the heading of BIN_LOCATION for all the relevant rows that the template is being uploaded to.
    alert ordinal icon
    Ensure the BARCODE_ID matches the BIN_LOCATION physically, if this incorrect the inventory will be uploaded into the wrong bin location
    10
    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.
    alert ordinal icon
    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
    11
    Press [[Ctrl]] + [[S]]