1b.app
Link copied -

Finalize the action of pulling payments with xlsx

Here https://brightbox.1b.app/admin/shop/workflowstatus/15/action/new/
There is an action "Import payments from CSV/XLS/XLSX file in process comments"
1. You need to upload the date and time in this format as separate fields https://prnt.sc/dOT90SaiSGL2
2. Make one field for loading the payment amount with auto-detection of incoming / outgoing, depending on the minus before the value https://prnt.sc/qSr_kICKdQxT
How many hours do you need to implement?
Original question is available on version: ru

Answers:




Good afternoon. Fields added to the action:
Payment creation time
Amount of payment
19.09.2023, 11:00
Original comment available on version: ru


Care Department
OneBox production wrote:
Good afternoon. Fields added to the action:
Payment creation time
Amount of payment

It works, the only thing is that the date format is apparently not processed as in the screenshot, the date is still adjusted by the date the payment was loaded.
02.10.2023, 10:43
Original comment available on version: ru

https://prnt.sc/WpajT94LIkc2
Here is an example of a process with a file that does not load data correctly https://brightbox.1b.app/9714/
As I understand it, when there is only one payment in the file, the date is taken into account, and if there are two or more, then the date becomes the one when they switched to the status “Wanted payments (new)”
Please correct.
10.11.2023, 13:24
Original comment available on version: ru

process https://brightbox.1b.app/9716/
the file is attached in the process https://i.imgur.com/Zszlh0b.png
when going to the stage https://brightbox.1b.app/admin/shop/workflowstatus/23/action/new/ should load payments, but does not load
also in the BP field - there is no entry for the BP into which it should be loaded (BP credit), there are only the statuses of this BP https://i.imgur.com/PhtuPHG.png
27.11.2023, 15:39
Original comment available on version: ru

Discussed - the error was in a space in the title of one of the columns
01.12.2023, 13:39
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