Customer Setup - General Ledger field descriptions

Fields are listed alphabetically within each section

General Ledger

Customer General Ledger Control Account

The Customer Control account accumulates the total invoice amount for each invoice generated for the customer. It can be used to confirm the customer's outstanding balance. This account code is updated during Customer Batch Update Entry Report, Customer Cash Receipts Entry, Customer Transaction Entry, Sales Entry Processing Invoice Processing Report, Sales Order Entry received on account and Customer Entry Roll Balances Report service charges.

Bank General Ledger Control Account

If no Customer Bank account code is set up in CR Banks Setup, then the Customer Bank account specified here is used to accumulate the total amount of cash received from this customer through Customer Cash Receipts Entry and Sales Order Entry tendering and received on account.

Discount General Ledger Account

The discount is determined when the invoice is paid. It is calculated from the terms code specified on the invoice. If the invoice is paid within the number of days specified, the discount is subtracted from the total amount due. The Customer Discount account accumulates the discounts taken on all invoices through Customer Cash Receipts Entry and Customer Transaction Entry.

Income General Ledger Account

The Customer Income account accumulates the total amount of income earned from this customer. It automatically defaults into the first account code line of the General Ledger distribution window in Customer Transaction Entry and Customer Batch Transaction Entry in the system.

Income General Ledger Account

Core Conversion

This account is updated for the difference between a core product's market cost and vendor cost when you process incoming inventory in Purchase Receipt of Inventory Entry.

This account is also updated if the replacement cost changes between order creation and when the customer invoice is created in the Sales Entry Invoice Processing Report.

Cost of Goods

The cost of goods sold is the cost of each product sold to the customers within the update selection made in Product GL Distribution Setup.

Cost of Goods Adjustment

This account is updated by Vendor Invoice Center Entry when adjustments must be made to the product or addon cost variance. This keeps your Cost of Goods account 'clean' of incidental adjustments.

Cost of Goods Returned

Specify the account to credit with the cost of a product that is returned to inventory. This field is only available when Use Separate COGS Accounts for Returns in SA Administrator Options-Product-Costs is selected.

Dir Order Cost of Goods

Use this account to track the cost of Direct Orders (DO) and Line DOs entered in Sales Order Entry. You can separate the cost of direct order goods from the regular cost of goods sold to perform profit analysis on the direct order sales.

When a returned line is applied against an invoiced DO or Line DO, this account and the Direct Order Sales account are used by default when the Sales Entry Invoice Processing Report is run. When Allow Direct Order Returns is selected in SA Administrator Options-Documents-Sales Orders-Entry Settings, this account and the Direct Order Returns account are used.

Dir Order Cost of Goods Returned

Specify the account to credit with the cost of a direct order product that is returned to the vendor by the customer. This field is only available when Use Separate COGS Accounts for Returns in SA Administrator Options-Product-Costs is selected.

Direct Order Returns

Specify the account to debit when a product on a direct sales order is returned to the vendor by the customer. This field is only available when Allow Direct Order Returns in SA Administrator Options-Documents-Sales Orders- Entry Settings is selected.

Direct Order Sales

The Direct Order Sales account is used to account for Direct Order (DO) and Line DO sales. You can separate gross sales and direct order sales to perform profit analysis on direct orders.

When a returned line has been applied against an invoiced line that was a Direct Order (DO) or Line DO, this account and the Direct Order Cost of Goods account are updated when the Sales Entry Invoice Processing Report is run. When Allow Direct Order Returns is selected in SA Administrator Options-Documents-Sales Orders-Entry Settings, the Direct Order Returns and Dir Order Cost of Goods accounts are used.

Gross Sales

The Gross Sales account represents the gross sales for all customers grouped within the update selection made in SA Administrator Options-Products-Costs. The gross sales are the sales before any line or order discounts are subtracted.

IC Rebate Writeoff

Use this account to post rebates that are written off.

Line Discounts

Line discounts represent the amount of discount given on each line of an order entered in Sales Order Entry. Line discounts may be offered as a customer's standard pricing format, a discount from price rather than a discounted price.

Order Discount

The order discount is calculated at the end of an order and is prorated back to each line during Sales Entry Invoice Processing Report. This account represents all order discounts given to the customers grouped within the update selection made in SA Administrator Options-Products-Costs. Order discounts include whole order discounts and special price type discounts.

Rebate Cost Adjust

Rebates may be used to adjust costs on specific items without adjusting their average cost. If a rebate is based on when an item is sold, this account is updated by the Sales Entry Invoice Processing Report. To lower your cost of goods sold, specify the same account number as your cost of goods sold. If the rebate is based on when you purchased it, the inventory value is adjusted rather than the cost. Therefore, this account would not be affected.

Restock Charge

The restock charge represents the charge for restocking returned merchandise. If restocking charges are to be distributed to a separate account, enter the account number in this field. This account is credited for charges received from customers, and is updated by the Sales Entry Invoice Processing Report.

Sales Returns/Allow

Use this account to track sales order returns. It is updated by the Sales Entry Invoice Processing Report. All returns are recorded in this account except Direct Order (DO) returns. DO returns are posted to the Direct Order Sales account by default. When Allow Direct Order Returns is selected in SA Administrator Options-Documents-Sales Orders-Entry Settings, DO returns are posted to the Direct Order Returns account.

WT Cost Adjustments

This account is updated by Vendor Invoice Center Entry under these conditions:

• The cost of a warehouse transfer needs to be adjusted
• The transfer was filled by a purchase order
• The transfer has already been shipped before the purchase order was costed