Costing question:

jeremyd · 2006-03-09

Hey guys, question:

If I've got a PO dated say 10/01/05, with one item line costing $2,000.00,
and we've received the product(posted the receipt, but haven't yet invoiced it) and turned it around and sold it the same year...

And we go back to the received PO, and change the unit cost of the one line to $3,000.00, change the posting date to something into next year, such as 01/02/06, and then invoice that PO...

When we run adjust cost/post to g/l...is there any way to make that cost difference ($1000) post in 2006, and not 2005? Simply changing the posting date and running adj cost/post to g/l doesn't seem to work this way.

Basically, we would want the charge this cost difference, or change into 2006, and keep the original $2000.00 cost in 2005. Make sense?

Any help would be much appreciated. Thanks!

bbrown · 2006-03-09

Set the "allow posting from date" in GL (and user setup to 01/01/06. Then run "adjust cost" with a date of 01/02/06. Since the original sale transaction is in a closed period (prior to "allow posting from date") the adjusting value entry will be posted using the date set in "adjust cost"

themave · 2006-03-09

This will work, but you have to change the allow to posting date on the g/l setup also, not just the user setup.

Sorry, I read your answer and you did say to change both.

Alex_Chow · 2006-03-09

One other thing I want to add is that this only works with version 3.7B forward.

Costing question:

Comments

Categories