Monday, August 7, 2017

Receiving Accounting over view

Receiving: 

Receiving valuation                                                         Dr
Inventory AP Accrual                                                      Cr                                                          

Inventory AP Accrual   - This account represents your uninvoiced receipts and it gets relieved when the invoice is matched and approved. This account is setup at each inventory org.
It’s an account to track the total receipt value that is not invoiced for an Inventory organization.

Put Away/Deliver transaction:

Receiving valuation                                                         Cr
Subinventory valuation                                                 Dr

Invoice Match:

Inventory AP Accrual                                                      Dr
Supplier Liability                                                               Cr

Supplier Liability  -  This account represents the amount that you are liable to pay to the supplier.
You can setup the account for individual supplier and requires no customization.

Payment:

Supplier Liability                                                               Dr
Cash                                                                                      Cr

Sunday, May 21, 2017

Oracle WIP JOBs Migration Approach

This is Data conversion task and often give some challenge while implementation. This is critical to Business.

Per Business scenarios, its needed to capture Data conversion approach in CV200 documents and get it reviewed with Business prior to actual conversion. So that Business is well aware how each data element is being migrated from Legacy system to New ERP system.

Following types of Jobs conversion scenario might exist in every Business

         1. Jobs created but not released for Mfg.
·       Convert or Let oracle to create new Job once after Plan runs
·     This Approach needs to be explained to Business upfront to take out any ambiguity

2. Jobs released but not moved from 1st Operation
·        Convert or Let oracle to create new job once after Plan runs
·     This Approach needs to be explained to Business upfront to take out any ambiguity

3. Jobs released & moved and at some operation (in this case Few resources, Parts might have been issued and cost incurred on job until that operation)

  • Create Dummy Items for Resource Conversion Cost & Item conversion cost & etc.
  • WIP-CNV-MTL-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF MATERIAL COSTS)
  • WIP-CNV-RES-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF RESOURCE COSTS)
  • WIP-CNV-OSP-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF OUTSIDE SERVICE PROVIDER COSTS)
  • WIP-CNV-MOH-DMY (WORK IN PROCESS DUMMY ITEM FOR CONVERSION OF MATERIAL OVERHEAD COSTS)
  • Add these Items to capture cost incurred on the job
  • Convert jobs and keep qty where it was on Operations in legacy system
4.  Jobs released, moved and at OSP operation (in this case, OSP requisition already been created and Parts were out for Processing)
  •           Convert OSP POR & POs
  •        Keep OSP jobs in Run status at OSP operation, so that system will not trigger any OSP POR again. (Assume OSP Requisition creation is in WIP Parameters is At Operation)

·       Note: Don’t keep job at Queue at OSP operation


   Pls check applicability and always ensure Business specific criterias   before jumps to conclusion. Hope these points may help, wish you good luck.