Scribd
Upload
70 views2 pages

Reverse Physical Inventory Adjustment

The document describes a 3 step process for physical inventory adjustment and reverse engineering in an inventory management system. Step 1 defines the physical inventory and inserts records into tables to store inventory, subinventory, item, and cost details. Step 2 updates tag counts by inserting records into a tag table. Adjustment records are also updated. Step 3 launches an adjustment posting program to create a journal entry to update the general ledger and item quantities.

Uploaded by

Akash
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
70 views2 pages

Reverse Physical Inventory Adjustment

The document describes a 3 step process for physical inventory adjustment and reverse engineering in an inventory management system. Step 1 defines the physical inventory and inserts records into tables to store inventory, subinventory, item, and cost details. Step 2 updates tag counts by inserting records into a tag table. Adjustment records are also updated. Step 3 launches an adjustment posting program to create a journal entry to update the general ledger and item quantities.

Uploaded by

Akash
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Physical Inventory Adjustment Reverse

Engineering
Step1 -Define Physical Inventory
Records get inserted in MTL_PHYSICAL_INVENTORIES table. The main column of the table is
1.Physical_inventory_id
[Link](Physical Inventory name)
3.Approval_required(Approval for adjustment, the possible value is 1 for Yes and 2 for No)
4.Tag_number_increment(It will work if default tag generate is pick to No)
5.Number_of_skus(stock keeping unit)
6.Dynamic_entry_tag_flag(possible value is 1 for yes and 2 is for no)
7. COUNTED_BY_EMPLOYEE_ID

Subinventory detail will be inserted in MTL_PHYSICAL_SUBINVENTORIES. The main column


of this table is organization_id, physical_inventory_id and subinventory_name.
All item detail will be fetched from mtl_system_items_b like item_code, item_Description on
the basis of organization_id.
Current item count will be fetched from mtl_onhand_quantities on the basis of organization_id
and inventory_item_id.
And the current average cost will be fetched from cst_item_costs.

Step 2:- Update the Tag count


In this process first it will check WMS_ENABLED_FLAG from mtl_parameters (Warehouse
management system flag), if Y then Yes and if N then no.
If the item is serial controlled then it will fetched details from mtl_System_items_b.
We need to update the tag count of items in physical inventory. After this the record will be
inserted in table MTL_PHYSICAL_INVENTORY_TAGS. Main column of this table is
1. Tag_id (this is the unique tag_id)
2. Physical_inventory_id (physical inventory id of physical inventory)
3. Organization_id (this is the inventory id)
4. Inventory_item_id
5. Tag_number (this is the tag number which we define against item)
6. Tag_quantity (updated quantity against item)
7. Tag_uom (primary unit of measure of item)

After updated the physical count MTL_PHYSICAL_ADJUSTMENTS also get updated. The main
column of that table is
1. Adjustment_id
2.Inventory_item_id
3.Organization_id
4.Inventory_item_id
5.System_quantity (that will be fetched from mtl_onhad_quantities, means the current quantity
in the system)
6.Count_quantity(total no. quantity after adjustment)
7.Adjustment_quantity (the quantity which needs to be adjusted)
8.Actual_cost (this cost will be fetched from cst_item_costs, means the current cost of
item.)
9.Approval_status (approval status of adjusted item. The possible value is 1 for approved, 2 for
rejected and 3 for posted)
10.Approved_by_employee_id(That employee which approved adjusted item. That will be fetched
from per_people_f table)
Step 3-
After that we need to Launch Adjustment posting programme against a adjustment account. This
is a spwaned programme.
After that a journal entry will cretaed against the provided account in gl.
And the count in mtl_onhand_quanties table will also get updated.
In that completed process only Inventory module tables will get updated.

You might also like