Hello Friends; Greetings from Rusty Old Palestine;
Today I would like to discuss with you if it is worth while to allocate resources to this feature:
[adding an equation box to custom fields, which multiply, divide, add, or subtract numbers and then calculate and send the sum to another field]
My Team -which is a Saas Company in Palestine- really needs such a feature, it has been requested from at least 4 customers so far.
After much discussion within our small team; we really can’t find anything worth more work than this feature; manager can easily adapt to any organization; which set’s it up from any other software; this feature will make it the best adaptable software in the market -for people who do not know code; which is 90% of population- [all of us are ready to put work into this -3 developers-]
Regarding to this thread, I have another specific question.
In my business I sometimes have to deal with rights.
This means that a percentage of my article price should be invoiced as rights (with a different VAT).
EDITING OF CORPORATE MOVIE €250 21% €302.5
This should become…
EDITING OF CORPORATE MOVIE €162.5 21% €196,63
User Rights €87,5 6% €92,75
First line = services at 65% of the amount.
Second line = rights at 35% of the amount.
Now, I have to do this manually.
Is there a way to do this with custom fields?
Something like adding a number custom field on an article.
If this number is not blank (the percentage of the rights), automatically calculate the rights and put it on the line below. AND, change the total price of the article to 65%.
I suppose this can only be done when generating the invoice because?? But what could be the code?
Or should I use 2 custom fields with both percentages?
You cannot do anything close to what you describe, @Bart_De_Jonge. Tax codes cannot be applied to custom fields, only line item amounts, which cannot be involved in calculations with custom fields. Taxes are interwoven through the hard coding in some fairly complex ways. Those calculations have to be done by the program and posted to correct accounts. The type of calculations described in this thread are for display purposes only. They do not store information or post amounts to accounts.
If your job or hourly rates are standardized, you could create non-inventory items for editing and user rights. The sales prices (per job or hour) could be fixed at your desired ratio. Tax codes for the different rates could be set for each non-inventory item. Separate posting accounts could be selected, if desired.
Then, let us say you edit your movie. You would enter the editing item, quantity 1, and on another line the user rights item, quantity 1, and you would have your total. This would be the routine for a fixed rate.
For an hourly rate, you would enter the hours as the quantity for each non-inventory item. The ratio would be preserved, proper tax codes applied, etc.
It would all be fairly automatic and avoid the need for tedious calculation for every job. Set up the non-inventory sales prices per job or hour once.
This is exactly what I do now.
The only difference is that I only use 1 non-inventory item ‘rights’ for everything.
Because I have for some clients different prices, and that should create too much ‘rights’-items.
I was wondering:
Can’t I work with discount 35% per line on the editing item, and then use the rights-item as follows:
line 1 : editing 1 €250 discount 35% €162.5
line 2 : rights 250 €0,35 €87,5
Then change the layout to not print the discount, and adding a custom column to indicate the rights percentage…?
Better would be adding a functionality of calculated fields
Your approach gets into a lot of problems. You would have a unit price, an invisible discount, and a magically different amount. And the code to eliminate the discount column would not be trivial, possibly blowing up the layout. (I don’t know.)
You also encounter the problem that in-line custom fields cannot be set as numbers. So no calculations are possible with them using Liquid’s arithmetic filters.
This would involve very significant changes to the program. You are talking about calculations involving multiple line items. Everything in Manager is structured on a line-item basis except the totals.