Versions Compared

Key

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

Overview

Prebooks are normally created through three different screens: the most common one is the "Add Prebook" screen and the other one is through Future Sales within your Komet Sales account or through the E-commerce portal. Komet also allows you to use an excel file to create Prebooks. You just have to fill in the information on the template and upload it in order to generate the Prebook.

Instructions
Excerpt

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

where you will be able to type in the Prebook information. To download the template, click on the "here" link located above the dotted section of this page. On the right side, you will see the instructions under the XLS Format title. 

Image Removed

For Multi-Location companies, there's the option to enter the Location Code. It will appear in the Excel sample.This code is to assign the Location to the prebook that will be created. 

Image RemovedOnce your template has the information to create the Prebook
  1. .

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

  3. Once your template is completed, save the file and then drag it to the dotted section or click

within
  1. on the dotted line to upload the file

to the system
  1. .

Once
  1. 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 something is wrong with

If the file

you

is not uploaded, you will receive an email

notification with For you to verify that the prebook was

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 and use the filters to find

 tab and verify the last Prebook created has the information you entered.

Panel
titleRelated Articles
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.