SLMM150 Item Movement Document Excel Upload

You can upload item movement documents from an Excel file (Please refer to the manual site for the required format)

    Basic Operation

    Create an upload file containing the item movement information.

    As for the format, please see the Manual Site.


    For GR/Vendor Invoices based on PO approval: If '1 Manage' is set, only approved purchase order documents can be specified in the company master with Transaction Type 'R01' for GR related to the PO.


    For GI/Invoices based on SO approval: If '1 Manage' is set, only approved sales order documents can be specified in the company master with Transaction Type 'I01' for GI related to Sales.

     

    <Please create it in Excel file format.>

    • Upload the file. (Please refer to the following)

      Select the Company and Transaction Type, specify the Start Line (indicating the line from which the upload information is set in the file created above; for example, '7'), add the outbound line item (FIFO), and click the Upload button."

       

      Select the file you want to upload.

      Check the execution result.

      When the import is complete, an execution result file will be generated. If there are no errors, the Doc No., IM Row No., and Accounting Doc No. will be recorded in the Doc No. Result

      If there is an error, the Doc No., IM Row No., and Accounting Doc No. will not be set, and the error details will be displayed in the error message field. If there is even one error, no documents will be registered.