Item inventory by location calc

kenjes

Hi

I need a simple list page like this :

"Location Code", "Location Name", "Inventory"

---

"", "", 455
"Blue", "Blue", 155
"Red", "Red", 44
"Yellow", "Yellow", 11

Someone that can send me in the right direction --- Thanks

Cheers

Kenenth

kine

Inventory of what? Everything? It means all apples, pears, plums counted together?

kenjes

Item : "1001"

kine

Because you need to add the line for empty location, you will need to use some buffer for it. Do you really need a page or it could be a report? Because report will be easier...

If it must be a page (I expect it is some home work...) you can base it over temp table you will fill up on open (using calcsums from item ledger entries for all locations and empty location...).

kenjes

If we say that I don't need blank location ??

( no report )

kenjes

Hi Kine

Thanks for your feedback - I have solved it by using Page 5701 "Stockkeeping Unit List" :)

Cheers
Kenneth

kine

Than adding flowfield for the inventory (sum from Item Ledger Entries) with one flowfilter (Item No. Filter) on the Location table should be enough for you...