Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Amend Receipt XML to s...
Small and medium business | Business Central, N...
Unanswered

Amend Receipt XML to show vat amount.

(0) ShareShare
ReportReport
Posted on by nazza 395

This is my receipt layout. Can someone please help me replace the "Location" column with VAT to show the VAT amount on each line? Really appreciate your help.

Thanks

<XML>
<PROPERTIES>
<DESCRIPTION> A4 Inv with Loc (Net of Vat) a </DESCRIPTION>
<AUTHOR> Microsoft Corporation </AUTHOR>
<VERSION> Version 1.04 </VERSION>
</PROPERTIES>
<!--
===========================
Attributes
===========================
-->
<SET name="ReceiptCount" custom="true" description="Receipt Count" type="vbLong">1</SET>
<SET name="PaperWidth" custom="true" description="Paper Width" type="vbdouble"> 8.27 </SET>
<SET name="PaperHeight" custom="true" description="Paper Height" type="vbdouble"> 11.69 </SET>
<SET name="MarginLeft" custom="true" description="Margin Left" type="vbdouble"> 0.5 </SET>
<SET name="MarginRight" custom="true" description="Margin Right" type="vbdouble"> 0.5 </SET>
<SET name="MarginTop" custom="true" description="Margin Top" type="vbdouble"> 0.5 </SET>
<SET name="MarginBottom" custom="true" description="Margin Bottom" type="vbdouble"> 0.5 </SET>
<SET name="HeaderHeight" custom="true" description="Header Height" type="vbdouble"> 3.5 </SET>
<SET name="FooterHeight" custom="true" description="Footer Height" type="vbdouble"> 1.7 </SET>
<SET name="CommentLine1" custom="true" description="Comment Line 1" type="vbString">"Thank you for your order"</SET>
<SET name="CommentLine2" custom="true" description="Comment Line 2" type="vbString">"To re-order, please call us"</SET>
<SET name="CommentLine3" custom="true" description="Comment Line 3" type="vbString"/>
<SET name="CommentLine4" custom="true" description="Comment Line 4" type="vbString"/>
<SET name="CommentLine5" custom="true" description="Comment Line 5" type="vbString"/>
<SET name="LogoFilename" custom="true" description="Logo Filename" type="vbString"/>
<SET name="ShowStoreInfo" custom="true" description="Show Store Name/Address" type="vbBoolean"> True </SET>
<SET name="ShowCustomerAddress" custom="true" description="Show Customer Address" type="vbBoolean"> True </SET>
<SET name="ShowLineDiscounts" custom="true" description="Show Line Discounts" type="vbBoolean"> False </SET>
<SET name="ShowTaxDetails" custom="true" description="Show Tax Details" type="vbBoolean"> False </SET>
<SET name="ShowBarcode" custom="true" description="Show Barcode" type="vbBoolean"> False </SET>
<SET name="ShowLogo" custom="true" description="Show Logo" type="vbBoolean"> True </SET>
<SET name="ShowComments" custom="true" description="Show Comments" type="vbBoolean"> True </SET>
<SET name="ShowDuplicate" custom="true" description="Show Duplicate" type="vbBoolean">FALSE</SET>
<SET name="ShowAccountBalance" custom="true" description="Show Customer Account Balances" type="vbBoolean"> False </SET>
<SET name="MaskCreditCard" custom="true" description="Mask Credit Card Number" type="vbBoolean"> True </SET>
<SET name="LineColor" custom="true" description="Line Color" type="vbLong"> vbRed </SET>
<!--
===========================
Variable Declarations
===========================
-->
<SET name="PageWidth" type="vbdouble"> PaperWidth - MarginLeft - MarginRight </SET>
<SET name="PageHeight" type="vbdouble"> PaperHeight - MarginTop - MarginBottom - HeaderHeight - FooterHeight</SET>
<SET name="NewAccountBalance" type="vbcurrency"> 0 </SET>
<SET name="subtot" type="vbcurrency"> 0 </SET>
<SET name="subtot1" type="vbcurrency"> 0 </SET>
<SET name="acc" type="vbDouble"> 0 </SET>
<SET name="cc" type="vbDouble"> 0 </SET>
<SET name="wo" type="vbDouble"> 0 </SET>
<SET name="td" type="vbDouble"> 0 </SET>
<SET name="ext" type="vbcurrency"> 0 </SET>
<!--
===========================
Page Settings
===========================
-->
<MARGIN>
<COPIES> ReceiptCount </COPIES>
<TOP> MarginTop + HeaderHeight </TOP>
<BOTTOM> MarginBottom + FooterHeight </BOTTOM>
<LEFT> MarginLeft </LEFT>
<RIGHT> MarginRight </RIGHT>
</MARGIN>
<!--
===========================
Font Declarations
===========================
-->
<FONT name="">
<NAME>"Times New Roman"</NAME>
<SIZE> 10 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Small">
<NAME>"Times New Roman"</NAME>
<SIZE> 10 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Smallest">
<NAME>"Times New Roman"</NAME>
<SIZE> 8 </SIZE>
<BOLD> False </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Large">
<NAME>"Times New Roman"</NAME>
<SIZE> 18 </SIZE>
<BOLD> True </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbBlack </COLOR>
</FONT>
<FONT name="Huge">
<NAME>"Times New Roman"</NAME>
<SIZE> 36 </SIZE>
<BOLD> True </BOLD>
<UNDERLINE> False </UNDERLINE>
<ITALIC> False </ITALIC>
<COLOR> vbRed </COLOR>
</FONT>
<!--
===========================
Header
===========================
-->
<SUB name="DrawHeader">
<TABLE>
<TOP> MarginTop </TOP>
<FONT> "Large" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<IF>
<CONDITION> ShowLogo </CONDITION>
<THEN>
<WIDTH> PageWidth * 0.15 </WIDTH>
</THEN>
<ELSE>
<WIDTH> 0.001 </WIDTH>
</ELSE>
</IF>
<TEXT newline="true"/>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<IF><CONDITION> ShowLogo </CONDITION>
<THEN><WIDTH> PageWidth * 0.40 </WIDTH></THEN>
<ELSE><WIDTH> PageWidth * 0.10 </WIDTH></ELSE>
</IF>
<IF><CONDITION> ShowStoreInfo </CONDITION>
<THEN><TEXT> "" </TEXT></THEN>
<ELSE><TEXT> "" </TEXT></ELSE>
</IF>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.42 </WIDTH>
<IF><CONDITION>Transaction.Type = transactionSales</CONDITION>
<THEN>
<IF><CONDITION>Transaction.Total &gt;=0</CONDITION>
<THEN><TEXT>"INVOICE"</TEXT></THEN>
<ELSE>
<TEXT>"CREDIT NOTE"</TEXT>
<SET name="cc" type="vbDouble"> 1 </SET>
</ELSE>
</IF>
</THEN>
<ELSE>
<IF><CONDITION>Transaction.Type = transactionWorkOrder</CONDITION>
<THEN>
<IF><CONDITION>Transaction.ReceiptReferenceNumber</CONDITION>
<THEN>
<TEXT>"INVOICE"</TEXT>
<SET name="wo" type="vbdouble"> 1.0 </SET></THEN>
<ELSE><TEXT>"Order Acknowledgement"</TEXT>
</ELSE>
</IF>
</THEN>
<ELSE>
<IF><CONDITION>Transaction.Type = transactionLayaway</CONDITION>
<THEN>
<TEXT>"LAYAWAY"</TEXT></THEN>
<ELSE><TEXT>Transaction.ReceiptTransactionName</TEXT></ELSE>
</IF>
</ELSE>
</IF>
</ELSE>
</IF>
</COLUMNHEADER>
</TABLE>
<!--
===========================
Store Address & trans. info
===========================
-->
<TABLE>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<IF>
<CONDITION> ShowLogo </CONDITION>
<THEN><WIDTH> PageWidth * 0.30 </WIDTH></THEN>
<ELSE><WIDTH> 0.001 </WIDTH></ELSE>
</IF>
<TEXT newline="true"/>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<IF><CONDITION> ShowLogo </CONDITION>
<THEN><WIDTH> PageWidth * 0.40 </WIDTH></THEN>
<ELSE><WIDTH> PageWidth * 0.10 </WIDTH></ELSE>
</IF>
<IF><CONDITION> ShowStoreInfo </CONDITION>
<THEN><TEXT> "" </TEXT></THEN>
<ELSE><TEXT> "" </TEXT></ELSE>
</IF>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.14 </WIDTH>
<IF>
<CONDITION> Transaction.ReceiptReferenceNumber </CONDITION>
<THEN>
<TEXT> Transaction.ReceiptReferenceNumberCaption ": " </TEXT>
</THEN>
<ELSE>
<TEXT> "" </TEXT>
</ELSE>
</IF>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.14 </WIDTH>
<IF>
<CONDITION> Transaction.ReceiptReferenceNumber </CONDITION>
<THEN>
<TEXT> Transaction.ReceiptReferenceNumber </TEXT>
</THEN>
<ELSE>
<TEXT> "" </TEXT>
</ELSE>
</IF>
</COLUMNHEADER>
<IF><CONDITION> ShowStoreInfo </CONDITION>
<THEN>
<ROW> "||" Transaction.ReceiptTransactionNumberCaption ":|" Transaction.ReceiptTransactionNumber </ROW>
<ROW> "||Account #:|" Customer.AccountNumber </ROW>
<ROW> "||Page:|\p of \t" </ROW>
</THEN>
<ELSE>
<ROW> "||" Transaction.ReceiptTransactionNumberCaption ":|" Transaction.ReceiptTransactionNumber </ROW>
<ROW> "||Account #:|" Customer.AccountNumber </ROW>
<ROW> "||Page:|\p of \t" </ROW>
</ELSE>
</IF>
<ROW> Store.Name "||Date:|" Transaction.Date </ROW>
<ROW> Store.Address1 "||Time:|" Transaction.Time </ROW>
<ROW> Store.CityStateZip "||Cashier:|" Cashier.Number </ROW>
<ROW> Store.Phone "||Register #:|" Register.Number</ROW>
<ROW> Store.Fax "||VAT #:|" Store.VATRegistrationNumber </ROW>
<ROW>
</ROW>
</TABLE>
<!--
===========================
Bill To & Ship To
===========================
-->
<TABLE>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.10 </WIDTH>
<TEXT> "Bill To:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.38 </WIDTH>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.Company </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.StreetAddress</TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.StreetAddress2</TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.CityStateZip </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.PhoneNumber </TEXT>
<TEXT skipblank="true" newline="true"> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.10 </WIDTH>
<TEXT> "Ship To:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.38 </WIDTH>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.Company </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.StreetAddress</TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.StreetAddress2</TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.CityStateZip </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.PhoneNumber </TEXT>
<TEXT skipblank="true" newline="true"> "" </TEXT>
</COLUMNHEADER>
</TABLE>
<TABLE>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.85 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<IF>
<CONDITION>Len(Transaction.Comment)</CONDITION>
<THEN>
<ROW>"Reference:|" Transaction.ReferenceNumber </ROW>
</THEN>
</IF>
<IF>
<CONDITION>Len(Transaction.Comment)</CONDITION>
<THEN>
<ROW>"Comment:|" Transaction.Comment </ROW>
</THEN>
</IF>
</TABLE>
<!--
===========================
Store Logo
===========================
-->
<IF>
<CONDITION> ShowLogo </CONDITION>
<THEN>
<PICTURE>
<FILENAME> LogoFilename </FILENAME>
<WIDTH> PageWidth * 0.15 </WIDTH>
<LEFT> MarginLeft </LEFT>
<TOP> MarginTop + 0.10 </TOP>
</PICTURE>
</THEN>
</IF>
</SUB>
<!--
===========================
Draw Footer
===========================
-->
<SUB name="DrawFooter">
<MARGIN>
<BOTTOM> MarginBottom </BOTTOM>
</MARGIN>
<TABLE>
<TOP> PaperHeight - MarginBottom - FooterHeight </TOP>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth </WIDTH>
<TEXT/>
</COLUMNHEADER>
<ROW> "Continued on next page..." </ROW>
</TABLE>
</SUB>
<!--
===========================
Draw Last Footer
===========================
-->
<SUB name="DrawLastFooter">
<MARGIN>
<BOTTOM> MarginBottom </BOTTOM>
</MARGIN>
<TABLE>
<TOP> PaperHeight - MarginBottom - FooterHeight </TOP>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth </WIDTH>
<TEXT> " " </TEXT>
</COLUMNHEADER>
</TABLE>
<IF>
<CONDITION>Transaction.Type = transactionSales | Transaction.Type = transactionWorkOrder | Transaction.Type = transactionQuote | Transaction.Type = transactionBackOrder | Transaction.Type = transactionLayaway</CONDITION>
<THEN>
<TABLE>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<IF><CONDITION> wo = 0</CONDITION>
<THEN>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.85 </WIDTH>
<TEXT> "Sub Total" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> Transaction.SubTotal </TEXT>
</COLUMNHEADER>
</THEN>
<ELSE>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.85 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
</ELSE>
</IF>
<IF>
<CONDITION> ShowTaxDetails </CONDITION>
<THEN>
<FOR each="SalesTaxes">
<IF>
<CONDITION> Transaction.SalesTaxes.ShowOnReceipt &amp; Transaction.SalesTaxes.IsTransactionMember </CONDITION>
<THEN>
<ROW> Transaction.SalesTaxes.Description "|" Transaction.SalesTaxes.Total </ROW>
</THEN>
</IF>
</FOR>
</THEN>
<ELSE>
<IF><CONDITION> wo = 0</CONDITION>
<THEN>
<ROW> "VAT|" Transaction.SalesTax </ROW>
</THEN>
</IF>
</ELSE>
</IF>
<IF>
<CONDITION> Len(Shipping.Carrier) </CONDITION>
<THEN>
<ROW> Shipping.Carrier " " Shipping.Service "|" Shipping.Charge </ROW>
<IF>
<CONDITION> Len(Shipping.Notes) </CONDITION>
<THEN>
<ROW> Shipping.Notes "|" </ROW>
</THEN>
</IF>
<IF>
<CONDITION> Len(Shipping.TrackingNumber) </CONDITION>
<THEN>
<ROW> Shipping.TrackingNumber "|" </ROW>
</THEN>
</IF>
</THEN>
</IF>
<IF><CONDITION> wo = 0</CONDITION>
<THEN>
<ROW> "Total|" Transaction.Total </ROW><ROW> " " </ROW></THEN></IF>
<IF>
<CONDITION> (Transaction.TotalDue &lt;&gt; Transaction.Total) &amp; (Transaction.Type &lt;&gt; transactionQuote) </CONDITION>
<THEN>
<IF><CONDITION> wo = 1</CONDITION>
<THEN>
<SET name="subtot" type="vbcurrency">(Transaction.TotalPurchased - Transaction.SalesTaxPurchased) </SET>
<ROW> "Sub Total|" subtot</ROW>
<ROW> "VAT Purchased|" Transaction.SalesTaxPurchased </ROW>
<ROW> "Total Purchased|" Transaction.TotalPurchased </ROW>
<SET name="subtot1" type="vbcurrency">(Transaction.TotalPurchased) </SET>
<ROW/>
</THEN>
</IF>
</THEN>
<ELSE>
<IF><CONDITION> wo = 1</CONDITION>
<THEN>
<SET name="subtot" type="vbcurrency">(Transaction.TotalPurchased - Transaction.SalesTaxPurchased) </SET>
<ROW> "Sub Total|" subtot</ROW>
<ROW> "VAT Purchased|" Transaction.SalesTaxPurchased </ROW>
<ROW> "Total Purchased|" Transaction.TotalPurchased </ROW>
<SET name="subtot1" type="vbcurrency">(Transaction.TotalPurchased) </SET>
<ROW/>
</THEN>
</IF>
</ELSE>
</IF>
<FOR each="tender">
<IF>
<CONDITION> (Tender.AmountIn &lt;&gt; 0) | (Tender.AmountInRounding &lt;&gt; 0) </CONDITION>
<THEN>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderAccount </CONDITION>
<THEN>
<IF><CONDITION> wo = 1 </CONDITION>
<THEN><ROW> Tender.Descriptor.Description "|" subtot1</ROW></THEN>
<ELSE><ROW> Tender.Descriptor.Description "|" Tender.AmountIn </ROW></ELSE>
</IF>
</THEN>
<ELSE>
<ROW> Tender.Descriptor.Description " Tendered|" Tender.AmountIn </ROW>
</ELSE>
</IF>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderCreditCard </CONDITION>
<THEN>
<IF>
<CONDITION> MaskCreditCard </CONDITION>
<THEN>
<ROW> "Card: " Tender.AccountNumberMasked "|" </ROW>
</THEN>
<ELSE>
<ROW> "Card: " Tender.AccountNumber "|" </ROW>
</ELSE>
</IF>
<ROW> "Exp: " Tender.Expiration "|" </ROW>
<ROW> "Auth: " Tender.Approvalcode "|" </ROW>
</THEN>
</IF>
<IF>
<CONDITION> (Tender.Descriptor.TenderType = tenderAccount) &amp; ShowAccountBalance </CONDITION>
<THEN>
<SET name="NewAccountBalance" type="vbcurrency"> Customer.AccountBalance + Tender.AmountIn - Tender.AmountOut </SET>
<ROW> "Previous Balance|" Customer.AccountBalance </ROW>
<ROW> "New Balance|" NewAccountBalance </ROW>
<ROW/>
</THEN>
</IF>
<IF>
<CONDITION> (Tender.Descriptor.TenderType = tenderAccount) </CONDITION>
<THEN>
<SET name="acc" type="vbDouble"> 1 </SET>
</THEN>
</IF>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderVoucher </CONDITION>
<THEN>
<ROW> "Number:" Tender.VoucherNumber "|" </ROW>
<ROW> "Previous Balance|" Tender.VoucherPreviousBalance </ROW>
<ROW> "New Balance|" Tender.VoucherNewBalance </ROW>
<ROW/>
</THEN>
</IF>
<IF>
<CONDITION> Tender.AmountInRounding &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Roundoff " Tender.Descriptor.Description "|" Tender.AmountInRounding </ROW>
</THEN>
</IF>
</THEN>
</IF>
</FOR>
<!-- RSS
<IF>
<CONDITION> Transaction.TotalTenderOut </CONDITION>
<THEN>
<FOR each="tender">
<IF>
<CONDITION> Tender.AmountOut &lt;&gt; 0 | Tender.AmountOutRounding &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Change " Tender.Descriptor.Description "|" Tender.AmountOut </ROW>
<IF><CONDITION> Tender.Descriptor.TenderType = tenderAccount </CONDITION>
<THEN><SET name="td" type="vbDouble"> 1 </SET></THEN>
</IF>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderCreditCard </CONDITION>
<THEN>
<IF>
<CONDITION> MaskCreditCard </CONDITION>
<THEN>
<ROW> "Card: " Tender.AccountNumberMasked "|" </ROW>
</THEN>
<ELSE>
<ROW> "Card: " Tender.AccountNumber "|" </ROW>
</ELSE>
</IF>
<ROW> "Auth: " Tender.ApprovalCode "|" </ROW>
</THEN>
</IF>
<IF>
<CONDITION> (Tender.Descriptor.TenderType = tenderAccount) &amp; ShowAccountBalance </CONDITION>
<THEN>
<SET name="NewAccountBalance" type="vbcurrency"> Customer.AccountBalance + Tender.AmountIn - Tender.AmountOut </SET>
<ROW> "Previous Balance|" Customer.AccountBalance </ROW>
<ROW> "New Balance|" NewAccountBalance </ROW>
<ROW/>
</THEN>
</IF>
<IF>
<CONDITION> Tender.AmountOutRounding &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Roundoff " Tender.Descriptor.Description "|" Tender.AmountOutRounding </ROW>
</THEN>
</IF>
</THEN>
</IF>
</FOR>
</THEN>
<ELSE>
<ROW> "Change Due|" Transaction.TotalTenderOut </ROW>
</ELSE>
</IF>
-->
<IF>
<CONDITION> (Transaction.TotalDue &lt;&gt; Transaction.Total) &amp; (Transaction.Type &lt;&gt; transactionQuote) </CONDITION>
<THEN>
<ROW/>
<ROW>
</ROW>
<ROW>
</ROW>
</THEN>
</IF>
</TABLE>
</THEN>
</IF>
<IF>
<CONDITION> Transaction.Type = transactionAccountPayment </CONDITION>
<THEN>
<TABLE>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.85 </WIDTH>
<TEXT> "Total Payments" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> Customer.AccountReceivables.TotalPayments </TEXT>
</COLUMNHEADER>
<IF>
<CONDITION> Customer.AccountReceivables.AppliedCredits &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Applied Credit|" Customer.AccountReceivables.AppliedCredits </ROW>
</THEN>
</IF>
<FOR each="tender">
<IF>
<CONDITION> Tender.AmountIn &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Paid " Tender.Descriptor.Description "|" Tender.AmountIn </ROW>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderCreditCard </CONDITION>
<THEN>
<IF>
<CONDITION> MaskCreditCard </CONDITION>
<THEN>
<ROW> "Card: " Tender.AccountNumberMasked "|" </ROW>
</THEN>
<ELSE>
<ROW> "Card: " Tender.AccountNumber "|" </ROW>
</ELSE>
</IF>
<ROW> "Exp: " Tender.Expiration "|" </ROW>
<ROW> "Auth: " Tender.ApprovalCode "|" </ROW>
</THEN>
</IF>
<IF>
<CONDITION> Tender.AmountInRounding &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "RoundOff " Tender.Descriptor.Description "|" Tender.AmountInRounding </ROW>
</THEN>
</IF>
</THEN>
</IF>
</FOR>
<FOR each="tender">
<IF>
<CONDITION> Tender.AmountOut &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Paid " Tender.Descriptor.Description "|" Tender.AmountOut </ROW>
<IF>
<CONDITION> Tender.Descriptor.TenderType = tenderCreditCard </CONDITION>
<THEN>
<IF>
<CONDITION> MaskCreditCard </CONDITION>
<THEN>
<ROW> "Card: " Tender.AccountNumberMasked "|" </ROW>
</THEN>
<ELSE>
<ROW> "Card: " Tender.AccountNumber "|" </ROW>
</ELSE>
</IF>
<ROW> "Auth: " Tender.ApprovalCode "|" </ROW>
</THEN>
</IF>
<IF>
<CONDITION> Tender.AmountOutRounding &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "RoundOff " Tender.Descriptor.Description "|" Tender.AmountOutRounding </ROW>
</THEN>
</IF>
</THEN>
</IF>
</FOR>
<ROW/>
<ROW> "Previous Balance|" Customer.PreviousAccountBalance </ROW>
<ROW> "Payments|" Customer.AccountReceivables.TotalPayments </ROW>
<ROW> "New Balance|" Customer.AccountBalance </ROW>
<ROW/>
</TABLE>
</THEN>
</IF>
<IF>
<CONDITION> ShowComments </CONDITION>
<THEN>
<TABLE>
<BORDER> tbAll </BORDER>
<TOP>PaperHeight - FooterHeight - MarginBottom + 0.15 </TOP>
<FONT> "Smallest" </FONT>
<COLUMNHEADER>
<ALIGNMENT>"&lt;"</ALIGNMENT>
<WIDTH>PageWidth * 0.40</WIDTH>
<IF>
<CONDITION> cc = 1</CONDITION>
<THEN>
<IF><CONDITION>td = 1</CONDITION>
<THEN>
<TEXT>"Thank you for shopping with Gaule Food "</TEXT>
<TEXT>"Your invoice is now due. "</TEXT>
<TEXT>"Please make paymnet to: "</TEXT>
<TEXT>"Gaule Food Ltd. "</TEXT>
<TEXT>"Account Number:23532569 "</TEXT>
<TEXT>" Sort Code: 20-11-43 "</TEXT>
<TEXT>" "</TEXT>
<TEXT>" "</TEXT>
<TEXT newline="true">"Thank you for Your custom."</TEXT>
</THEN>
<ELSE>
<TEXT newline="true"></TEXT>
<TEXT newline="true"> CommentLine1 </TEXT>
<TEXT newline="true">CommentLine2</TEXT>
<TEXT newline="true">CommentLine3</TEXT>
<TEXT newline="true">CommentLine4</TEXT>
<TEXT newline="true">CommentLine5</TEXT>
<TEXT newline="true"></TEXT>
<TEXT newline="true"></TEXT>
</ELSE>
</IF>
</THEN>
<ELSE>
<IF><CONDITION>acc = 1</CONDITION>
<THEN>
<TEXT>"Thank you for shopping with Gaule Food "</TEXT>
<TEXT>"Your invoice is now due. "</TEXT>
<TEXT>"Please make paymnet to: "</TEXT>
<TEXT>"Gaule Food Ltd. "</TEXT>
<TEXT>"Account Number:23532569 "</TEXT>
<TEXT>" Sort Code: 20-11-43 "</TEXT>
<TEXT>" "</TEXT>
<TEXT>" "</TEXT>
<TEXT newline="true">"Thank you for Your custom."</TEXT>
</THEN>
<ELSE>
<TEXT newline="true"></TEXT>
<TEXT newline="true"> CommentLine1 </TEXT>
<TEXT newline="true">CommentLine2</TEXT>
<TEXT newline="true">CommentLine3</TEXT>
<TEXT newline="true">CommentLine4</TEXT>
<TEXT newline="true">CommentLine5</TEXT>
<TEXT newline="true"></TEXT>
<TEXT newline="true"></TEXT>
</ELSE>
</IF>
</ELSE>
</IF>
</COLUMNHEADER>
</TABLE>
</THEN>
</IF>
<!--
===========================
Barcode
===========================
-->
<IF>
<CONDITION> ShowBarcode &amp; (Transaction.ReceiptTransactionNumber &lt;&gt; 0) </CONDITION>
<THEN>
<BARCODE>
<TOP> PaperHeight - MarginBottom - 0.5 </TOP>
<STYLE> msS3of9 </STYLE>
<UPCNOTCHES> msUPCNBelow </UPCNOTCHES>
<LEFT> MarginLeft </LEFT>
<WIDTH> PageWidth * .40 </WIDTH>
<HEIGHT> 0.2 </HEIGHT>
<PRINTCAPTION> True </PRINTCAPTION>
<BARWIDTH> 0 </BARWIDTH>
<TEXT> Transaction.ReceiptTransactionNumber </TEXT>
</BARCODE>
</THEN>
</IF>
</SUB>
<!--
===========================
Draw Duplicate
===========================
-->
<SUB name="DrawDuplicate">
<MARGIN>
<BOTTOM> MarginBottom </BOTTOM>
<TOP> MarginTop </TOP>
</MARGIN>
<TABLE>
<TOP> PaperHeight / 2 </TOP>
<FONT> "Huge" </FONT>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "^~" </ALIGNMENT>
<WIDTH> PageWidth </WIDTH>
<TEXT>"DUPLICATE RECEIPT"</TEXT>
</COLUMNHEADER>
</TABLE>
</SUB>
<SUB name="OverlayFirstPage">
<CALL> "DrawHeader" </CALL>
<CALL> "DrawFooter" </CALL>
</SUB>
<SUB name="OverlayMiddlePage">
<CALL> "DrawHeader" </CALL>
<CALL> "DrawFooter" </CALL>
</SUB>
<SUB name="OverlayLastPage">
<CALL> "DrawHeader" </CALL>
<CALL> "DrawLastFooter" </CALL>
</SUB>
<SUB name="OverlayOnlyPage">
<CALL> "DrawHeader" </CALL>
<CALL> "DrawLastFooter" </CALL>
</SUB>
<SUB name="Duplicate">
<IF>
<CONDITION> ShowDuplicate </CONDITION>
<THEN>
<CALL> "DrawDuplicate" </CALL>
</THEN>
</IF>
</SUB>
<!--
===========================
Document
===========================
-->
<DOCUMENT>
<!--
===========================
Drop & Payout
===========================
-->
<IF>
<CONDITION> Transaction.Type = transactionDrop | Transaction.Type = transactionPayOut </CONDITION>
<THEN>
<TABLE>
<BORDER> tbNone </BORDER>
<HEADERSHADE> LineColor </HEADERSHADE>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.50 </WIDTH>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.50 </WIDTH>
</COLUMNHEADER>
<ROW/>
<IF>
<CONDITION> Transaction.Type = transactionPayout </CONDITION>
<THEN>
<ROW> "Pay To:|" Transaction.PayOutRecipient </ROW>
</THEN>
</IF>
<ROW> "Comment:|" Transaction.Comment </ROW>
<ROW/>
<FOR each="tender">
<IF>
<CONDITION> Tender.AmountOut &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Amount Out (" Tender.Descriptor.Description "):|" Tender.AmountOut </ROW>
</THEN>
</IF>
</FOR>
<ROW/>
<FOR each="tender">
<IF>
<CONDITION> Tender.AmountIn &lt;&gt; 0 </CONDITION>
<THEN>
<ROW> "Amount In (" Tender.Descriptor.Description "):|" Tender.AmountIn </ROW>
</THEN>
</IF>
</FOR>
</TABLE>
</THEN>
</IF>
<!--
============================
Account Payment - Receivable date
============================
-->
<IF>
<CONDITION> (Transaction.Type = transactionAccountPayment) &amp; (Customer.AccountDateDueType = accountdueAccountReceivableDatePlusGracePeriod) </CONDITION>
<THEN>
<TABLE>
<TOP> HeaderHeight + MarginTop </TOP>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<HEADERSHADE> LineColor </HEADERSHADE>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.25 </WIDTH>
<TEXT> "Reference" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "Invoice Date:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "Due Date:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "Invoice Amount:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "Balance Due:" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.15 </WIDTH>
<TEXT> "Payment:" </TEXT>
</COLUMNHEADER>
<FOR each="AccountReceivable">
<IF>
<CONDITION> (Customer.AccountReceivable.Payment &lt;&gt; 0) | (Customer.AccountReceivable.Balance &lt;&gt; 0) </CONDITION>
<THEN>
<ROW> Customer.AccountReceivable.Reference "|" Customer.AccountReceivable.OriginalDate "|" Customer.AccountReceivable.DueDate "|" Customer.AccountReceivable.OriginalAmount "|" Customer.AccountReceivable.Balance "|" Customer.AccountReceivable.Payment </ROW>
</THEN>
</IF>
</FOR>
</TABLE>
</THEN>
</IF>
<!--
============================
Account Payment - Revolving
============================
-->
<IF>
<CONDITION> (Transaction.Type = transactionAccountPayment) &amp; (Customer.AccountDateDueType = accountdueCloseOfBillingCyclePlusGracePeriod) </CONDITION>
<THEN>
<TABLE>
<TOP> HeaderHeight + MarginTop </TOP>
<FONT> "Small" </FONT>
<BORDER> tbNone </BORDER>
<HEADERSHADE> LineColor </HEADERSHADE>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth </WIDTH>
<TEXT> "" </TEXT>
</COLUMNHEADER>
<ROW> "Payment on Account..." </ROW>
</TABLE>
</THEN>
</IF>
<!--
===========================
Transaction Details
===========================
-->
<IF>
<CONDITION> Transaction.Type = transactionSales | Transaction.Type = transactionWorkOrder | 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> vbYellow </HEADERSHADE>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.12 </WIDTH>
<TEXT> "Location" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth * 0.16 </WIDTH>
<TEXT> "Item Code" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.35 </WIDTH>
<TEXT> "Description" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.08 </WIDTH>
<TEXT> "Qty Ordered" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.08 </WIDTH>
<TEXT> "Qty Picked" </TEXT>
</COLUMNHEADER>
<!-- RSS
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.09 </WIDTH>
<TEXT> "UnitPrice Incl Vat" </TEXT>
</COLUMNHEADER>
-->
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.11 </WIDTH>
<TEXT> "Unit Price Net GBP" </TEXT>
</COLUMNHEADER>
<COLUMNHEADER>
<ALIGNMENT> "&gt;" </ALIGNMENT>
<WIDTH> PageWidth * 0.10 </WIDTH>
<TEXT> "Line Value Net of Vat" </TEXT>
</COLUMNHEADER>
<FOR each="Entry">
<IF><CONDITION>( Entry.Quantity &lt;&gt; 0) </CONDITION>
<SET name="ext2" type="vbcurrency"> (Entry.Price * Entry.QuantityPurchased) </SET>
<SET name="ext1" type="vbcurrency"> (Entry.ExtendedPrice/Entry.Quantity) </SET>
<SET name="ext" type="vbcurrency"> (Entry.ExtendedPrice-Entry.ExtendedBasePrice) </SET>
<THEN>
<IF><CONDITION> wo = 1</CONDITION>
<THEN>
<IF><CONDITION> (Entry.QuantityPurchased &lt;&gt; 0) </CONDITION>
<THEN>
<!-- <ROW> Entry.Item.BinLocation "|" Entry.Item.ItemLookupCode "|" Entry.Description "|" Entry.Quantity "|" Entry.QuantityPurchased "|" Entry.Price "|" ext1 </ROW> -->
<!-- <ROW> Entry.Item.BinLocation "|" Entry.Item.ItemLookupCode "|" Entry.Description "|" Entry.Quantity "|" Entry.QuantityPurchased "|" Entry.Price "|" Floor((Entry.ExtendedBasePrice/Entry.Quantity)*10000)/10000 "|" Entry.ExtendedBasePrice </ROW> -->
<ROW> Entry.Item.BinLocation "|" Entry.Item.ItemLookupCode "|" Entry.Description "|" Entry.Quantity "|" Entry.QuantityPurchased "|" Floor((Entry.ExtendedBasePrice/Entry.Quantity)*10000)/10000 "|" Entry.ExtendedBasePrice </ROW>
</THEN>
</IF>
</THEN>
<ELSE>
<ROW> Entry.Item.BinLocation "|" Entry.Item.ItemLookupCode "|" Entry.Description "|" Entry.Quantity "|" Entry.QuantityPurchased "|" Floor((Entry.ExtendedBasePrice/Entry.Quantity)*10000)/10000"|" Entry.ExtendedBasePrice </ROW>
</ELSE>
</IF>
</THEN>
</IF>
<!-- RSS
<IF><CONDITION>( Entry.Quantity&lt;&gt; 0)</CONDITION>
<THEN>
<IF>
<CONDITION> ((Entry.QuantityOnOrder &lt;&gt; 0) | (Entry.QuantityRTD &lt;&gt; 0)) &amp; (Transaction.Type &lt;&gt; transactionQuote) </CONDITION>
<THEN>
<ROW> "|| RTD:"Entry.QuantityRTD " On Order:"Entry.QuantityOnOrder " Picked Up:"Entry.QuantityPurchased </ROW>
</THEN>

</IF>

</THEN>
</IF>
-->
</FOR>
</TABLE>
<!--
===========================
Canceled Transaction
===========================
-->
<IF>
<CONDITION> Transaction.Type = transactionAbortedTransaction </CONDITION>
<THEN>
<TABLE>
<BORDER> tbNone </BORDER>
<COLUMNHEADER>
<ALIGNMENT> "&lt;~" </ALIGNMENT>
<WIDTH> PageWidth </WIDTH>
</COLUMNHEADER>
<ROW> "" </ROW>
<ROW> "Transaction cancelled..." </ROW>
<ROW> "" </ROW>
<ROW> "" </ROW>
</TABLE>
</THEN>
</IF>
</THEN>
</IF>
</DOCUMENT>
</XML>

  • nazza Profile Picture
    nazza 395 on at
    RE: Amend Receipt XML to show vat amount.

    Just did. Thanks a lot.

  • ToddB Profile Picture
    ToddB on at
    RE: Amend Receipt XML to show vat amount.

    Hi Nazza,

    Please PM me your email address; and I will send you the .zip file.

  • nazza Profile Picture
    nazza 395 on at
    RE: Amend Receipt XML to show vat amount.

    Thanks for that however none of the topics displays anything on the reading pane. 

  • ToddB Profile Picture
    ToddB on at
    RE: Amend Receipt XML to show vat amount.

    Hi Nazza,



    For your reference, I have attached the zipped Customization Guide which lists the available receipt variables.[View:/cfs-file/__key/communityserver-discussions-components-files/106/8865.CustomizationGuide.zip]

    This Transaction Entry Template Variable for this shows as Entry.Tax:

    pastedimage1621869538666v3.png

    _______________________________________________

    Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

    https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs
     
    pastedimage1621868505261v2.png

    This is around 7 weeks from now; and you can continue using RMS after this date, but technical support will not be available.

    I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans