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"
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
[file]3242[/file]
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"
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