This page demonstrates use of the wpDataTables and WP Report Builder plugins to produce a simple example invoice for download and update in Microsoft Word. The page initially display 10 items by default, so select ALL in Show Entries to display approx. 100 records as when a report is produced, it contains only the records displayed on screen. To produce a report for a single product, therefore, filter on that product and then click the Download Report button. At present, it is not possible to add 2 formulae  when creating a MicroSoft Word report for example Nett Total and Tax to create Grand Total.

Purchases Tables

wdt_ID Date Product Price Qty Total Tax Row_Total Tax 20%
1 04/04/2016 Wireless Headphone 4,400.00 10 44,000.00 7,920.00 44,000.00 8,800.00
2 04/04/2016 Gaming Keyboard 3,800.00 8 30,400.00 5,472.00 30,400.00 6,080.00
3 06/04/2016 LCD HD Monitor 12,000.00 5 60,000.00 10,800.00 60,000.00 12,000.00
4 07/04/2016 LCD HD Monitor 12,000.00 6 72,000.00 12,960.00 72,000.00 14,400.00
5 08/04/2016 Wireless Headphone 4,400.00 7 30,800.00 5,544.00 30,800.00 6,160.00
6 08/04/2016 Gaming Keyboard 3,800.00 8 30,400.00 5,472.00 30,400.00 6,080.00
7 09/04/2016 Mini Wireless Keyboard 3,300.00 2 6,600.00 1,188.00 6,600.00 1,320.00
8 09/04/2016 USB HD Webcam 1,500.00 4 6,000.00 1,080.00 6,000.00 1,200.00
9 10/04/2016 Gaming Keyboard 3,800.00 2 7,600.00 1,368.00 7,600.00 1,520.00
10 10/04/2016 USB HD Webcam 1,500.00 9 13,500.00 2,430.00 13,500.00 2,700.00
Date Product Price Qty Total Tax
∑ = 61
Close Menu
PHP Code Snippets Powered By : XYZScripts.com