Setting Up Item and Automatic Entry Types for Revenue Estimate Processing

Revenue Estimate processing creates the source transactions for the revenue entries to control budgets. A budget in PeopleSoft Receivables is a fixed income allocation (that is, a revenue estimate) with two monetary buckets:

Recognized revenue is revenue that has been billed to the customer but for which payment has not yet been received.
Collected revenue is cash that has been received as payment.

See Performing Commitment Control Processing.

The entry type (or the combination of the entry type and reason) defines how and when to generate source transactions based on preset values in the system function. The system function specifies whether the bucket that the process updates is user-defined on the item entry type or an automatic entry type. If it is not user-defined, the system function specifies whether to:

Update the recognized revenue bucket.
Update the collected revenue bucket.
Update both revenue buckets.

Note: When the user enters the item information, the user must enter the correct entry type and reason to update the correct buckets.

System Function Attributes

This table lists the revenue estimate definitions for each system function. Oracle sets these defaults for PeopleSoft Receivables and you cannot modify them. If the bucket to update is user-defined, the information in the table suggests how to set up the item entry type or automatic entry type associated with the system function.

System Function ID	Description	Update to Recognized Bucket	Update to Collected Bucket	User-Defined	Transaction Generated
DD-01	Direct Debit Remit - Clearing	Not applicable	Not applicable	No	None
DD-02	Direct Debit Remit - Cash	Not applicable	Credits budget	No	One for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated.
DD-03	Direct Debit Cancel - Clearing	Not applicable	Not applicable	No	None
DD-04	Direct Debit Cancel - Cash	Not applicable	Debits budget	No	One for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated.
DD-05	Direct Debit Cash Clearing	Not applicable	Credits budget	No	One for each of the item's user-defined lines. The amount comes from the Cash Control line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated.
DD-06	Direct Debit Cash Clearing	Not applicable	Credits budget	No	One for each of the item's user-defined lines. The amount comes from the Cash Control line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated.
DD-07	Direct Debit Cancel - Clearing	Not applicable	Not applicable	No	None
DD-08	Direct Debit Cancel - Cash	Not applicable	Debits budget	No	One for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated.
DD-09	VAT at Due Date	Not applicable	Not applicable	No	None
DM-01	Pay an Item (Draft Accepted)	Not applicable	Credits or debits budget	No	If an IT-01, IT-02, or FC-01 item activity generates the item, the process creates one transaction for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated. The system places the transaction on hold until the cash is recognized. Then the Budget Processor Application Engine process (FS_BP) checks the source transaction.
DM-02	Prepay an Item	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you receive the invoice.
DM-03	Place an Amount On Account	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you apply the payment to an item.
DM-04	Adjust Remaining Overpayment	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you apply the payment to an item.
DM-05	Adjust Remaining Underpayment	Not applicable	Not applicable	Not applicable	None
DM-06	Create a Deduction	Not applicable	Not applicable	Not applicable	None
DM-07	Write off an Item	Credits or debits budget	Not applicable	Yes	If an IT-01, IT-02, or FC-01 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from the user-defined lines.
Not applicable	Not applicable	Credits budget	Credits budget	Yes	If an MT-05, DM-02, DM-03, or DM-04 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from user-defined lines. (Because the original item did not create any source transaction, you need to update neither bucket or else to update both buckets for the buckets to balance.)
Not applicable	Not applicable	Debits budget	Debits budget	Yes	If an MT-04, DM-05, or DM-06 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from user-defined lines. The collected bucket must be reversed, because the bucket was updated when you created the underpayment.
DM-08	Write off an Overpayment	Credits budget	Credits budget	Yes	One transaction for each user-defined line. The amounts and accounts come from user-defined lines. (Because the original item did not create any source transaction, you need to update neither bucket or else to update both buckets for the buckets to balance.) Note: The system places these transactions on hold until the cash is recognized. Then the Budget Processor checks the source transactions.
DM-09	Write off an Underpayment	Debits budget	Debits budget	Yes	One transaction for each user-defined line. The amounts and accounts come from user-defined lines. The collected bucket must be reversed, because the bucket was updated when you created the underpayment. Note: The system places these transactions on hold until the cash is recognized. Then the Budget Processor checks the source transactions.
DM-20	Draft Remitted to Bank	Not applicable	Not applicable	Not applicable	None
DM-21	Draft Remitted with Discount	Not applicable	Not applicable	Not applicable	None
DM-22	Draft Remitted to Bank	Not applicable	Not applicable	Not applicable	None
DM-23	Draft Remitted to Bank	Not applicable	Not applicable	Not applicable	None
DM-24	Draft Remitted with Discount	Not applicable	Not applicable	Not applicable	None
DM-30	Collect Cash on Discount Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-31	Collect Cash on Discount Draft	Not applicable	Not applicable	Not applicable	Takes the source transaction that the process generated for a prior activity off hold and releases them for budget checking.
DM-32	Collect Cash on Discount Draft	Not applicable	Not applicable	Not applicable	Takes the source transaction that the process generated for a prior activity off hold and releases them for budget checking.
DM-33	Collect Cash on Discount Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-40	Collect Cash on Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-41	Reverse Discount Liability	Not applicable	Not applicable	Not applicable	None
DM-42	Collect Cash on Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-43	Reverse Discount Liability	Not applicable	Not applicable	Not applicable	None
DM-44	Collect Cash on Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-45	Reverse Discount Liability	Not applicable	Not applicable	Not applicable	None
DM-46	Collect Cash on Draft	Not applicable	Not applicable	Not applicable	Takes the source transactions that the process generated for a prior activity off hold and releases them for budget checking.
DM-47	VAT on Discounted Draft	Not applicable	Not applicable	Not applicable	None
DM-50	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-52	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-53	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-54	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-55	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-56	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-57	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-58	Dishonor Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-90	Bank Fees	Not applicable	Not applicable	Not applicable	None
DM-98	Cancel Remitted Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity.
DM-99	Void Draft	Not applicable	Not applicable	No	Generates transactions to reverse a prior draft activity. If the draft is voided before the cash is recognized, it does not create transactions.
FC-01	Create an Overdue Charge	Credits Budget	Not applicable	No	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
IT-01 Item Entry	Create an Invoice/Debit Memo	Credits Budget	Not applicable	No	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
IT-02 Item Entry	Create a Credit Memo	Debits Budget	Not applicable	No	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
DM-10	Deduction Write-off	Debits budget	Debits budget	Yes	One transaction for each user-defined line. The amounts and accounts come from user-defined lines. The collected bucket must be reversed, because it was updated when you created the deduction.
MT-01 Maint Wksht	Offset an Item	If the offset is an item, it either debits or credits the budget.	If the offset is cash, it debits the budget.	Yes	If an IT-01, IT-02, or FC-01 item activity generates the item, the process creates one for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated. The update to either the recognized or collected budget is determined by the entry reason, which indicates whether the offset is an item or cash.
MT-02 Maint Wksht	Write off a Credit	Credits budget	Not applicable	Yes	If an IT-02 item activity generates the item, the process creates one transaction for each user-defined line. The amount and account come from user-defined lines.
Not applicable	Not applicable	Credits budget	Credits budget	Yes	If an MT-05, WS-04, WS-05, or WS-06 item activity generates the item, the process creates one transaction for each user-defined line. The amount and account come from user-defined lines. Note: This information provides a suggested setup for this system function. Specify by reason code which buckets to update.
MT-03 Maint Wksht	Write off a Debit	Debits budget	Not applicable	Yes	If an IT-01 or FC-01 item activity generates the item, the process creates one transaction for each user-defined line. The amount and account come from user-defined lines.
Not applicable	Not applicable	Debits budget	Debits budget	Yes	If an MT-04, WS-07, or WS-08 activity generates the item, the process creates one transaction for each user-defined line. The amount and account come from user-defined lines.
MT-04 Maint Wksht	Create New Debit	Not applicable	Not applicable	Not applicable	None
MT-05 Maint Wksht	Create New Credit	Not applicable	Not applicable	Not applicable	None
MT-06 Maint Wksht	Write off Remaining Credit	Credits budget	Credits budget	Yes	If the amount does not come from IT-02 item activity (partial or full), the process creates one transaction for each user-defined line. The amount and account come from the user-defined line.
MT-07 Maint Wksht	Write off Remaining Debit	Debits budget	Debits budget	Yes	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
MT-08 Maint Wksht	Refund Remaining Credit	Not applicable	Not applicable	Not applicable	None. Note: None of the refunded credit should come from an IT-02 item activity.
MT-09 Maint Wksht	Refund a Credit	Not applicable	Debits budget	Yes	If it is an IT-02 item activity, the amount and accounts come from Refund Control. Warning! If you use an expense account in the distribution code for refund control, the system updates an expense budget and not a recognized revenue or collected revenue bucket. If it is not an IT-02 item activity, the system does not generate transactions. (Oracle recommends that you use two entry reason codes.)
TR-01 Transf Wksht	Transfer Item From Customer	Not applicable	Not applicable	Not applicable	None
TR-02 Transf Wksht	Transfer Item To Customer	Not applicable	Not applicable	Not applicable	None
TR-03 Transf Wksht	Transfer Item To Doubtful Acct	Not applicable	Not applicable	No	None
WS-01 Pay Wksht	Pay an Item	Not applicable	Credits or debits budget	No	If an IT-01, IT-02, or FC-01 item activity generates the item, the process creates one transaction for each of the item's user-defined lines. The amount comes from the AR line and the accounts come from the item's user-defined lines. If multiple user-defined lines exist, the amounts are prorated if users do not perform a manual revenue allocation on the worksheet.
WS-02 Pay Wksht	Take Earned Discount	Debits budget	Not applicable	No	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
WS-03 Pay Wksht	Take Unearned Discount	Debits budget	Not applicable	No	One transaction for each user-defined line. The amount and accounts come from the user-defined line.
WS-04 Pay Wksht	Prepay an Item	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you apply the payment to an item.
WS-05 Pay Wksht	Place An Amount On Account	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you receive the invoice.
WS-06 Pay Wksht	Adjust Remaining Overpayment	Not applicable	Not applicable	Not applicable	None Note: The system updates the revenue budget when you apply the payment to an item.
WS-07 Pay Wksht	Adjust Remaining Underpayment	Not applicable	Not applicable	Not applicable	None
WS-08 Pay Wksht	Create a Deduction	Not applicable	Not applicable	Not applicable	None
WS-09 Pay Wksht	Write off an Item	Credits or debits budget	Not applicable	Yes	If an IT-01, IT-02, or FC-01 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from the user-defined lines.
Not applicable	Not applicable	Credits budget	Credits budget	Yes	If an MT-05, WS-04, WS-05, or WS-06 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from user-defined lines. (Because the original item did not create any source transactions, you need to update neither bucket or else update both buckets for the buckets to balance.)
Not applicable	Not applicable	Debits budget	Debits budget	Yes	If an MT-04, WS-07, or WS-08 item activity creates the item, the process creates one transaction for each user-defined line. The amounts and accounts come from user-defined lines. The collected bucket must be reversed, because the bucket was updated when you created the underpayment.
WS-10 Pay Wksht	Write off an Overpayment	Credits budget	Credits budget	Yes	One transaction for each user-defined line. The amounts and accounts come from user-defined lines. (Because the original item did not create any source transaction, you need to update neither bucket or else update both buckets for the buckets to balance.)
WS-11 Pay Wksht	Write off an Underpayment	Debits budget	Debits budget	Yes	One transaction for each user-defined line. The amounts and accounts come from user-defined lines. The collected bucket must be reversed, because the bucket was updated when you created the underpayment.