Skip to main content

AutoInvoice Line Ordering Rules

Define invoice line ordering rules for transaction lines that you import into Receivables using AutoInvoice. AutoInvoice uses these rules to order transaction lines when grouping the transactions it creates into invoices, debit memos, and credit memos. You can assign a line ordering rule to each grouping rule.
You also assign transaction attributes to your line ordering rules. AutoInvoice uses these attributes to order invoice lines. You can assign a priority to these attributes for each of your invoice line ordering rules. You can also specify an ascending or descending order for each transaction attribute assigned to a rule.
Active invoice line ordering rules appear as list of values choices in the Grouping Rules window.
Suggestion: If you are importing transactions from Oracle Order Management, create an invoice line ordering rule with the attribute SALES_ORDER_LINE to list the items on the invoice in the same order as they appear on the sales order.
To define an invoice line ordering rule:
1. Navigate to the AutoInvoice Line Ordering Rules window.
2. Enter the Name of this line ordering rule.
3. Enter a range of Effective Dates for this line ordering rule. The default start date is today's date, but you can change it. If you do not enter an end date, this line ordering rule will be active indefinitely.
4. Enter a Description of this line ordering rule (optional).
5. Enter the priority of the transaction attribute in the Sequence field. Enter a higher number to specify a lower priority transaction attribute for this invoice line ordering rule.
6. Enter the Transaction Attribute to use to order your invoice lines. Receivables uses the transaction attributes you specify to determine how AutoInvoice orders invoice lines when it groups the transactions that it creates into invoices, debit memos, and credit memos.
7. Enter the type of this line ordering attribute. Enter either 'Ascending' or 'Descending' to specify whether you want this transaction attribute to be ordered from least to greatest (Ascending), or greatest to least (Descending).
8. Save your work.

Comments

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc

Application Utilities Lookups and Application Object Library Lookups

Maintain existing and define additional Lookups for your shared Lookup types. You can define up to 250 Lookups for each Lookup type. Each Lookup has a code and a meaning. For example, Lookup type YES_NO has a code Y with meaning Yes, and a code N with a meaning No. Note: In Releases 11.0 and earlier, there were two Lookup features, Special Lookups and Common Lookups. These two features have been merged into one. The new consolidated Lookups feature has Lookups maintained in this form. If you make changes to a Lookup, users must log out then log back on before your changes take effect. Lookups Block Type Query the type of your Lookup. You can define a maximum of 250 Lookups for a single type. User Name The user name is used by loader programs. Application Query the application associated with your Lookup type. Description If you use windows specialized for a particular Lookup type, the window uses this description in the window title. Access Level The access level restricts changes that

Matching Prepayments to Purchase Orders

You can match a prepayment to a purchase order or receipt. The accounting entries for Item distributions on a matched prepayment typically debit a prepayment account that Payables provides. However, during prepayment entry you can override any account that Payables defaults or builds. Payables does not create an encumbrance entry for the prepaid amount when a prepayment is matched to a purchase order. The match is treated like a reservation of the quantity billed. Payables does not calculate the invoice price variance or exchange rate variance at this point. Furthermore, you cannot change the unit price during the prepayment match to purchase order. A final match to the purchase order is not allowed either. When the matched prepayment is applied to an invoice, Payables reverses the matched quantity on the prepayment to reflect the balance of the total quantity matched. The following example illustrates a prepayment application to a purchase order: You contract to attend a $5,000 trade