Versions Compared

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:

 

.

Ui text box
sizelarge
typewarning

ATTENTION: Companies Using Quickbooks

KOMET SALES IS NO LONGER SUPPORTING THIS INTEGRATION.

We are in the process of investigating to offer you full integration with Quickbooks Online.

We apologize for any inconvenience this may cause. 


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.

Image RemovedImage Added

Warning

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

 

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 The system will prevent Sending to an External system any POs without additional charges associated.


ui-text-
expand
box
title
In this case, the Bill item created is called "Flowers"
Image Removed
  • 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 go to "Setup" > "Settings" > "Integrations" > "QuickBooks".

    Ui step

     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 Removed

     

    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 stepClick on File> Update web services.
    Ui step A new window will pop-up, click on the "Add an application" button.
    Ui step A window to select the file needed will pop up. Look for the "komet_sales.qwc" file.
    Ui step The Authorize New Web Service window will pop-up showing the file information. Click on the "Ok" button.
    Ui stepThe 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 stepFind 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 Removed

    Ui stepTo 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.
     
    size
    Companies 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 Removed
    medium

    (lightbulb) Roles enabled to perform this action: Admin, Accounts Payable, Procurement, Procurement Manager.



    Ui text box
    sizelarge
    typewarning

    ATTENTION: Companies Using Quickbooks

    KOMET SALES IS NO LONGER SUPPORTING THIS INTEGRATION.

    We are in the process of investigating to offer you full integration with Quickbooks Online.

    We apologize for any inconvenience this may cause. 



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