Home Page link  

Selling on Account

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Selling on Account dan 12-20-2006
|--> Re: Selling on Account Glenn Adams [MV...12-20-2006
`--> Re: Selling on Account Jeff @ Check Po...01-04-2007
Posted by dan on December 20, 2006, 3:51 am
Please log in for more thread options
Hi All,
I have set up a new tender type called "Store Account". I have also setup my
store accounts (10 stores) so we can sell goods to each other. Goods are
sold at cost+GST (tax in Australia).
The cost in the system is Ex Tax so we calculate the cost + GST manually and
then change the item price on screen at the POS to be this figure per line
item.
I have developed accurate profit margin and gross profit reports to see how
we are tracking. Even with the stock standard (inaccurate) reports for sales
which show profit margin, how will the selling of goods on store accounts
affect the reported GP, profit margin when the invoice is closed,ie, payment
in full is made?

--
Regards

Dan Levin



Posted by Glenn Adams [MVP - Retail Mgmt on December 20, 2006, 8:46 pm
Please log in for more thread options
rather than manually calculating the selling price, you could use one of
your price levels (A, B & C) - you can use the inventory wizard to set
these level prices in bulk using a formula and assign the selected level
to your customer accounts so they are automatically applied.

Profit reports have to be calculated using actual selling price and item
cost at the time of sale - this is recorded for each line item of each
sale in the TransactionEntry table. The data is there, but I have no
idea how it may affect your customized reports.

If you normally sell Tax Exclusive, why are your store to store sales
Tax Inclusive? Never mind - I just barely understand the tax system
here in the US and I live with it every day....

Why not just use HQ and interstore transfers?

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.


dan wrote:
> Hi All,
> I have set up a new tender type called "Store Account". I have also setup my
> store accounts (10 stores) so we can sell goods to each other. Goods are
> sold at cost+GST (tax in Australia).
> The cost in the system is Ex Tax so we calculate the cost + GST manually and
> then change the item price on screen at the POS to be this figure per line
> item.
> I have developed accurate profit margin and gross profit reports to see how
> we are tracking. Even with the stock standard (inaccurate) reports for sales
> which show profit margin, how will the selling of goods on store accounts
> affect the reported GP, profit margin when the invoice is closed,ie, payment
> in full is made?
>

Posted by Jeff @ Check Point Software on January 4, 2007, 2:52 pm
Please log in for more thread options
: quoted-printable

Dan,

I would be using the transfer function instead of sales as it will =
affect your profit margin and inflate your true sales figures.

If you need to actually pay for the product between stores, do that in =
your accounting program.

--=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

Hi All,
I have set up a new tender type called "Store Account". I have also =
setup my=20
store accounts (10 stores) so we can sell goods to each other. Goods =
are=20
sold at cost+GST (tax in Australia).
The cost in the system is Ex Tax so we calculate the cost + GST =
manually and=20
then change the item price on screen at the POS to be this figure per =
line=20
item.
I have developed accurate profit margin and gross profit reports to =
see how=20
we are tracking. Even with the stock standard (inaccurate) reports for =
sales=20
which show profit margin, how will the selling of goods on store =
accounts=20
affect the reported GP, profit margin when the invoice is closed,ie, =
payment=20
in full is made?

--=20
Regards

Dan Levin=20


------=_NextPart_000_048B_01C72FF6.BF022E80
Content-Type: text/html;
        charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Dan,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>I would be using the transfer function =
instead of sales=20
as it will affect your profit margin and inflate your true sales=20
figures.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>If you need to actually pay for the product =
between=20
stores, do that in your accounting program.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</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>&nbsp;</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).&nbsp; If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.&nbsp; Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV>&nbsp;</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>"dan" &lt;<A =
wrote in message <A=20
=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>Hi=20
All,<BR>I have set up a new tender type called "Store Account". I have =
also=20
setup my <BR>store accounts (10 stores) so we can sell goods to each =
other.=20
Goods are <BR>sold at cost+GST (tax in Australia).<BR>The cost in the =
system=20
is Ex Tax so we calculate the cost + GST manually and <BR>then change =
the item=20
price on screen at the POS to be this figure per line <BR>item.<BR>I =
have=20
developed accurate profit margin and gross profit reports to see how =
<BR>we=20
are tracking. Even with the stock standard (inaccurate) reports for =
sales=20
<BR>which show profit margin, how will the selling of goods on store =
accounts=20
<BR>affect the reported GP, profit margin when the invoice is =
closed,ie,=20
payment <BR>in full is made?<BR><BR>-- <BR>Regards<BR><BR>Dan Levin=20
<BR><BR></BLOCKQUOTE></BODY></HTML>

------=
Similar ThreadsPosted
Top selling items report including non-selling items September 9, 2007, 8:15 pm
selling August 21, 2006, 11:10 am
SELLING KEG BEER USING RMS? April 20, 2008, 12:03 pm
Selling from Other store July 23, 2008, 9:46 am
Not-Selling Item Report November 30, 2005, 11:50 am
Selling Serialized Inventory December 2, 2005, 1:19 pm
Selling by Different units of measure February 8, 2006, 12:31 pm
Top Selling Items Report February 23, 2007, 4:12 pm
Buy by case selling by unit May 8, 2007, 12:16 pm
Buying and selling used items at the POS February 11, 2008, 2:42 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap