1b.app
Link copied -

How the Balance report works

Good afternoon. Tell me where the value comes from in the Balance report, for the fields:
Debt to suppliers
Buyer's advance
Supplier prepayment
Original question is available on version: ru

Answers:

Hello. Approximately the following logic for the fields you are interested in:
we take processes with the outgoing type for which the client is specified and the amount of the process is specified, and they are also scheduled for the specified month (displayed at the top of the column)
we go through these processes and calculate the difference between the amount of the process and the amount of payments for the process. If this difference is negative, then it will be added in the "Debts to suppliers" column; if this difference is positive, then this difference goes to the "Prepayments to suppliers" column
For example, if we take one of your orders to the supplier (see screenshot), we will get the following amounts:
−403.23 - (-402.81) = -0.42
we get a negative amount, which will be displayed in "Debt to suppliers"
and so we count for each process that is suitable for the condition and the total amounts are included in the report

we take processes with the type incoming for which the client is specified and the amount of the process is specified, and they are also scheduled for the specified month (displayed at the top of the column)
we go through these processes and calculate the balance of the obligations of the client of the process, if the balance is negative, then it will be displayed in the "Accounts Receivable" column, if positive - then in the "Advance payment of buyers"
28.01.2021, 18:07
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