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.

Students Click Here

Inventory Repots

Inventory Repots

Inventory Repots

The Inventory Trial Balance has incorrect pricing on it, but the Inventory Valuation Report and the Item in Inventory is correct. How can I only change the Inventory Trial Balance price, without effecting GL?
Replies continue below

Recommended for you

RE: Inventory Repots

You cannot. The Inventory Trail Balance is meant to balance to the GL. In your case does it?  The Inventory Valuation report is NOT meant to balance to the GL. It is a live report, meant to show valuation as of the moment you run the report. Also pricing, that is the price you sell it at has nothing to do with valuation. It is the unit cost. Also a couple of questions. Are your items Average, FIFO, Lot or Serial?  And why do you think the Trial Balance is incorrect?

Visit Sage's Online Community

RE: Inventory Repots

Thank you for the info. I apologize, I did mean cost. The Trial Balance has the incorrect cost on two items. The item has the correct cost in the inventory module and in the Invetory Valuation Report. We use a mix of FIFO (this sometimes defaults to average because of overdistributions) other items we use serial.

So, if we do an inventory adjustment to fix a cost in the MAS90 will it change both reports (inventory valuation and trial balance) and the GL? After a cost adjustment is when the report no longer matches.

With exception of the two items the Inventory Trial Balance and the Inventory Valuation are the same.

RE: Inventory Repots

If you use FIFO and serial there is no way an item can have an incorrect cost.  Also you did not answer my question. Does the inventory trial balance tie to the GL?

If you adjust out an item and then bring it back in at a different cost this will be reflected in all reports.

Visit Sage's Online Community

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! Already a Member? Login

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