Hi we are looking to remove the time print out on our Purchase Orders under the "date required" field. Any ideas?
Thanks,
Devon
*This post is locked for comments
Thanks Ryan that's what we figured.
Devon
Devon,
I am sorry, but after looking into this further it does not appear that this can be easily changed. Odd that no other Date variables I have worked with include time, but there are not functions available to trim this out either.
Hi Ryan, sorry for the late response. Yes, I would just like to remove this from the print out.
Here's a screenshot of our purchase order. Note under "ship date" there is a time next to the date. (I believe this was originally labelled "Required Date")
Here's the XML from the PO in Headquarters.
XML>
<PROPERTIES>
<DESCRIPTION> XML Purchase Order </DESCRIPTION>
<AUTHOR> Microsoft Corporation </AUTHOR>
<VERSION> Version 1.01 </VERSION>
</PROPERTIES>
<!-- ========================= -->
<!-- Variable Declarations -->
<!-- ========================= -->
<!-- These variables may be altered: -->
<SET name="PaperWidth" custom="true" description="Paper Width" type="vbDouble"> 8.50 </SET>
<SET name="PaperHeight" custom="true" description="Paper Height" type="vbDouble"> 11.00 </SET>
<SET name="LogoWidth" custom="true" description="Logo Width" type="vbDouble"> 1.125 </SET>
<SET name="LogoFilename" custom="true" description="Logo Filename" type="String"> </SET>
<SET name="HeaderHeight" custom="true" description="Margin Left" type="vbDouble"> 0.75 </SET>
<SET name="FooterHeight" custom="true" description="Footer Height" type="vbDouble"> 0.25 </SET>
<SET name="TotalsHeight" custom="true" description="Totals Height" type="vbDouble"> 1.8 </SET>
<SET name="MarginLeft" custom="true" description="Margin Left" type="vbDouble"> 0.30 </SET>
<SET name="MarginRight" custom="true" description="Margin Right" type="vbDouble"> 0.25 </SET>
<SET name="MarginTop" custom="true" description="Margin Top" type="vbDouble"> 0.50 </SET>
<SET name="MarginBottom" custom="true" description="Margin Bottom" type="vbDouble"> 0.50 </SET>
<SET name="PageWidth" description="Page Width" type="vbDouble"> PaperWidth - MarginLeft - MarginRight </SET>
<SET name="PageHeight" description="Page Height" type="vbDouble"> PaperHeight - MarginTop - MarginBottom - HeaderHeight - FooterHeight</SET>
<!-- Margin -->
<MARGIN>
<TOP> MarginTop + HeaderHeight </TOP>
<BOTTOM> MarginBottom </BOTTOM>
<LEFT> MarginLeft </LEFT>
<RIGHT> MarginRight </RIGHT>
</MARGIN>
<FONT name="">
<!-- No ID is default font -->
<NAME> "Arial" </NAME>
<SIZE> 12 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Small">
<NAME> "Arial" </NAME>
<SIZE> 10 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="SmallBold">
<NAME> "Arial" </NAME>
<SIZE> 10 </SIZE>
<BOLD> True </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Tiny">
<NAME> "Arial" </NAME>
<SIZE> 8 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> True </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Large">
<NAME> "Arial" </NAME>
<SIZE> 18 </SIZE>
<BOLD> True </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<SUB name="PrintHeader">
<!-- =========================================================================- -->
<!-- STUB -->
<!-- =========================================================================- -->
<TABLE>
<FONT> "Large" </FONT>
<BORDER> tbNone </BORDER>
<TOP> MarginTop </TOP>
<COLUMNHEADER>
<ALIGNMENT> " <~" </ALIGNMENT>
<WIDTH> PageWidth * 0.10 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> " <~" </ALIGNMENT>
<WIDTH> PageWidth * 0.50 </WIDTH>
<TEXT> Configuration.StoreName </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">~" </ALIGNMENT>
<WIDTH> PageWidth * 0.40 </WIDTH>
<TEXT> "Purchase Order" </TEXT>
</COLUMNHEADER>
</TABLE>
<TABLE>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "<~" </ALIGNMENT>
<WIDTH> PageWidth * .10 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "<~" </ALIGNMENT>
<WIDTH> PageWidth * .50 </WIDTH>
<TEXT> Configuration.StoreAddress </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">~" </ALIGNMENT>
<WIDTH> PageWidth * .40 </WIDTH>
<TEXT> "PO NUMBER: " PurchaseOrder.Number </TEXT>
</COLUMNHEADER>
<ROW> "|" Configuration.CityStateZip "|" </ROW>
<ROW> "" </ROW>
<ROW> "" </ROW>
</TABLE>
<!-- =========================================================================- -->
<!-- Logo -->
<!-- =========================================================================- -->
<PICTURE>
<TOP> MarginTop + 0.1 </TOP>
<!-- Height = .75 -->
<LEFT> MarginLeft </LEFT>
<WIDTH> PageWidth * .10 </WIDTH>
<FILENAME> LogoFilename </FILENAME>
</PICTURE>
<!-- ========================= -->
<!-- Barcode -->
<!-- ========================= -->
<Barcode>
<STYLE> msSExtendedCode93 </STYLE>
<UPCNOTCHES> msUPCNBelow </UPCNOTCHES>
<TEXT> PurchaseOrder.Number </TEXT>
<TOP> MarginTop + 0.5 </TOP>
<LEFT> MarginLeft + PageWidth * 0.8 </LEFT>
<WIDTH> PageWidth * 0.2 </WIDTH>
<HEIGHT> 0.2 </HEIGHT>
<ALIGN> bcaLeft </ALIGN>
<PRINTCAPTION> False </PRINTCAPTION>
<BARWIDTH> 0 </BARWIDTH>
</Barcode>
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
</SUB>
<SUB name="PrintAddress">
<!-- =========================================================================- -->
<!-- To & ShipTo -->
<!-- =========================================================================- -->
<TABLE>
<TOP> MarginTop + HeaderHeight </TOP>
<FONT> "Small" </FONT>
<PENSTYLE> psSolid </PENSTYLE>
<HEADERSHADE> vbYellow </HEADERSHADE>
<BORDER> tbBoxColumns </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "<" </ALIGNMENT>
<WIDTH> PageWidth * .50 </WIDTH>
<TEXT newline="true"> "TO" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "<" </ALIGNMENT>
<WIDTH> PageWidth * .50 </WIDTH>
<TEXT> "SHIP TO" </TEXT>
</COLUMNHEADER>
<IF>
<CONDITION> Len(PurchaseOrder.ShipTo) | Len(PurchaseOrder.Supplier) </CONDITION>
<THEN> <ROW> PurchaseOrder.Supplier "|" PurchaseOrder.ShipTo </ROW> </THEN>
<ELSE>
<ROW> " | " </ROW>
<ROW> " | " </ROW>
<ROW> " | " </ROW>
<ROW> " | " </ROW>
<ROW> " | " </ROW>
<ROW> " | " </ROW>
</ELSE>
</IF>
</TABLE>
<!-- =========================================================================- -->
<!-- PO Info -->
<!-- =========================================================================- -->
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
<!-- ========== -->
<!-- Line 1 -->
<!-- ========== -->
<TABLE>
<FONT> "Small" </FONT>
<PENSTYLE> psSolid </PENSTYLE>
<HEADERSHADE> vbYellow </HEADERSHADE>
<BORDER> tbBoxColumns </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .15 </WIDTH>
<TEXT> "P.O. DATE" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .15 </WIDTH>
<TEXT> "SHIP DATE" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .20 </WIDTH>
<TEXT> "REQUISITIONER" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .50 </WIDTH>
<TEXT> "REMARKS" </TEXT>
</COLUMNHEADER>
<ROW> PurchaseOrder.DateCreated "|" PurchaseOrder.DateRequired "|" PurchaseOrder.Requisitioner "|" PurchaseOrder.Remarks </ROW>
</TABLE>
<!-- =========================================================================- -->
<!-- Space -->
<!-- =========================================================================- -->
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
<!-- =========================================================================- -->
<!-- Line 2 -->
<!-- =========================================================================- -->
<TABLE>
<FONT> "Small" </FONT>
<BORDER> tbBoxColumns </BORDER>
<HEADERSHADE> vbYellow </HEADERSHADE>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .15 </WIDTH>
<TEXT> "SHIP VIA" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .15 </WIDTH>
<TEXT> "F.O.B. POINT" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .20 </WIDTH>
<TEXT> "TERMS" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .21 </WIDTH>
<TEXT> "FREIGHT" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .29 </WIDTH>
<TEXT> "POWER TAILGATE REQUIRED" </TEXT>
</COLUMNHEADER>
<ROW> PurchaseOrder.ShipVia "|" PurchaseOrder.FOBPoint "|" PurchaseOrder.Terms "|" PurchaseOrder.Freight "|" PurchaseOrder.ConfirmingTo </ROW>
</TABLE>
<!-- =========================================================================- -->
<!-- Space -->
<!-- =========================================================================- -->
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
</SUB>
<SUB name="PrintEntries">
<!-- =========================================================================- -->
<!-- PO Entries -->
<!-- =========================================================================- -->
<TABLE>
<FONT> "Small" </FONT>
<HEADERSHADE> vbYellow </HEADERSHADE>
<PENSTYLE> psSolid </PENSTYLE>
<BORDER> tbBoxColumns </BORDER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * 0.08 </WIDTH>
<TEXT> "QTY" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "<" </ALIGNMENT>
<WIDTH> PageWidth * 0.23 </WIDTH>
<TEXT> "ORDER NUMBER" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "<" </ALIGNMENT>
<WIDTH> PageWidth * 0.31 </WIDTH>
<TEXT> "DESCRIPTION" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "UNIT PRICE" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "TOTAL" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * 0.08 </WIDTH>
<TEXT> "TAX(%)" </TEXT>
</COLUMNHEADER>
<IF>
<CONDITION> PurchaseOrder.Entries.Count = 0 </CONDITION>
<THEN>
<ROW> "|||||" </ROW>
<ROW> "|||||" </ROW>
<ROW> "***|***|***|*** No entries exist for this PO ***|***|***|***" </ROW>
<ROW> "|||||" </ROW>
<ROW> "|||||" </ROW>
</THEN>
<ELSE>
<FOR each="PurchaseOrderEntry">
<ROW> PurchaseOrder.Entry.QuantityOrdered "|" PurchaseOrder.Entry.OrderNumber "|" PurchaseOrder.Entry.Description "|" PurchaseOrder.Entry.UnitPrice "|" PurchaseOrder.Entry.ExtendedPriceOrdered "|" PurchaseOrder.Entry.TaxRate </ROW>
</FOR>
</ELSE>
</IF>
<EXTENDLASTROW> True </EXTENDLASTROW>
<EXTENDLASTROWMARGIN> TotalsHeight </EXTENDLASTROWMARGIN>
</TABLE>
<!--
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
-->
</SUB>
<SUB name="PrintTotals">
<!-- =========================================================================- -->
<!-- Tail -->
<!-- =========================================================================- -->
<!-- Needs to position itself exactly at the bottom of the last page, or if there's not enough room, print itself on -->
<!-- the next page. -->
<TABLE>
<FONT> "Small" </FONT>
<BORDER> tbboxcolumns </BORDER>
<HEADERSHADE> vbYellow </HEADERSHADE>
<PENSTYLE> psSolid </PENSTYLE>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * .77 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * .23 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<ROW> "SUB TOTAL|" PurchaseOrder.SubTotal </ROW>
<ROW> "SALES TAX|" PurchaseOrder.TaxTotal </ROW>
<ROW> "SHIPPING & HANDLING|" PurchaseOrder.ShipRate </ROW>
</TABLE>
<TABLE>
<FONT> "SmallBold" </FONT>
<BORDER> tbboxcolumns </BORDER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * .77 </WIDTH>
<TEXT newline="true"> "TOTAL" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">" </ALIGNMENT>
<WIDTH> PageWidth * .23 </WIDTH>
<TEXT newline="true"> PurchaseOrder.Total </TEXT>
</COLUMNHEADER>
</TABLE>
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
<PARAGRAPH>
<TEXT newline="true"> "" </TEXT>
</PARAGRAPH>
<TABLE>
<FONT> "Small" </FONT>
<BORDER> tbTop </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .375 </WIDTH>
<TEXT> "AUTHORIZED BY" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth * .125 </WIDTH>
<TEXT> "DATE" </TEXT>
</COLUMNHEADER>
</TABLE>
</SUB>
<SUB name="PrintFooter">
<TABLE>
<TOP> PaperHeight - MarginBottom - FooterHeight </TOP>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "<~" </ALIGNMENT>
<WIDTH> PageWidth * 0.5 </WIDTH>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> ">~" </ALIGNMENT>
<WIDTH> PageWidth * 0.5 </WIDTH>
</COLUMNHEADER>
<ROW> "P.O. NUMBER: " PurchaseOrder.Number "|Page \p of \t" </ROW>
</TABLE>
</SUB>
<SUB name="OverlayFirstPage">
<CALL> "PrintFooter" </CALL>
</SUB>
<SUB name="OverlayMiddlePage">
<CALL> "PrintHeader" </CALL>
<CALL> "PrintFooter" </CALL>
</SUB>
<SUB name="OverlayLastPage">
<CALL> "PrintHeader" </CALL>
<CALL> "PrintFooter" </CALL>
</SUB>
<SUB name="OverlayOnlyPage">
<CALL> "PrintHeader" </CALL>
<CALL> "PrintFooter" </CALL>
</SUB>
<DOCUMENT>
<!-- header must be printed as a NON-overlay on the first page due to export-to-html issues -->
<CALL> "PrintHeader" </CALL>
<CALL> "PrintAddress" </CALL>
<CALL> "PrintEntries" </CALL>
<CALL> "PrintTotals" </CALL>
</DOCUMENT>
</XML>
Thanks,
Devon
Devon,
Do you mean you wish to remove this from the print out? Because on mine I don't even see this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156