Customer Allowance Adjustment Import Format

A

1

Customer Code

12

Character

Yes

Enter a valid active customer code for the customer allowance adjustment. For information on setting up customers, see Customer Maintenance.

B

2

Location Prefix

3

Character

Yes

Enter a valid location prefix for the customer allowance adjustment. For information on setting up locations, see Location Maintenance.

C

3

Customer Allowance Type

12

Character

Yes

Enter a valid customer allowance type for the customer allowance adjustment. For information on setting up customer allowance types, see Customer Allowance Type Maintenance.

D

4

Allowance Account

29

Character

Yes

Enter the allowance account for the customer allowance adjustment. This field must be formatted with hyphens, decimals, spaces, etc., according to your general ledger setup.

E

5

Allowance Amount

11

Decimal

Yes

Enter the amount of the customer allowance adjustment. You can enter an amount between -9999999.99 and 9999999.99.

F

6

Allowance Offset Account

29

Character

Yes

Enter the allowance offset account for the customer allowance adjustment. This field must be formatted with hyphens, decimals, spaces, etc., according to your general ledger setup.

G

7

Product Range

13

Character

Yes, only if the Posted to General Ledger field (position 10) is No or blank

Enter one of the following:

• All - The customer allowance adjustment is for all products.

• Product - The customer allowance adjustment is for a specific product.

• Product Style - The customer allowance adjustment is for a specific product style.

• Category - The customer allowance adjustment is for a specific product category.

• Subcategory - The customer allowance adjustment is for a specific product subcategory.

NOTE Leave this field blank if you enter Yes for the Posted to General Ledger field (position 10).

H

8

Product Code/Style/Category

40

Character

Yes, only if Product, Product Style, Category, or Subcategory is entered for the Product Range field (position 7)

Enter the product code, product style, or product category for the customer allowance adjustment. The value you enter is based on the value entered for the Product Range field (position 7).

I

9

Product Subcategory

12

Character

Yes, only if Subcategory is entered for the Product Range field (position 7)

Enter the product subcategory for the customer allowance adjustment. This field is only used if you enter Subcategory for the Product Range field (position 7).

J

10

Posted to General Ledger

3

Yes/No

No

Enter Yes to mark the customer allowance adjustment as posted to the general ledger.

Note If you enter Yes for this field, the import affects profitability data as if invoices were posted for an order that met the criteria of a customer allowance rule. However, the import does not impact the general ledger or create a journal entry. As a result, you must manually make journal entries for allowance adjustment amounts to allowance and allowance offset accounts if necessary.

Enter No to not mark the customer allowance adjustment as posted to the general ledger. If you enter No for this field , the record is displayed in Customer Allowance Adjustment Entry.

If this field is blank, it defaults to No.