I am trying to retreiving a statistic sales report for all items grouping by item category then by item product group . there is too much reports for this reason . I need to calcuclate qty of certain Item category and then per item product group .
all the reports are done on value entry table .
the question i have items depends on pcs as BUOM and items depend on KG as BUOM .for the same item product group .
My question is : I supposed to arrange the item product group one per kilo end one per Pcs .???/
OR I supossed to separate them by reporting wise ? the question ? To separate them by UOM.We don’t have UOM in value entry table to filter or group on UOM. So I couldn’t update the report .
TO work on item ledger entry ,… I will get very slow report becuase i acnnot calcsum the flowfield sales and qty fields .
On the face of it - it sounds like you need to re-design the report and base it on the item table with either a variable for the value entry or a sub dataitem. Using the item table as a dataitem will give you the item category, product group code and BUOM on one table.
If this is not an option then you will probably have to go with a temporary table.
Is there a Sales Qty field on Item Category table? Is it from a localization or a customization?
You may add a second flowfield based on Item Ledger Entry table which could be filtered on UOM as well as on Item Category.
Is there a Sales Qty field on Item Category table? Is it from a localization or a customization?
my answer that i just found those fields in item category , but i think it’s localization because many reports are based on this fields like report 10000708
and many of those reports 100000706 and etc…
the flow field on this table item catregory are done based on value entry …and for our luck ; there is no UOM in value enrty table so we cannot do the same as for location filter or date filter
and we cannot do flow filter on UOM on Item Ledger entry because the SalesACtual are flow field and not normal fields .
I don’t know if there is any way to add UOM to value entry depended on UOM of item ledger entry ? if we can added then we can do what you suggested above and what i tried before to do it , but i failed because of many reason , mentioned them above .
but as i believe always ther must be a little light at end of each tunnel .
No, of course, that would work just for quantity. I would print two or more line for quantities, summarized by UOM, and a unique line with total value, at Item Category end or the other way around - a line with Item Category total value followed by the quantity detail.
Okay for all answers , but your answer that pasted below, you are telling me to print , If can you specify more what do you mean in your answer pasted below , if you mean to do a report in this way , so we are going through Reporting wise solution.
No, of course, that would work just for quantity. I would print two or more line for quantities, summarized by UOM, and a unique line with total value, at Item Category end or the other way around - a line with Item Category total value followed by the quantity detail.