On Order field in report

Hello, 

Can someone send me the query that would allow me to view an item's ON ORDER 
qty in a report?

I can seem to manipulate every other field accept for the ON ORDER field for 
some reason.

Thx,
Peter
0
Utf
12/2/2009 5:01:01 PM
pos 14173 articles. 0 followers. Follow

2 Replies
889 Views

Similar Articles

[PageSpeed] 28

Hi Peter - "on order" is not a column on the item table, or any table - there 
is a view I believe called viewonorder that calculates open PO qties by item. 
 Your report will need to join the item table to the view - in store 
operations the join would be item.id = viewonorder.itemid.

I believe there is a custom report you can download from customersource that 
already includes this for you.

Hope this helps

"Shop" wrote:

> Hello, 
> 
> Can someone send me the query that would allow me to view an item's ON ORDER 
> qty in a report?
> 
> I can seem to manipulate every other field accept for the ON ORDER field for 
> some reason.
> 
> Thx,
> Peter
0
Utf
12/2/2009 8:37:01 PM
This is a multi-part message in MIME format.

------=_NextPart_000_00D3_01CA985E.9B0982C0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_00D4_01CA985E.9B0982C0"


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

Peter,

Try this one.

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


  "Shop" <Shop@discussions.microsoft.com> wrote in message =
news:DBE07B79-BCCD-4099-9307-20EF350B4AD1@microsoft.com...
  Hello,=20

  Can someone send me the query that would allow me to view an item's ON =
ORDER=20
  qty in a report?

  I can seem to manipulate every other field accept for the ON ORDER =
field for=20
  some reason.

  Thx,
  Peter
------=_NextPart_001_00D4_01CA985E.9B0982C0
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 content=3Dtext/html;charset=3Dutf-8 http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16466"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>Peter,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Try this one.</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"BORDER-LEFT: #008000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV>"Shop" &lt;<A=20
  =
href=3D"mailto:Shop@discussions.microsoft.com">Shop@discussions.microsoft=
..com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:DBE07B79-BCCD-4099-9307-20EF350B4AD1@microsoft.com">news:DBE=
07B79-BCCD-4099-9307-20EF350B4AD1@microsoft.com</A>...</DIV>Hello,=20
  <BR><BR>Can someone send me the query that would allow me to view an =
item's ON=20
  ORDER <BR>qty in a report?<BR><BR>I can seem to manipulate every other =
field=20
  accept for the ON ORDER field for <BR>some=20
reason.<BR><BR>Thx,<BR>Peter</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_00D4_01CA985E.9B0982C0--

------=_NextPart_000_00D3_01CA985E.9B0982C0
Content-Type: application/octet-stream;
	name="Custom - Items - Quantity with On Order.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Items - Quantity with On Order.qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeItems
   ReportTitle =3D "Item Quantity with On Order"
   PageOrientation =3D pageorientationLandscape
   OutLineMode =3D True
   Groups =3D 0
   GroupDescription =3D ""
   DisplayLogo =3D True
   LogoFileName =3D "MyLogo.bmp"
   ProcedureCall =3D ""
   PreQuery1 =3D "IF EXISTS (SELECT TABLE_NAME FROM =
INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME =3D 'ViewOnOrder') DROP VIEW =
ViewOnOrder"
   PreQuery2 =3D <BEGIN>
     	CREATE VIEW ViewOnOrder AS=20
         SELECT ItemID,=20
	  SUM(QuantityOrdered - QuantityReceivedToDate) AS OnOrder
=20
         FROM PurchaseOrderEntry=20
          LEFT JOIN PurchaseOrder on PurchaseOrderEntry.PurchaseOrderID =
=3D PurchaseOrder.ID=20

         WHERE POType < 2=09

         GROUP BY ItemID
     	<END>
   TablesQueried =3D <BEGIN>=20
	FROM Item WITH(NOLOCK)=20
	LEFT JOIN Department WITH(NOLOCK) ON Item.DepartmentID =3D =
Department.ID=20
	LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID =3D Category.ID=20
	LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID =3D Supplier.ID=20
	LEFT JOIN SupplierList ON Supplier.ID =3D SupplierList.SupplierID AND =
