Account Statements with Template Layout

V5 Question
12

Transaction list would show payments also, so if not paid in full.
Its a statement of account, thats it.

Example of what I mean;

06/11/15  12:03      Ticket 428                     £  54.20
07/11/15  14:12      Ticket 497                     £  24.50
07/11/15  16:01      Ticket 502                     £  32.80
07/11/15  16:01      Payment Cash                  -£ 111.50
08/11/15  18:46      Ticket 521                     £  54.20

So a statement/bill would look something like this;
Although this has room number and guest name it would be same principle for customer accounts where it would obviously be customer name and account would be whatever the customer account is formatted to [Name]-[Number]?

                        Hotel Name
                         Address
                          Email
                         Website
                        VAT Number

Date:  08/11/15                  Account: Room 1
Time:  19:52                     Guest Name: Joe Trice-Rolph

06/11/15  12:03      Ticket 428                     £  54.20
07/11/15  14:12      Ticket 497                     £  24.50
07/11/15  16:01      Ticket 502                     £  32.80
07/11/15  16:01      Payment Cash                  -£ 111.50
08/11/15  18:46      Ticket 521                     £  54.20

Total Charges:                                      £ 165.70
Total Payments:                                     £ 111.50
Balance Due:                                        £  54.20


VAT Breakdown
Total Charges: £ 165.70
VAT Included:  £  27.62
Net Charges:   £ 138.10

The right hand column would either be +/- transaction values or two columns as on the print account transactions Credit/Debit columns, either way, columns are already implemented in the action so they would probably be easier to go with.
So would expect a template something like this (template tags may not be 100% as typed off top of my head but should show the idea);

                    Hotel Name
                     Address
                      Email
                     Website
                    VAT Number

Date:  {DATE}                    Account: {ENTITY NAME:Rooms}
Time:  {TIME}                    Guest Name: {ENTITY DATA:Rooms:Guest Name}

{ACCOUNT TRANSACTION DETAILS:{ENTITY DATA:Account}} 

Total Charges:                                      £ {ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}}
Total Payments:                                     £ {ACCOUNT TRANSACTION CREDIT TOTAL:{ENTITY DATA:Account}}
Balance Due:                                        £  [=F({ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}}-{ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}})]


VAT Breakdown
Total Charges: £ {ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}}
VAT Included:  £   [=F({ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}/6}
Net Charges:   £ [=F({ACCOUNT TRANSACTION DEBIT TOTAL:{ENTITY DATA:Account}/1.2}
2 Likes