Reply to topic  [ 2 posts ] 
Newbie trying to create invoice with currency and VAT calc. 
Author Message

Joined: 2007-12-09 07:53:08
Posts: 1
Location: Denmark
I am a very new user of Nisus Writer Pro and am trying to figure out how to create an invoice template with currency and VAT calculations. The actual creation of the tables and the general setup went extremely quickly and without any problems.

I just can't figure out to get a series of cells in a column to add up to a subtotal, calculate 25% of the subtotal for VAT and then add the total in the last cell of the column. I have checked both the manual and the forum, but haven't found anything that would help.


2007-12-09 08:08:10
Profile WWW
Official Nisus Person
User avatar

Joined: 2002-07-11 17:14:10
Posts: 4251
Location: San Diego, CA
Post 
There's no built-in mechanism for this. Our tables don't provide any kind of automatic calculations.

That said you could probably write a macro to do what you like. We actually ship a "sum column" macro (found on the menu Macro > calculation). The code is pretty complicated, mostly because it needs to handle currency symbols, commas, etc, but you could modify the macro to calculate a VAT.


2007-12-11 14:55:10
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software