Sort by date in Customer report (document template)
Greetings!
There is a report, for example https://knkrd.1b.app/app/report/desiner/1/view/?filter_user_client=48&filter... D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
here are its settings https://knkrd.1b.app/app/report/desiner/1/
implementation via row:paymentin_cdate and row:paymentout_cdate
task: it is necessary that the sorting (order) of data rows be by dates (bottom - new)
Now it shows first incoming dates in ascending order, then outgoing ones, but it is necessary that they go mixed up, depending on the date.
Please evaluate the possibility of improvement, if necessary - or help with the code or implementation.
Thank you for your time!
Original question is available on version: ru
There is a report, for example https://knkrd.1b.app/app/report/desiner/1/view/?filter_user_client=48&filter... D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C
here are its settings https://knkrd.1b.app/app/report/desiner/1/
implementation via row:paymentin_cdate and row:paymentout_cdate
task: it is necessary that the sorting (order) of data rows be by dates (bottom - new)
Now it shows first incoming dates in ascending order, then outgoing ones, but it is necessary that they go mixed up, depending on the date.
Please evaluate the possibility of improvement, if necessary - or help with the code or implementation.
Thank you for your time!
Answers:
to display all payments instead of incoming and outgoing separately use the payment_dvtcnj paymentin and paymentout variable. Sorting in this case will be by creation date (oldest on top)
14.04.2023, 23:09
Original comment available on version: ru
.dev
OneBox production wrote:
to display all payments instead of incoming and outgoing separately use the payment_dvtcnj paymentin and paymentout variable. Sorting in this case will be by creation date (oldest on top)
then can't use paymentin_sum to correct column (debit, credit)
:(
24.04.2023, 12:09
Original comment available on version: ru
{|if $aa > 0|} {|$aa|} {|else|} 0 {|/if|}
in templates you need to drink something like this, or maybe without |, check both ways
in templates you need to drink something like this, or maybe without |, check both ways
27.04.2023, 23:10
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
Copyright © OneBox 2024
