Important: If you use summary accounts in your recurring journals, General Ledger maintains references to those summary account templates, even if you delete then recreate the summary accounts.
ERP provides the backbone for an enterprise-wide information system.
Evolving out of the manufacturing industry, ERP implies the use of packaged software rather than proprietary software written by or for one customer.
At the core of this enterprise software is a central database which draws data from and feeds data into modular applications that operate on a common computing platform, thus standardizing business processes and data definitions into a unified environment.
With ERP software, companies can standardize business processes and more easily enact best practices.
By creating more efficient processes, companies can concentrate their efforts on serving their customers and maximizing profit.
SAP was the first to integrate a corporation’s worldwide functions tightly into one application.
SAP R/2 was released as the first version of their software in 1979. Its domination of the market occurred during the 1980s, expanding first throughout Europe (early 1980s) and then North America (1988).
SAP R/3, an advanced, client-server based version of the popular R/2 product, was released in 1992 and sparked a stunning takeover of America’s largest businesses — 44% of US companies were using it within five years of its expansion.
R/3 is scalable and highly suited for many types and sizes of organizations. SAP R/3 is based on various hardware and software architectures, running on most types of UNIX, on Windows NT and OS/400. SAP R/3 runs on several databases Oracle, Adabas D, Informix, DB2 for UNIX, DB2/400, and Microsoft’s SQL Server 6.0.
mySAP ERP Financials
mySAP ERP Human Capital Management
mySAP ERP Operations
mySAP ERP Corporate Services
Customer Relationship Management
Financial Management
Human Capital Management
Service Automation
Supply Chain Management
Enterprise Tools and Technology
Siebel
Tom Siebel (CEO) and Pat House (Executive Vice President) founded Siebel Systems in July 1993. Headquartered in San Mateo, California.
Open: In the Open status you can enter and post Journals.
Closed: In this status Journal entry and posting not allowed until accounting period is reopened. Reporting and inquiry allowed.
Permanently Closed: In this status Journal entry and posting not allowed. You cannot change this period status. Reporting and inquiry allowed. You can change the status.
Never Opened: Journal entry and posting are not allowed. General Ledger assigns this status to any period preceding the first period ever opened in your
calendar, or to any period that has been defined, but is not yet future-enterable. You cannot change this period status.
Future-Entry: Journal entry is allowed, but posting is not. Your period is not yet open, but falls within the range of future-enterable periods you designated in the Set of Books window. You cannot change this period status without using the concurrent process to open the period.
Make to Order:
Make To Stock:
Assemble to order:
Make To Assemble:
Order to Cash Cycle:
- Oracle Order Management: Customer places the order.
- Oracle Order Management: You enter the customer order
- Oracle Inventory: Check the available unit and the quantity ordered by the customer.
- Oracle Order Management: You ship the product to customer site and decreases the Finished Goods inventory.
- Oracle Receivables: The customer receives the product and you invoice the customer.
- Oracle General Ledger: You record your revenue and receivables.
- Oracle Receivables: The customer pays and you receive the cash/check.
- Oracle Cash Management: Oracle Receivables sends the customer receipt for Bank Reconciliation. After reconciliation, Oracle Cash Management send the actual bank balance or Oracle General Ledger.
- Oracle General Ledger: You have the actual bank balance.
Following Accounting entries will be generated for O2C
- Sales order creation – No entries
- Pick release:
Inventory Stage A/c…………………Debit
Inventory Finished goods a/c……..Credit - Ship confirm:
Cogs A/c ……………………………Debit
Inventory Organization a/c………Credit - Receviable:
Receviable A/c………………………Debit
Revenue A/c………………………Credit
Tax ………………..…………………Credit
Freight…………..….……………….Credit - Cash:
Cash A/c Dr…………………………Debit
Receivable A/c……………………….Credit
Procure to Pay:
- Oracle Purchasing: You enter Suppliers of different materials and products you want to purchase to manufacture a finished good that your organization plans to sell.
- Oracle Purchasing: You prepare a Request for Quotation (RFQ) and send it to different suppliers to get the best and/or economical price for the product.
- Oracle Purchasing: Suppliers sends their quotations and you upload those quotations in Oracle Purchasing to get the best three quotes and further to get the one best quote.
- Oracle Purchasing: You prepare a Purchase Order(PO) against the best RFQ to buy the goods from the supplier who quoted the suitable price and sends the PO to that supplier
- Oracle Purchasing: The supplier receives the confirmation of purchase from PO and ships the ordered goods. You receive the goods enter a Goods Received Note (GRN) in Oracle Purchasing.
- Oracle Inventory / Oracle Assets: It’s up to you whether you want to receive the goods at your head office or you Inventory directly. In either case you move the received goods to your different Raw Material Inventory from Oracle Purchasing to Oracle Inventory and the Item Count increases. If the item is Asset Type then it will move to Oracle Assets at the time of Invoice creation in Oracle Payables.
- Oracle General Ledger: Once you move the goods to Oracle Inventory, it sends the Material Accounting to Oracle General Ledger.
- Oracle Payables: After this the supplier sends you the invoice for the purchased goods and you Enter or Match the invoice against the PO from Oracle Purchasing in Oracle Payables. As said before, if the item is Asset in nature then it will move to Oracle Asset.
- Oracle General Ledger: When you enter the invoice it means that you have created a Liability against that supplier and also you have recorded the expense incurred or asset purchased. Oracle Payables sends the invoice accounting to Oracle General Ledger.
- Oracle Payables: You pay the invoice and settle the Liability.
- Oracle General Ledger: The liability is settled and your cash movement account is updated.
- Oracle Cash Management: As you pay the invoice Oracle Payables sends the payment information to Oracle Cash Management for Bank Reconciliation. Once reconciled, Oracle Cash Management sends the updated Bank/Cash accounting entry to Oracle General Ledger.
- Oracle General Ledger: Your cash at bank is updated with actual balance.
- Oracle Process Manufacturing(OPM) / Oracle Discrete Manufacturing(ODM): You start the manufacturing of your final product. Both OPM or ODM requests the different raw materials from you inventory organizations and manufactures a finished good.
- Oracle Inventory: As the raw materials are issued to OPM and ODM the inventory sends the issuing material accounting to General Ledger and decreases the Item Count from the Raw Material Store. As the finished good is prepared, Oracle Inventory receives the finished good in Finished Good Store and increase the Item Count.
Following Accounting entries will be generated for P2P:
- Purchase Requisition creation No entry
- Purchase Order creation no entry
- Inventory Receipt:
Inventory A/c…………….Debit
AP Accrual A/C………Credit(This A/c We are giving in Financial Option) - At the time of Matching the Invoice with Purchase Order
AP Accrual A/c………….Debit
Supplier A/c…………..Credit - At the time of making payment to supplier
Supplier A/C…………… Debit
Bank A/c…………….Credit
- Existing Business Practices
- Catalog change practices
- Leading practices
- Future practices
Latest Posts
- R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERPAugust 25, 2023 - 1:20 pm
- R12 – How to Delete Oracle AR TransactionsMarch 22, 2019 - 8:37 pm
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
Recent Comments