help with INVENTORY ON A CERTAIN DATE

agsboy · 2006-07-31

hi everyone....can someone tell me if is there a way in navision to get the nventory on a certain date???
i mean, if i want to see the inventory of a certain product 7 days ago

thanks in advance

Savatage · 2006-07-31

have you tried the inventory valuation report?

check the options tab for "As of Date"

agsboy · 2006-07-31

ok..i'll check it..thanks

ara3n · 2006-07-31

What is funny with that report is that for a lot of the customers, you run as of certain date and you see zero on hand and the value is -100 or something.

I know it's a costing bug, when how do you explain that to the client. And where do you start from fixing the cost?

I just refere the to the costing consultant.

Savatage · 2006-07-31

ok then how about form 158: Item Turnover

Set it for 7 Days so you can see what was sold & purchased in the last 7 days and adjust the current inventory #

(if you just want to get a number?)

Alex_Chow · 2006-07-31

ara3n wrote:

What is funny with that report is that for a lot of the customers, you run as of certain date and you see zero on hand and the value is -100 or something.

I know it's a costing bug, when how do you explain that to the client. And where do you start from fixing the cost?

I just refere the to the costing consultant.

It's not a bug. It's just the timing of when you run the adjust cost process.

ara3n · 2006-07-31

Well it shouldn't make a difference when you run adjust cost. If inventory is zero, the value should be zero.

Also average costing was never working corectly, especially if you went negative on it. That is why they are creating a new type of average costing in v5 that called periodic average costing. I'm sure a lot of manufacturing company will be happy about this costing, especially if they have raw material set as average costing.

Alex_Chow · 2006-07-31

ara3n wrote:

Well it shouldn't make a difference when you run adjust cost. If inventory is zero, the value should be zero.

Also average costing was never working corectly, especially if you went negative on it. That is why they are creating a new type of average costing in v5 that called periodic average costing. I'm sure a lot of manufacturing company will be happy about this costing, especially if they have raw material set as average costing.

Well.. I guess it's how it's presented. Personally I don't think it's a bug, our clients doesn't think it's a bug as well. Although the maintainence on the costing is tedious.

jreynolds · 2006-08-01

ara3n wrote:

What is funny with that report is that for a lot of the customers, you run as of certain date and you see zero on hand and the value is -100 or something.

I know it's a costing bug, when how do you explain that to the client. And where do you start from fixing the cost?

I just refere the to the costing consultant.

The inventory valuation report in the North American version (report 10139) cannot correctly report inventory as of a prior date. This is because the report uses item ledger posting dates to determine the quantity on hand as of the specified date and value entry posting dates to determine the value as of that date. It's pretty easy to create situations where the cost of a positive entry is changed on one date (e.g. invoicing a purchase order posts a value entry with a date matching the posting date of the invoice) and the adjust cost process adjusts the applied negative entries on different dates (e.g. the date of the negative item ledger entry).

rsfairbanks · 2006-08-01

In a way it is showing the correct value, but based on the best information at that time. It is all a question of cut-off, at some point you have to present accounts and you take the information as at that time (the value entries). Later you may get better information and an adjustment is made (a later value entry).

Not saying it is perfect though.

Miklos_Hollender · 2006-08-06

As inventory on a certain date is a very common and often a high priority requirement, I suggest changing the Inventory flowfield in Item table by adding a new filter to the CalcFormula property: Posting Date, FILTER, Date Filter - and then running all the reports you normally use with a <=20060301 - like filter. Maybe it needs some changes in the keys of table Item Ledger Entry as well, but not big ones (only if you got an error message, in that case, it will display clearly what kind of key it wants).

David_Cox · 2006-08-07

Hi There is a field called "Net Change", this takes all the filters inventory takes plus a date filter.

Its as easy as this on the Item table

Item - OnPreDataItem()
SETRANGE("Date Filter",0D,AsAtDate);

Item - OnAfterGetRecord()
CALCFIELDS("Net Change");

This is the sum of quantity from Zero date to the date you want, no field or special changes, just standard Navision.

Kowa · 2006-08-09

There is no need to write code , it is sufficient to add the "Net change" field to the item card and apply a date flowfilter to the form.

http://www.mibuso.com/forum/viewtopic.p ... &highlight

David_Cox · 2006-08-09

Kowa wrote:

There is no need to write code , it is sufficient to add the "Net change" field to the item card and apply a date flowfilter to the form.

http://www.mibuso.com/forum/viewtopic.p ... &highlight

The original poster did not make it clear as to where the field was required.

I assumed like all the other answers a report, as this would be most likely scenario, but if it is on the item card you are quite correct, but they would have to apply a date filter just the same in each case, one problem two solutions.

help with INVENTORY ON A CERTAIN DATE

Comments

Categories