1b.app
Link copied -

OS - negative sum Total for the process in the universal block

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
Original question is available on version: ru Вячеслав Легеза

Answers:

outgoing process? Amounts are minus, for incoming - plus.
25.10.2021, 13:34
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

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
25.10.2021, 13:38
Вячеслав Легеза Original comment available on version: ru

Slava, well, honestly - not up to a 5-minute video. Can you just explain in two words and a screen?
25.10.2021, 13:51
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

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
25.10.2021, 14:32
Вячеслав Легеза Original comment available on version: ru

abs([suminorder])-abs([sumpaid])
25.10.2021, 14:59
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
Or just for outgoing to plus change
25.10.2021, 15:01
Original comment available on version: ru

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
25.10.2021, 15:02
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

anonymous duck
OneBox production
Employee wrote:
abs([suminorder])-abs([sumpaid])

and this thing is really cool, sorry I didn’t know before
25.10.2021, 15:02
Original comment available on version: ru


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
25.10.2021, 15:39
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

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.
:)
25.10.2021, 15:59
Вячеслав Легеза Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license
abs module
this is a really cool solution
25.10.2021, 15:59
Вячеслав Легеза Original comment available on version: ru

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