AutoAccounting Account Types and Segment Values

Define AutoAccounting to specify how to determine the default general ledger accounts for transactions that you enter manually or import using AutoInvoice.

You must define AutoAccounting before you can enter transactions in Receivables. When you enter or update transactions, you can override the default general ledger accounts that AutoAccounting creates.

Account Types

Define an AutoAccounting record for each type of account. You can then assign either a table name or constant value to each segment of the account.

AutoInvoice Clearing

The clearing account for imported transactions. Receivables uses the clearing account to hold any difference between the specified revenue amount and the selling price times the quantity for imported invoice lines. Receivables only uses the clearing account if you have enabled this option on the transaction source used for imported transactions.

Bills Receivable

The bills receivable account for your transactions. Receivables uses this account when you apply transactions to bills receivable.

Factored Bills Receivable

The factored bills receivable account for your bills receivable transactions.

Freight

The freight account for transactions.

Receivable

The receivable account for transactions.

Remitted Bills Receivable

The remitted bills receivable account for your bills receivable transactions.

Revenue

The revenue and late charges account for transactions.

Tax

The tax account for transactions.

Unbilled Receivable

The unbilled receivable account for transactions. Receivables uses this account when the transaction uses the In Arrears invoicing rule. If the revenue scheduling rule on the transaction recognizes revenue before the invoicing rule bills it, Receivables uses this account.

Unearned Revenue

The unearned revenue account for transactions. Receivables uses this account when a transaction uses the In Advance invoicing rule. If the revenue scheduling rule on the transaction recognizes revenue after the invoicing rule bills it, Receivables uses this account.

Unpaid Bills Receivable

The unpaid bills receivable account for your bills receivable transactions.

Table Names

Enter either the table name or constant value that you want Receivables to use to retrieve information for each accounting flexfield segment of a given account.

Enter a constant value instead of a table name if you want AutoAccounting to always use the same value for a given segment.You must ensure that you enter valid information for this segment.

For example, if you defined your Company segment as a two-character segment with valid values ranging from 00 to 10, you must only enter a two-character value within this range.

Bill-to Site

Use the bill-to site of the transaction to determine this segment of revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue accounts.

Drawee Site

Use the drawee site table to determine this segment of your bills receivable, factored bills receivable, remitted bills receivable, and unpaid bills receivable account.

Remittance Banks

Use the remittance banks table to determine this segment of your factored bills receivable and remitted bills receivable account.

Salesperson

Use the salesperson table to determine this segment of revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue accounts.

If you select this option for AutoInvoice clearing, tax, or unearned revenue accounts, Receivables uses the revenue account associated with the salesperson on the transaction. If you select this option for the unbilled receivable account, Receivables uses the receivable account associated with the salesperson on the transaction.

If the transaction has a line type of Line with an inventory item of Freight, AutoAccounting uses the revenue scheduling rules for the freight account rather than the revenue account.

Standard Lines

Use the memo line or inventory item on the transaction to determine this segment of revenue, AutoInvoice clearing, freight, tax, unbilled receivable, and unearned revenue accounts.

If you select this option for AutoInvoice clearing, freight, tax, unbilled receivable or unearned revenue accounts, Receivables uses the revenue account associated to the memo line item or inventory item.

If the transaction has a line type of Line with an inventory item of Freight, AutoAccounting uses the revenue scheduling rules for the freight account rather than the revenue account.

Tax

Use the tax account assigned to the tax rate codes on the transaction.

Transaction Types

Use the transaction types table to determine this segment of revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue accounts.

If the transaction has a line type of Line with an inventory item of Freight, AutoAccounting uses the revenue scheduling rules for the freight account rather than the revenue account.