Item Sales Statistics by Month?

yuppicide · **Posted:** Wed Mar 07, 2012 7:17 pm

In Sales Reports there's a report "Customer Sales Statistics". Under options I can put Start Date and Length of Periods. For example 1M, 1Y, etc.

For example 06/01/09 and 1M shows me sales by customer for Before 06/01/09, 06/01/09 to 06/30/09, 07/01/09 to 07/30/09, 08/01/09 to 08/31/09, and After 08/31/09.

Is there something like this for Items? So I can see for example item 1234-5555 how many sold during the month?

I couldn't find anything so far.

If not maybe I can code something borrowing some code from the other report:

Code: Select all

FOR i := 1 TO 5 DO BEGIN
  SETRANGE("Date Filter",PeriodStartingDate[i],PeriodStartingDate[i + 1] - 1);
  CALCFIELDS("Sales ($)","Profit ($)","Inv. Discounts ($)","Pmt. Discounts ($)",
                "Fin. Charge Memo Amounts ($)","Payments ($)");
  "Sales$"[i] := "Sales ($)";
  "Profits$"[i]   := "Profit ($)";
  "CostOfSales$"[i] := "Sales$"[i] - "Profits$"[i];
  IF "Sales$"[i] > 0 THEN
    "Profit%"[i] := ROUND("Profits$"[i] / "Sales$"[i] * 100,0.1)
  ELSE
    "Profit%"[i] := 0;
  "InvoiceDiscounts$"[i] := "Inv. Discounts ($)";
  "PaymentDiscounts$"[i] := "Pmt. Discounts ($)";
  "Payments$"[i] := "Payments ($)";
  "FinanceCharges$"[i] := "Fin. Charge Memo Amounts ($)";
END;

Savatage · **Posted:** Wed Mar 07, 2012 10:07 pm

are you looking for something like form 354 Item Turnover Lines does?

Savatage · **Posted:** Wed Mar 07, 2012 10:38 pm

here's a report - based on this post
viewtopic.php?f=5&t=10082
you can alter it to customer sales or vendor purchases - & even item sales

it;s in FOB form since you probably don't have text import capabilities.
I've named it Report 50077 - so if you have used that # already - I suggest you move it to a new # so this report doesn't replace it when uploaded.

www.biloltd.net/Mibuso/Report50077-Item ... -Month.fob

mibuso.com

Item Sales Statistics by Month?

Who is online