Why are work order colums identical with sales receipt columns?

I designed work order sheet and sales receitp differently. 
But Sales Receipt copies work order columns whenever I start sale with work 
order. Is there any way to use those 2 different forms?

For your reference I added the following code to the  full page receipt.  
Now work order prints as I wanted.  

   <IF>
			<CONDITION> Transaction.Type = transactionWorkOrder </CONDITION>
			<THEN>
				<TABLE>
					<TOP> HeaderHeight + MarginTop </TOP>
					<FONT> "Small" </FONT>
					<BORDER> tbNone </BORDER>
					<HEADERSHADE> LineColor </HEADERSHADE>
					<COLUMNHEADER>
						<ALIGNMENT> "<" </ALIGNMENT>
						<WIDTH> PageWidth * 0.15 </WIDTH>
						<TEXT> "Item Code" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> "<" </ALIGNMENT>
						<WIDTH> PageWidth * 0.25 </WIDTH>
						<TEXT> "Description" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> "<" </ALIGNMENT>
						<WIDTH> PageWidth * 0.15 </WIDTH>
						<TEXT> "Case Mark" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.07 </WIDTH>
						<TEXT> "Bin" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.05 </WIDTH>
						<TEXT> "Qty" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.10 </WIDTH>
						<TEXT> "UM" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.23 </WIDTH>
						<TEXT> "Remarks" </TEXT>
					</COLUMNHEADER>
					<FOR each="Entry">
						<ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|" 
Entry.Item.Subdescription1 "|" Entry.Item.Binlocation "|" 
Entry.QuantityOnOrder "|" Entry.Item.UnitofMeasure "|" 
Entry.Item.ExtendedDescription  </ROW>
					</FOR>
				</TABLE>
                        </THEN>         
                 </IF>


Code for Sales Receipt is just a modification of existing codes, which is as 
follows.



<!--
   ===========================
   Transaction Details
   ===========================
-->
		<IF>
			<CONDITION> Transaction.Type = transactionSales | Transaction.Type = 
transactionQuote | Transaction.Type = transactionBackOrder | Transaction.Type 
= transactionLayaway | Transaction.Type = transactionAbortedTransaction 
</CONDITION>
			<THEN>
				<TABLE>
					<TOP> HeaderHeight + MarginTop </TOP>
					<FONT> "Small" </FONT>
					<BORDER> tbNone </BORDER>
					<HEADERSHADE> LineColor </HEADERSHADE>
					<COLUMNHEADER>
						<ALIGNMENT> "<~" </ALIGNMENT>
						<WIDTH> PageWidth * 0.10 </WIDTH>
						<TEXT> "Item Code" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> "<" </ALIGNMENT>
						<WIDTH> PageWidth * 0.20 </WIDTH>
						<TEXT> "Description" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.07 </WIDTH>
						<TEXT> "Qty" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.08 </WIDTH>
						<TEXT> "UM" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.20 </WIDTH>
						<TEXT> "Remarks" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.10 </WIDTH>
						<TEXT> "Ea Pricee" </TEXT>
					</COLUMNHEADER>
					<COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.10 </WIDTH>
						<TEXT> "Unit Price" </TEXT>
                                        </COLUMNHEADER>
                                        <COLUMNHEADER>
						<ALIGNMENT> ">" </ALIGNMENT>
						<WIDTH> PageWidth * 0.15 </WIDTH>
						<TEXT> "Extd Price" </TEXT>
					</COLUMNHEADER>

					
					<FOR each="Entry">
						<IF>
							<CONDITION> ShowLineDiscounts & (Entry.ExtendedDiscount <> 
0)</CONDITION>
							<THEN>
								<IF>
									<CONDITION> (Receipt.TaxSystem = taxsystemVAT) & (Entry.Taxable = 
0) </CONDITION>
									<THEN>
										<SET name="ExtendedExclsvPricePlusDiscount" type="vbcurrency">  
Entry.ExtendedExclsvPrice + Entry.ExtendedDiscount</SET>
										<SET name="PricePlusDiscount" type="vbcurrency">  Entry.Price + 