Item.ID =3D SupplierList.ItemID=20
	LEFT JOIN ViewOnOrder ON Item.ID =3D ViewOnOrder.ItemID
	<END>
   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D ""
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Generated On <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
   Font =3D "Arial"
   FontBold =3D False
   FontSize =3D 8
   Color =3D "Black"
End TitleRow

//--- Filters ---//

Begin Filter
   FieldName =3D "Item.Inactive"
   FilterOp =3D reportfilteropEqual
   FilterLoLim =3D "0"
   FilterHilim =3D "0"
End Filter

Begin Filter
   FieldName =3D "QuantityToOrder"
   FilterOp =3D reportfilteropGreater
   FilterLoLim =3D "0"
   FilterHilim =3D "0"
   FilterNegated =3D False
   FilterConnector =3D reportfilterbooleanconAND
End Filter

//--- Columns ---//

Begin Column
   FieldName =3D "Item.ItemLookupCode"
   DrillDownFieldName =3D "Item.ItemLookupCode"
   DrillDownReportName =3D ""
   Title =3D "ILC"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.Description"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Description"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Department.Name"
   DrillDownFieldName =3D "Department.Name"
   DrillDownReportName =3D ""
   Title =3D "Department"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Category.Name"
   DrillDownFieldName =3D "Category.Name"
   DrillDownReportName =3D ""
   Title =3D "Category"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2500
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.WebItem"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Web Item"
   VBDataType =3D vbBoolean
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.BinLocation"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Bin Location"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1140
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.Quantity"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "OnHand"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D "###"
End Column

Begin Column
   FieldName =3D "Item.QuantityCommitted"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Commit"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D "###"
End Column

Begin Column
   FieldName =3D "Available"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Avail"
   VBDataType =3D vbDouble
   Formula =3D "Item.Quantity - Item.QuantityCommitted"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 700
   GroupMethod =3D groupmethodSum
   ColFormat =3D "###"
End Column

Begin Column
   FieldName =3D "Item.ReorderPoint"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Reorder Pt."
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1065
   GroupMethod =3D groupmethodNone
   ColFormat =3D "####"
End Column

Begin Column
   FieldName =3D "Item.RestockLevel"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Restock Lvl."
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1215
   GroupMethod =3D groupmethodNone
   ColFormat =3D "####"
End Column


Begin Column
   FieldName =3D "ViewOnOrder.OnOrder"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "On Order"
   VBDataType =3D vbDouble
   Formula =3D "ISNULL(ViewOnOrder.OnOrder, 0)"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D "####"
End Column

Begin Column
   FieldName =3D "QuantityToOrder"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Qty to Order"
   VBDataType =3D vbDouble
   Formula =3D "CASE WHEN Item.Quantity - Item.QuantityCommitted <=3D =
Item.ReorderPoint THEN CASE WHEN Item.RestockLevel - Item.Quantity + =
Item.QuantityCommitted - (CASE WHEN ViewOnOrder.OnOrder IS NULL THEN 0 =
ELSE ViewOnOrder.OnOrder END)  < 0 THEN 0 ELSE Item.RestockLevel - =
Item.Quantity + Item.QuantityCommitted - (CASE WHEN ViewOnOrder.OnOrder =
IS NULL THEN 0 ELSE ViewOnOrder.OnOrder END) END ELSE 0 END"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1200
   GroupMethod =3D groupmethodSum
   ColFormat =3D "###"
End Column

Begin Column
   FieldName =3D "Item.MSRP"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "MSRP"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 945
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "SupplierList.MasterPackQuantity"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "MPQ"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 700
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "QuantityToOrderMPQ"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Qty to Order (MPQ)"
   VBDataType =3D vbDouble
   Formula =3D "CASE WHEN Item.Quantity - Item.QuantityCommitted <=3D =
Item.ReorderPoint AND SupplierList.MasterPackQuantity > 0 THEN CEILING =
((Item.RestockLevel - Item.Quantity + Item.QuantityCommitted) / =
SupplierList.MasterPackQuantity) * SupplierList.MasterPackQuantity WHEN =
Item.Quantity - Item.QuantityCommitted <=3D Item.ReorderPoint THEN =
Item.RestockLevel - Item.Quantity + Item.QuantityCommitted ELSE 0 END"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1500
   GroupMethod =3D groupmethodSum
   ColFormat =3D "###"
