Adjust Cost - Item Entries Posting Date

liyoke

Hi,

1. I post Sales Shipment for Order S-001 on Aug 28, 2007.
I run Adjust Cost-Item Entries. After that there are 2 lines in
Value Entry table; both with Posting Date Aug 28, 2007 with
Source Code of 'Sales' and 'Invtadjmt' respectively.

2. I post Sales Invoice for same Order S-001 on January 15, 2008.
I run Adjust Cost-Item Entries after Jan 15, 2008; entering Dec 31,
2007 for 'Closed Period Entry Posting Date'.
After that there are another 2 lines in Value Entry table; -
first line has Posting Date of Jan 15, 2008 with Source Code of 'Sales'.
second line has Posting Date of Dec 31, 2007 with Source Code
of 'InvtAdjmt'.

The cost is picked up correctly but the question is -

Is the Value Entry table's Posting Date for the 'InvtAdjmt' correct at Dec 31, 2007 OR should it be Jan 15, 2008?

When I run Post Inventory Cost to GL, it gets posted to GL with Posting Date of Dec 31, 2007.

Can anyone help?

Thanks.

bbrown

If Aug 28, 2007 is prior to your GL Allow-from date (Closed Period) then this is correct behavior.

The posting date used by adjust cost is determined by 3 things.

1) The posting data of the entry being adjusted.

2) The GL Allow-from Date

3) The 'Closed Period Entry Posting Date' entered in Adjust Cost

If Item 1 is after item 2 then Item 1 is used as posting date, else item 3 is used.

liyoke

Hi,

Thanks for the reply.

Just wondering, what is the normal frequency for users to run the 'Adjust Cost - Item Entries' and the 'Post Inventory Cost to GL' processes?

Are they run on a daily basis?

Thanks and Regards.

bbrown

We strongly recommend that our clients run Adjust Cost on a daily basis.

Note: If "Automatic Cost Posting" is on, you do not need to run 'Post Inventory Cost to GL'.