Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
OverviewInstructions
Excerpt

Prebooks can be created through three different screens: the most common one is the "Add Prebook" screen, the second one would be through the E-commerce portal and last would be through an Excel file. You just have to fill in the proper information and upload the template to generate the Prebook(s).

You can create prebooks from three screens: Add Prebook, E-Commerce, or Create Prebooks from Excel. In this article, you will learn how to upload an XLS file that the system will use to create your Prebooks from the Create Prebooks from Excel screen.

Tip

Roles enabled to perform this action: Fulfillment, Admin, Sales Manager, Sales, Allocations, Procurement Manager.




Download, Prepare, and Upload the XLS File

If you want to start using this feature,

please follow

do the following instructions

below

:

  1. Go to Prebooks &

SO's >
  1. SOs and select Prebook Summary.

  2. Click

on the Actions button and then click on  "
  1. on Actions at the top of the list.

  2. Select Add Prebook from Excel File

"
  1. .

Image Removed

  •  

  • The system will take you to the "Create Prebooks from Excel" screen. This screen will allow you
    1. Click on the "here" link above the dotted line to download the template

    format to upload the Prebooks. To download the template, click on the "here" link located above the dotted line. On the right side, you will see the instructions
    1. .

    2. Follow the instructions on the right side of the page on what each column should have.

     

    Image Removed

    This is the full list of the fields that are included in the excel template:

    Image Removed

     

    For Multi-Location companies, there's the option to enter the Location Code. It will appear in the Excel file.This code is required to assign the prebooks to that specific Location. 

    Image Removed
    1.   

    2. Once your template is completed, save the file and then drag it to the dotted section or click on the dotted line to upload the file.

    3. When the file is successfully uploaded, the system will create the Prebook using the information on the XLS file.

    Keep in mind that this process can take

    a few

    minutes to

    be

    complete.

    In case For you to verify the prebooks

    If the file is not uploaded, you will receive an email notifying you of the errors.

    Image Removed

    For Multi-Location companies:

    You must enter the Location Code in the XLS File so the system can assign the Prebooks to the specific Location.

    Tip

    To verify the Prebooks were created, go to

    the

    the Prebook Summary

    tab

     tab and verify the last

    prebook titleRelated Articles

    Prebook created has the information you entered.

    Panel
    Image AddedImage Added
    false

    Filter by label (Content by label)
    showLabelsfalse
    max5
    sorttitle
    titleRelated Articles
    showSpace
    cqllabel in ( "create-prebook" , "prebooks-creation" , "add-prebooks" )
    labelsadd-prebooks prebooks-creation create-prebook

    We've encountered an issue exporting this macro. Please try exporting this page again later.