Inventory Report Opening/In/Out/Closing base on every Transaction

[Former Member]

Hi Experts

I need a report bese on transaction in inventory module like this:

Item Code-Transaction Type- Opening(untill from Date)In-Out-Closing(base on this Transaction)

for example for Item A from 20090101 to 20090230

A GR 10 , 5 , 0 ,15

A GI 15, 0 , 2 ,13

A GRPO 13,2,0,15

Thanks

[Former Member]

Hi,

You may check this thread:

Thanks,

Gordon

[Former Member]

Hi

thanks for your consideration, But I need to calculate balance field like Cumulotive amount, like following sample

Item Code - DocDate Doctype--In -- Out -- Balance

A 20090201 Good recipt 10 -

---

0 -

---

10

A 2009-02-03 Good Recipt From PO--

---

20--

---

0 -

---

30

A 20009-02-03 Good Issue -

---

0 -

---

5----

---

25

I have a problem in calculation Balance

[Former Member]

Your opening balance will be the sum of in & out where the date is less that your report start date. As your report will be filtering these values, you may need to bring this in as a command - you can include your parameter value in the command.

[Former Member]

thanks , but the problem is calculatin of Cumulative amount in each row base on previous row

[Former Member]

All the data you are needing will be in the OINM (Inventory Movements) table, you should start with that in your query

[Former Member]

how can I reach Opening amoumt upto specific date in this Table?