|
Posted by Todd Berger [MSFT] on May 21, 2007, 1:33 pm
Please log in for more thread options
: 7bit
Good afternoon Jay,
Thank you for the update.
I would recommend that you take a look at the Report - Item Quantity List
for Parent Child Items in the Reports Library; and then add a column to
calculate your gross margin from the Item.Cost and Item.Price values.
https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rm
s/ModifiedReports/
In testing my Cost on the report for the child item reflected the cost that
was updated when the parent item was received.
If you need assistance with creating and adding this column onto your
report you can take a look at how the Profit / Profit Margin columns are
done on the Detailed Sales Report or contact Technical Support to open a
support request: https://mbs.microsoft.com/support/newstart.aspx or by
calling MBS support at: 1-888-477-7877.
Todd Berger
Microsoft Online Partner Support
======================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
--------------------
Date: Mon, 21 May 2007 10:26:10 -0400
Subject: Re: Parent / Child Receiving Report or Gross Margin report
Todd,
I receive items by the case (parent) item and sell them by the each
(child). When I run a receiving report it will show the last cost,
retail price (parent item) and my gross margin. I am looking for a
report that I would run after receiving my items, which would show me my
gross margin for the child based upon the cost I just paid for the
parent item. The program works fine as far as updating the costs.
Thanks,
Jay
Todd Berger [MSFT] wrote:
> Good morning,
>
> Thank you Jay for posting your question about the cost of parent/child
> items; and thank you Akber for posting that a report for this could be
> customized.
>
> In testing on version 2.0.0109 I received 1 of a parent item with a cost
of
> $4.00; and the child item's cost (with a child quantity of 2) was changed
> to $2.00 as expected. This was with Last Cost selected as the Cost Update
> Method.
>
> The child quantity still shows 0.
>
> There was a fix in 1.3.1009 that fixed an issue where Item costs are not
> updated correctly in Microsoft Retail Management System Store Operations
if
> two or more items have the same parent item.
>
> Please let me know if this answers your question; and if not what steps I
> can take to recreate the scenario you are describing and what build are
you
> using.
>
> Todd Berger
> Microsoft Online Support Engineer
>
> Get Secure! - www.microsoft.com/security
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> --------------------
> Date: Thu, 17 May 2007 06:28:34 -0400
> Subject: Re: Parent / Child Receiving Report or Gross Margin report
>
> Akber,
> The problem I am having is linking the child's cost to the last cost
> for the parent item. It is very easy to get a report on the child's
> parent item number just by using the item table. How do I get the last
> cost for that parent item, divide it by the number of children and
> report it as the child's cost.
> The child's cost will only update AFTER it pulls a child from the
> parent. When receiving an item I want to see the margin I am making on
> the parent item sold as a parent and also the child. I believe this
> should be a basic function. I am assuming since the parent/child feature
> is used in many businesses, someone would have already created the report.
>
> Akber Alwani wrote:
>
>>HI Jay,
>>Such thing can be handle by your own customize report. look at any report
>>with .grp extention and try to make yours else send your detail I will
>
> see I
>
>>can help you out. I need all kind of detail for your report.
>>
>>"Jay" wrote:
>>
>>
>>
>>>I receive items by the case (parent) and sell them by units (child).
>>>Does any one have a receiving report that will show the child's retail
>>>price, the received unit cost (parents cost / # units) and the gross
>>>margin ?
>>>OR
>>>Is there a report which shows the same info for all parent child items?
>>>
>>>Thanks for your help
>>>
>>>Jay
>>>
>
>
------=_NextPart_0001_3BA4307E
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit
{rtf1ansiansicpg1252deff0deflang1033{fonttbl{f0fnilfprq2fcharset0 MS
Sans Serif;}}
viewkind4uc1pardf0fs20 Good afternoon Jay,
par
par Thank you for the update.
par
par I would recommend that you take a look at the Report - Item Quantity List
for Parent Child Items in the Reports Library; and then add a column to
calculate your gross margin from the Item.Cost and Item.Price values.
par
https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rms/ModifiedReports/
par
par In testing my Cost on the report for the child item reflected the cost that
was updated when the parent item was received.
par
par If you need assistance with creating and adding this column onto your
report you can take a look at how the Profit / Profit Margin columns are done on
the Detailed Sales Report or contact Technical Support to open a support
request: https://mbs.microsoft.com/support/newstart.aspx or by calling MBS
support at: 1-888-477-7877.
par
par Todd Berger
par Microsoft Online Partner Support
par
par ======================================================
par Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
par If this response time does not meet your needs, please contact CSS for more
immediate assistance:
par http://support.microsoft.com/default.aspx
par We look forward to hearing from you!
par ======================================================
par When responding to posts, please "Reply to Group" via your
par newsreader so that others may learn and benefit from this issue.
par ======================================================
par This posting is provided "AS IS" with no warranties, and confers no rights.
par ======================================================
par
par
par pardli720 --------------------
par Date: Mon, 21 May 2007 10:26:10 -0400
par Subject: Re: Parent / Child Receiving Report or Gross Margin report
par
par Todd,
par tab I receive items by the case (parent) item and sell them by the each
par (child). When I run a receiving report it will show the last cost,
par retail price (parent item) and my gross margin. I am looking for a
par report that I would run after receiving my items, which would show me my
par gross margin for the child based upon the cost I just paid for the
par parent item. The program works fine as far as updating the costs.
par
par Thanks,
par
par Jay
par
par Todd Berger [MSFT] wrote:
par > Good morning,
par >
par > Thank you Jay for posting your question about the cost of parent/child
par > items; and thank you Akber for posting that a report for this could be
par > customized.
par >
par > In testing on version 2.0.0109 I received 1 of a parent item with a cost
of
par > $4.00; and the child item's cost (with a child quantity of 2) was changed
par > to $2.00 as expected. This was with Last Cost selected as the Cost Update
par > Method.
par >
par > The child quantity still shows 0.
par >
par > There was a fix in 1.3.1009 that fixed an issue where Item costs are not
par > updated correctly in Microsoft Retail Management System Store Operations
if
par > two or more items have the same parent item.
par >
par > Please let me know if this answers your question; and if not what steps I
par > can take to recreate the scenario you are describing and what build are
you
par > using.
par >
par > Todd Berger
par > Microsoft Online Support Engineer
par >
par > Get Secure! - www.microsoft.com/security
par > =====================================================
par > When responding to posts, please "Reply to Group" via your newsreader so
par > that others may learn and benefit from your issue.
par > =====================================================
par > This posting is provided "AS IS" with no warranties, and confers no
rights.
par >
par >
par > --------------------
par > Date: Thu, 17 May 2007 06:28:34 -0400
par > Subject: Re: Parent / Child Receiving Report or Gross Margin report
par >
par > Akber,tab
par > tab The problem I am having is linking the child's cost to the last cost
par > for the parent item. It is very easy to get a report on the child's
par > parent item number just by using the item table. How do I get the last
par > cost for that parent item, divide it by the number of children and
par > report it as the child's cost.
par > The child's cost will only update AFTER it pulls a child from the
par > parent. When receiving an item I want to see the margin I am making on
par > the parent item sold as a parent and also the child. I believe this
par > should be a basic function. I am assuming since the parent/child feature
par > is used in many businesses, someone would have already created the report.
par >
par > Akber Alwani wrote:
par >
par >>HI Jay,
par >>Such thing can be handle by your own customize report. look at any report
par >>with .grp extention and try to make yours else send your detail I will
par >
par > see I
par >
par >>can help you out. I need all kind of detail for your report.
par >>
par >>"Jay" wrote:
par >>
par >>
par >>
par >>>I receive items by the case (parent) and sell them by units (child).
par >>>Does any one have a receiving report that will show the child's retail
par >>>price, the received unit cost (parents cost / # units) and the gross
par >>>margin ?
par >>>OR
par >>>Is there a report which shows the same info for all parent child items?
par >>>
par >>>Thanks for your help
par >>>
par >>>Jay
par >>>
par >
par >
par pard
par
par }
------=
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap