In the business process, there might be a requirement of Stock UOM conversion directly from Purchase Request to Purchase Order instead of using Packaging Unit.
Hereafter is something that you can consider to achieve your requirement in Sage X3:
- Firstly, we have a look at the product master’s UOM setup.
- Stock Unit= BAG, Purchase Unit = CS.
- Conversion PUR-STK = 24
- Create a Purchase Request.
- Line 1: enter 2 BAGs
- Line 2: enter 5 CSs
- Line 3: using another product with the same UOM conversion setup, enter 3 BAGs
- Create it.
- Convert Purchase Request to Purchase Order as usual.
- If you look at the PO Lines, the conversion went wrong due the rounding which is 6CS for the first product and 1CS for the second product which lead to STK qty wrongly too.
How do we correct it?
- Option1:
Increase the UOM to higher. In this case, we will set it to 6.
As you can see the PO lines display correctly for both PUR and STK unit after the change.
- Option 2:
To use the entry point ECLBESOINS in the scripts TRTACHCDE1 and TRTACHPOH1 to avoid the grouping of the 2 purchase request lines. To do that, you have to make a variance on the 2 purchase request lines, for example in the description, so you can set ECLAT_DES=2 or =3.
Below is online help of the entry point ECLBESOINS for your further reference.
TRTACHCDE1 processing: TRTACHCDE1
Hope it’s helpful 