![]() |
Invoice formatting |
Post Reply ![]() |
Author | |
rscass ![]() Senior Member ![]() Joined: 07 November 2007 Status: Offline Points: 720 |
![]() ![]() ![]() ![]() ![]() Posted: 31 May 2019 at 10:59am |
At present, Romancart invoice totals are laid out as follows:
Subtotal, <subtotal> tag, 'displays total of all items, including tax, before shipping is added'. Total shipping VAT Total Would it be possible to create a new tag, <subtotalnet> which will return the total of all items excluding VAT? ie, the combined value of all numbers generated in the <itemtotalnetprice> fields? Would it be possible to creat a new tag <totalshippingnet> which will return the total shipping cost without VAT? A number of my customers are Health Authorities. For example, the standard accounting layout for a VAT receipt, as required by them, and as generated with most accounts packages is as follows: Goods, net price - 10.00 Goods, net price - 10.00 Goods, net price - 10.00 Goods, net price - 10.00 Goods, subtotal, exc. VAT - 40.00 Total shipping, exc. VAT - 5.00 VAT - 9.00 Invoice total - 54.00 or:- Goods, net price - 10.00 Goods, net price - 10.00 Goods, net price - 10.00 Goods, net price - 10.00 Total shipping, exc. VAT - 5.00 Subtotal, exc. VAT - 45.00 VAT - 9.00 Invoice total - 54.00 Looks like I could create either quite easily if I had the tags which would populate the fields with total goods before VAT and total shipping before VAT. At present, I have to copy and paste Romancart invoices into word, manually amend the fields, resave as a pdf and send the bill. It's a pain. Richard. |
|
![]() |
|
Support ![]() RomanCart Team ![]() Joined: 16 March 2004 Location: United Kingdom Status: Offline Points: 10794 |
![]() ![]() ![]() ![]() ![]() |
Hi Richard,
Apologies for the delay in replying - I saw your message on the poll. We did take a look at your question and it's not a simple piece of work with high risk. That doesn't mean we won't do it, but it's one of those things where we need a quiet moment to really have a look at it properly and we have not had that yet. I will update on this when available. Many thanks Simon RomanCart Support |
|
![]() |
|
rscass ![]() Senior Member ![]() Joined: 07 November 2007 Status: Offline Points: 720 |
![]() ![]() ![]() ![]() ![]() |
Emailed earlier, should of posted on the forum so it makes sense to others looking for similar. -
Thank you Simon. To be clear, I’m not suggesting for one moment that invoices should be reconfigured by default. The thing I particularly like about RomanCart is the ability to customise things. I’ll send a copy of an invoice which I sent to the NHS last week. The wombles they employ in purchasing simply cannot get their heads round the standard RomanCart version [in particular, the placement of 'subtotals' inc. VAT]. This is an example of a standard format (I use ’standard’ loosely, there isn’t a manual/set of hard rules - It’s what would be generated in Sage or similar) VAT invoice. The only variation would be whether the shipping line went before or after the subtotal depending on preference. In my example it’s irrelevant because the shipping prices are included for sales to this customer. As you will see, I could make an html Romancart template easily, provided I could generate a subtotal excl. VAT and a shipping total excl. VAT. I would not use such a template for non VAT registered customers because it would cause confusion. There is also the potential issue of rounding errors caused by recalculating the VAT as 16.666% of the gross on separate lines. Also a mix of zero rated and standard rated goods could be foreseen, but not for what I sell. Best wishes, Richard. Edited by rscass - 05 June 2019 at 1:00pm |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |