Credit Allocations record overview

The Credit Allocation Setup page creates a credit allocation record. The data can be entered manually through the DTN TABS web interface or uploaded with an ADMLOD file.

Credit Allocations record setup field descriptions

The following fields are available on the Credit Allocations Setup page.

Field Description
Credit Name (Customer ID):

Identifies the credit name associated with the customer’s accounts receivables name. The credit name is a unique 1 to 50 character, alphanumeric identifier.
Status:

Specifies the status of the credit record. Options are:

  • Enforced
  • Unenforced
  • Deny
  • One time
  • Open
Currency:

Displays the default country currency used to calculate the credit price values.
Enforce Full Truck:

Indicates the customer must have available credit in the estimated amount of a full truck load, when selected.  If it is not selected, then the customer can have any positive amount remaining in the credit allocation and be allowed to lift.
Credit Limit: Identifies the credit limit amount assigned to the credit record.
Pre-Paid Amount: Provides the amount the customer has prepaid on the credit account.
Valued BOLs: Contains the value amount of the BOLs that have not been invoiced by the suppliers back office.  This information come from the Credit Account updates from the suppliers back office.
Orders:

Provides the dollar balance for non-Fuel Marketing scheduled transactions that impact credit but have not yet reached the receivables balance.

The dollar value is deducted from the amount in the Credit Limit field.  Classified as a Debit Type, it calculates a customer’s remaining credit.

This field name can be changed or removed from the Custom Display Options page.
Special Liabilities:

Contains the dollar balance for any special liability for the customer in SAP that id deducted from the amount in the Credit Limit field.

Classified as a Debit Type, it calculates a customer’s remaining credit.

This field name can be changed or removed from the Custom Display Options page.
Receivables:

Indicates the dollar balance for special liabilities for the customer in SAP.

Classified as a Debit Type, it calculates a customer’s remaining credit by deducting from the amount in the Credit Limit field.

This field name can be changed or removed from the Custom Display Options page.
Credit Adjustments: Adds or deducts from a customer’s credit limit.  Used when identifying prepay customers. Classified as a Credit Type, it calculates a customer’s remaining credit.
Total Credit Remaining:

Specifies the amount of the following formula:

Credit Remaining = Credit Limit + Credit Adjustment – (Receivables + Orders + Special Liabilities + In Process BOL Balance + Unprocessed BOL Balance + Credit Hold Balance)
Unprocessed BOLs: Describes the total estimated load cost of all Unprocessed BOLs.  These are BOLs that have been received in DTN TABS but not yet downloaded by company.
In Process BOLs: Defines the total estimated load cost of all In-Process BOLs.
Credit Hold Balance:

Provides the amount of currency reserved against the customer’s credit remaining when a load is authorized prior to the receipt of the BOL.  The following formula is used:

Dollars reserved against remaining credit = Configured Decrement size of a load x  Average Fuel Price currently in effect + Federal Tax Amount + State Tax Amount
Pre-Ordering Hold Balance: Identifies the amount of currency, on hold, for the credit account for outstanding pre-orders.
Credit Decrement Amount:

Indicates the amount used to calculate the credit hold amount and the volume or weight used. Options are:

  • Gallons
  • Imperial Gallons
  • Imperial Ton
  • Kilo Barrels
  • Kilograms
  • Liters
  • Metric Ton
  • Pounds
  • Ton
Use Standard Truck Size: Indicates that credit process should use the standard truck size to calculation the estimated credit amount during the authorization process.
Credit Analyst: Displays an assigned Credit Analyst for the credit allocation.  This list of Credit Analysis is setup in the Data Management > Customer Attributes.
Risk Category: Specifies an assigned Credit Risk Category for the credit allocation.  This list of Risk Categories is setup in the Data Management > Customer Attributes.
Sales/Territory Manager: Contains an assigned Sales Rep or Territory Manager for the credit allocation.  This list of managers is setup in the Data Management > Customer Attributes.
Comments: Provides an area for entering user notes about the credit allocation.

Note: Comments are limited to 2000 characters. Do not use commas. Make this field required by selecting the Enforce Comment Rules in Credit Setup option on the Defaults page (Admin > TABS Defaults). Then the system requires the user to enter a comment when the remaining amount is set to 0 (zero) or when the Active field is not selected when no comment currently exists.

Credit Allocations record best practices

Credit Allocations should always be managed by the Customer SoldTo Credit Consignee Group across all terminals.

  • Enables control across all facilities

  • Provides one entry point for edits and modifications making troubleshooting credit issues easier

Suggested Credit Record Naming Convention:

  • Customer Name Master Credit SoldTo

    • ABLE GAS 12294

Category: FAQs