End Column

Begin Column
   FieldName =3D "Supplier.SupplierName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Supplier"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1350
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "SupplierList.ReorderNumber"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Reorder No."
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1300
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.Cost"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Cost"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.Price"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceA"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price A"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceB"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price B"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceC"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price C"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 800
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceLowerBound"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Lo Bound"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1000
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceUpperBound"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Hi Bound"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1100
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SalePrice"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Price"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1100
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SaleStartDate"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Starts"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1100
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SaleEndDate"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Ends"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1100
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.LastSold"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Last Sold"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1100
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.Inactive"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Inactive"
   VBDataType =3D vbBoolean
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1057
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignCenterCenter
End Column

------=_NextPart_000_00D3_01CA985E.9B0982C0--

0
Jeff
1/19/2010 12:52:22 AM
Reply:

Similar Artilces:

Report writer #17
I have a client that needs to add a field to the Financial and Payables Edit list... the field they need can't be linked through the tables in Report Writer. How would be the best way for me to pull in the information from Segment Description - only segment 5's description. The only way I can think of accomplishing this is by using Report Writer with VBA. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "GPNut" wrote: > I have a client that needs to add a field to the Financial and > Payables Edi...

Update of Inter-Store transfer orders
I am at the end of my rope with transfers. I can't understand ho RMS can have the ability to create and Inter-store transfer at one location, but changes are not reflected after the order is "placed." Has anyone found a workaround? My situation is that a smaller location orders products from the main location which houses the warehouse. The warehouse crew picks items from the transfer order, but very frequently the requested items are not available. They may send a substitute, adding it to thier transfer out order. Tehy may also send some items that were not requested by ...

View one record at a time in a report.
I am new to access. I created a report from a table using the wizard. When I view the report, I only want to see one given record at a time - not all records. How do I do this? Thank you Ron The easiest way is to start from a form, where you bring up the record you want to see. Then put a command button on the form, to open the report to just that one record. Here's the code you need for the command button: Print the record in the form at: http://allenbrowne.com/casu-15.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne...

Payee Matching using Memo Field?
Note sure if this is specific to BofA, or if I'm just missing something.I am using MS Money Deluxe 2004, but also had same prob with 2000 When I download ofx (problems with qif also) statements the Payee or <name> is truncated to 32 char which normally I wouldnt care since money only allows 32 char in the payee feild. Problem is my transactions in the OFX are like this: <NAME>INTERLINK NETWORK TRANS ****** O <MEMO>INTERLINK NETWORK TRANS ****** ON 07-03 CUSTOMER ******** PAYMENT TO ACME Is it possible to auto match Payees using...

Change Regarding Field
Quite often an e-mail thread has been started before a problem in promoted to a case. Because the regarding file is closed in existing e-mails I cannot link them to the case. Any way to change the regarding field or create a copy of the e-mail with an open regarding field? ...

Populate field on resolution of a case
I want to populate a field on the resolution of a case, however when I created a workflow on the update of status equals resolved, it errors saying "the record is marked as readonly" any ideas on how to do this before it is resolved? On 10 jul, 21:44, "Michael San Filippo" <Mich...@datacubesystems.com> wrote: > I want to populate a field on the resolution of a case, however when I > created a workflow on the update of status equals resolved, it errors saying > "the record is marked as readonly" > > any ideas on how to do this before it i...

To make fields invisible using Dexterity Utilities
Hello I know we could use Windows propoerties to make fields visible or invisible on a Window in a form. I understand we could use Dexterity Utilities to make the fields visible or invisible to user. Could anyone say how to do it Dexterity Utilities is not the correct tool to hide fields from a user. You can do this using Modifier, VBA, Field Level Security or Dexterity. Dexterity can either use triggers or you can create an alternate window. David Musgrave [MSFT] Senior Development Consultant Escalation Engineer MBS Support - Asia Pacific Microsoft Business Solutions http://www.mi...

