Oracle ERP System Loan Relationship Table

Oracle ERP System Loan Relationship Table

Summary of accounting information of costing
According to the source type of the transaction is summarized.
First, the procurement received warehousing and return:
1. Receive: Borrow: Material purchase (order price)
Credit: Accrued liability (order price)
2. Warehousing: Borrowing: raw materials (Standard cost)
Loan: Material purchase (order price)
Borrowing or lending: Material Cost Variance _ Material order price
3. Returns to the receipt of the transaction with the opposite of the 2nd above, the return to the supplier to produce a transaction contrary to the 1th step above.
Second, sub-inventory transfer: Only the transfer of sub-Library generated ledger transactions
Borrowing: raw materials (homemade semi-finished products, stock items)
Credit: Raw materials (homemade semi-finished products, stock items)
Iii. Miscellaneous Transaction Processing:
1. Increase in stock: Borrowing: raw materials (semi-finished products, stock items)
Credit: Account alias (or custom account)
2. Inventory reduction: Transactions contrary to the above
Iv. Purchase Invoice matching: Debit: Accrued liability (order price)
Taxable Tax _ VAT _ Input Duty
Credit: Accounts payable (invoice price)
Borrowing or lending: Material Cost Variance _ Material Invoice Price Variance
Five, the production process:
1. Standard work Order:
① Standard Work Order picking: Borrow: Production cost _ Direct production cost _ material
Credit: Raw materials (homemade semi-finished products, stock items)
② Standard Work Order withdrawal: the opposite transaction
③ standard Work order resource transaction processing (i.e. manual): Although we do not have the actual manual cost accounting in the WIP module, the system will automatically calculate a sum, based on the absorption account when defining resources as "production cost _ Direct production cost _ direct labor", the system produces the following entries:
Borrowing: Production cost _ Direct production cost _ direct labor (including cost center information)
Loan: Production cost _ Direct production cost _ Direct Labor
(a value of zero, and only the Assembly defines the resource, the route's ticket will produce this ledger entry)
Therefore, when the general ledger module deals with actual labor and manufacturing costs, it is recommended that:
Borrowing: Production cost _ Production cost Difference _ Labor (real pay)
Credit: Wages payable
Borrowing: Production cost _ Production cost Variance _ Cost (actual manufacturing costs incurred)
Credit: Manufacturing costs
④ Standard work Order finished: Borrow: raw materials (semi-finished products, inventory items)
Loan: Production cost _ Direct production cost _ direct material
Production cost _ Direct production cost _ Direct Labor
Production cost _ Direct production cost _ Direct Cost
(Manual and Expense accounts are only available for inventory items)
⑤ if a standard cost of production, namely the occurrence of costs and cost of reduction in line with the cost of work orders closed without differences;
⑥ when the work order is closed, if the cost of the material is greater than the cost of the reduction, that is, the consumption of materials:
Borrowing: Production cost _ Production cost difference _ material
Loan: Production cost _ Direct production cost _ direct material
The opposite ledger is produced if the material is consumed less.
The production process only produces a poor amount and does not produce a spread.
When the ⑦ work order is closed, the entries for labor and expense are constant:
Borrowing: Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
Loan: Production cost _ Production cost Difference _ Labor
Production cost _ Production cost difference _ cost
2. Non-standard work order: (Do not summarize the general ledger, such as lead materials, etc.)

① non-disassembly work order with report as finished
When issuing the finished product: Borrow: Production cost _ Direct production cost _ direct material (standard)
Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
Loan: finished product
When finished: Borrow: Stock items
Loan: Production cost _ Direct production cost _ direct material (standard)
Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
　　　　　
Closed: Borrow: Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
Loan: Production cost _ Production cost Difference _ Labor
Production cost _ Production cost difference _ cost
Borrowing: Production cost _ Production cost difference _ material
Loan: Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
② Demolition Work Order:
Issue the finished product, ibid.
Issue Negative components: Borrow: raw materials (homemade semi-finished products)
Loan: Production cost _ Direct production cost _ direct material
return negative components, resulting in the opposite ledger;
Closed: Borrow: Production cost _ Production cost difference _ material
Loan: Production cost _ Direct production cost _ direct material (standard)
Production cost _ Direct production cost _ Direct labor (standard)
Production cost _ Direct production cost _ Direct cost (Standard)
3. Other types of outsourcing processing, external processing, code splitting, etc. work order processing (because of the same set of accounts)
Vi. Sales Links:
1. Pick the library: borrow: Instalment payment issued goods
Credit: Stock goods (homemade semi-finished products, raw materials)
2. Shipping: Debit: Instalment receipts issue goods
Credit: Goods issued by instalment receipts
Vii. Cost Update:
1. Impact on Inventory:
If unit costs increase, borrow: raw materials (semi-finished products, inventory items)
Credit: Material Cost Variance _ Material Cost update variance
If unit cost is reduced, the opposite entry is generated
2. The impact on the product, the need to distinguish between different work order status
① work order has been issued status, the components have not been issued, assembly parts are not in storage, assembly materials, labor and manufacturing costs and components of the update do not have an impact;
② work order has been issued, the components have been sent, not installed parts warehousing, assembly materials, labor and manufacturing costs of the update does not have an impact, the cost of a component update will have an impact,
Borrowing (credit): Production cost _ Direct production cost _ direct material
Loan: Production cost _ Production cost difference _ WIP Cost
③ work order issued status, component has been sent, assembly parts of the storage, if the assembly of a component update caused the installation cost updates, components and assembly updates will have an impact:
(component cost increase) the impact of the component:
Borrowing: Production cost _ Direct production cost _ direct material (quantity of raw materials * Updated value)
Loan: Production cost _ Production cost difference _ WIP Cost
Effects of assembly:
Borrowing: Production cost _ Production cost difference _ WIP Cost
Credit: Production cost _ Direct production cost _ direct material (number of incoming * updated value)
For later re-storage of the cost of the newly installed parts to reduce.
Component cost reduction produces opposite ledger entries.
④ work order has been issued, components have been sent, parts of the assembly storage, the material is not updated, the assembly of resources or manufacturing costs update (manually defined non-cumulative update) has an impact on the inbound part:
Cost Increase: Production cost _ Production cost difference _ WIP Cost
Credit: Production cost _ Direct production cost _ direct labor (number of incoming * update value)
(or Loan: production cost _ Direct production cost _ Direct cost)
The cost reduction produces opposite ledger entries.
⑤ The work order is completed, the component is sent, a component is updated (but the assembly is not updated), and the component's hair is affected:
Cost Increase: Production cost _ Direct production cost _ direct material (quantity issued * updated value)
Loan: Production cost _ Production cost difference _ WIP Cost
The cost reduction produces opposite ledger entries.
⑥ The work order is completed, the component is sent, and a component update causes the assembly item cost update, which has an impact on component release and assembly warehousing:
Cost Increase: Production cost _ Direct production cost _ direct material (quantity issued * updated value)
Loan: Production cost _ Production cost difference _ WIP Cost
Borrowing: Production cost _ Production cost difference _ WIP Cost
Loan: Production cost _ Direct production cost _ direct material (Incoming quantity * Update value)
The cost reduction produces opposite ledger entries.
⑦ work order completed status, component issued, item not updated, resource or manufacturing cost updated (manually defined non-accumulative):
Cost Increase: Production cost _ Production cost difference _ WIP Cost
Loan: Production cost _ Direct production cost _ direct labor (direct cost)
The cost reduction produces opposite ledger entries.
Viii. cost of sales carried forward in the general ledger according to the invoicing information:
Borrowing: main business cost (other operating expenses _ material)
Credit: Goods issued by instalment receipts
Ix. summarize the differential accounts and distribute them in the general ledger according to the rules.

1. The procurement acceptance operation, the production will be recorded as follows: (
Loan): Receipt account (receiving Inventory) @ PO Price
(Credit): Inventory AP Accrual (Inventory ap Accrual) @ PO Price
2. Warehousing operations, there is accounts payable accounting information, follow the billing information, no accounting information, then use the purchase order information, the resulting will be scored as follows (assuming there is accounts Receivable account information):
(borrowed): Original Item account (Material accounts) @ Accounts Payable Lizhang local currency Amount
(Credit): Receipt account (receiving Inventory) @ PO Price
(borrowing or lending): Commercial Invoice price Variance (Invoice prices Variance, IPV)
Purchase slip Difference income/loss (rate Variance Gain/loss)
3. The Accounts Payable account assignment will be recorded as follows:
(borrowed): Inventory AP Accrual (Inventory ap Accrual) @ PO Price
(Credit): Accounts Payable account @ Accounts Payable Lizhang local currency Amount
(borrowing or lending): Commercial Invoice price Variance (Invoice prices Variance, IPV)
Purchase slip Difference income/loss (rate Variance Gain/loss)
4. Under the recurring cost, the invoice of Wakahara material purchase has the action of match receipt when the bill is posted, then the periodical cost will convert the commercial Invoice price difference (IPV) of this invoice into the original material cost, but if the invoice match prophase receipt of this period, The IPV generated by this invoice will not be included in the material cost calculation of the current period by the cyclical cost.

Off and in-product accounting classification (WIP Accounting Class)
1. The direct material of the hair material
The amount of the ledger transaction is "current recurring cost"
(borrowed): In-Product pricing account (WIP Valuation) @ Current periodic cost
(Credit): Inventory (MTL account) @ Current recurring cost

2. Direct Labor cost Management
The amount of the ledger transaction is "the wage rate maintained in the current period"
(borrowed): In-Product pricing account (WIP Valuation) @ Maintenance of the payroll rate in the current period
(credit): Distributed direct labor (absorption) @ Current maintenance wage rate

3. Cost management of manufacturing costs/outsourcing processing costs
The cost response of manufacturing costs will result in the following entries, the amount of which is "department share rate maintained in the current period"
(borrowed): In-Product pricing account (WIP Valuation) @ Current period maintenance rate of assessment
(Credit): assessed manufacturing costs (absorption) @ Current maintenance rate of assessment

The cost of outsourcing processing costs will result in the following entries
The amount of the ledger transaction is "departmental rate of assessment maintained in the current period"
(borrowed): In-Product pricing account (WIP Valuation) @ Current period maintenance rate of assessment
(credit): processing cost assessed (absorption) @ Current maintenance rate of assessment

If the standard outsourced work process is used, the following entries are generated in the acceptance work:
(borrowed): Receipt account (receiving Inventory) @ PO Price
(Credit): Inventory AP Accrual (Inventory ap Accrual) @ PO price?

The Accounts Payable account assignment will be recorded as follows:
(borrowed): Inventory AP Accrual (Inventory ap Accrual) @ PO Price
(Credit): Accounts Payable account @ Accounts Payable Lizhang local currency Amount
(borrowing or lending): Commercial Invoice price Variance (Invoice prices Variance, IPV)
Purchase slip Difference income/loss (rate Variance Gain/loss)

When a work order is resumed, there is a bill of accounts payable, the information of the purchase order is followed in accordance with the accounting information and no accounting information is used, and the resulting scoring will be recorded as follows (assuming there is an account payable account information):
(borrowing): WIP-Outsourcing processing (Wip-outside process) @ Accounts Payable Lizhang local currency Amount
(Credit): Receipt account (receiving Inventory) @ PO Price
(borrowing or lending): Commercial Invoice price Variance (Invoice prices Variance, IPV)
Purchase slip Difference income/loss (rate Variance Gain/loss)

When the work order is finished, the following ledger entries are generated, in which the debit account reads the "Recurring account specified" Credit account for the "WIP Accounting Classification" in the list of finished/semi-finished items.
(borrowed): Inventory account (MTL valuation)
(credit): In-Product pricing account (WIP valuation)

Number of work orders as finished = When the ticket is open, the system switches the status to complete.
Before closing the bill at the end of the month, it is necessary to check that all open work orders will still have a trade show, and for the work orders that can be closed, you need to switch the ticket status to "completed – no fee re-entry (complete-no Charge)".
At the end of the month, the ticket is checked for all work orders that have a status of "Completed – no fee re-entry (complete-no Charge)", to execute the work order cost-closing action.
When the work order is closed, if there are remaining WIP values on the work order, the corresponding "Variance account" will be given to the "WIP accounting classification" according to the cost elements, resulting in the following entries:
(Borrow or loan): WIP valuation
(loan or loan): WIP Variance Account (Variance)

RMA Jobs

There are "pin back", "retreat" and "exchange" three kinds of patterns.
The replacement operation is processed by order shipment and RMA receipt, and the part that has not been returned is expressed with "temporary withdrawal material", and it is necessary to assist to express whether there is any discrepancy in the returned part through the auxiliary report, and if there is any discrepancy, adjust the general ledger to the "manufacturing cost" account.
The above differences, on the one hand may be brought out with the return of the material number is different, this part does belong to the difference, on the other hand even if the same material number, because the collar and return of the period is different, there will be differences, according to reason, this part of the difference should not happen.
Assuming that H is out of the original material to W, the in-transit assets belong to the receiver W, then H is shipped with the following entry (Transfer credit for transfer benefit):
(borrowed) in-transit inventory (intransit, W) accounts receivable (receivable, H)
(loan) original material (Material, h) Transfer pin refund (Transfer credit, h)
Accounts payable (payable, W)?

W when receiving, the following entries are generated:
(borrowed) raw material (Material, W)
(credit) in-Transit inventory (intransit, W)

Recurring cost, cost calculation for finished or semi-finished products when finished
According to each station's unit cost contribution plus total, the expression has the distinguishing cost element (costs Elements).
When the station unit contribution cost = (when the station takes place costs – ticket storage, when the station has relief cost)/(when the station is transferred – number of ticket inbound).