Page 1 of 1
why we cannot reopen inventory period
Posted: Tue Sep 08, 2009 11:00 pm
by macromedia
I know this question sound silly..[;)]
but please be patient and en-light me with your opinion..[8)]
AFAIK, on payable, purchasing,GL and OM we can re-open last closed period as far the period hasn't permanent closed yet..
now, on Inventory, why oracle doesn't have this option?
what is the reason on business perspective?
thank you..
Posted: Tue Sep 08, 2009 11:32 pm
by admin
Because in inventory with each receipt/issuance average rate is updated/used so reopen of period is not allowed. tks
Posted: Wed Sep 09, 2009 12:34 am
by macromedia
hi..
what an honor to have reply from our admin
could you elaborate more about when we receipt/issuing, average rate is updated/used? do you mean with cost update issue when we do the transactions?
thank you..
Posted: Fri Sep 11, 2009 12:33 pm
by admin
On each receipt the average rate is calculated based on existing quantity, Amount and new quantity, Amount. Now on next issue this new calculated rate will be applied to that transaction. If there is no change in rate (PO) then even still rate will be calculated but will remain same. This is on going process....
01-01-09 Rate = 5
01-02-09 Rate = 10
01-03-09 Rate = 15
current is 15
Now if you will try to receipt/issue in existing months then always rate will be an issue.
In other modules there is no such calculations and each transaction is independent.
Hope the point is clear.
Thanks
Posted: Mon Mar 08, 2010 10:04 am
by amit.pimparkar
Hi Admin,
Can you please eloberate this with a different example.it's a bit confusing.[?]
Regards,
Amit