1b.app
Link copied -

Goods movement report

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?
Original question is available on version: ru

Answers:

Good afternoon, exactly the same on the basis of standard functionality cannot be configured
06.11.2020, 17:50
Original comment available on version: ru

Rate the update, please.
06.11.2020, 18:02
Original comment available on version: ru

Will there be an answer to this question?
10.11.2020, 15:54
Original comment available on version: ru

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?
10.11.2020, 17:27
Original comment available on version: ru


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?
11.11.2020, 11:28
Original comment available on version: ru

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.
12.11.2020, 10:56
Original comment available on version: ru

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?
13.11.2020, 12:42
Original comment available on version: ru


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.

http://91.225.138.240/admin/shop/productfield/9/

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?

The nomenclature is all products that are not hidden or removed
http://91.225.138.240/admin/shop/products/?searchLine=
13.11.2020, 21:24
Original comment available on version: ru


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.
30.11.2020, 17:20
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