Entry.Discount</SET>
										<ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|" 
Entry.Quantity "|" Entry.Item.UnitOfMeasure "|" 
Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" 
PricePlusDiscount "|" ExtendedExclsvPricePlusDiscount         </ROW>
									</THEN>
									<ELSE>
										<ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|" 
Entry.Quantity "|" Entry.Item.UnitOfMeasure "|" 
Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" 
Entry.FullPrice "|" Entry.ExtendedFullPrice </ROW>
									</ELSE>
								</IF>
								<IF>
									<CONDITION> Entry.DiscountNegative <> 0 </CONDITION>
									<THEN>
										<ROW>  "||Discount||" Entry.DiscountNegative "|" 
Entry.ExtendedDiscountNegative </ROW>
									</THEN>
								</IF>
							</THEN>
							<ELSE>
								<IF>
									<CONDITION> (Receipt.TaxSystem = taxsystemVAT) & (Entry.Taxable = 
0) </CONDITION>
									<THEN>
										<ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|" 
Entry.Quantity "|" Entry.Item.UnitofMeasure "|" 
Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" Entry.Price 
"|" Entry.ExtendedExclsvPrice         </ROW>
									</THEN>
									<ELSE>
										<ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|" 
Entry.Quantity "|" Entry.Item.unitofMeasure "|" 
Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" Entry.Price 
"|" Entry.ExtendedPrice </ROW>
									</ELSE>
								</IF>
							</ELSE>
						</IF>


	                                 </FOR>
				</TABLE>
                        </THEN>         
                 </IF>


Is there any one who can explain why?

-- 
Shalom!
0
cosamo (10)
12/12/2008 7:59:02 PM
pos 14173 articles. 0 followers. Follow

1 Replies
435 Views

Similar Articles

[PageSpeed] 4

This is a multi-part message in MIME format.

------=_NextPart_000_01BB_01C9611A.9F0DDE60
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Cosamo,

Did you re-select your template after making the changes?  You must for =
every change to it.

I didn't look at the code to see if it was correct.

--=20

Jeff=20
Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w  (Stolen from DRS)
=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/Windows Mail 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


  "cosamo" <cosamo@discussions.microsoft.com> wrote in message =
news:F80C4C1B-E509-45D7-9154-753703E04B4A@microsoft.com...
  I designed work order sheet and sales receitp differently.=20
  But Sales Receipt copies work order columns whenever I start sale with =
work=20
  order. Is there any way to use those 2 different forms?

  For your reference I added the following code to the  full page =
receipt. =20
  Now work order prints as I wanted. =20

     <IF>
  <CONDITION> Transaction.Type =3D transactionWorkOrder </CONDITION>
  <THEN>
  <TABLE>
  <TOP> HeaderHeight + MarginTop </TOP>
  <FONT> "Small" </FONT>
  <BORDER> tbNone </BORDER>
  <HEADERSHADE> LineColor </HEADERSHADE>
  <COLUMNHEADER>
  <ALIGNMENT> "<" </ALIGNMENT>
  <WIDTH> PageWidth * 0.15 </WIDTH>
  <TEXT> "Item Code" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> "<" </ALIGNMENT>
  <WIDTH> PageWidth * 0.25 </WIDTH>
  <TEXT> "Description" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> "<" </ALIGNMENT>
  <WIDTH> PageWidth * 0.15 </WIDTH>
  <TEXT> "Case Mark" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.07 </WIDTH>
  <TEXT> "Bin" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.05 </WIDTH>
  <TEXT> "Qty" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.10 </WIDTH>
  <TEXT> "UM" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.23 </WIDTH>
  <TEXT> "Remarks" </TEXT>
  </COLUMNHEADER>
  <FOR each=3D"Entry">
  <ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|"=20
  Entry.Item.Subdescription1 "|" Entry.Item.Binlocation "|"=20
  Entry.QuantityOnOrder "|" Entry.Item.UnitofMeasure "|"=20
  Entry.Item.ExtendedDescription  </ROW>
  </FOR>
  </TABLE>
                          </THEN>        =20
                   </IF>


  Code for Sales Receipt is just a modification of existing codes, which =
