How Oracle EBS is a monthly knot [Z]

Source: Internet
Author: User

Overview
Most of the business of the coping module is based on procurement and inventory operations, so the monthly closing of the Payables module should be closed after the purchase module and the Inventory module month.
Monthly Knot Step
At the end of each fiscal year, the monthly closing of the Payables module should follow the following process:
1. Check whether the business is fully entered;
2. Check if there is an unverified, pending invoice;
3. Update the expired forward payment status;
4. Check whether the accounts payable are raw ingredients;
5. Delivery of the business to the General Ledger;
6. Confirm that all accounts payable transactions are transmitted to the general Ledger;
7. Create a batch increase;
8. Review the voucher and post it with the correct confirmation;
9. Confirm and check the supplier balance;
10. Closing the Accounts payable period;
11. Open a new accounting period;
12. Preparing data for the adjustment of manual access to inventory costs;
Check if all transactions are entered
Check whether the Payables invoice and payment are all entered by running the report:
Payable Statement "Invoice Registration Form": Combined with "accrued liability statement" to check the invoice entered into the system;
Payable Report "Print payment form", "Payment form": Check the payment entered into the system;
Through the above report to confirm the invoice and payment is all input, if there is omission, then fill in.
Alias in addition, with the procurement module, "Not invoiced receive" report to check whether there are invoices not entered;
Check for non-verified, pending invoices
Review details about unapproved invoices by using the Invoice registration form (Note: Select Yes in the parameter limited to unverified invoices only)

Use the Pending Invoice report to determine which invoices are in the pending status. The report provides the total and total amount of pending invoices in the standard currency, which helps to check and release the hold.

Update expired forward payment status

Use this program to automatically update the status of an expired forward payment from "issued" to "negotiated". If the due date of the payment is equal to or earlier than the "due date" parameter that you specified, the system updates the status of this payment. In addition, a journal entry is created manually or through this program to record the change status of the payment.

It then creates an "expired forward payment" report so that you can view the updated payments and the payments that Oracle payables cannot update.

Check if business transactions are produced
Check whether the Payables invoice and payment are all in the Payables sub-module by running the report:
1.
Payables Report "Non-accounting Transactions report";
Through the above statement to confirm whether the invoice and payment are all in the accounts payable, the report can display both the invoice and the payment, as long as the non-raw ingredients recorded, all will be displayed, and explain the reasons for the current status of processing.
Payable business to General Ledger and posted
The prerequisite for the delivery of the business to the general Ledger is that the accounting entries have been created for all the transactions that are due. To ensure that all business has created accounting entries at the time of posting, you can submit a "Payables Accounting process" request when you run a payables transfer to a general ledger request.
See if there is a record of not being posted (Creating a ledger Entry) through the requested output file.
If you submit the Accounts Payable management System Accounting process, submit to General Ledger, select Yes, submit journal import, and select Yes, the voucher is routed directly to the General ledger module. Otherwise, you will need to submit the following two requests separately:
1. (payable module) transfer of payables to General Ledger
2. Journal import (General Ledger module)
Note that you get the relevant information from the output file to help you review the build of the journal.
Verify that all payables transactions are transferred to the General Ledger
After the above-mentioned business transfer General Ledger is completed, the check is confirmed in the application, and the payables Ledger is transferred to the General ledger.
Path:ap> accounting > view ledger account lines
Enter "Fiscal date" from the To, and select "routed to GL" to confirm that the corresponding fiscal period of the generated payables Ledger has been transferred to the general ledger, you can select "No" and "error" to confirm
Confirm and check supplier balance
Run the Vendor Balance Summary report request to check whether the accounts Payable account balances are equal to the G/L Liability account balance. and confirm the balance of each supplier individually.

Vendor Balance Summary Report Proofs:

In addition, you can check each vendor's invoice and payment information through the Supplier Balance Detail report. In order to obtain the latest vendor balance, please update the vendor balance by requesting the vendor Balance maintenance request in time.

Deal delivery to assets
After completing the above-mentioned business transfer General Ledger, and confirming that all accounts payable entries transmit the general ledger, the contents of the assets involved in the payables are transferred to the asset interface, and "Create a batch increase" by submitting the request.
The request is routed to the asset module as "xxxxx", the fixed asset suspense account, as a fixed asset in the distribution line in the Payables invoice, provided that the ledger transaction has been routed to the General ledger (including the interface).
Closed due period of accounting
During the month end or early next month, in order to prevent the user from dealing with the business in the wrong period, the corresponding accounting period will be closed
Path:ap> Accounting > control Payables Period
Select the period state as close and save it, and when saved, the system automatically checks for an exception, including invoices and payments for the non-raw ingredient, and payables for non-routed General ledger, if any, and then, if so, the process before the closing of the payables period.

During the Control Payables window, update the period status to one of the following states:
L in the future. Oracle Payables allows invoice entry and accounting to take place in the future. Oracle Payables does not allow you to enter payments or revoke payments during future fiscal periods. Oracle Payables allows you to limit the number of future periods based on the number entered in the future periods field in the Oracle Financials Options window. After you change the status of a future period to open, you cannot make it back to future.
L opens. You can record and post transactions within the open period. You cannot open an adjustment period. You can use the Define Calendar window to define the adjustment period. The adjustment period can have overlapping dates.
L is closed. Oracle Payables does not allow transactional processing during shutdown. If the corresponding general ledger and purchase periods are open, you can reopen the shutdown period. You cannot close a period in which any of the following conditions exist:
N Outstanding payment batches. The
N expiration date is within the period, but the status is still "issued" for the forward payment.
N The transaction is not in the accounting process.
N has not been routed to the general ledger for the posted transaction.
L Close permanently. Oracle Payables does not allow transactions to be processed during a permanently closed period. You cannot reopen a permanently closed period.
Open due fiscal period
at the beginning of the month, to ensure that the payables business is handled normally, you need to open the payable fiscal period
Path:ap> accounting > control Payables Period
Select the period status as open, and then save it.
Prepare data for end-of-term cost adjustment
The cost of the material purchased, in addition to the amount received at the time of receipt, also includes the invoice price variance when the invoice is matched, as well as the shipping costs for materials not directly associated with the purchase receipt and other miscellaneous items that require entry into the inventory cost.
for the invoice price variance, when the matching amount is adjusted, the system is automatically produced when the matched amounts are matched, which needs to go into the inventory cost and cost updates through the development of the Cost update program (FORM).
for other miscellaneous items that require entry into the inventory cost, are entered into the system by manual entry to the invoice, the corresponding subjects are inventory goods and other subjects; in the case of input invoice allocation line, select "related to Inventory Cost" is, and specify the corresponding purchase order and the number received. Cost updates by developing a cost-updated program (FORM)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.