Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Remove time from HQ Purchase Order "date required" field

Posted on by 1,565

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

  • DEVON LEROUX Profile Picture
    DEVON LEROUX 1,565 on at
    Re: Remove time from HQ Purchase Order "date required" field

    Thanks Ryan that's what we figured.

    Devon

  • Verified answer
    Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: Remove time from HQ Purchase Order "date required" field

    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.

  • DEVON LEROUX Profile Picture
    DEVON LEROUX 1,565 on at
    Re: Remove time from HQ Purchase Order "date required" field

    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> " &lt;~" </ALIGNMENT>
       <WIDTH> PageWidth * 0.10 </WIDTH>
             <TEXT> "" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> " &lt;~" </ALIGNMENT>
       <WIDTH> PageWidth * 0.50 </WIDTH>
             <TEXT> Configuration.StoreName </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;~" </ALIGNMENT>
             <WIDTH> PageWidth * 0.40 </WIDTH>
             <TEXT> "Purchase Order" </TEXT>
          </COLUMNHEADER>

       </TABLE>

       <TABLE>

          <BORDER> tbNone </BORDER>

          <COLUMNHEADER>
             <ALIGNMENT> "&lt;~" </ALIGNMENT>
       <WIDTH> PageWidth * .10 </WIDTH>
             <TEXT> "" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&lt;~" </ALIGNMENT>
        <WIDTH> PageWidth * .50 </WIDTH>
             <TEXT> Configuration.StoreAddress </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;~" </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> "&lt;" </ALIGNMENT>
             <WIDTH> PageWidth * .50 </WIDTH>
             <TEXT newline="true"> "TO" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&lt;" </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> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * 0.08 </WIDTH>
             <TEXT> "QTY" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&lt;" </ALIGNMENT>
             <WIDTH> PageWidth * 0.23 </WIDTH>
             <TEXT> "ORDER NUMBER" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&lt;" </ALIGNMENT>
             <WIDTH> PageWidth * 0.31 </WIDTH>
             <TEXT> "DESCRIPTION" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * 0.15 </WIDTH>
             <TEXT> "UNIT PRICE" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * 0.15 </WIDTH>
             <TEXT> "TOTAL" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </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> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * .77 </WIDTH>
             <TEXT> "" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * .23 </WIDTH>
             <TEXT> "" </TEXT>
          </COLUMNHEADER>

          <ROW> "SUB TOTAL|" PurchaseOrder.SubTotal </ROW>
          <ROW> "SALES TAX|" PurchaseOrder.TaxTotal </ROW>
          <ROW> "SHIPPING &amp; HANDLING|" PurchaseOrder.ShipRate </ROW>
       </TABLE>

       <TABLE>
          <FONT> "SmallBold" </FONT>
          <BORDER> tbboxcolumns </BORDER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </ALIGNMENT>
             <WIDTH> PageWidth * .77 </WIDTH>
             <TEXT newline="true"> "TOTAL" </TEXT>
          </COLUMNHEADER>

          <COLUMNHEADER>
             <ALIGNMENT> "&gt;" </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> "&lt;~" </ALIGNMENT>
       <WIDTH> PageWidth * 0.5 </WIDTH>
      </COLUMNHEADER>

      <COLUMNHEADER>
       <ALIGNMENT> "&gt;~" </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

     

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: Remove time from HQ Purchase Order "date required" field

    Devon,

    Do you mean you wish to remove this from the print out?  Because on mine I don't even see this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans