why we cannot reopen inventory period

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
macromedia
Posts: 15
Joined: Mon Nov 26, 2007 8:49 am
Location: Indonesia
Contact:

why we cannot reopen inventory period

Post 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..
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Because in inventory with each receipt/issuance average rate is updated/used so reopen of period is not allowed. tks
macromedia
Posts: 15
Joined: Mon Nov 26, 2007 8:49 am
Location: Indonesia
Contact:

Post 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..
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post 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
amit.pimparkar
Posts: 3
Joined: Wed Mar 03, 2010 9:15 am
Location: India

Post by amit.pimparkar »

Hi Admin,

Can you please eloberate this with a different example.it's a bit confusing.[?]

Regards,
Amit
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest