Goods in transit calculation

[Former Member]

Hi,

I'm calculating GIT=Receipt stock in transit-Issue Stock in transit

Cube=IC_C03

Some values are correct as per logic.

But the problem is as following

If the goods receipt date is end of month and it is delivered on next month.

But the users are taking GIT as its value for current month only

ex:

issue=100 07092010

receipt=100 10092010

GIT = 100-100=0(Correct)\

But

issue=100 20092010

receipt= 100 23092010

issue=0 30092010

receipt=200 30092010

GIT= 300 -100=200 (correct)

next mont it is delivered on 2nd Oct 2010

I.e receipt qty=0

issue qty =200

GIT=0-200=-200(wrong)

Hope you do the needful

Thanks

Shyam

[Jelena]

To have the correct value in monthly buckets, you'd need to add a column with stock balance at the beginning of the month. E.g. you have 200 in stock, then you post goods issue for 200 and you end up with 0 in stock.

Otherwise, if you're looking only at the transaction amounts (received/issued) within a month then, well, the numbers are correct. After all, you did receive X in one montha and issued Y in another month.

P.S. This doesn't really look like an SD question to me... Are you posting in the right forum?

[eduardo_hinojosa]

Hi

Do you use the tcode MB5T ?

Regards

Eduardo