Versions Compared

Key

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

Table of Contents

Overview

...

Table of Contents

Enabling the credit limit feature within X Dispatch allows 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.  

 

...

Note
  • Imported A/R records are updated according to the specific schedule set in the Credit Calculations X

...

...

  • For assistance updating

...

...

  • limits are not currently supported by Rapidship Client

...

  • .

...

How to Set or Edit Credit

...

Limits Permissions

...

for X Dispatch Users

You can set permissions for an X Dispatch user to

...

use the

...

credit limits feature. See Users (Classic Operations App).

  1. Go to Maintenance > Permissions

...

  1. .
  2. Select the user you would like to

...

  1. set or edit credit limits permissions for.

...

  1. Click the '+' next to X Dispatch Functions

...

  1. .
  2. Click the '+' next to Customers.
  3. Select which permission you would like to

...

  1. set for the user

...

  1. by checking, or unchecking, View Credit Limits, Edit Credit Limits, and/

...

  1. or Import Credit Limit Data.
  2. Press OK to save and close the

...

  1. permission record.

...

Image Added

How to Enable Credit

...

To enable the Credit Limit feature open the Customer record follow the steps below:

...

Limits for Customers

You can set a credit limit on the customer record. See Customers - New/Edit Customer.

  1. Go to Maintenance > Customers.
  2. Select and open the customer record you would like to set a credit limit on. 
  3. Go to the Invoices tab.
  4. Check
the
  1. the Enable Credit
Limit
  1. Limit box.  
Fill in the
  1. Enter the Credit Limit
amountyou
  1. amount you want to set for
this specific Customer.Saveand close the Customer record.

Image Removed

Overview of each field in the Credit Limit window.  

Image Removed
  1. the customer.
  2. Click the Save button.

Image Added

Configuring Credit Limit Enforcement

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

Image Removed

  • From theAccountingtab users can configureX Dispatchnotifications and enforcement of the Credit Limits feature by selecting toIgnore,Warn, orEnforce.  
  • Users can configure to IgnoreorEnforcefunctionality forX Internet.

Image Removed

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

Image Removed

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

Image Removed

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

 Image Removed

...

The configuration of credit limits enforcement is done in the global options. See Global Options.

Click the Options button in the toolbar.

Configure Enforcement in X Dispatch and/or X Internet

  1. Go to the Accounting tab.
  2. Go to Enforce X Dispatch Credit Limit and/or Enforce X Internet Credit Limit and select how you would like to enforce credit limits. You can choose between:
    • Ignore - Any credit limit set on a customer record will be ignored and all orders can be placed.
    • Warn - This option is only available for Enforce X Dispatch Credit Limit. A warning will be displayed when entering the Customer ID of a customer with a credit limit when placing an order or editing any posted route stop.
      Div

      Image Added


    • Enforce - A warning will be displayed when entering the Customer ID of a customer with a credit limit when placing an order or editing any posted route stop. See Configure Internet Credit Exceeded Message for the warning message in X Internet.
      Div

      Image Added


      Info

      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 theX Internettab inside of the GlobalOptions form.
  • Enter your company's message in theCredit Exceeded Messagefield.  

Image Removed

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 toReport > Customers & Receivables > AR Aging Detail.
  • OpenCustomize report and select on theFilters tab.
  • FromFilters select Account.
  • From theFilterchoices select Paid Status.
  • FromPaid Status click theEitherradio button.
  • SelectOKwhich will close the window.
  • From the menu select Memorize then enter in a name to save the filter with and clickOK. 
  • The A/R Aging Detail form is still open, click theExceldrop-down button.
  • SelectCreate New Worksheet.
  • Export thecomma separated.CSV file with a File Name of your choosing.

Use this memorized report with the set Filters to exporteachtime 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:

  • OpenX Dispatch, click theActionmenu drop-down and selectImport A/R Data.  
  • Navigate to the location of the file to be imported and selectOpen.  

Image Removed

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

Image Removed

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

Once theX Stream Definitionis 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.    
 

...

    • and cannot be changed,


  1. Click OK or continue to the steps below to configure the internet credit exceeded message.

Anchor
creditExceededMessage
creditExceededMessage
Configure Internet Credit Exceeded Message

  1. Go to the Internet Options tab.
  2. In the Orders section under Credit Exceeded Message, enter the text you would like to display.
  3. Click OK.

Export from QuickBook and Import to X Dispatch