Versions Compared

Old Version 67

changes.mady.by.user Former user

Saved on

compared with

New Version 68

changes.mady.by.user Former user

Saved on

Key

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

Overview

Excerpt

Komet Sales allows the uploading of vendor invoices in order to synchronize them with your company's External Accounting System. If the company has a QuickBooks integration active, the user will have the option to synchronize Vendor invoices with QuickBooks.

Info

To enable the QuickBooks integration please contact Komet Sales.

Instructions:

 

To be able to synchronize vendor invoices with the external accounting system follow the instructions below:

Ui steps
sizesmall
Ui step

The vendor must confirm and ship the purchase order, and upload their invoice to Komet following the instructions provided in .

Ui step

 The Accounting and Procurement users must approve the invoice by following the  instructions.

Ui step

Once approved, go to Accounts Payable (A/P) > PO Reconciliation > click on the Actions button and select the option "Send to External System". At this point, the Vendor Invoice Status will be changed to "Sent to External System". This process takes a second unless the invoice is unable to be synchronized.

Ui step

Following this, the system will synchronize the data from Komet with the external system, and once done the Vendor Invoice Status column will change to "S" (Synchronized). 

Ui step

Finally, the invoice will be synchronized with the External System and the user will be able to process payments for that invoice within the external system.

Warning

The system will only synchronize vendor invoices approved by Procurement and Accounting users.

 

 

Panel
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
sorttitle
cqllabel in ("grower","accounting","purchase-orders","quickbooks")
labelspurchase-orders, Grower, accounting, quickbooks

Warning
titleInvoices Without Additional Charges

The system will prevent Sending to an External system any POs without additional charges associated.

Ui expand
titleCompanies using QuickBooks

The following items must be taken into account when using the QuickBooks Integration with Komet.

  • The vendor account within Komet should have the same QB Accounting name as the one assigned in QuickBooks. 
  • The Purchase Order in Komet will be transferred as a "Bill" in QB.
  • The Bills Reference Number in QB will be composed by the Purchase Order number and the vendor invoice number assigned in Komet. 
  • The Bills Date in QB will be the same as the Ship Date in Komet.
  • A Bill Item must be first created in QB.

    Image Modified

    In this case, the Bill item created is called "Flowers"

    Image Modified
  • By the default, the product description in QB will always be "Fresh Cut Flowers", but there is also the option to use the product description already created within QB. If you want to use a product description different from "Fresh Cut Flowers", please contact us  so we can make any necessary dose adjustments. 
  • The Bills totals in QB will be the same as the Komet PO total. 
  • The PO must be associated to a vendor with an Accounting Name.
  • The PO must have an invoice number which is the one the vendor uploads from the Grower Portal.

Info

If using different QuickBooks classes, please contact Komet Sales to have this option enabled.


Ui expand
titleQuickBooks Setup
Info
titleInformation
  • The user must have an admin role in QuickBooks.
  • This setup will only work for the Desktop version of QuickBooks.

Generating the komet_sales.qwc File:

In order to setup QuickBooks, follow the steps below:

Ui steps
sizesmall
Ui step

Contact Komet Sales to activate this option.

Ui step

 Once the option has been activated, Komet will notify you, so you can proceed with the integration.

Ui step

 Next  Next go to "Setup" > "Settings" > "Integrations" > "QuickBooks".

Ui step

 A  A pop-up window called "QuickBooks" will appear. 

Ui step

Click on the "Download" link to download a file called komet_sales.qwc. This file is for users to configure the integration between Komet Sales and QuickBooks. The user should then add the file in QuickBooks. 

Image Modified

 

Adding the komet_sales.qwc File into QuickBooks

Log on to your QuickBooks account to continue with the integration and follow the instructions below:

Ui steps
sizesmall
Ui step

Click on File> Update web services.

Ui step

 A  A new window will pop-up, click on the "Add an application" button.

Ui step

 A  A window to select the file needed will pop up. Look for the "komet_sales.qwc" file.

Ui step

 The  The Authorize New Web Service window will pop-up showing the file information. Click on the "Ok" button.

Ui step

The system will prompt you to specify the permissions that should be given. Please choose the "Yes, whenever this QuickBooks company file is open" option and click on Continue. Another window called Access Confirmation will appear; you should click on Done.

 

Ui step

Find the Komet Sales application within QuickBooks in order to add the password (token integration) provided by Komet Sales, this is mandatory.

 

Info
titleToken Generation

Make sure of creating a token from your Komet Sales account without any API method associated, the description could be "Quickbooks ". This token can be used within the Quickbooks system as a password.

Image Modified

Ui step

To complete the activation, check the box on the left side of the Komet Sales option in the "Application" column, followed by clicking on "Update Selected" button.