Good afternoon!
You need a report based on the report Change in the balance in warehouses (template in the file).
Variables:
Quantity gone (including reserve) = Quantity gone + In reserve
Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity
Order Quantity = Outgoing Quantity (including reserve) - Remaining Quantity (including reserve)
Order amount = Order quantity * Additional field 3 (supplier price)
It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them.
How can you set up?
[file]551[/file]
Good afternoon! You need a report based on the report Change in the balance in warehouses (template in the file). Variables: Quantity gone (including reserve) = Quantity gone + In reserve Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity Order Quantity = Outgoing Quantity (including reserve) - Remaining Quantity (including reserve) Order amount = Order quantity * Additional field 3 (supplier price) It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them. How can you set up?
Good afternoon, those columns that I see in the file do not match your description in any way. Can you put together a single statement of what you want?
Good afternoon, those columns that I see in the file do not match your description in any way. Can you put together a single statement of what you want?
Bodyako Dmitry Employee wrote: Good afternoon, those columns that I see in the file do not match your description in any way. Can you put together a single statement of what you want?
What exactly do you not understand?
[quote]
Bodyako Dmitry
Employee wrote:
Good afternoon, those columns that I see in the file do not match your description in any way. Can you put together a single statement of what you want?
[/quote]
What exactly do you not understand?
The report is needed ON THE BASIS of the report Change in the balance in warehouses, but with some changes - the columns must be the same as in the template. In the descriptions - formulas are given, according to which the data in the columns should be calculated, everything else, as in the report Change in the balance in warehouses. Can you please answer this question.
The report is needed ON THE BASIS of the report Change in the balance in warehouses, but with some changes - the columns must be the same as in the template. In the descriptions - formulas are given, according to which the data in the columns should be calculated, everything else, as in the report Change in the balance in warehouses.
Can you please answer this question.
with reserve - take into account the current reserve of the product? Don't look at the date the product was reserved? Or view only the stock of the product that was delivered during the filtered period? Quantity gone (including reserve) = Quantity gone + In reserve - 2h Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity - 2h Order quantity \u003d Quantity left (including reserve) - Remaining quantity (including reserve) - 1h Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value. It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them. - What is a nomenclature?
with reserve - take into account the current reserve of the product? Don't look at the date the product was reserved? Or view only the stock of the product that was delivered during the filtered period?
Quantity gone (including reserve) = Quantity gone + In reserve - 2h
Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity - 2h
Order quantity \u003d Quantity left (including reserve) - Remaining quantity (including reserve) - 1h
Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value.
It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them. - What is a nomenclature?
Bodyako Dmitry Employee wrote: with reserve - take into account the current reserve of the product? Don't look at the date the product was reserved? Or view only the stock of the product that was delivered during the filtered period?
Here we mean the union of the data of the columns "Quantity gone" and "In reserve", and the remainder is calculated taking into account this union. Simply put - everything that is in the reserve is also considered as gone. https://prnt.sc/vis7qw You need to take into account all reserved products at the time of the report, regardless of the date of the reservation.
Bodyako Dmitry Employee wrote: Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value.
Bodyako Dmitry Employee wrote: It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them. - What is a nomenclature?
[quote]
Bodyako Dmitry
Employee wrote:
with reserve - take into account the current reserve of the product? Don't look at the date the product was reserved? Or view only the stock of the product that was delivered during the filtered period?
[/quote]
Here we mean the union of the data of the columns "Quantity gone" and "In reserve", and the remainder is calculated taking into account this union. Simply put - everything that is in the reserve is also considered as gone.
https://prnt.sc/vis7qw
You need to take into account all reserved products at the time of the report, regardless of the date of the reservation.
[quote]
Bodyako Dmitry
Employee wrote:
Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value.
[/quote]
http://91.225.138.240/admin/shop/productfield/9/
[quote]
Bodyako Dmitry
Employee wrote:
It is also necessary that this report shows all products from the nomenclature, even if there was no movement for them. - What is a nomenclature?
[/quote]
The nomenclature is all products that are not hidden or removed
http://91.225.138.240/admin/shop/products/?searchLine=
Bodyako Dmitry Employee wrote: Quantity gone (including reserve) = Quantity gone + In reserve - 2h Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity - 2h Order quantity \u003d Quantity left (including reserve) - Remaining quantity (including reserve) - 1h Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value.
these points will take 6 hours show all products in the report, even if there was no movement for them for 6 hours total 12.
[quote]
Bodyako Dmitry
Employee wrote:
Quantity gone (including reserve) = Quantity gone + In reserve - 2h
Remaining quantity (including reserve) = Quantity left + In reserve - Remaining quantity - 2h
Order quantity \u003d Quantity left (including reserve) - Remaining quantity (including reserve) - 1h
Order amount = Order quantity * Additional field 3 (supplier price) - Please provide a link to this field or a screenshot of where to get the value.
[/quote]
these points will take 6 hours
show all products in the report, even if there was no movement for them for 6 hours
total 12.
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
Donate
You don't have enough funds in your account Top up