It seems. what a question to the developers of OneBox
Here is the challenge: https://multiform.crm-onebox.com/4521/
We have a process amount: 679.21 EUR, which we have to pay to the supplier
screen 928
at the same time, the same amount is displayed in the Total universal block field, but with a minus sign: -679.21 EUR, screen 929
Explain why it is displayed like this
And what needs to be done. so that this field has a positive value, and not a negative one, as it is now
[file]11618[/file]
[file]11619[/file]
It seems. what a question to the developers of OneBox Here is the challenge: https://multiform.crm-onebox.com/4521/ We have a process amount: 679.21 EUR, which we have to pay to the supplier screen 928 at the same time, the same amount is displayed in the Total universal block field, but with a minus sign: -679.21 EUR, screen 929 Explain why it is displayed like this And what needs to be done. so that this field has a positive value, and not a negative one, as it is now
anonymous duck OneBox production Employee wrote: outgoing process? Amounts are minus, for incoming - plus.
this I know but how to deal with what happens to payments in progress here is a specially made video https://youtu.be/XGBoAnEKnwg
[quote]
anonymous duck
OneBox production
Employee wrote:
outgoing process? Amounts are minus, for incoming - plus.
[/quote]
this I know
but how to deal with what happens to payments in progress
here is a specially made video https://youtu.be/XGBoAnEKnwg
anonymous duck OneBox production Employee wrote: Slava, well, honestly - not up to a 5-minute video. Can you just explain in two words and a screen?
Dim, I know that you don't like videos much let me try to explain yes, I have an outgoing process, this is a purchase I make a payment for 679.21 EUR, it is correctly formed and processed as outgoing screen 931 but i have a field that i am updating because i am calculating the payment balance using the formula [suminorder]-[sumpaid] then they explained to me that the system supposedly stored these amounts and therefore, when calculating, I get -679.21-679.21 \u003d -1358.42 instead of the expected 679.21-679.21=0 I tried changing the formula to something like this -[suminorder]-[sumpaid] nothing worked then to this one ([suminorder]-[suminorder]*2)-[sumpaid] expected result when calculating 0 because (-679.21- (-679.21*2)) - 679.21=0 - on - according to the mathematical rules of calculation should give +, but in fact I get -2716.84 it looks like the math rules when calculating in the OneBox formula don't work the question is how to get 0 in an additional field when paying the entire amount of the process, and not doubling the amount, as it turns out now
[quote]
anonymous duck
OneBox production
Employee wrote:
Slava, well, honestly - not up to a 5-minute video. Can you just explain in two words and a screen?
[/quote]
Dim, I know that you don't like videos much
let me try to explain
yes, I have an outgoing process, this is a purchase
I make a payment for 679.21 EUR, it is correctly formed and processed as outgoing
screen 931
but i have a field that i am updating because i am calculating the payment balance using the formula
[suminorder]-[sumpaid]
then they explained to me that the system supposedly stored these amounts
and therefore, when calculating, I get -679.21-679.21 \u003d -1358.42
instead of the expected 679.21-679.21=0
I tried changing the formula to something like this
-[suminorder]-[sumpaid]
nothing worked
then to this one
([suminorder]-[suminorder]*2)-[sumpaid]
expected result when calculating 0 because
(-679.21- (-679.21*2)) - 679.21=0
- on - according to the mathematical rules of calculation should give +,
but in fact I get -2716.84
it looks like the math rules when calculating in the OneBox formula don't work
the question is how to get 0 in an additional field when paying the entire amount of the process, and not doubling the amount, as it turns out now
[file]11628[/file]
and if you need to put two minuses on top of each other, then you had to take the minus number in the arches. You yourself when you counted (-679,21- (-679,21*2)) took it into the arms, but didn’t tell the box, but simply wrote ([suminorder]-[suminorder]*2)-[sumpaid] instead of ([suminorder]- ([suminorder])*2)-([sumpaid]) so I got a joint. But better use abs
and if you need to put two minuses on top of each other, then you had to take the minus number in the arches. You yourself when you counted (-679,21- (-679,21*2)) took it into the arms, but didn’t tell the box, but simply wrote ([suminorder]-[suminorder]*2)-[sumpaid] instead of ([suminorder]- ([suminorder])*2)-([sumpaid]) so I got a joint. But better use abs
anonymous duck OneBox production Employee wrote: abs([suminorder])-abs([sumpaid])
and this thing is really cool, sorry I didn’t know before
[quote]
anonymous duck
OneBox production
Employee wrote:
abs([suminorder])-abs([sumpaid])
[/quote]
and this thing is really cool, sorry I didn’t know before
anonymous duck OneBox production Employee wrote: abs([suminorder])-abs([sumpaid])
Thank you, and I have twisted the formulas more than once to solve this problem, now I will know
[quote]
anonymous duck
OneBox production
Employee wrote:
abs([suminorder])-abs([sumpaid])
[/quote]
Thank you, and I have twisted the formulas more than once to solve this problem, now I will know
anonymous duck OneBox production Employee wrote: abs([suminorder])-abs([sumpaid])
yeah that is, it was just necessary to take the value modulo checked Dim, it helped. :)
[quote]
anonymous duck
OneBox production
Employee wrote:
abs([suminorder])-abs([sumpaid])
[/quote]
yeah
that is, it was just necessary to take the value modulo
checked
Dim, it helped.
:)
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up