Report to show Purchases by Category

Posted by Ryan V on January 10, 2007, 2:27 pm

Please log in for more thread options

Does a report exist that will show purchases, transfer ins, and transfer outs
by category? I ask because I sell fish, and account for dead fish using a
transfer out. Sales reports show a specific margin, but that margin is
incorrect because it doesn't account for dead fish that were transferred out.

Basically, I need a report that will show the cost of purchases within a
certain date range in all categories, transfer ins within a date range for
all categories, and transfer outs within a date range for all categories.

Please let me know if this exists.

Posted by Jen Losch on January 10, 2007, 3:58 pm

Please log in for more thread options

Hi Ryan,

Professional Advantage has a product called REtail Analytics that will
enable you to create the report you are looking for. We also offer the UCAP
(Up Close and Personal) program. We have streamlined a process to get your
RMS data in house (we sign all NDA's, confidentilaity agreements, etc), load
our product and then demonstrate the full power of the product on your data
at no cost.

If this is something that you would be interested in or if you have any
questions, please do not hesitate to contact me.

Jen Losch
jenl@profad.com

"Ryan V" wrote:

> Does a report exist that will show purchases, transfer ins, and transfer outs

> by category? I ask because I sell fish, and account for dead fish using a

> transfer out. Sales reports show a specific margin, but that margin is

> incorrect because it doesn't account for dead fish that were transferred out.

> Basically, I need a report that will show the cost of purchases within a

> certain date range in all categories, transfer ins within a date range for

> all categories, and transfer outs within a date range for all categories.

> Please let me know if this exists.

Posted by Jeff @ Check Point Software on January 10, 2007, 5:07 pm

Please log in for more thread options

: quoted-printable

Ryan,

There isn't a report that I can think of for this.

But something you need to understand, your sales margins _are_ correct. =

What you are describing is a shrinkage account. This is an accounting =
issue, not a sales or RMS issue. Its part of your P&L as a cost of =
doing business. IANAA, but I would talk to one to get this right.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Does a report exist that will show purchases, transfer ins, and =
transfer outs=20
by category? I ask because I sell fish, and account for dead fish =
using a=20
transfer out. Sales reports show a specific margin, but that margin is =

incorrect because it doesn't account for dead fish that were =
transferred out.=20

Basically, I need a report that will show the cost of purchases within =
a=20
certain date range in all categories, transfer ins within a date range =
for=20
all categories, and transfer outs within a date range for all =
categories.

Please let me know if this exists.
------=_NextPart_000_0527_01C734C0.AE428A30
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Ryan,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>There isn't a report that I can think of for=20
this.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>But something you need to understand, your =
sales=20
margins _are_ correct.  </FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>What you are describing is a shrinkage =
account. =20
This is an accounting issue, not a sales or RMS issue.  Its part of =
your=20
P&L as a cost of doing business. IANAA, but I would talk to one to =
get this=20
right.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ryan V" <<A=20
=
ft.com</A>>=20
wrote in message <A=20
=
2B535-7D9E-4A3D-A9A2-C3EA55A0327B@microsoft.com</A>...</DIV>Does=20
a report exist that will show purchases, transfer ins, and transfer =
outs=20
<BR>by category? I ask because I sell fish, and account for dead fish =
using a=20
<BR>transfer out. Sales reports show a specific margin, but that =
margin is=20
<BR>incorrect because it doesn't account for dead fish that were =
transferred=20
out. <BR><BR>Basically, I need a report that will show the cost of =
purchases=20
within a <BR>certain date range in all categories, transfer ins within =
a date=20
range for <BR>all categories, and transfer outs within a date range =
for all=20
categories.<BR><BR>Please let me know if this =
exists.</BLOCKQUOTE></BODY></HTML>

------=

Posted by Craig on January 11, 2007, 12:34 pm

Please log in for more thread options

Jeff's right. I sell fish also, and use reason codes to track losses. Then I
take those figures and put them into a shrinkage account under COGS in
Quickbooks.
Craig
Ryan,

There isn't a report that I can think of for this.

But something you need to understand, your sales margins _are_ correct.

What you are describing is a shrinkage account. This is an accounting
issue, not a sales or RMS issue. Its part of your P&L as a cost of doing
business. IANAA, but I would talk to one to get this right.

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader,
follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

Does a report exist that will show purchases, transfer ins, and transfer
outs
by category? I ask because I sell fish, and account for dead fish using a
transfer out. Sales reports show a specific margin, but that margin is
incorrect because it doesn't account for dead fish that were transferred
out.

Basically, I need a report that will show the cost of purchases within a
certain date range in all categories, transfer ins within a date range for
all categories, and transfer outs within a date range for all categories.

Please let me know if this exists.