Versions Compared

Key

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

...

Overview

...

Komet Sales allows uploading external information into

...

the system by using

...

API methods. However, from the Data Import section, users are allowed to upload Open Invoices, Inventory in Boxes, Hard Goods, and

...

Open Credits directly into the system.

...

Image Removed

...

titleUpload External Invoices Into Komet Sales

The system allows to upload an Excel file with a certain structure; all the records on it will be processed as Open Invoices in Komet Sales. Please follow the following instructions in order to upload external invoices:

1) Go to Setup>>Data Import.

2) The Data Import screen will open. The first step is to select the type of information you want to upload. Select Open Invoices. From this screen, users can upload the Excel file with all the invoice information to be imported into Komet Sales. The Excel file must contain the following columns:

Image Removed

...

3) Once the file has been uploaded, a message will appear at the top of the screen:

4) An email notification will be sent out with the results of the importing process. If the process is successful, an email will be sent to the logged on user. If some registers cannot be uploaded, the system will send an email notification a link where users can review the reasons why the registers were not imported into Komet Sales.

Image Removed

 

5) Once the information is uploaded, you can validate the information either from the Order Summary or the Open Invoices screens by searching for the Customer PO # or Invoice Date. 

Image Removed

 

This is how the invoice detail will look. Notice that the carrier is "No Carrier" and that the total of the invoice is saved as an Additional Charge.

Image Removed

Expand
titleUpload Open Credits Into Komet Sales

The system allows you to upload an Excel file with a certain structure; all the records on it will be processed as Open Credits in Komet Sales. The open credits uploaded for the customer will be saved in the system as Balance adjustments for the customer. Please follow these instructions in order to upload them:

1) Go to Setup>>Data Import.

2) The Data Import screen will open. The first step is to select the type of information you want to upload. Select Open Credits. From this screen, users can upload the Excel file with all the invoice information to be imported into Komet Sales. Download here an example of the Excel file. Keep in mind that the credit balance must be a positive number.

3) Upload the file into the selected area and wait a couple of seconds.

4) An email notification will be sent out with the results of the importing process. If the process is successful, an email will be sent to the logged on user. If some registers cannot be uploaded, the system will be sent an email with a link where users can review the reasons why the registers were not imported into Komet Sales.

Image Removed

Expand
titleUpload Inventory in Boxes Into Komet Sales

To upload inventory in boxes into Komet, follow the same steps explained on How to Upload Inventory in Boxes. This process can be performed either from the Add Inventory or from the Data Import screen.

 

 

Panel
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max10
sorttitle
showSpacefalse
labelsopen-invoices external-system data-import order-summary

...

titleImportant

...

This screen will only be available for Admin users.

...

Child pages (Children Display)
styleh3
excerptTyperich content
We've encountered an issue exporting this macro. Please try exporting this page again later.