Skip to main content

Export SKU List per Partner Inventory Transfer Slip (Excel)

Overview​

This section explains how to export the Partner Inventory Transfer Slip – Slip-wise SKU List as an Excel (.xlsx) format file.

Purpose​

Obtaining the SKU detail data for each slip in Excel format allows you to confirm the loan and return history of Partner Inventory and use it for sales and inventory management.

Feature Description​

Export Targets​

This feature exports the Partner Inventory Transfer Slip – Slip-wise SKU List as an Excel (.xlsx) format file.

Specify Partner Inventory Transfer Slip – Slip-wise SKU List (XLSX) as the Data Export Type.

Data Extraction Condition​

Specify the Slip Status, Slip Type, and period as the Data Extraction Condition.

  • Slip Status: You can specify EDITABLE, COMPLETED, or All.
  • Slip Type: You can specify either Goods Dispatch Slip or Goods Return Slip.
  • Period: Set by combining the type of reference date and the target period.
    • Document Date: Uses the Document Date set in the Partner Inventory Transfer Slip as the reference.
    • Create date: Uses the date the Partner Inventory Transfer Slip was created as the reference.

Instructions​

Moving to the Operation Screen​

  1. Click the Data Export menu.
  2. Click the Inventory tab.
  3. Click the Data Export tab.
    *It is open by default.

How to Fill Out the Form​

  1. Data Export Type
    Select Partner Inventory Transfer Slip – Slip-wise SKU List (XLSX) from the pulldown menu.

  2. Slip Status
    Use the toggle button to specify whether to include all Slip Statuses for export or to select them individually.

    • Enable Include all slip statuses: Includes all Slip Statuses as export targets.
    • Disable Include all slip statuses: Specifies the Slip Statuses individually.

  3. Slip Type
    Select Goods Dispatch Slip or Goods Return Slip from the pulldown menu.

  4. Period
    Specify the target period for export.

    • Select the reference date type from Document Date or Create date via the pulldown menu.
    • Enter the start and end dates for the period. You can specify dates using the calendar icon.

  5. Select Target Buyers
    Check the checkboxes for the buyers whose data you wish to export.

    • You can narrow down the buyers by entering conditions into the Search Buyers field.
    • To select all buyers that match the search conditions, click Select All.
    • To uncheck all, click Remove All Selections.

Downloading the Slip-wise SKU List Data​

After confirming the input details, click the Download button.

Upon successful processing, the Excel file will be downloaded directly.

Important Notes​

Detail Data per Slip​

This feature exports detail data for each slip.

It is not a feature for aggregating inventory data or data by SKU.

Slips Without a Registered Document Date​

Partner Inventory Transfer Slips can be created even if the Document Date remains unregistered.

If the Document Date is specified in the period filter, slips with an unregistered Document Date will be excluded from the export.