Unable to Void a Payment. Void Button on Payments is Greyed Out.

 

Below are the reasons due to which Void Button is disabled on the Payment Workbench form.

1. Payment is Reconciled

When the status of the Payment is 'Reconciled' then the void button will be greyed out. To void a payment, first note the statement number from the show field from the payment then go to cash management and find the statement, and then unreconciled the payment. After this Void Button will be enabled.

2. Prepayment Application / Un-application

If the void button is disabled on a payment and that payment is of Prepayment Invoice then we need to make sure that prepayment is not partially or fully applied. Only after unapplying of prepayment from the invoice, you can void the payment. Until then the void button will be greyed out.

Accounts Payable Trial Balance

 

Accounts Payable Trial Balance is a standard report that displays the data for the creditors according to the parameters given in Report Definition.
Here we can design the Report Definition according to the business requirements.

Below are the steps to create a report definition and then use it in the 'Accounts Payable Trial Balance' standard report.

Step 1: Go to "Open Account Balance Listing Definitions"

Click on Create

Here we give a proper code and naming conventions and select the ledger for which you want to select the values. 
Here we have "Defined By" which has two values "Segment" and "Accounting Flexfield". In Segment, you can select any particular segment of COA for which the report will populate data for all the active code combinations in which that segment value is used. we have taken this in the above example. In Accounting Flexfield, you have to pass the exact Code Combination for which the report will populate the data for that combination only and nothing else.

Now after that select the Journal Source for which data has been posted in GL and then select the Segment and its values for which the business wants the balances.

Now we submit the report with our report definition. Here we can submit both a Summary and a Detail Report.

We can also customize this report and use the same definition we have created above.

AutoInvoice Grouping Rules - Receivables

 

Auto-Invoice Grouping rules is a seeded functionality through which the system clubs the data which is imported from Order Management or other sources and creates Sales Invoice in Receivables. 

In EBS Grouping Rules can work with multiple Permutations and Combinations and we assign these rules in the "AR Transaction Source" Setup which is assigned to "Sales Order Transaction Type". Through this linkage system understands how to group the data from OM and creates Invoices in AR.

A few examples are Grouping by Sales Order.

Example: Grouping by Sales Order

Here "L.INTERFACE_LINE_ATTRIBUTE1" is the Sales Order Number

Assign this Grouping Rule to "AR Transaction Source"

To link this Grouping Rule we assign this Transaction Source to OM Transaction Type.

Creating Sales Orders and Importing them to AR.

Accounting Difference When "Accrue at Receipt" is Checked and Unchecked at PO Level

 

When "Accrue At Receipt" is Checked.

When "Accrue At Receipt" is Not Checked.

Multi-Period Accounting - Custom SLA - Standalone Invoice

 

Case Scenario: If company is paying Rent in the month of "April" but the amount is inclusive of accumulated total for 3 Months i.e. April, May & June. Business wants to distribute this amount in all three above mentioned period without creating separate invoice in different month.

Solution Approach: As per the above case, In Payables we have "Multiperiod Accounting" functionality to distribute that amount in the next future periods without opening those periods. To elaborate the approach, business has created an invoice for Rs. 1,00,000 in the month of April and want to distribute that amount in the future months (Never Opened). Here system behavior's is to generate accounting entries for all the the three months and by distributing that amount on the basis of "Proration Type".

In that accounting entry system distribute the invoice amount in the months but will only post balance to trial balance for current open month which is April, rest will be transferred to GL but will only get posted once those period is opened.

For proper understanding of this functionality you can follow the below process in which I have explained what Custom SLA setups needs to be done.

To understand the step by step process for Custom SLA Setups. (Click Here)

Step 1: Create Value Set and add values

Step 2: Create Mapping Set

Step 3: Add Context DFF at Invoice Line Level

Step 4: Create Account Derivation Rule

Step 5: Create Journal Line Definition by Copying the standard and assign the same to "Invoices" Event Class in your Custom Application Accounting Definition.

Go to your Custom Application Accounting Definition. Click on "Invoices" Event Class. 
Go to "Journal Line Definition". Click on Copy and enter name and chart of accounts.

Remove standard JLD and assign your custom.

Step 6: Create 2 Journal Line Type, one for accrual and one for recognition. Will explain the concept of "Accrual" and "Recognition" at the time of accounting entry.

Open your Custom Journal Line Definition and go to Journal Line Type of  "Item Expense" and click on "Line Type" and then copy the same for your "Accrual" Line Type.

 

Change the setup for JLT after copying as below for Accrual.

Copy "Item Expense" JLT again for Recognition and change the setup as shown below. Also delete all the conditions for "Recognition" JLT as per oracle standards.

 

Step 7: Go to Journal Line Definition and Inactive the standard "Item Expense" JLT and add your new JLT for "Accrual"

Click on "Multiperiod Accounting"

Enter Values according to Business Process.

Save and Click on "Line Assignments"

Accrual Line Type is already added here. We need to our Recognition Line Type here and our Custom Account Derivation Rule to it which we created at step 4.

Save and Close

Now Validate the Application Accounting Definition and assign the same to your Custom Sub-Ledger Accounting Method and assign the Custom Sub-Ledger Accounting Method to your ledger.

 

Now we create AP Invoice. 

For system to understand this AP Invoice is of Prepaid Expense we have to give the invoice "Deferred Dates". By which system treats this invoice as prepaid expense invoice and recognize the expense in future months.

Enter "Default Distribution Account" as "Prepaid Expense" and enable "Deferred Dates" check box and after that enter enter Start Date and End Date in which prepaid expense amount will be distributed.

Go to Line Level DFF and enter value as "RENT" which was mapped to GL Code "E10266" and will distribute the balance from Prepaid Expense GL Code (entered at line level) to Expense Account mapped at ADR Level at Step 2.

 

Validate the Invoice and Submit Create Accounting to its impact.

Now we understand the work of "Accrual" & "Recognition"

Here the first two lines is generated from "Accrual" JLT as uses the default distribution account as Item Expense Account.

For "Recognition" system passes additional entries in which GL Account which was mapped against "RENT" at mapping set level is debited and default distribution account is credited.

Here same entry is passed in each month which shows the "Recognition" Event as per JLT.

Here in the above screenshot we can see that GL Date is having 3 Months i.e. April, May and June. GL Period is Open for the month of April, so entries will be posted and will show impact in Trial Balance. As for the month of May & June, when period is opened these entries will not be posted directly. We need to submit the below program "Complete Multiperiod Accounting" for those entries to be accounted as per there period in the GL Date.

 

After completion of this program "Journal Entry Status" will be changed from "Incomplete" to "Final".