Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Overview

Enabling the Credit Limit feature within X Dispatch permits a user to import and reference QuickBooks accounts receivable and aging data to easily monitor the line of credit for a specific Customer. This tool can ensure that orders are not placed for any Customer who is over their credit limit, warn when a Customer has reached their credit limit, and can keep track of the invoiced and un-invoiced order amounts.
 
Important Notes:
  • Imported A/R records are updated according to the specific schedule set in the Credit Calculations X Stream Definition.  For assistance updating that interval please contact Customer Support. 
  • Credit Limits are not currently supported by Rapidship Client, look for this in a future release.  

Credit Limit Permissions

To set Permissions for an X Dispatch user to manipulate the Credit Limit feature:
  • Navigate to Maintenance > Permissions and open the Permission record for the User ID you would like to configure.
  • Expand X Dispatch Functions > Customers then select if you would like to allow the user to View Credit Limits, Edit Credit Limits, and/or Import Credit Limit Data.
  • Press OK to save and close the Permission record.

Enable Credit Limit

To enable the Credit Limit feature open the Customer record follow the steps below:
  •  Navigate to Maintenance > Customers and navigate to the Invoices tab.
  • Check the Enable Credit Limit box.  
  • Fill in the Credit Limit amount you want to set for this specific Customer.
  • Save and close the Customer record.

    Overview of each field in the Credit Limit window.  

Configuring Credit Limit Enforcement

To configure the Credit Limit Enforcement follow the steps below:
  • Open the Global Options form from the top menu bar.

  • From the Accounting tab users can configure X Dispatch notifications and enforcement of the Credit Limits feature by selecting to Ignore, Warn, or Enforce.  
  • Users can configure to Ignore or Enforce functionality for X Internet.

  • If set to Ignore, all orders can be placed in X Dispatch and X Internet regardless of  the Credit Limit that is set on the Customer record.
  • If set to Warn in X Dispatch, the following warning are displayed upon entering the Customer ID when placing any On-Demand order or editing any posted Route Stop.

  • If set to Enforce in X Dispatch, the following warning are displayed upon selecting the Customer ID. 

  • If set to Enforce in X Internet, the following warning will appear at the top of the order entry page after selecting the Customer ID.

 

Important Note: The Warn and Enforce message for all orders placed inside of X Dispatch is set by CXT Software.  

The Credit Exceeded Message for use in X Internet is set by the user.  To set the Credit Exceeded Message follow the steps below:

  • Navigate to the X Internet tab inside of the Global Options form.
  • Enter your company's message in the Credit Exceeded Message field.  

QuickBooks Import

Exporting from QuickBooks

The configuration of the export done in QuickBooks is critical to a successful import into X Dispatch.  Once a payment has been applied in QuickBooks to the Customer(s) you are updating in X Dispatch take the following steps to export the file:

  • In QuickBooks navigate to Report > Customers & Receivables > AR Aging Detail.
  • Open Customize report and select on the Filters tab.
  • From Filters select Account.
  • From the Filter choices select Paid Status.
  • From Paid Status click the Either radio button.
  • Select OK which will close the window.
  • From the menu select Memorize then enter in a name to save the filter with and click OK. 
  • The A/R Aging Detail form is still open, click the Excel drop-down button.
  • Select Create New Worksheet.
  • Export the comma separated .CSV file with a File Name of your choosing.

Use this memorized report with the set Filters to export each time for use in X Dispatch.  

Important Note: These steps are taken from QuickBooks Pro 2015 and may be different with each version.  

Importing to X Dispatch

To import a .CSV from a QuickBooks export:

  • Open X Dispatch, click the Action menu drop-down and select Import A/R Data.  
  • Navigate to the location of the file to be imported and select Open.  

  • Once you select Open you will then see an Import Complete popup.  Click OK to close the window.

The newly imported A/R data will then be queued to be updated according to the specific interval set in the Credit Calculations X Stream Definition

Once the X Stream Definition is run, the Outstanding Invoiced aging data is updated inside the Customer record.  

Update A/R QuickBooks data as often as possible to keep the X Dispatch Customer records up to date.

For assistance updating the X Dispatch queue interval, please contact Customer Support.

Troubleshooting

If you encounter the message displayed in the image below after importing a .CSV file through Action > Import A/R Data, follow the instructions listed in the message and verify the file is correct.  If you are unsure why you are receiving this error, you can re-export the file from QuickBooks and try again.  Generally the error is displayed because a footer for the last category was not included in the source file.    
 
  • No labels