Oracle Receivables provides a default Account Generator process for you to use. If the default does not satisfy your accounting requirements, you can use the Oracle Workflow Builder to customize the default process or create a new one.
If you want to create a new process to meet your company’s needs, use the Oracle Workflow Builder to create a new process, or copy the existing default and change the name before making extensive changes to it.
For more information about the generic features and functions of the Account Generator, refer to Customizing the Account Generator in the Oracle Applications Flexfields Guide.
For more information on how to use the Oracle Workflow Builder, refer to the Oracle Workflow Guide.
Customization Example
For example, you can customize the AR Substitute Balancing Segment item type to use a different balancing segment for either the finance charges or Receivables account.
Testing a Customized Account Generator Process
You must test any modified Account Generator process before using it on a production database.
To test your customized Account Generator Process, run the General Ledger Interface program, then verify that the Account Generator substituted the correct segment for that account. You can run this program from the Run General Ledger Interface Program window.
Implementing a Customized Account Generator Process
If you have customized your Account Generator process for a particular Account Generator item type and assigned a new name to it, use the Account Generator Processes window to associate the new process name with the appropriate Accounting Flexfield structure and item type.
If you made customizations to the default process, but did not change the name of the process, then you do not need to perform this step.
Choosing the Process for a Flexfield Structure
1. Navigate to the Account Generator Process window.
2. Select the structure to which you want to assign a process. You can choose the application, flexfield title, structure, and description from the list of values.
3. Specify the Item Type containing the process, for example, Replace Balancing Segment.
4. Specify the process you want to use to generate the accounts.
The default process, Replace Balancing Segment, will be the default.
If you want to use a different process, enter the name of the process you want to use.
5. Save your work.
Using the Account Generator Profile Option
The Account Generator:Purge Runtime Data profile option ensures that data used to build account combinations is purged after the Account Generator has completed. For more information, see: Profile Options in Oracle Application Object Library: page B – 34.
See Also
Overview of the Account Generator in the Oracle Applications Flexfields Guide
Running General Ledger Interface: page 8 – 6
AutoAccounting
Define AutoAccounting to specify how you want Receivables to determine the general ledger accounts for transactions that you enter manually or import using AutoInvoice. Receivables creates default accounts for revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, bills receivables accounts, and AutoInvoice clearing (suspense) accounts using this information.
When you enter transactions in Receivables, you can override the default general ledger accounts that AutoAccounting creates.
You can control the value that AutoAccounting assigns to each segment of your Accounting Flexfield, such as Company, Division, or Account.
You must define AutoAccounting before you can enter transactions in Receivables.
Suggestion: If you use the multiple organization support feature, you can set up AutoAccounting to derive the Product segment of your Revenue account based on inventory items.
To do this, define the Product segment of your Revenue account to use Standard Lines and specify a Warehouse ID when entering transactions.
" To define AutoAccounting:
1. Navigate to the Automatic Accounting window.
2. Enter the Type of account to define. Choose from the following:
• AutoInvoice Clearing: The clearing account for your 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 feature for the invoice batch source of your imported transactions. See:
Invoices Posted to Suspense report: page 10 – 123.
• Bills Receivable: The bills receivable account for your transaction. Receivables uses this account when you exchange transactions for bills receivable.
• Remitted Bills Receivable: The remitted bills receivable account for your bills receivable transactions.
• Revenue: The revenue and finance charges account for your transaction.
• Tax: The tax account for your transaction.
• Unbilled Receivable: The unbilled receivable account for your transaction. Receivables uses this account when you use the Bill In Arrears invoicing rule. If your accounting rule recognizes revenue before your invoicing rule bills it, Receivables uses this account.
• Unearned Revenue: The unearned revenue account for your transaction. Receivables uses this account when you use the Bill In Advance invoicing rule. If your accounting rule recognizes revenue after your invoicing rule bills it, Receivables uses this account.
• Unpaid Bills Receivable: The unpaid bills receivable account for your bills receivable transactions.
3. For each segment, enter either the table name or constant value that you want Receivables to use to get information. When you enter an account Type, Receivables displays all of the segment names in your Accounting Flexfield Structure. Segments include such information as Company, Product, Department, Account, and Sub–Account. Receivables lets you use different table names for different accounts. Choose one of the following table names:
• Bill To Site: Use the bill–to site of the transaction to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account.
• 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.
• Salesreps: Use the salesperson’s table to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account. If you choose this option for your AutoInvoice clearing, tax, or unearned revenue accounts, Receivables uses the revenue account associated with this salesperson. If you choose this option for your unbilled receivable account, Receivables uses the
receivable account associated with this salesperson. If the transaction has a line type of ”LINE” with an inventory item of freight (”FRT”), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
• Standard Lines: Use the standard memo line or inventory item on the transaction to determine this segment of your revenue, AutoInvoice clearing, freight, tax, unbilled receivable, and unearned revenue account. If you choose this option for your AutoInvoice clearing, freight, tax, unbilled receivable or unearned revenue accounts, Receivables uses the revenue account associated to this standard memo line item or inventory item. If the transaction has a line type of ”LINE” with an inventory item of freight (”FRT”), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
• Taxes: Enter this option to use tax codes when determining your tax account.
• Transaction Types: Use the transaction types table to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account, and of your bills receivable, factored bills receivable, remitted bills receivable, and unpaid bills receivable account. If the transaction has a line type of ”LINE” with an inventory item of freight (”FRT”), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
4. If you did not enter a Table Name, enter a Constant value for this segment, or select one from the list of values.
Enter a Constant value if you want AutoAccounting to always use the same value for this Accounting Flexfield segment. Be sure to enter information that is valid for this segment. For example, if you defined your Company flexfield segment as a two–character segment with valid values ranging from 00 to 10, you must enter a two–character value within this range.
5. Save your work.
See Also
Entering Transactions: page 4 – 2 Using AutoAccounting: page 4 – 289