Report Taking a Long Time to Print
I have a main report with 2 subreports in it. One of the subreports seems to be holding up the report when it comes to running and printing. When I run the query and/or report for the problem subreport it returns data within 1 minute. When I run the main report, it takes anywhere up to 5 minutes to run and about 12 minutes to print. When this subreport is removed from the main report, running and printing is under 1 minute, so I know this subreport is the problem. I had seen a post similar to this question and I tried the suggestions (removing page breaks, turning force new page ...

Resource Assignments View Filtered on Booked Type Field
I have a project that has been cancelled part way through. To deal with this, I've set the Booked Type field to be proposed for all resources in this project. This works great in that the tasks from this project no longer appear in the resources My Tasks view but they do still appear in the Resource Assignments views I have and I don't seem to be able to filter Resource Assignnments on Booked Type. Is that possible or is there another way I should be going about what I want to achieve? Which is to keep a copy of the cancelled projects plan in Project Server for refere...

Can't see categories in Budget Planner/Won't load Monthly Budget report
In the last couple of days, Money stopped showing the categories under the budget details. In the "Review your current budget status" screen, under budget details, it usually shows each income and expense category and how I'm doing so far in the month. Now none of that shows. I have made sure to check View all budget items and show expense and income in the view menu, but this does not help. In addition, Money will no longer load the monthly budget report when I click "Other Tasks, view reports, monthly budget." I have this problem no matter what budget I...

how do i show text in the data field of a pivot table?
If you put a text field into the data area of a pivot table, it will summarize the field to show a count, instead of showing the text. You can place the text fields in the Row, Column or Page areas, where their text will show. pum75 wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

Changing field sze of labels and text boxes independently
I am using Access 2007. I created a report with the wizard. Now I can't change the size of labels or text boxes without all the fields/labels changing in concert. What do I do to permit changing these things individually? Must be simple, but the help function in Acess 2007 I find not very helpful. On the arrange tab, look for the button for Remove. Highlight the controls and click remove. This will ungroup the controls. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "gg" <gg@discussions.microsoft.com> wrote in message news:92DDB6...

Adding field in Scrolling window
Hello: I was wondering how can I add a field in scrolling window if it is not mapped in DB? Thanks candidcarper Use a local field, and assign a value to it in the Fill script on the scrolling window. "ammad_u@yahoo.com" wrote: > Hello: > > I was wondering how can I add a field in scrolling window if it is not > mapped in DB? > > Thanks > > candidcarper > > ...

Making pretty reports
I am fairly proficient in the use of formulas to produce data that need for a fairly complex mortgage and real estate investmen spreadsheet, but I'm lacking in presentation. I need to be able t print a presentable report for my clients and I've had a difficult tim importing the data from my spreadsheet to Word in a reliable manner ( must not be doing something right, because it seems too tedious an time-consuming). I've tried to format a worksheet in Excel to be abl to present the data in a professional and eye-pleasing manner, bu frankly I'm just bombing-out. DOES ANYONE H...

Find field in CRM and Case search in CRM
hey: I have a ton of cases with emails attached/regarding each case individually. How can we search these cases for all cases that have a common element, for example: I want to search all my cases for the word "disconnect" to see if it appears ANYWHERE in the case, email, title, or part of this case. Anyone know how I can do this? FYI: Building a specialized advanced find won't work because I need the ability to search ANY word -- today I want Disconnect tomorrow, latency, etc... Actually, an Advanced Find might be a good way to go, because you can save your Advanced F...

automate sales order fulfillment details received through excel
We receive an excel file from our distribution center every day which has the order fulfillment details for existing sales orders. How can I load this into Great Plains? If someone has done this, any examples will be of great help. Thanks in advance, Jack Hi Jack, We have a add solution for Remote SOP using Excel interface through GP, please drop a email. Regards, Manick manick.m@hotmail.com "Jack Tundra" wrote: > We receive an excel file from our distribution center every day which has > the order fulfillment details for existing sales orders. How can I load this...

Order Entry Form
I have a form with a subform. The subform only asks for product and quantity. First time through this form works great. Second entry skips the product code and goes directly to quantity. I have tried creating this form from the tables and also a query. I have checked all the tab stops and everything else I can think of but can't seem to find what is making this happen. -- Taylor Taylor, Did you create the subform so that you know that know code is causing this? If not, then open a module and do a find on the word 'setfocus' (no quotes). If no results use the word &...

Changing the order of page numbers
Example: On a 10 page doc. you want the first 5 pages to be numbered '1' to '5' then the next 5 pages to be numbered '14' to '18' Is there a way of changing page numbers like the above example? Thanks! Ben Ben Don't understand why you want to do this but the best way is to record a macro while you do it manually. 1. print pages 1 to 5 2. go into page setup and change the first page from auto to the value 9 3. print pages 6 to 10. The page count should start at 14. 4 go into page set up and change the first page back to auto. you'll get so...

Format criteria for text field
I am writing an text box expression in a report as follows: =DLookUp("[BILLINGDATE]","[DATATABLE]","[InDate] =" & [Forms]![Invoices Query]![InDate]) The field INDATE is a text field. BILLINGDATE is a text field also. What delimiter do I need to add to the statement to make it work on a text field? I am getting garbage out. Must I change it to a numeric or date field to make it work? jayC, One has to ask why you are storing dates in a Text field instead of a Date/Time field. If you must keep the dates in a Text field, the format of the dates nee...

Clear all pivot table fields with a Macro
I have a two things I would like to do, ideally with a macro 1. Clear all fields from a pivot table 2. If any of the fields have been filtered - remove the filters I am hoping there is a simple command or two that I have not yet discovered. To put things into perspective: I have multiple pivot tables (all copies of the original table, and each on their own spreadsheet). My plan is to have each table set up for particular queries (that is with different fields and filters). I will then examine the data on each, and sometimes alter the fields as needed. But when I am done I want to press a b...

Custom date field and Fill
I have a customer that is using a date/time fill that isn't calculating the right time. It can be duplicated on a new spreadsheet. Start with "A1" and enter in "1/29/2004 7:30:50 AM" and format the column with this custom type: m/d/yyyy h:mm:ss AM/PM. the fill series should decrease by 20 seconds every cell. So I manually put in the first 5 cells as follows: 1/29/2004 7:30:50 AM 1/29/2004 7:30:30 AM 1/29/2004 7:30:10 AM 1/29/2004 7:29:50 AM 1/29/2004 7:29:30 AM Highlight the series and drag it out past A110. In cell A103 I have lost a second. the value should ...

Report window is so small
Every time I open a report, the window of the report is so small and also I have to Zoom in every time I want to read it. I also have to drag the window so it gets bigger. Is there a way to automatically have the size of the window say 700 x 500 pixels? And also I want to have it zoomed in so it looks like a word document with font Arial size 10? Aprox. that size at least. Any help is very much appreciated. Regards Jan T. You can use the event OnOpen Procedure use docmd.movesize to adjust the position and size "Jan T." <MyFirstName.MyLastName@hotmail.com> wrote in...

WLM Beta
Using WLM latest beta. I had been using messages sorted by conversation but as many are being "lost" through jumping to lower view I reverted to sort by "From". Now my incoming messages are all over the place with respect to date. No matter whether I select descending or ascending there are some messages that should be at either end but are seen in the middle of the list or elsewhere. Perhaps I am misunderstanding the "From" sort. Is it From by date order or something else? There does not seem to be a way of just sorting by "date&qu...

Internet Order download Improvement
When pulling in an Internet order to RMS via cntl-shift-F10, a basic customer match occurs. If a match is not found the only choice available is to create a new customer account. In addition to the "New" option a "Set Customer" option should be made available to allow for a more extensive search and match to occur. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this li...

inventory aging report #4
Hello: What is a good report in GP 9.0 to use if you want an inventory aging report? The stock status and historical stock status do not offer what I'm looking for. I want to see transactions in detail and their effect on inventory valuation. Thanks! childofthe1980s oh, and the report needs to also show the valuation affected by inevntory adjustments. So, the Purchase Receipts report is not good enough either. childofthe1980s "childofthe1980s" wrote: > Hello: > > What is a good report in GP 9.0 to use if you want an inventory aging > report? The stock...