Report For Inventory

sprabhucppl

Dear All,

Can any one help me out of this,

for a given period how can i take a inventory quantity like

Opening Stock,Purchase, Purchase Return,Sales,Sales return,Inbound Transfer,Outbound Transfer,Positive Adjustment,Negative Adjustment,Closing Stock.

Thanks in Advance

Marije_Brummel

This is not the ideal way to ask questions here.

Study the documentation on MS NAV Inventory.

Have you looked at the Item Ledger Entries and Warehouse Entries?

What have you tried yourself before posting this question?

sprabhucppl

I have tried taking this report using item ledger entry with these below fields

Purchase, Purchase Return, Sales, Sales Return, Closing Stock. but i need opening stock for the period and then these transaction quantity and closing stock.

Marije_Brummel

What about using a date filter? Are you familiar with those?

sprabhucppl

yes, using the date filter i had calculated these results.

but i cant get any logic for calculating opening stock.

Marije_Brummel

Can you post your code?

Have you posted the opening stock with a special document number? Or on a special date? Maybe you can filter on those.

sprabhucppl

I can get you. but the thing is, if i give date filter as 01.01.2010..31.01.2010 then the inventory of 31.12.2009 have to be calculated as opening stock.

FDickschat

Take a look at report 1001. There you can see how it is done (and you could use it as a base for your report)

Marije_Brummel

Good thing that this is one of the easiest reports in Navision.

Thanks Frank.

jubeljoy

Better you define requirements in the Analysis Reports of Warehouse-> Analysis & Reporting-> Analysis & Reports... then you will get all your result easily.. there you can verify your entries also...

chengalasettyvsrao

jubeljoy wrote:

Better you define requirements in the Analysis Reports of Warehouse-> Analysis & Reporting-> Analysis & Reports... then you will get all your result easily.. there you can verify your entries also...

I think in standard Nav Classic this functionality avaible in Financial Mangement - > Inventory - > Analysis & Reporting

jubeljoy

ya same only..