1b.app
Link copied -

Finalization of the report Reconciliation act - count for all counterparties, not just suppliers

For the report https://take.ms/ZLi2k
https://crm-77.com/admin/report/designer/3/view/?filter_user_client=39%2C612%2C6...
It is necessary that the report read sales data, that is, make some checkbox "Generate a report on buyers and suppliers"
1) Pleasure / product
- if the sale of goods - we write Sale of goods to the buyer
- if the return of goods to the warehouse - we write Return of goods from the buyer
- if capitalization - Receipt to the warehouse
- return posting - Return of goods to the supplier
- if the incoming payment is the counterparty's payment for the account...
- if outgoing - Payment to the counterparty for the account...
Here is the prehistory - in 1s the report is generated for the counterparty, therefore the Incoming is goods, and the Outgoing is money in the original version of the report. We need to generate a report for ourselves, so we need to swap them like this:
2) Arrival of goods
- Rename to "Parish"
- inc
Original question is available on version: ru

Answers:

29h
somehow you are going to change the report too much
08.10.2021, 19:44
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
a little bit fat, but thanks for the rating
08.10.2021, 19:47
Original comment available on version: ru

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

Sukhanitsky Andrey
Integrator
Integrator CRM wrote:
According to the initial balance, I ask you to tell me how it thinks, in order to determine whether it needs to be finalized

You didn’t write on this item, or will it be included in the assessment?
08.10.2021, 19:49
Original comment available on version: ru


Sukhanitsky Andrey
Integrator
Integrator CRM wrote:
According to the initial balance, I ask you to tell me how it thinks, in order to determine whether it needs to be finalized
[/ quote] the balance of liabilities for this date considers
08.10.2021, 19:52
Original comment available on version: ru

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

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:

Sukhanitsky Andrey
Integrator
Integrator CRM wrote:
According to the initial balance, I ask you to tell me how it thinks, in order to determine whether it needs to be finalized
[/ quote] the balance of liabilities for this date considers

According to the report? That is, the ending balance before the specified date?
08.10.2021, 19:55
Original comment available on version: ru


Sukhanitsky Andrey
Integrator
Integrator CRM wrote:
According to the report? That is, the ending balance before the specified date?

No
on obligations
08.10.2021, 20:06
Original comment available on version: ru

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

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
No
on obligations

Then you will need to do to count the balance of operations
indicate "date from"
then we calculate the entire Income before this date - all the Expense before this date
How much will be added to the score?
08.10.2021, 20:10
Original comment available on version: ru


Sukhanitsky Andrey
Integrator
Integrator CRM wrote:

Ustimenko Igor
OneBox production
Administrator
OneBox CTO wrote:
No
on obligations

Then you will need to do to count the balance of operations
indicate "date from"
then we calculate the entire Income before this date - all the Expense before this date
How much will be added to the score?

4h
11.10.2021, 07:06
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