
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)
Note: we need to make the relation between PO and SO for Cost perspective.
Rana,
You can create links between SO and PO utilizing Drop Shipment or Special Orders. Drop Shipment defines the PO will drop ship to the Customer Address. Special Orders link the PO and the receipt comes back to the main location.
Here is a handout on this.
Thanks,
Steve