Moving goods - a problem when moving

Hello. Due to a crash, the move operation was not written to the database. Can I delete the entire history of goods movements so that you can post the right quantity to the right warehouse?

There was more than one product in the movement, is it possible to somehow restore it, as it was done before, just so that it can be seen? This will be enough

Can you recover?

Can you help me decide?

The problem is gaining momentum. Here are a couple more orders, where they put on receipt, but some were credited, and some were not + the operation was not created, that is, similar to the problem in the description 1) https://cabinet.b2bframes.com/admin/customorder/zakupki/43509/edit/ For example, a product from this order https://cabinet.b2bframes.com/admin/customorder/zakupki/43509/storage/ 2) https://cabinet.b2bframes.com/admin/customorder/zakupki/43452/edit/ It is necessary to decide, I myself can’t do anything, only write off, but I’m not sure that this will normally be reflected in the future

Another example https://cabinet.b2bframes.com/admin/customorder/order/43295/edit/ In general, the thing that was included in the database did not help, the warehouses are a complete mess

How to fix goods? And most importantly, how to solve the problem with such operations?

[quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: Another example https://cabinet.b2bframes.com/admin/customorder/order/43295/edit/ In general, the thing that was included in the database did not help, the warehouses are a complete mess [/quote] logical because it was knocked out it is not clear who and why

And do what? How to decide?

Here is a list of such processes in which some of the goods were sold or credited, and some were not, the records for them were not saved, there is no way to fix it on your own, there are more such processes and soon it will not be possible to understand at all how much this or that product should be in the warehouse without inventory . At the same time, there is no error that there is not enough goods or it was not possible to sell everything. https://cabinet.b2bframes.com/admin/customorder/zakupki/43452/edit/ https://cabinet.b2bframes.com/admin/customorder/zakupki/43509/edit/ https://cabinet.b2bframes.com/admin/customorder/order/43295/edit/ https://cabinet.b2bframes.com/admin/customorder/order/43470/edit/ https://cabinet.b2bframes.com/admin/customorder/order/42223/edit/ https://cabinet.b2bframes.com/admin/customorder/order/43328/edit/

I made edits to mysql mode watch now on new ones and make a recount on these

ok, let's do it. Only question next will this option be for all projects or just this one? That is, what should be done if the same problem appears somewhere else? And for example, if you change the server, will the setting fail?

[quote] Ustimenko Igor OneBox Corp. OneBox CTO wrote: I made edits to mysql mode watch now on new ones and make a recount on these [/quote] If I give a list of goods, will it be possible to mow operations on them completely? To keep everything clean?

[quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: ok, let's do it. Only question next will this option be for all projects or just this one? That is, what should be done if the same problem appears somewhere else? And for example, if you change the server, will the setting fail? [/quote] while on this If it works, I'll do it in bulk changing the server with incorrect settings can aggravate the situation, but not significantly [quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: If I give a list of goods, will it be possible to mow operations on them completely? To keep everything clean? [/quote] if all operations in warehouses for these goods are direct, then I think yes

Here are the products that have a problem with the balance Here they were credited but there are no operations https://cabinet.b2bframes.com/admin/shop/products/22411/storage/ https://cabinet.b2bframes.com/admin/shop/products/16610/storage/ https://cabinet.b2bframes.com/admin/shop/products/21208/storage/ https://cabinet.b2bframes.com/admin/shop/products/26689/storage/ https://cabinet.b2bframes.com/admin/shop/products/26690/storage/ https://cabinet.b2bframes.com/admin/shop/products/26691/storage/ https://cabinet.b2bframes.com/admin/shop/products/26692/storage/ These have been moved but no operations https://cabinet.b2bframes.com/admin/shop/products/26002/storage/ https://cabinet.b2bframes.com/admin/shop/products/25935/storage/ https://cabinet.b2bframes.com/admin/shop/products/25943/storage/ https://cabinet.b2bframes.com/admin/shop/products/25931/storage/ https://cabinet.b2bframes.com/admin/shop/products/25985/storage/ https://cabinet.b2bframes.com/admin/shop/products/21965/storage/ https://cabinet.b2bframes.com/admin/shop/products/25933/storage/ It is possible to simply align the remainder of the operations on them? Everything after problematic operations, I will do manually. If you delete all transactions, then the wrong balance will appear in the orders. And I don’t know if this is related, but such a problem appeared https://1b.app/ua/support/business-processes/12061-zavisaet-perehod-v-status/

[quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: It is possible to simply align the remainder of the operations on them? Everything after problematic operations, I will do manually. [/quote] Or just make this operation visible, as it used to be done in Comoros, when such a problem was

[quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: [quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: It is possible to simply align the remainder of the operations on them? Everything after problematic operations, I will do manually. [/quote] Or just make this operation visible, as it used to be done in Comoros, when such a problem was [/quote] and you do not want to completely clear all operations for these goods and re-do the receipt?

[quote] Ustimenko Igor OneBox Corp. OneBox CTO wrote: and you do not want to completely clear all operations for these goods and re-do the receipt? [/quote] we don’t want, of course, there are about 30 sales, for which obligations will then fly off, it’s not clear how to look for them later If possible, it is better to fix it. I can write for each product from which date to remove the leftovers, is it possible?

https://cabinet.b2bframes.com/admin/shop/products/22411/storage/ Delete after 2021-08-05 14:06:30

[quote] Sukhanitsky Andrey OneBox Corp. Integrator wrote: https://cabinet.b2bframes.com/admin/shop/products/22411/storage/ Delete after 2021-08-05 14:06:30 [/quote] This is the date of the last operation that was carried out correctly [file]12444[/file] - it should remain, that is, you need to delete everything after

https://cabinet.b2bframes.com/admin/shop/products/22411/storage/ https://cabinet.b2bframes.com/admin/shop/products/16610/storage/ https://cabinet.b2bframes.com/admin/shop/products/21208/storage/ https://cabinet.b2bframes.com/admin/shop/products/26689/storage/ https://cabinet.b2bframes.com/admin/shop/products/26690/storage/ https://cabinet.b2bframes.com/admin/shop/products/26691/storage/ https://cabinet.b2bframes.com/admin/shop/products/26692/storage/ Delete everything from 11/15/2021, 04:35 PM https://cabinet.b2bframes.com/admin/shop/products/26002/storage/ https://cabinet.b2bframes.com/admin/shop/products/25935/storage/ https://cabinet.b2bframes.com/admin/shop/products/25943/storage/ https://cabinet.b2bframes.com/admin/shop/products/25931/storage/ https://cabinet.b2bframes.com/admin/shop/products/25985/storage/ https://cabinet.b2bframes.com/admin/shop/products/21965/storage/ https://cabinet.b2bframes.com/admin/shop/products/25933/storage/ Delete everything from 25.10.2021, 12:00

there are 2 orders https://cabinet.b2bframes.com/admin/customorder/zakupki/43452/edit/ https://cabinet.b2bframes.com/admin/customorder/zakupki/43509/edit/ And moving for the date 10/25/2021, 12:04