DBD: Customer - Default Data
This section controls customer billing options, "Inventory permission (IMS)" and default settings. This document focuses on the three Customer Defaults screens.
Customer Defaults - first screen

-
Order Processing section
a. Is Customer PO Required? - Forces a client PO # to be entered on their orders.
b. Unique req – If the "Custom PO Required" box is checked, this forces a unique number to be entered on each order.
- Finder’s Fee section: Not covered.
-
Summary Billing/Detail Shipment Reporting section: Allows Invoice information to be accumulated in a file and reported to the customer periodically.
a. Summary Bill For: Order types to be included in summary bill: Enter ITW for all.
i. (I) Invoice, (R) Requisition, (W) Billable Requisition
b. Print Invoice for each Shipment
i. Enter Y for Yes and N for N 3 times for each order type (example: YNN).
- Monthly Shipment detail reporting: Check this option when Summary Billing or IMS permissions are activated. It records monthly shipment details to support summary billing and inventory management clients. Best Practice! STRONGLY Recommended!
- Do you wish to treat this customer as an IMS Customer?: Checking this box activates inventory management functions for this customer.
- Format code for Reorder notices (Blank = none): Must be a valid Flexible format code (Most companies will use formats U or V).
- Reduce On-hand by committed qty?: Checking this option reduces the quantity on hand by the committed amount. Recommended as standard for all IMS Customers.
Customer Defaults - second screen
Non-IMS customers will advance directly to this second screen of parameters.

Additional Parameters
-
Minimum Percentage Mark-up for all lines:
a. When set, upon exiting an order all lines will be reviewed, and the designated markup will be applied to all lines that do not meet this criterion. Not recommended!
- Require Entry of Ordered By in Order Entry? Checked equals Yes.
-
Require Entry of RC Number in Order Entry? Checked equals Yes.
a. This information is written to the EDW file and is used for User Generated reporting.
- Retain Sell Price during B/O Fill? Checked equals Yes.
- CC Plus: Alt Terms code if invalid credit card? Checked equals Yes.
- Merchant account: Overrides default Merchant Account.
-
Job Card Override in Invoice Printing:
a. This is a 3-digit code that corresponds to the Invoice Delivery option setting.
b. Allows a different set of printing rules for this customer’s invoices.
c. Also used to print invoices with a different company logo.
- Picking Priority: Used with WMS (Warehouse Management System).
-
Require Entry of Contract Number in Order Entry:
a. When set, Order Entry requires entry of a valid Contract number in the order header.
-
Send Inventory quantities to external system:
a. Used with Flowpoint integrations. Covered separately.
- 3rd Party Sender ID: Used with Flowpoint to output invoice data. Covered separately.
-
These next 3 fields used with custom Flowpoint integration. Covered Separately.
a. 3rd Party Sender ID – validated field
b. All Invoice lines
c. Include credit Lines
i. No Sig. Required
ii. S-Signature Required
iii. M-Mature Signature Required
-
Order Customer Reference to populate SH9 PKG_REF_1 and REF_2:
a. Drop Down allows a selection from 01 to 10.
b. These are 60 characters long.
c. This uses the "FV1-OrderCustRefs file."
d. Allows data to come in via eCommerce orders.
e. Used for reporting purposes.
f. Can be output to packing list.
- Use customer location code for PL receiving dept field: The "Receiving Department" is a 20- character field stored in the customer’s Ship-To. It can be output to the packing list (field 95). Checking this option overrides that output with the 9-character "Customer Location Code."
-
Sales Journal Bypass Custom Item Master Update:
a. The Sales Journal Update program will not update these fields when checked.
b. Cost: Cost Unit, Cost Qty/Unit, and Cost Amt/Unit.
c. Price: Price Unit, Price Qty/Unit, and Price Amt/Unit.
d. Vendor/Plant: Vendor and Plant.
e. Carton Weight
f. Carton Pack
-
If no warehouse specified in incoming XML order, default warehouse to use:
a. Dropdown option for Reg. orders and Purchase Orders.
b. Not generally used, requires special integration. Not Covered.
-
Monthly Budgets:
a. Requires setup of the Budget Module. Not covered.
- Click Next.
Customer Defaults - third screen

-
Freight Parameters:
a. Set up freight mark-up by order type. See document on Freight Markups for details.
- Foreign currently to print on invoice: Select from preset list (if applicable).
- Customer always gets lowest QBG price: Used with price plans.
- Tax Items received into Customer Owned Goods at time of release: This option charges tax on client owned releases based on the final shipping location (not standard).
-
Default Number of storage Months: how long is the planned Storage for items coming into the warehouse.
a. Defaults to order entry line.
b. "Calculates Storage Expiration" to the lot during "Purchase Order Receiving."
-
Product Code and Salesperson:
a. Override- if order line 001 has product code (selected), change the salesperson.
-
Substitute Digits of Warehouse Code for Packing List Printing Only ##:
a. Enter a 2-digit number to direct the printing of packing lists to a specified printer.
-
Immediate print speed bill invoice: Requires alternate invoice printing selection.
a. Dropdown options are:
i. Don’t ask, just print.
ii. Ask first.
iii. No.
-
Eliminate posting of sell in lot record for Dist owned during PO receiving?:
a. The System defaults sell price on “Bill as Ship” order type to “Lot Record”, at the time of receiving. Check to override.
-
Print Lot Value for Customer Owned Items in field 46 on Packing List:
a. Check to print the sell price for all items on Packing Lists.
-
Order lines with PO: Don’t invoice customer for overruns:
a. Check box if customer does not allow billing for overruns.
b. Overruns can still be received into the warehouse, but this can cause a difference in the quantity in inventory and quantity billed for reconciliation purposes.