Incorrect Inventory Receiving Date

[barbola]

An inventory receiving was entered as 06/27/2006 instead of 2005. How do we correct this? The posting date was correct, just the Receipt document date is wrong.

One option is to re-enter the receiving with the correct document date. But then how do we get rid of that last layer of inventory? We use FIFO.



Thanks!
Barb E.

 

[jazgeek]

if it's just a receiving date you're after fixing, I'd go into the database and change the date on the receipt and the inventory adjustment

IV10000
IV10001

and


POP30300

probably be the easiest way. Alternatively, if you haven't paid for the stuff yet, do a PO return, recreate the PO line and then re-receive correctly.

watch your cost though, it may have changed from then to now.



-----------
and they wonder why they call it Great Pains!

jaz

 

[barbola]

I'll take a look at those tables. We don't have the ability to do PO returns - is that something new?

Thanks!
Barb E.

 

[barbola]

There is nothing in IV10000 or IV10001.

I updated POP30300 and IV30300 but those are the only tables I could find that needed changing.

When I go to Inventory > Adjust costs, this layer still shows the date of 06/27/2006 and is at the end. Where would I change this date?

thanks!

Thanks!
Barb E.

 

[Dukester0122]

how can somebody enter a 2006 transaction, that means the user overrode the message that the year is still close.

i wouldn't recommend changing it in sql, first because if you run the stock status report (using temp tables) the transaction will still use the 2006 and your on-hand would be wrong.

create a negative inventory adjustment then delete the transaction history of the receipt in 2006. enter a new receipt with the correct date.

 

[barbola]

Easy as that, eh? I'll give it a try!

I'm not sure what message if any they got when they entered the document.



Thanks!
Barb E.

 

[Dukester0122]

here's the message:

The date you've entered falls within a fiscal period that hasn't been set up. Do you want to use this date?

Now anybody who knows how to read would understand that, eh!

 

[jazgeek]

that message means ignore and override.

at least that's what they do here



-----------
and they wonder why they call it Great Pains!

jaz

 

[barbola]

They would not have received that error. We have future fiscal years set up in all our companies because they have different fiscal years. When we do consolidated reporting in FRx, if one company is in 2006, then the reports will only work if that year exists for all the companies in the report.

Thanks, Dukester, your method worked...I forgot about the remove history option!



Thanks!
Barb E.

 

[jazgeek]

you can still have the future periods inactive. We typically have the next fiscal year set up as well, but we only open the subledgers at month end for the following month.



-----------
and they wonder why they call it Great Pains!

jaz