Hi Experts,
we are facing an issue regarding cost on warehouse inventory. we want to make the relation between PO & SO.Our business process is as under:
1st we create a Purchase Order and Receive the Inventory with specific (Serial No. and tracking No.) in our Company Warehouse, after some time we purchase same item from same Vendor but deferent Unit Cost and Serial No. and tracking No. as below;
Registering Date |
Bin Code |
Item No. |
Variant Code |
Quantity |
Unit Cost |
Cost Amount |
Source Document |
Source No. |
Whse. Document Type |
Whse. Document No. |
10/11/2021 |
X-STORAGE-1 |
AX9002449 |
C000160 |
15 |
850 |
12,750 |
P. Order |
8002003 |
Receipt |
PR-000003 |
10/20/2021 |
X-STORAGE-1 |
AX9002449 |
C000160 |
20 |
1,000 |
20,000 |
P. Order |
8002006 |
Receipt |
PR-000006 |
Now we have same Inventory in our Warehouse of a specific item with different Unit Cost .
Now we need to create a Sales Order with reference of specific Purchase Order (I want to make relation/Link between PO & SO)
- Create Sales Order and get purchase order lines in Sales Order
- Create Sales Order from Purchase Order
Note: we need to make the relation between PO and SO for Cost perspective.