Customer Inquiries (SU45)

The A1 - Account Info folder in Customer Consolidated Inquiries (ibis_su45) displays customer information created and maintained in Customers (ibis_sucu.su13) for the customer entered in the Header Section.

The following list defines every field available on the A1 folder:

  • Interest Code - the interest code defines the type of interest charge applied to overdue invoices. The following are valid codes:

    • M - Memo on Statement; interest is calculated and printed as a memo line on the statement from A/R Statement Print (ibis_ar85). No open item record is generated.
    • N - No Interest; no interest is calculated for this customer.
    • I - Produce Interest Invoice; interest is calculated, an open item record is generated, the calculated interest charge is printed on the statement (ar85) and a supporting invoice is printed.

  • Vendor Code - displays the vendor code that the customer uses to refer to your company; AR staff can assist the customer's AP staff in locating the vendor code used to pay your invoices.

  • Accept B/O - this check box indicates whether or not back orders are accepted by the customer.

    • When selected, the customer accepts back orders.
    • When this check box is not selected, the customer does not accept back orders. This sets the default (unchecked) for the 'Accept B/O' field in OE30, IN41 and RS41, but you can override the default as required. When an Order is entered that includes back orders for a customer that does not accept back orders, the back order quantity is still set in the order detail line. When the invoice is printed and the program detects that this customer does not accept back orders, "B/O" is printed in the Extension column and the following note prints on the bottom of the invoice: "***Any back ordered product has been cancelled. Please reorder.***". The back order line is automatically cancelled in Invoice and Credit Note Update (ibis_in43).

  • Default Order Type - displays the default order type assigned to the customer. Valid options include: regular, sample and FOB. The default order type determines the order type selection that automatically displays in OE30, IN41 and RS41.

  • B/O Fill Priority - the back order fill priority field determines the priority for releasing back orders. Valid priorities are 0 to 9; the higher the priority code, the higher the priority when back orders are released by Release Backorders (ibis_oe61) for non-order management customers.

    • For customers running order management, releasing back orders is incorporated into the stock allocation function within order management.
    • For customers with the same priority code, OE61 releases back orders in date sequence (oldest back orders are filled and released first).

  • Default to Import Order - this field is reserved for future use.

  • Order Confirmation Required - the order confirmation required check box indicates whether or not an order confirmation is required by the customer.

    • When the check box is selected, an order confirmation is required by the customer. Clicking on New in OE30 opens the Print Selection screen allowing you to select the order confirmation destination.
    • When the check box is not selected, an order confirmation is not required.

  • Customer Type - displays the customer type code assigned to the current customer. Valid options are 0 to 9. This field allows you to separate the GL accounts for up to 9 different types of customers.

    • The customer type is used in combination with the sales office and the product GL code to determine the specific GL control accounts for sales, cost of sales, inventory and ticketing recovery for all invoices processed through the invoicing module.
    • In CC00/Invoicing/General Ledger, the GL control accounts are defined for each combination of the sales office (from the sales order), the GL code (for the product), and the customer type code. This is also known as the inventory sales GL table or the GL relating table.
    • Note: When a customer record represents a warehouse or store location to process warehouse transfers, the customer type code is always set to '9'.

  • Mailing Label - mailing labels are based on the information:

    • The address from the customer record (ibis_sucu.su13) and the attention information from Customer Attention Codes (ibis_suma.su18).

  • Language - displays the language code used for sales order/invoice headings and product descriptions. Valid options are:

    • E - English
    • F - French

  • Order Stream Customer - when this check box is selected, the customer is included in the inventory update created from e-Sales Customer and Inventory Export File Creation (ES50). This option is only available to customers with Order Stream installed.

  • # Employees - displays the number of people employed by the customer (if applicable).

  • EDI Qualifier - this field is for display purposes only.

  • EDI ID - this field is for display purposes only.

  • Store - displays the store number of the customer, if applicable. The store number prints on sales orders and invoices.

  • Department - displays the department number for the customer, if applicable. The department number prints on sales orders and invoices.

  • Tax Group - displays the tax group for this customer. The tax group is used by the tax routine to calculate the appropriate taxes for the customer's order.

    • The tax group assigned to the customer becomes the default tax group used on the sales order in OE30/IN41/RS41.

  • Tax Lic 1 - the tax license 1 field typically displays the customer's goods & services tax (GST) license number. The tax lic. 1 prints on customer invoices.

  • Tax Lic 2 - the tax license 2 field typically displays the customer's provincial sales tax (PST) license Number. The tax lic. 2 prints on customer invoices.

  • Freight - displays the freight terms for the customer. The freight terms print on the invoice. Valid options are:

    • PR - Prepaid
    • CO - Collect
    • PC - Prepaid & Charge

  • Commission Group - displays the commission rate code assigned to the customer. This code represents one of the criteria used in S/A Commission Rates (ibis_sa02).

  • Ship Via - displays the ship via code for the customer. The ship via field in OE30/IN41/RS41 automatically displays this value. You can change the ship via option in OE30/IN41/RS41.

  • Print Discount - this field determines if the discount will print on the invoice.

    • When the check box is selected, the discount prints on the invoice.
    • When the check box is not selected, the discount does not print on the invoice.

      Note: The calculation for the line discount will be different depending the setting of the print discount field.

  • Summary Invoicing - when this check box is selected, summary invoicing is available for the customer. summary invoicing is an optional module. The summary invoicing option is available in OE30, IN41 and RS41.

  • Print Accrual Invoice - when this check box is selected, accrual invoices will print for this customer IF the global flag 'Print Accrual Invoices' in CC00/Summary Invoicing is also selected.

    • If the global flag is selected but the customer flag is not selected, then accrual invoices will not print for this customer. If the global flag is not selected, accrual invoices will never print.

    • Note: Accrual invoices for pre-bill sales offices always print.

  • Available to Retail Sales - when this check box is selected, the summary invoice option is active in RS41 for this customer.

  • Stock Allocation Priority - displays the stock allocation priority for Order Management customers. Valid options include:

    • High
    • Medium
    • Low

  • Apply Credit Limit Weight - when selected, the apply credit limit weight invokes a credit limit check. If the customer is over their credit limit, the appropriate weighting from CC00/Order Entry/Order Management/Priority Weightings is applied.

  • Apply Delinquency Weight - when selected, the apply delinquency weight invokes a delinquency check. If the customer's account is delinquent, the appropriate weighting from CC00/Order Entry/Order Management/Priority Weightings is applied.

  • Zone - displays the zone that represents location of the customer as defined in the Zones (ibis_suz) table.

  • WMS Info - the WMS button , when clicked, opens the WMS Info window:

    All of the fields displayed on the WMS Info window are set up in the Customers (ibis_sucu.SU13) view. They are displayed here for information purposes only.

    • Pack and Mark Separately - when this check box is selected, the pack and mark separately flag in OE30/General for this customer defaults to a Yes setting (i.e. the check box is selected).

    • Address Label Format - this field displays the address label document format name that is required for the current customer to print address labels in Elite WMS.

    • Container Label Format - this field displays the container label document format name that is required for the current customer to print container labels in Elite WMS.

    • Pick Label Format - this field displays the pick label document format name that is required for the current customer to print pick labels in Elite WMS.