|
Point-Of-Sale Software - - MS Point Of Sale software discussed here
|
|
|
|
|
Posted by Alex on June 17, 2008, 12:33 pm
Please log in for more thread options
Does anybody have a report that will show the below information on one
report?
Today Cost, Today Retail, Today Profit, Today Margin % MTD Cost, MTD
Retail, MTD Profit, MTD Margin % YTD Cost, YTD Retail, YTD Profit, YTD
Margin %
So in other words I need the Cost, Retail, Profit, and Profit Margin % for
Today, Month To Date, and Year To Date time frames in one report.
For now I just need these numbers for the entire store but it would even be
better to have them broken down per Department and Category as well.
|
|
Posted by Ryan on June 18, 2008, 3:17 pm
Please log in for more thread options
Alex,
We do not have a report that can do this, and in fact an RMS report would be
very difficult to make happen in this manner. We do however have a tool
called Advanced Purchase Order that make this and other information readily
available when creating purchase orders. If you are interested please
contact Rick Feuling at my office who is in charge of that project. He can
be reached via email at rfeuling@rite.us or on the phone at 1-888-267-RITE
--
Thank you,
Ryan Sakry
Program Manager
Retail Information Technology Enterprises
320-230-2288
rsakry@rite.us
www.rite.us
> Does anybody have a report that will show the below information on one
> report?
>
> Today Cost, Today Retail, Today Profit, Today Margin % MTD Cost, MTD
> Retail, MTD Profit, MTD Margin % YTD Cost, YTD Retail, YTD Profit, YTD
> Margin %
>
> So in other words I need the Cost, Retail, Profit, and Profit Margin % for
> Today, Month To Date, and Year To Date time frames in one report.
>
> For now I just need these numbers for the entire store but it would even
> be better to have them broken down per Department and Category as well.
>
|
|
Posted by Alex on June 19, 2008, 1:09 pm
Please log in for more thread options I was hoping that somebody had already written the SQL query that would
extract these numbers out of the database and the report could easily figure
out the percentages (just like the summary sales report for sales today,
week to date, month to date, and year to date).
It seems strange that your module is called Advanced Purchase Order and but
it actually generates report on historical sales and margins?
Anybody else that would be able to write this query for me to extract
today's cost and sales, MTD cost and sales, and YTD cost and sales? I was
trying to save myself some time....
> Alex,
> We do not have a report that can do this, and in fact an RMS report would
> be very difficult to make happen in this manner. We do however have a
> tool called Advanced Purchase Order that make this and other information
> readily available when creating purchase orders. If you are interested
> please contact Rick Feuling at my office who is in charge of that project.
> He can be reached via email at rfeuling@rite.us or on the phone at
> 1-888-267-RITE
>
> --
> Thank you,
> Ryan Sakry
> Program Manager
> Retail Information Technology Enterprises
> 320-230-2288
> rsakry@rite.us
> www.rite.us
>> Does anybody have a report that will show the below information on one
>> report?
>>
>> Today Cost, Today Retail, Today Profit, Today Margin % MTD Cost, MTD
>> Retail, MTD Profit, MTD Margin % YTD Cost, YTD Retail, YTD Profit, YTD
>> Margin %
>>
>> So in other words I need the Cost, Retail, Profit, and Profit Margin %
>> for Today, Month To Date, and Year To Date time frames in one report.
>>
>> For now I just need these numbers for the entire store but it would even
>> be better to have them broken down per Department and Category as well.
>>
>
>
|
|
Posted by convoluted on June 22, 2008, 2:43 pm
Please log in for more thread options Hi Alex - Ryan's got a point - it'll be pretty difficult to pull in a single
sql statement - what you may be able to do is create a couple of view for MTD
and YTD then bring in those values into a sql query that also shows "today"
or "week to date" - I've done this before and it got me the info I needed.
If you need help creating the views repost - but see if you can give it a
shot yourself - if you're involved with RMS for the long haul it'll be worth
the time invested.
Hope this helps
"Alex" wrote:
> I was hoping that somebody had already written the SQL query that would
> extract these numbers out of the database and the report could easily figure
> out the percentages (just like the summary sales report for sales today,
> week to date, month to date, and year to date).
>
> It seems strange that your module is called Advanced Purchase Order and but
> it actually generates report on historical sales and margins?
>
> Anybody else that would be able to write this query for me to extract
> today's cost and sales, MTD cost and sales, and YTD cost and sales? I was
> trying to save myself some time....
>
>
> > Alex,
> > We do not have a report that can do this, and in fact an RMS report would
> > be very difficult to make happen in this manner. We do however have a
> > tool called Advanced Purchase Order that make this and other information
> > readily available when creating purchase orders. If you are interested
> > please contact Rick Feuling at my office who is in charge of that project.
> > He can be reached via email at rfeuling@rite.us or on the phone at
> > 1-888-267-RITE
> >
> > --
> > Thank you,
> > Ryan Sakry
> > Program Manager
> > Retail Information Technology Enterprises
> > 320-230-2288
> > rsakry@rite.us
> > www.rite.us
> >> Does anybody have a report that will show the below information on one
> >> report?
> >>
> >> Today Cost, Today Retail, Today Profit, Today Margin % MTD Cost, MTD
> >> Retail, MTD Profit, MTD Margin % YTD Cost, YTD Retail, YTD Profit, YTD
> >> Margin %
> >>
> >> So in other words I need the Cost, Retail, Profit, and Profit Margin %
> >> for Today, Month To Date, and Year To Date time frames in one report.
> >>
> >> For now I just need these numbers for the entire store but it would even
> >> be better to have them broken down per Department and Category as well.
> >>
> >
> >
>
>
>
|
|
Posted by Alex on June 24, 2008, 2:28 pm
Please log in for more thread options Convoluted,
Thanks, for your pointers I'll have to take a closer look at this over the
next couple of days. Meanwhile if anybody else would like to jump in or post
some similar reports/solutions please do so!
> Hi Alex - Ryan's got a point - it'll be pretty difficult to pull in a
> single
> sql statement - what you may be able to do is create a couple of view for
> MTD
> and YTD then bring in those values into a sql query that also shows
> "today"
> or "week to date" - I've done this before and it got me the info I needed.
>
> If you need help creating the views repost - but see if you can give it a
> shot yourself - if you're involved with RMS for the long haul it'll be
> worth
> the time invested.
>
> Hope this helps
>
>
>
> "Alex" wrote:
>
>> I was hoping that somebody had already written the SQL query that would
>> extract these numbers out of the database and the report could easily
>> figure
>> out the percentages (just like the summary sales report for sales today,
>> week to date, month to date, and year to date).
>>
>> It seems strange that your module is called Advanced Purchase Order and
>> but
>> it actually generates report on historical sales and margins?
>>
>> Anybody else that would be able to write this query for me to extract
>> today's cost and sales, MTD cost and sales, and YTD cost and sales? I was
>> trying to save myself some time....
>>
>>
>> > Alex,
>> > We do not have a report that can do this, and in fact an RMS report
>> > would
>> > be very difficult to make happen in this manner. We do however have a
>> > tool called Advanced Purchase Order that make this and other
>> > information
>> > readily available when creating purchase orders. If you are interested
>> > please contact Rick Feuling at my office who is in charge of that
>> > project.
>> > He can be reached via email at rfeuling@rite.us or on the phone at
>> > 1-888-267-RITE
>> >
>> > --
>> > Thank you,
>> > Ryan Sakry
>> > Program Manager
>> > Retail Information Technology Enterprises
>> > 320-230-2288
>> > rsakry@rite.us
>> > www.rite.us
>> >> Does anybody have a report that will show the below information on one
>> >> report?
>> >>
>> >> Today Cost, Today Retail, Today Profit, Today Margin % MTD Cost, MTD
>> >> Retail, MTD Profit, MTD Margin % YTD Cost, YTD Retail, YTD Profit,
>> >> YTD
>> >> Margin %
>> >>
>> >> So in other words I need the Cost, Retail, Profit, and Profit Margin %
>> >> for Today, Month To Date, and Year To Date time frames in one report.
>> >>
>> >> For now I just need these numbers for the entire store but it would
>> >> even
>> >> be better to have them broken down per Department and Category as
>> >> well.
>> >>
>> >
>> >
>>
>>
>>
|
| Similar Threads | Posted | | Profit Margin on Dept Sales/Cost Report | June 22, 2007, 11:35 am |
| Cost/Price/Profit How does RMS compute profit margin? | December 11, 2005, 11:37 pm |
| Profit Margin Report | September 9, 2005, 7:54 am |
| Report Profit Margin | February 12, 2007, 4:22 pm |
| Profit margin field in report | May 13, 2006, 1:33 pm |
| Need a report of items sorted by profit margin (Crystal reports?) | January 5, 2010, 12:18 pm |
| HQ Detailed Sales Report - Total-Cost<>Profit | September 19, 2006, 4:27 pm |
| Free sales detail report fix -- proper cost and profit | June 14, 2006, 1:00 pm |
| Interstore Transfer Report With the Retail not the Cost on the rep | October 20, 2006, 10:28 am |
| Profit Margin | March 5, 2007, 4:33 pm |
|
|
|
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap