Good afternoon.
For a year and a half I didn’t work somewhere with clients and their obligations, and when I returned to them I found strange changes.
Previously, in the "Finance" block, there was another field, "The final balance of the client", which was calculated as:
Client obligations (balance sheet) - Our obligations (balance sheet).
It was a standard boxing decision and it completely suited us according to its logic. And it is under this logic that we have configured all business processes for several years.
Now this field has disappeared somewhere, and the additional block "Balance for the period" displays quite strange values. [file]4808[/file]
I tried to play with the settings of the finance block, but the result is zero. There are two settings for the output of the final balance, which give exactly the same result, and in our case it is wrong, because. for some reason they add obligations instead of their difference.
The question is how to retur
Good afternoon. For a year and a half I didn’t work somewhere with clients and their obligations, and when I returned to them I found strange changes. Previously, in the "Finance" block, there was another field, "The final balance of the client", which was calculated as: Client obligations (balance sheet) - Our obligations (balance sheet). It was a standard boxing decision and it completely suited us according to its logic. And it is under this logic that we have configured all business processes for several years. Now this field has disappeared somewhere, and the additional block "Balance for the period" displays quite strange values. I tried to play with the settings of the finance block, but the result is zero. There are two settings for the output of the final balance, which give exactly the same result, and in our case it is wrong, because. for some reason they add obligations instead of their difference. The question is how to retur
Thanks, but alas, it's not. I wrote about this above, as I have already tried all the settings of the block. All our orders/payments/returns have been carried out for several years, taking into account the fact that obligations are considered as the difference (of the client minus ours). This setting produces incorrect results. Boxing gives -173268.39, but it should be -36540.59
[quote]
Chirkov Maxim
Tzov Ekomora wrote:
more precisely
[file]4823[/file]
[/quote]
Thanks, but alas, it's not. I wrote about this above, as I have already tried all the settings of the block.
All our orders/payments/returns have been carried out for several years, taking into account the fact that obligations are considered as the difference (of the client minus ours). This setting produces incorrect results. Boxing gives -173268.39, but it should be -36540.59
[file]4824[/file]
Good afternoon, Lyudmila. In "System settings" --> "Other", namely here /admin/shop/settings/finance/ , there is a setting "Calculate the final balance of obligations as the sum of the client's obligations and our obligations" . When this checkbox is enabled, the data in the interface block "Balance for the period" will be considered as the client's obligations + our obligations. Try to enable the specified checkbox, and then go to the contact card and click on the "Show" button in the interface block.
Good afternoon, Lyudmila.
In "System settings" --> "Other", namely here /admin/shop/settings/finance/ , there is a setting "Calculate the final balance of obligations as the sum of the client's obligations and our obligations" [file]4836[/file] .
When this checkbox is enabled, the data in the interface block "Balance for the period" will be considered as the client's obligations + our obligations.
Try to enable the specified checkbox, and then go to the contact card and click on the "Show" button in the interface block.
Markov Evgeny Igorevich wrote: Good afternoon, Lyudmila. In "System settings" --> "Other", namely here /admin/shop/settings/finance/ , there is a setting "Calculate the final balance of obligations as the sum of the client's obligations and our obligations" . When this checkbox is enabled, the data in the interface block "Balance for the period" will be considered as the client's obligations + our obligations. Try to enable the specified checkbox, and then go to the contact card and click on the "Show" button in the interface block.
Thanks, but again it's not. As a result, the Sum is again, but the Difference is needed (as before). Gives -173268.39, but it should be -36540.59
[quote]
Markov Evgeny Igorevich wrote:
Good afternoon, Lyudmila.
In "System settings" --> "Other", namely here /admin/shop/settings/finance/ , there is a setting "Calculate the final balance of obligations as the sum of the client's obligations and our obligations" [file]4836[/file] .
When this checkbox is enabled, the data in the interface block "Balance for the period" will be considered as the client's obligations + our obligations.
Try to enable the specified checkbox, and then go to the contact card and click on the "Show" button in the interface block.
[/quote]
Thanks, but again it's not. As a result, the Sum is again, but the Difference is needed (as before). Gives -173268.39, but it should be -36540.59
[file]4840[/file]
If the specified checkbox is off, then the calculation will be: "client's obligations" - "our obligations" Both values are modulo. Here is the result of counting .
If the specified checkbox is off, then the calculation will be: "client's obligations" - "our obligations"
Both values are modulo. Here is the result of counting [file]4841[/file] .
Markov Evgeny Igorevich wrote: If the specified checkbox is off, then the calculation will be: "client's obligations" - "our obligations" Both values are modulo. Here is the result of counting .
That's the problem, that it counts modulo. For example, another client, 383. He has +267 hryvnia when pressed and without pressing. These +267 UAH are his deposit, in fact he overpaid us. You can open his orders and count with your hands. This amount is displayed with a plus, and this is logical: the final balance of the client is +267, which means he has a deposit. And for client 807, the indicated UAH 36,540.59 is the client's debt (the goods have been shipped, but not yet paid, because the client has a deferred payment). As a result, when I open the client card, I don’t see in the final balance what kind of balance it is, is it a client’s debt or an overpayment. The old line with the Total balance (in the "Finance" block, above) counted without a module, and taking into account the signs and it was convenient, because. it was immediately clear who owes whom, we to the client or he to us. But now that line is gone.
[quote]
Markov Evgeny Igorevich wrote:
If the specified checkbox is off, then the calculation will be: "client's obligations" - "our obligations"
Both values are modulo. Here is the result of counting [file]4841[/file] .
[/quote]
That's the problem, that it counts modulo.
For example, another client, 383.
He has +267 hryvnia when pressed and without pressing. These +267 UAH are his deposit, in fact he overpaid us. You can open his orders and count with your hands. This amount is displayed with a plus, and this is logical: the final balance of the client is +267, which means he has a deposit.
And for client 807, the indicated UAH 36,540.59 is the client's debt (the goods have been shipped, but not yet paid, because the client has a deferred payment).
As a result, when I open the client card, I don’t see in the final balance what kind of balance it is, is it a client’s debt or an overpayment.
The old line with the Total balance (in the "Finance" block, above) counted without a module, and taking into account the signs and it was convenient, because. it was immediately clear who owes whom, we to the client or he to us. But now that line is gone.
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