Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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?
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:
Hope this helps.
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?
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 very much for this. You have saved me a fair amount of manual entry with your last answer, it is much appreciated
Business Applications communities