is as=20
  follows.



  <!--
     =
=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
     Transaction Details
     =
=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
  -->
  <IF>
  <CONDITION> Transaction.Type =3D transactionSales | Transaction.Type =
=3D=20
  transactionQuote | Transaction.Type =3D transactionBackOrder | =
Transaction.Type=20
  =3D transactionLayaway | Transaction.Type =3D =
transactionAbortedTransaction=20
  </CONDITION>
  <THEN>
  <TABLE>
  <TOP> HeaderHeight + MarginTop </TOP>
  <FONT> "Small" </FONT>
  <BORDER> tbNone </BORDER>
  <HEADERSHADE> LineColor </HEADERSHADE>
  <COLUMNHEADER>
  <ALIGNMENT> "<~" </ALIGNMENT>
  <WIDTH> PageWidth * 0.10 </WIDTH>
  <TEXT> "Item Code" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> "<" </ALIGNMENT>
  <WIDTH> PageWidth * 0.20 </WIDTH>
  <TEXT> "Description" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.07 </WIDTH>
  <TEXT> "Qty" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.08 </WIDTH>
  <TEXT> "UM" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.20 </WIDTH>
  <TEXT> "Remarks" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.10 </WIDTH>
  <TEXT> "Ea Pricee" </TEXT>
  </COLUMNHEADER>
  <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.10 </WIDTH>
  <TEXT> "Unit Price" </TEXT>
                                          </COLUMNHEADER>
                                          <COLUMNHEADER>
  <ALIGNMENT> ">" </ALIGNMENT>
  <WIDTH> PageWidth * 0.15 </WIDTH>
  <TEXT> "Extd Price" </TEXT>
  </COLUMNHEADER>


  <FOR each=3D"Entry">
  <IF>
  <CONDITION> ShowLineDiscounts & (Entry.ExtendedDiscount <>=20
  0)</CONDITION>
  <THEN>
  <IF>
  <CONDITION> (Receipt.TaxSystem =3D taxsystemVAT) & (Entry.Taxable =3D=20
  0) </CONDITION>
  <THEN>
  <SET name=3D"ExtendedExclsvPricePlusDiscount" type=3D"vbcurrency"> =20
  Entry.ExtendedExclsvPrice + Entry.ExtendedDiscount</SET>
  <SET name=3D"PricePlusDiscount" type=3D"vbcurrency">  Entry.Price +=20
  Entry.Discount</SET>
  <ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|"=20
  Entry.Quantity "|" Entry.Item.UnitOfMeasure "|"=20
  Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|"=20
  PricePlusDiscount "|" ExtendedExclsvPricePlusDiscount         </ROW>
  </THEN>
  <ELSE>
  <ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|"=20
  Entry.Quantity "|" Entry.Item.UnitOfMeasure "|"=20
  Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|"=20
  Entry.FullPrice "|" Entry.ExtendedFullPrice </ROW>
  </ELSE>
  </IF>
  <IF>
  <CONDITION> Entry.DiscountNegative <> 0 </CONDITION>
  <THEN>
  <ROW>  "||Discount||" Entry.DiscountNegative "|"=20
  Entry.ExtendedDiscountNegative </ROW>
  </THEN>
  </IF>
  </THEN>
  <ELSE>
  <IF>
  <CONDITION> (Receipt.TaxSystem =3D taxsystemVAT) & (Entry.Taxable =3D=20
  0) </CONDITION>
  <THEN>
  <ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|"=20
  Entry.Quantity "|" Entry.Item.UnitofMeasure "|"=20
  Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" =
Entry.Price=20
  "|" Entry.ExtendedExclsvPrice         </ROW>
  </THEN>
  <ELSE>
  <ROW> Entry.Item.ItemLookupCode "|" Entry.Description "|"=20
  Entry.Quantity "|" Entry.Item.unitofMeasure "|"=20
  Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|" =
Entry.Price=20
  "|" Entry.ExtendedPrice </ROW>
  </ELSE>
  </IF>
  </ELSE>
  </IF>


                                   </FOR>
  </TABLE>
                          </THEN>        =20
                   </IF>


  Is there any one who can explain why?

  --=20
  Shalom!
