calculation item rest on Location by Zone

gala · 2012-08-13

I try to calculate item rests on location for each zone (for complex location like WHITE location in NAV demo-database).
I was going to do it using Warehouse Entry table, because it reflects Posted Documents and Movements (it is exactly what I need), but I found that total sum of all transaction with Entry Type = Movement is not 0. Is it OK? I supposed that they should be 0 and my reports will have only Negative Adjmt and Positive Adjmt – Entry Type Transaction.
I tried to compare Warehouse Entry and Item Ledger Entry by Item and found a lot of differences between tables as well. Is it OK or my customer database has some issues in this area?

Which is the right way to calculate item rests on locations by Zone (or even Bins)?

Thanks in advance.

Alex_Chow · 2012-08-13

calculate item rests on location for each zone

What do you mean by this?

gala · 2012-08-13

Alex Chow wrote:

calculate item rests on location for each zone

What do you mean by this?

I want to get the following report:

Item No, Location Code, Zone Code, Qty

The main question is how to calculate the field Qty.

Alex_Chow · 2012-08-13

My question is how do you determine what quantity should be added.

gala · 2012-08-14

Alex Chow wrote:

My question is how do you determine what quantity should be added.

Probably I gave you dark explanation. I try again

.

I want to calculate how many Items are on each and every Location and Zone. So I am going to sum up all quantity from the each line Warehouse Entry table (which is fit to my filters by “Item No”, “Location Code”, “Zone Code”).

So my question is it corrects way to calculate total quantity of Item by Location and Zone.

Alex_Chow · 2012-08-14

Yes it is.

Or you can just use the Bin Content table.

calculation item rest on Location by Zone

Comments

Categories