Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Invoice Statement Document

Hi Experts,

Can we create Invoice statement like below template?

«INVOICETITLE»

Invoice Date

«InvoiceDate»

Account Number

«ContactAccountNumber»

Invoice Number

«InvoiceNumber»

Reference

«Reference»

«OrganisationTaxDisplayName»
«OrganisationTaxDisplayNumber»

«OrganisationName»

«OrganisationPostalAddress»

«ContactName»

«ContactPostalAddress»

«ContactTaxDisplayName» «ContactTaxNumber»

Description

Quantity

Unit Price

«TaxUnitName»

Amount «InvoiceCurrency»

«TableStart:LineItem»«Description»

«Quantity»

«UnitAmount»

«TaxPercentageOrName»

«LineAmount»«TableEnd:LineItem»

«DefaultCurrency» Equivalent Conversion

«CurrencyConversionMessage»

«TAXUNITNAME» RATES

NET GOODS

«TAXUNITNAME»

«TableStart:TaxItem»«TaxCode»

«NetGoodsAmount»

«TaxTotal»«TableEnd:TaxItem»

Subtotal

«InvoiceSubTotal»

«TableStart:TaxSubTotal»Total «TaxCode»

«TaxTotal»«TableEnd:TaxSubTotal»

Invoice Total «InvoiceCurrency»

«InvoiceTotal»

Total Net Payments «InvoiceCurrency»

«InvoiceTotalNetPayments»

Amount Due «InvoiceCurrency»

«InvoiceAmountDue»

Due Date: «InvoiceDueDate»

«PaymentImage»
«PaymentMessageAndUrl»

Is there any samples for this Please share those. Thanks in advance.

Regards,

Kabilan K.

1 Solution

Accepted Solutions
vikasmahajan

PFA

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

7 Replies
its_anandrjs

Yes you can by the help of the

1. variables.

2. Text objects

Also you can go through with the N-Printing features on this.

Regards,

Anand

avinashelite

Try like this ...

Create text objects for each data you want to show and align them in the sheet ..which gives the appears as above

vikasmahajan

see this link Re: Re: Creating a report

Refer Invoice.qvw by ROB

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

PFA

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Not applicable
Author

Thanks all of you for u better answer,


@vikasmahajan ---I m not able to open this invoice.qvw file... since i m using the personal edition..

Could u pls open in personal edition and open it and save it and upload it,,, so that i can open it.

Thanks in advance.

sunny_talwar

If you don't have license then I don't think Vikas can do anything to make it such that you can open it on your personal edition. AFAIK only Qlik has that ability