------=_NextPart_000_01BB_01C9611A.9F0DDE60
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3Dtext/html;charset=3Dutf-8>
<META content=3D"MSHTML 6.00.6001.18183" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>Cosamo,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Did you re-select your template after making =
the=20
changes?&nbsp; You must for every change to it.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>I didn't look at the code to see if it was=20
correct.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>Search this newsgroup -- <A=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A>&nbsp; =
(Stolen=20
from =
DRS)<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</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
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=
</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"cosamo" &lt;<A=20
  =
href=3D"mailto:cosamo@discussions.microsoft.com">cosamo@discussions.micro=
soft.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:F80C4C1B-E509-45D7-9154-753703E04B4A@microsoft.com">news:F80=
C4C1B-E509-45D7-9154-753703E04B4A@microsoft.com</A>...</DIV>I=20
  designed work order sheet and sales receitp differently. <BR>But Sales =
Receipt=20
  copies work order columns whenever I start sale with work <BR>order. =
Is there=20
  any way to use those 2 different forms?<BR><BR>For your reference I =
added the=20
  following code to the&nbsp; full page receipt.&nbsp; <BR>Now work =
order prints=20
  as I wanted.&nbsp; <BR><BR>&nbsp;&nbsp; =
&lt;IF&gt;<BR>&lt;CONDITION&gt;=20
  Transaction.Type =3D transactionWorkOrder=20
  &lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;TABLE&gt;<BR>&lt;TOP&gt;=20
  HeaderHeight + MarginTop &lt;/TOP&gt;<BR>&lt;FONT&gt; "Small"=20
  &lt;/FONT&gt;<BR>&lt;BORDER&gt; tbNone =
&lt;/BORDER&gt;<BR>&lt;HEADERSHADE&gt;=20
  LineColor =
&lt;/HEADERSHADE&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALIGNMENT&gt;=20
  "&lt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.15=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Item Code"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&lt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.25=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Description"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&lt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.15=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Case Mark"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.07=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Bin"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.05=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Qty"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.10=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "UM"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.23=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Remarks"=20
  &lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;FOR=20
  each=3D"Entry"&gt;<BR>&lt;ROW&gt; Entry.Item.ItemLookupCode "|"=20
  Entry.Description "|" <BR>Entry.Item.Subdescription1 "|"=20
  Entry.Item.Binlocation "|" <BR>Entry.QuantityOnOrder "|"=20
  Entry.Item.UnitofMeasure "|" <BR>Entry.Item.ExtendedDescription&nbsp;=20
  =
&lt;/ROW&gt;<BR>&lt;/FOR&gt;<BR>&lt;/TABLE&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &lt;/THEN&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &lt;/IF&gt;<BR><BR><BR>Code for Sales Receipt is just a modification =
of=20
  existing codes, which is as=20
  <BR>follows.<BR><BR><BR><BR>&lt;!--<BR>&nbsp;&nbsp;=20
  =
=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>&nbsp;&nbsp; Transaction=20
  Details<BR>&nbsp;&nbsp;=20
  =
=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>--&gt;<BR>&lt;IF&gt;<BR>&lt;CONDITION&gt;=20
  Transaction.Type =3D transactionSales | Transaction.Type =3D =
<BR>transactionQuote=20
  | Transaction.Type =3D transactionBackOrder | Transaction.Type <BR>=3D =

  transactionLayaway | Transaction.Type =3D =
transactionAbortedTransaction=20
  <BR>&lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;TABLE&gt;<BR>&lt;TOP&gt; =

  HeaderHeight + MarginTop &lt;/TOP&gt;<BR>&lt;FONT&gt; "Small"=20
  &lt;/FONT&gt;<BR>&lt;BORDER&gt; tbNone =
&lt;/BORDER&gt;<BR>&lt;HEADERSHADE&gt;=20
  LineColor =
&lt;/HEADERSHADE&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALIGNMENT&gt;=20
  "&lt;~" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.10=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Item Code"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&lt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.20=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Description"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.07=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Qty"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.08=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "UM"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.20=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Remarks"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.10=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Ea Pricee"=20
  =
&lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR>&lt;COLUMNHEADER&gt;<BR>&lt;ALI=
GNMENT&gt;=20
  "&gt;" &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.10=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Unit Price"=20
  =
&lt;/TEXT&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
&lt;/COLUMNHEADER&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &lt;COLUMNHEADER&gt;<BR>&lt;ALIGNMENT&gt; "&gt;"=20
  &lt;/ALIGNMENT&gt;<BR>&lt;WIDTH&gt; PageWidth * 0.15=20
  &lt;/WIDTH&gt;<BR>&lt;TEXT&gt; "Extd Price"=20
  &lt;/TEXT&gt;<BR>&lt;/COLUMNHEADER&gt;<BR><BR><BR>&lt;FOR=20
  each=3D"Entry"&gt;<BR>&lt;IF&gt;<BR>&lt;CONDITION&gt; =
ShowLineDiscounts &amp;=20
  (Entry.ExtendedDiscount &lt;&gt;=20
  =
<BR>0)&lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;IF&gt;<BR>&lt;CONDITION&g=
t;=20
  (Receipt.TaxSystem =3D taxsystemVAT) &amp; (Entry.Taxable =3D <BR>0)=20
  &lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;SET=20
  name=3D"ExtendedExclsvPricePlusDiscount" type=3D"vbcurrency"&gt;&nbsp; =

  <BR>Entry.ExtendedExclsvPrice + =
Entry.ExtendedDiscount&lt;/SET&gt;<BR>&lt;SET=20
  name=3D"PricePlusDiscount" type=3D"vbcurrency"&gt;&nbsp; Entry.Price + =

  <BR>Entry.Discount&lt;/SET&gt;<BR>&lt;ROW&gt; =
Entry.Item.ItemLookupCode "|"=20
  Entry.Description "|" <BR>Entry.Quantity "|" Entry.Item.UnitOfMeasure =
"|"=20
  <BR>Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|"=20
  <BR>PricePlusDiscount "|"=20
  =
ExtendedExclsvPricePlusDiscount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;=20
  &lt;/ROW&gt;<BR>&lt;/THEN&gt;<BR>&lt;ELSE&gt;<BR>&lt;ROW&gt;=20
  Entry.Item.ItemLookupCode "|" Entry.Description "|" <BR>Entry.Quantity =
"|"=20
  Entry.Item.UnitOfMeasure "|" <BR>Entry.Item.ExtendedDescription "|"=20
  Entry.Item.Subdescription2 "|" <BR>Entry.FullPrice "|" =
Entry.ExtendedFullPrice=20
  =
&lt;/ROW&gt;<BR>&lt;/ELSE&gt;<BR>&lt;/IF&gt;<BR>&lt;IF&gt;<BR>&lt;CONDITI=
ON&gt;=20
  Entry.DiscountNegative &lt;&gt; 0=20
  &lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;ROW&gt;&nbsp; "||Discount||" =

  Entry.DiscountNegative "|" <BR>Entry.ExtendedDiscountNegative=20
  =
&lt;/ROW&gt;<BR>&lt;/THEN&gt;<BR>&lt;/IF&gt;<BR>&lt;/THEN&gt;<BR>&lt;ELSE=
&gt;<BR>&lt;IF&gt;<BR>&lt;CONDITION&gt;=20
  (Receipt.TaxSystem =3D taxsystemVAT) &amp; (Entry.Taxable =3D <BR>0)=20
  &lt;/CONDITION&gt;<BR>&lt;THEN&gt;<BR>&lt;ROW&gt; =
Entry.Item.ItemLookupCode=20
  "|" Entry.Description "|" <BR>Entry.Quantity "|" =
Entry.Item.UnitofMeasure "|"=20
  <BR>Entry.Item.ExtendedDescription "|" Entry.Item.Subdescription2 "|"=20
  Entry.Price <BR>"|"=20
  =
Entry.ExtendedExclsvPrice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
  &lt;/ROW&gt;<BR>&lt;/THEN&gt;<BR>&lt;ELSE&gt;<BR>&lt;ROW&gt;=20
  Entry.Item.ItemLookupCode "|" Entry.Description "|" <BR>Entry.Quantity =
"|"=20
  Entry.Item.unitofMeasure "|" <BR>Entry.Item.ExtendedDescription "|"=20
  Entry.Item.Subdescription2 "|" Entry.Price <BR>"|" Entry.ExtendedPrice =

  =
&lt;/ROW&gt;<BR>&lt;/ELSE&gt;<BR>&lt;/IF&gt;<BR>&lt;/ELSE&gt;<BR>&lt;/IF&=
gt;<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
&lt;/FOR&gt;<BR>&lt;/TABLE&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &lt;/THEN&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &lt;/IF&gt;<BR><BR><BR>Is there any one who can explain why?<BR><BR>-- =

  <BR>Shalom!</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_01BB_01C9611A.9F0DDE60--

0
cptsoft (1248)
12/18/2008 10:12:12 PM
Reply:

Similar Artilces:

Out of Office (OOF) not working
Hello OOF isnt working on one of our users mailbox, ie. she turns it on, but it doesnt auto reply. ive searched through the existing posts on solutions but still no joy. Ive disabled/re-enable OOF setting in Exchange admin. The user has no exisitng rules setup. The oof never worked so it cannot have been send one per user. Im using Exchange 2003 with Outlook 2003 clients. Any help, would help! thanks Jay If new mailboxes are working fine, you may want to take the simple "shotgun" approach of exporting the users data to PST, saving out the rules, and then creating a new mailbo...

Outlook 2003 working with Groupwise client
We are moving our people from Groupwise to Exchange and I am having a horrible time getting the two to work together. We need to keep both clients on the machine for a short time while the switch is done. I installed Outlook 2003 on my workstation running Windows XP and Outlook and Groupwise are happily coexisting. When I tried this on a Windows 2000 machine everything went to crap. I've tried all of the tricks I can think of. I've removed Groupwise and windows messaging and reintalled everything from scratch and no dice. I just keep getting Outlook MAPI errors and messages s...

Rules not working #7
I have a mail profile that I use with one email address that gets a LOT of spam. I have a fair size number of rules (probably 10-15) for categorizing and filtering it, all of them starting wth "Apply this rule after the message arrives". Problem is that most of them only work about half the time. I'll get some messages that were moved to the correct folders, and some similar messages still in the inbox. If I click "Rules Wizard" and the "Run Now" button, selecting all the rules, it moves the ones still in the inbox to the correct folder. How come it didn&#...

failure of Open XML 1.1.4 to work
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Previous versions of this worked fine. This version comes up with comment &quot;not enough memory&quot;. As I have 2mg Ram this seems strange. Any help appreciated. I'm afraid you haven't provided sufficient information for anyone to go on, especially since that message quite often has nothing to do with memory. For any questions of a technical or performance nature it's important that you specify your current update level of OS X as well as for Office. Exactly when does this messag...

How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to do it. Can anyone here please give me step by step primer. Thanks in advance. All I get is the graph of (1,2,............n) (x axis) against the n values of either col A or B. i.e 2 graphs instead of one. (In the old Lotus this was so simple: select the column for the X axis and then select the col for the Y and press enter, and you'd get the chart) Why is it so diff in Excel? Select the entire range you want to graph such as a2:b44>insert>chart>>>> -- Don Guillett SalesAid Software dguillett1@au...

Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket column on the Print Sales Documents screen? Currently when we open the screen, we have to select which boxes to tick and since we always select the same boxes we wondered if there was a way to have them default when the screen is opened so we don't have to click each time. We want the "Picking Ticket Per Site" box, the "Include Kit Components" box and the "Bin Sequenced" box selected as default values. Thanks!! LMG, You can accomplish this with a small VBA customization, b...

hyperlinks within the same document are not working
Hi. I am trying to create an email publication in MS publisher 2007. It has several stories that will be sent out in email and the first section is supposed to contain a summary with hyperlinks to each story within the same email for more details. I am adding a bookmark at the begining of each story, and then trying to create a hyperlink in the summary section to the bookmark. However, when I send the publication as email, or do an email preview, the hyperlinks do not work. Please help! ...

Changing Costs in Detailed Sales Report
I just opened a new location and I have specified my costs in HQ Mgr under Supplier Tab in Item properties. And I also checked the Supplier tab in Item properties in the Store Ops Mgr, my cost is there. But when I ran a Detailed Sales report for yesterday, some of my items' costs are missing and listed as $0.00. So I open HQ Mgr and issued Worksheet 302 for the new location. I did a couple of test transactions today and ran a Detailed Sales report for today, and it shows the costs of the the test trasactions. But detailed sales report for yesterday still shows $0.00 costs. How do...

Printing
Hope you folks can help me out with a strange one. I have several worksheets formatted in exactly the same way as follows: Col A - width 4 Col B - hidden Col C - width 4 Col D - Width 108 Col E - Width 3 Col F - Width 11 Col G - Hidden Col H - Width 11 & Empty My print range should be Cols A:G (I have used page setup to set the scaling to fit 1 page wide by [blank] pages tall, thus each sheet will print as many pages as required depending on number of rows] When I have the print range set to A:G only columns A:E show on the print preview (and also on the actual print out) and when I m...

Business Portal
BP 3.0 I am trying to set up our Business Portal to be as easy as possible for our sales team. One of the requests they have made is the ability to find out WHAT PO is COMMITTED to the SPECIFIC line item in an order. Similar to actually looking at GP Sales Transaction Entry window where it gives an icon to show that the item has been purchased, what PO it's been committed to. I have spent hours trying to make this happen. Has anyone else been able to do this? If so, I would appreciate detailed steps. Thank you ...

Sales --> Transaction Entry Auto serial strange attitude
Dear All I am using GP 10 SP2 I am using screen Sales --> Transaction Entry When I type a serial in the document, number let us say “CAI00001” “CAI00002” “CAI00003” Then if I closed the document and then I opened it again I found that the default serial is “CAI00004” which I don’t want that 1 - So I am asking why is that happening ? 2 - How can I stop that? 3 – is there is a way to tell the system not to put these default numbers and I will let the user add them by his own. Please advise me what to do I am really in a big trouble. Thank you Go to Sales Order Processing Setup Options a...

Tab order #5
Pressing tab or enter key selects next cell to the right or below. Is there a method by which the tab/enter order can be customized to enable other specific cells to be selected? Thx! Don't know about your version of Excel, but in mine: Tools>Options>Edit, Move selection after enter, Directions, gives you some options -- Kind Regards, Niek Otten Microsoft MVP - Excel "Manhar" <anonymous@discussions.microsoft.com> wrote in message news:1c0bf01c4218d$e0db99d0$a301280a@phx.gbl... > Pressing tab or enter key selects next cell to the right > or below. I...

Keeping forms in order they are entered?
I am working with a database that was designed for us and have pretty much just used without having to change much in but have now run into a problem and hope someone can help. We track and number complaints we recieve by number using last digits of year recieved then next number, i.e. a complaint recived 12/31/09 might be 9234 and first one received this year would be 10001 and the next would be 10002. The problem is now when I open my forms and go to the last one it is the 9234 instead of the 10002 which I need. How do I keep that last form I entered last the next time I open the data...

Is it possible to add a "View" button under the purchase order section?
Would be nice to have the abilty to allow someone to be able to view the purchase order as opposed to the given "new, delete, edit, or receive" buttons. This way someone who needed the information and did not have the appropriate security would not be able to delete or change the PO. I tried to CTL S the new, delete, edit and receive buttons, but that basically locks them out completely. Is this something that may be possible? You can make excel pivot table so any employee can view that worksheet from their terminal. This way you can define the fields you want to show as well ...

Adding % of total sales to a sales report
How would I add a field that shows what percentage is the value of sales for an item compared to the report total? -- Geoff Geoff, Which report and what do you want to see? -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. 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 ********** "Geoff" <Geoff@discussions.micros...

Sales for Outlook Installation 10-24-05
I'm having trouble installing CRM sales for outlook. The installation errors literally on the point of finishing. The message is "Setup has failed because of an error. Setup was unable to install the .msi file for microsoft crm sales for outlook". I have searched the knowledge base and newsgroups to find any info on this matter but at the moment I have struggled to find any signifcant information. The pc used is running XP pro SP2. Thanks for any assistance in advance ...

Multiple indexes on same fields in different order
I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending order, is Jet smart enough to use the proper index if a give it a grouping query with the condition Max or Min, or am I just wasting resources? Pete -- This e-mail address is fake, to keep spammers and their address harvesters out of my hair. If you want to get in touch personally, I am 'pdanes' and I use yahoo mail. But please use the newsgroup when possible, so that all may benefit from the exchange of ideas. ...

Incorrect quantity transferred from SOP order to invoice
What's the correct way to fix an incorrect quantity that was transferred to an invoice? For example, say we have an order with many line items where half of the items were fulfilled, some were partial-shipped. When the order transfers to an invoice, we realize that the fulfilled quantity was wrong on one of the items. We can change the QTY Fulfilled and QTY to Invoice on the invoice but how do we fix the order so that the difference doesn't transfer again? Do we go into the order and enter the difference in Cancelled QTY, although that would be misleading when an inquiry is ...

initial default column width
Is there a way to configure Excel 2000 so that when I create a new Workbook or add a new Worksheet so that all the columns have a particular width instead of the default 64 pixels? TIA Create the workbook exactly the way you want it, then save it as a template with the name "Book.xlt" (no quotes) in you XLStart directory. It'll be then used as the template for new workbooks. Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for the template for Insert/Worksheet. In article <419E181F.6251D20D@nospam.net>, Bruceh <bruce@nospam.net&...

Windows and Mac have two distinctly different units for column width.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to format columns for some data I am entering in a spreadsheet and when I enter &quot;15.00&quot;, which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....

Daily Sales
I've been doing so reports on Sales out of the RMS database and was noticing some minor variances between my reports and canned sales reports. I've tracked this back to a particular transaction. It appears normal in the transaction and transaction entry file, but there is no entry for this transaction # in the tender entry file. So, my question is how do I complete and entry in the transaction file w/o having an entry in the tender file. thnx in advance ...

How to assign unique number to column duplicates?
Hi All, I need to assign a unique number to a set of duplicates all in one column in Excel 2007. so columnA will has about 9000 numbers, some of them unique, and others are duplicates of 2-4 approx. I used to conditional formatting to show which are duplicates, but need to be able to assign a unique number to each set duplicates, that will be in sequential order... e.g. ColumnA ColumnB(unique ID) 01233 0001 01233 0001 01234 - 01255 0002 01255 0002 etc.... Any ideas please? I don't know how to do programming, just form...

Cancelling Receipts in Outlook 2002 (XP)
Folks... I'm experiencing a problem that I think is due to read receipts. I have an e-mail account (POP3) that is set up twice in Outlook. The primary version is for receiving mail from either home or my office, as well as for sending from my office. The secondary version of this account is used only for sending e-mail from home (uses a different outgoing server, to accomodate my ISP's restrictions). The problem is that when I receive my e-mail on this account at home, Outlook attempts to send the read receipts using the primary (office) outgoing server setting, which fails. This esse...

Security tasks necessary to post from Sales >Receivables Batch scr
I created a new role and assigned task trx-sales-022, enter/edit receipts batches. Description of task says it doesn't include posting. When I click on post on the Receivables Batch screen I get message that I don't have security to the window that is trying to open. I assume it is one of the posting journals. What tasks do I have to assign to the new role so that I can post receivables batches? This could be a really tricky question to answer depending on whether you wish to use the default tasks that are set up, or if you need to modify to make your security more specific...

Journal stopped working #2
I have noticed that after upgrading from Outlook XP (2002) to Office Outlook 2003 my journal has completely stopped logging entries. I have turned it off and re-initialized it and still not entries. I mailing want it to log Word and Excel files. Any help would be appreciated I am running Exchange 2003 in cached outlook mode on a SBS 2003 server. ...