Opening and closing Inventory report in CR

[Former Member]

Hi Experts,

I want report like as below

ItemCode     ItemDescription     OpeningStk      Reciept       Issue     ClosingStk

Selection Criteria

OpeningStk Date :  01 .01. 2013

ClosingStk Date : 31.12.2013

My working:

OINM and OITM table inner join.

select expert record for the closing stock.

But for opening stock , how to achieve it ?

Is it possible in single report to get my requirement?

Thanks in advance,

Dwarak

[former_member226669 · Accepted solution]

Hi Dwarkanath,

Do you want the records between the opening stalk and closing stalk?

- Nrupal

[Former Member · Accepted solution]

Hi,

Yes. i want the Opening stock, Reciept, Issue and Closing stock as per the date.

Item Code	Description	Date	Inqty	Outqty	sum of Opening   Stock	sum of reciept	sum of reciept	Closing Stock
I0001	Item A	10-10-2013	10	0
I0001	Item A	11-11-2013	5	0
I0001	Item A	12-12-2013	0	10
I0001	Item A	03-01-2014	2	0
I0001	Item A	10-01-2014	0	1
I0001	Item A	20-02-2014	15	0
I0001	Item A	24-03-2014	0	12
					5	17	13	9

how to achieve this ?

thanks in advance,

Dwarak

[Former Member · Accepted solution]

Hi Experts,

For the above scenario,  i got an Idea to fix this,

I want to calculate the opening date of the stock based on the Closing date.

condition : if am giving the closing date as 31.03.2014 in EXPERT SELECTION, a formula should calculate as 01.04.2014 in openingmonth  fied. so, based on this i can achieve to calculate the opening stock, reciept qnty and issued qnty through formulas.

hence, i want the formula to calcuate openingmonth based on the closing date ?

Thanks in advance,

Regards,

Dwarak

[Former Member · Accepted solution]

hi,

i got fixed as below, if possible any one share the formula to fetch month instead of number of days.

openingDate = {?closingdate) - 365

Dwarak

[Former Member]

Hi ,

Try This ,

1.Parameter Should be {Command.refdate}  <= maximum({?Daterange})

2.Open Balance

if   {Command.refdate}<minimum({?Daterange}) then (inqty-Out) else 0

3.Take summary of open balance formula in Group .

-Rajesh N