Please suggest me the tables and fields necessary and if possible the code to design the following reports.please can also briefly explain how these reports are useful for an enterprise:
1<b>.<u>breakage/expiry material</u>:</b>to list materials returned due to breakage or expiry or any other reason.
2.<b><u>dispatch details</u></b>:to list dispatch details occured during a given period and for the given plant and division.
3.<b><u>pending po</u></b>:to list pending purchase orders of all vendors base on purchase organisation,group,purchase document number,item delivery date.
4.<b><u>email id's</u></b>: interactive report to list all the mail id's of contact persons for a given customer.
5.<b><u>plant specific expired material</u></b>.:to list plant specific expired material.
6.<b><u>stock transfer</u></b>:to list stocks transferred from various plants to the main plant.
7.<b><u>goods receipt document</u></b>:to list purchase order wise goods receipt document and invoice receipt details line item wise.
<u><b>8.sales journal:</b></u>:sales journal to dispaly monthwise sales journal based on sales organisation,material number and billing date.
9.<b><u>mm details report:</u></b>:to list material master details inputing material and plant as select options and material type as parameter.outptut list has total quantity by material group and quantity.
10.<b><u> vendor analysis report:</u></b>:listing material,material number,storage location,measure unit,material description,group totals.
11. <u><b>sales doc. details</b></u>: list displaying all the sales orders along with delivery and billing document details as per user defined date range and/or order ttypes.
12. <b><u>sales analysis:</u></b>: sales occured during a user selected month and compare it with the sales occured in first 20 days of the month.
Bluesky
