Versions Compared

Key

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

Table of Contents


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.

...

Image Added

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.

...

  • Image Added

    Overview of each field in the Credit Limit window.  

...

  • Image Added



Configuring Credit Limit Enforcement

To configure the Credit Limit Enforcement follow the steps below:
  • Open the Global

...

  • Options

...

  • form from the top menu bar.

...

Image Added

  • 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.

...

Image Added

  • 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.

Image Modified

  • If set to

...

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

Image Modified

  • 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.

 Image Modified

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.  

Image Modified

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.  

Image Modified

  • Once you select Open you will then see an Import Complete popup.  Click

...

  • OK

...

  • to close the window.

Image Modified

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

...

...

...

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.    
 
Image Modified