Hi Guys!
The problem is the following:
I have a table called "Productos Inventory", like this, which has a Product Column and Sucursal (warehouse) Column, that identifies the Product where it comes from.
I would like to change Id Inventario productos to a unique ID, because as you can see, I have only 3 products, Miel de abejas 500 gr, Miel de abejas 350 gr, and Flete. But I have 3 rows from every product because I have differente warehouses where the product is Located. The problem begins when I try to give every product (Product - Warehouse) an unique ID because I have another table called Transfer between warehouses (where as its name says, does the transfers between warehouses), and I have not found a way to sum the transfers from one warehouse to other if the ID's are different (having in mind that currently I can do it with a the same Id).
The following table is called "Transfers between warehouses).
Can you give me any hint, tip, or trick in order to do so?
Thank you very much!
Si estás manejando pesos mexicanos como moneda... está muy cara tu miel xD
primer consejo los ID de tus productos tendrían que ser únicos y no repetirse
Como funcionaria?
En el momento en el que vas a realizar una transferencia de una sucursal a otra, al seleccionar la sucursal de origen deberían filtrarse las opciones para productos dandote sólo los productos que corresponden a la sucursal de origen. y eso deberia solucionar tu problema.
Cómo lograrlo?
a la columna [Producto] debería ser tipo Enum y su Base type details Ref ,con una fórmula en el valid if. similar a...
SELECT(Inventario Productos[ID Inventario Productos], [Sucursal] = [_THISROW].[Origen Sucursal])
No se si sea la forma adecuada de lograr lo que buscas pero espero te sirva
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |