News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How do I create sales ...

Finance | Project Operations, Human Resources, ...

Unanswered

How do I create sales report breaking down quantity and sales price by batch number?

(0) Share

Report

Report

Posted on by tk.l

10

Hi All, I am trying to create a report to view sales by batch number. My main table is 'custinvoicetrans'. The problem I am facing now is that an item could come from different batches, however, 'custinvoicetrans' table doesn't split by batch number. So, I join to 'inventtrans' table but that creates new problem which the UOM is different between the two tables. And so I play around with 'unitofmeasure' and 'unitofmeasureconversion' tables but with no luck. Can someone share with me the proper way to do this select query?

All responses Img

All responses (1)

Answers Img

Answers (0)

tk.l 10 on at

Like (0)

Report

RE: How do I create sales report breaking down quantity and sales price by batch number?

the query seems ok when sales UOM found in the inventtablemodule table for the same itemid. refer to the picture below.

however, when sales UOM not found in the inventtablemodule table for the itemid, my query will not gives the correct sales amount.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans