Show stock balance on date

1. On date from or date to? About 4h will take for a common table 2. At the bottom, it is impossible to show balances for this particular date in this report.

[quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: 1. On date from or date to? About 4h will take for a common table [/quote] In fact, we need balances for a specific date, as I understand it, for a date before [quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: 2. At the bottom, it is impossible to show balances for this particular date in this report. [/quote] Then this report is not suitable. Is it possible to finalize all this in the report on the change in the balance in warehouses? What do we need: 1. Number of balances on the date 2. Amount of balances on the date 3. The list of goods (remains) for this date

You may have several hundred thousand different products on your balance sheet on this date. You obviously want to see the balances for a specific product and not for all 100k?

[quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: You may have several hundred thousand different products on your balance sheet on this date. You obviously want to see the balances for a specific product and not for all 100k? [/quote] They want to see all items in stock for that date. If there is a lot of data on the 1st page, it can load when scrolling or 50 per page and switch

This cannot be done in the current report. You can only make a separate one where you can see something like that. But to give an assessment, I must understand what exactly you want to see. Just a product + quantity in each of the warehouses, or plus a bunch of information on the type of price, additional fields and the remaining 20 columns that are now in the usual balance sheet

[quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: This cannot be done in the current report. You can only make a separate one where you can see something like that. But to give an assessment, I must understand what exactly you want to see. Just a product + quantity in each of the warehouses, or plus a bunch of information on the type of price, additional fields and the remaining 20 columns that are now in the usual balance sheet [/quote] I would not like to make a separate report, but to finalize it in Remains in warehouses. You wrote: [quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: You may have several hundred thousand different products on your balance sheet on this date. You obviously want to see the balances for a specific product and not for all 100k? [/quote] And how can you make it show for goods if you do it in Remains in warehouses?

for one product, it is possible to manually calculate what was the balance on a specific date in all warehouses. If there are several such products, pagination begins, a lot of additional miscalculations, brakes and another bunch of problems that are completely unnecessary in this content

[quote] snowball Death is coming to Brooklyn, it has big teeth and a fluffy tail. wrote: for one product, it is possible to manually calculate what was the balance on a specific date in all warehouses. If there are several such products, pagination begins, a lot of additional miscalculations, brakes and another bunch of problems that are completely unnecessary in this content [/quote] I understand, so in the end what are the options? It is possible not to display them at all with such filtering, but to display them only if I specify a specific product id/article, that is, show the balance of a specific product on this date. If the product is not specified - just show the total balance (not a list of products) of products and their amount for a specific date

[quote] Korop Vladislav Pavlovich KTS Premium partner wrote: What do we need: 1. Number of balances on the date 2. The amount of the purchase of balances on the date [/quote] If you do only these 2 points without displaying a list of products, how long will it take to finalize?