Month wise production report

[Former Member]

Dear Experts

Can anybody give me a query for taking month wise report of the produced items from production module

Thanks in advance

Edited by: shashidharpunna on Jun 28, 2010 2:16 PM

[Former Member]

hi sir,

this is sami

i need the req as follows in mm output must be as follows

sfgcode      mat desc                  month/year      no.of batches     qty    

abc       cut pieces       feb  2012          100              8250

            cut pieces       mar 2012           50               6450

                                                totals               150             147 00

xyz            chilli powder        jan 2012            60              4500

                 chilli powder       mar 2012           75               6250

                                                totals              135              10750

If u help me I will be very thankful to u

[Former Member]

If you have three or more year historical data, what the report would be look like?

[Former Member]

Well currently i don't have any report

[Former Member]

If no data, there is no way to create report.

[Former Member]

Hi,

Do you need the report in one month only or for the whole year?

Thanks,

Gordon

[Former Member]

hi gordon,

I want it monthly wise.

Thank you

Edited by: shashidharpunna on Jun 29, 2010 5:19 AM

[Former Member]

How many months are you expecting in the report?

[Former Member]

It would be really helpful if the report is for each month