I maintain my stock in Units as default UOM but want my reports in Boxes.
I have entered the conversion rate in item master.
If you ask why don’t i just maintain it as box , thats because of conversion .
for e.g if 1 box has 18 pieces , so the conversion rate would be 0.05555… , but it rounds of to 0.056 , so if i do enter 18 units it will be 1.08 boxes which is not right , hence this approach.
now I want to be able to view reports in Box UOM but current stock balance reports only shows everything in default one.
In stock ledger/stock balance report, you can see a field called include UOM, By selecting your required UOM you will be able to generate the reports. You should define the UOM conversion factor in the item level. System will take the conversion rate as 1 for the items where the conversion factor is not defined.