85
Hello,
I am running a report in Jet Basics, one of the canned ones "Item Sales and Profit". I am running into an issue that my Base unit of measure, and my sales unit of measure are different. Running the report it pulls from the field "72 Sales (Qty.)" . which reports in the base unit of measure.
I am wondering if it is possible to generate a report using the sales unit of measure, or if anyone has any ideas on how i could automate the conversion?
Thank you
Steve, thank you very much for this. You have saved me a fair amount of manual entry with your last answer, it is much appreciated
Josh,
Table Item Unit of Measure is where you can see the Item UOM and conversion and pull that into Jet for your formulas.
Steve
Thank you fort eh response Steve. The issue I am having is that the conversion is not necessarily straight forward like that - some items have a conversion of x2, and some have a conversion of x24. I was hoping that the sales UOM existed on a table somewhere, but I don't think it does from your answer, is that correct?
Hello,
The issue lies with the fact that BC is using the Base Unit of Measure for the report you are generating and your Sales UOM is an Item UOM conversion. I would recommend that you display the Sales UOM in one column and in another enter a formula to convert the Base to SalesUOM. For example, if Base = EA and Sales = BOX of 12 my formula would be Qty of Base x 12.
You could always send an request to Jet Reports who might have an easier solution from a past request. Here is a link:
support.jetglobal.com/.../en-us
Hope this helps.
Thanks,
Steve
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (