Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Rolling Costs

Rolling Costs

Has anyone ever rolled costs during the month instead of month end?    What are the implications of doing this?

In reviewing this past month, we had a lot of material increases and I'd rather the Finished Goods parts reflect accurate costs and not wait till month end.

RE: Rolling Costs


I am assuming you have not purchased the Std Costing module.

The Print Costed Bill with the checkbox "update parent cost in inventory" checked will do just that.  It will debit or credit the inventory asset account as defined in the Matl Cost Type/Location and the other side of the entry will go to the cost adjustment account.  It also creates type C transactions in the IMINVTRX table.

If there is no matl cost type/loc record that corresponds to the parent, it will use the same values but come from the IM control file.

How this affects subsequent transactions depends on what cost method you are using and the cost to use when posting flag in OE setup.  If you have any specific questions fire away.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:

RE: Rolling Costs

Nope..don't have std cost module.
Cost method to use in OE Setup = Actual
Inventory cost method in IM Setup - Std

I am thinking any orders already keyed/shipped after the cost roll will use the cost amount created at that point in time.

At mth end I manually recalculate the inventory to the correct purchase price, so we know we are not capturing FG costs 100% it is a point in time issue for FG.


RE: Rolling Costs

The cost to use when posting flag is A-Actual, so the std cost at the time the invoice is posted (assuming you are not using confirm pick or confirm ship) is what will be used.  

If this flag was L-Line Item, the std cost at the moment the order was entered will stay with the item forever, even if that cost was zero.

I don't see any problems with what you are trying to do but I would bounce it off your CPA firm.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:

RE: Rolling Costs

Thanks, Don.  Happy Easter.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close