General Questions
Laura L贸pez
Laura L贸pez
聽路聽CEO at LL Studio

Inventory Tracking (Multiple Locations)

Resolved

Hi!

I would love some help here.

I'm trying to track inventory of custom made boxes in different locations. So far I have one solution with the Following Apps:

  1. Purchase Orders (Contains Customer Data, Totals, Payments, Invoicing, "Orden Details" (Linked Field)

  2. Order Details. Each record contains quantity, product, location, and it's grouped by Purchase Order)

  3. Products (linked to order details)

  4. Production Control (Houses all Manufacturing Request of the boxes) also linked to products)

  5. Add to Inventory (To add all the boxes that arrive to each location)

  6. Locations (linked to all records where location is present)

I need a formula to filter the records by location when doing the calculations

Ex. I want a formula de SUMS all the Quantities sold of (Product X) but only if it is linked to "Location Y")

is that possible?

Thanks in advance

Best reply by Laura L贸pez

Hi! Just to let you know in case someone else is trying to built this, I figured it out.

The SUMIF formula doesn't work if the condition is based on a linked record. I change the "Location" field type to single select instead of linked records and it works.

The Formula is:

SUMIF([Link to Inventory Entries].[Location]="Showroom",

[Link to Inventory Entries].[Quantity])

Then the same for sales, and lastly a simple formula to subtract the result of the first formula (boxes entered to location) minus the second formula (boxes sold from location)

View original
Formulas
newbie
1
3 replies