|
How to Create a report which gives total purchase for each month of the year? Please Help Me? |
|---|
Is it a task for us ?? [^o)]
| How to Create a report which gives total purchase for each month of the year? |
|---|
How to Create a report which gives total purchase for each month of the year?
please help me bro
Check this post:
http://www.mibuso.com/forum/viewtopic.php?f=23&t=35456
I have a report that calc the monthly sales by customer for 1 year.
By simply changing the report from customers to vendors and calc-ing purchases instead of sales I was able to create a similar report for vendors - adding purchase by month for a year.
good luck!
Do the below steps
-
Use Date table as your first data item of your report(Virtual Table)
-
Use Item Ledger Entry as you second data item of your report (Table No 32)
-
Make a one step right indentation item ledger entry Data item
-
Paste the below code at Date - OnPreDataItem() trigger
Date.SETRANGE(Date.“Period Type”, Date.“Period Type”::Month);
- Paste the below code at Item Ledger Entry - OnPreDataItem() Trigger
Date.COPYFILTER(Date.“Period Start”,“Item Ledger Entry”.“Posting Date”);
6. Place the below code at “” DataItemTableView “” property of Item Ledger Entry data item
WHERE(Entry Type=FILTER(Purchase))
-
Insert a Date-Header and Item Ledger Entry-Header Sections\
-
Place Period Start, Period End, Period name fields to you Date Date-Body Section and move the labels to the Date-Header Section
-
Place Item No, Posting Date, Document No, Quantity to the Item Ledger Entry –Body Section and move labels to the Item Ledger Entry –Header Section
-
Place the below code at OnPreSection() Trigger of Item Ledger Entry-Body section
IF(“Item Ledger Entry”.“Posting Date” < Date.“Period Start”) OR (“Item Ledger Entry”.“Posting Date”>Date.“Period End”) THEN
CurrReport.SHOWOUTPUT(FALSE);
11.Make Period Start field as your RequestFilter Filed in Date Data Item
Run Your report its working
Thanks
Jerome Marshal.J
Thanks bro
If it is working then please verify the solution
Thanks
Jerome Marshal.J
in regards to http://savatage99.googlepages.com/Customer1YrSalesByMonth.pdf
you could also add a Show details on the request form to hide the individual Vendors and just produce totals.
That way you have a choice to filter by purchaser or account no or any other filter you can think of.
Also from the vendor card Vendor->purchases (i have it as form 156 & 352)
156->Vendor Purchases
352->Vendor Purchase Lines
you can see purchases by day, week, month, quarter, year or forever.
I’m very new to reports…Can this report be easily adapted to report on sales instead of purcahes?
Thanks Andy…