Report For Inventory

sprabhucppl · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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

sprabhucppl · 2010-01-22

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

but i cant get any logic for calculating opening stock.

Marije_Brummel · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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

Thanks Frank.

jubeljoy · 2010-01-23

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 · 2010-01-23

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 · 2010-01-23

ya same only..

Report For Inventory

Comments

Categories