Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

How Is Unit Cost Computed For FIFO Items Within MAS90 Sales Order Invoice Entry?

August 31, 2011 by Wayne Schulz

Here is an interesting tidbit that I just learned (or maybe I knew it before but re-learned it).

The cost field in the MAS90 Sales Order Invoice data entry may not be the true cost so long as the invoice is unposted.

A Client was using FIFO costing for an item that they sold. Noticed that the data entry cost didn’t match with the gross profit journal cost. Turns out the way that the cost is assigned is MAS90 and MAS200 may use last cost within the invoice data entry cost field. (see this link for the Sage explanation)

When the transaction is posted the cost is assigned properly to the invoice history file.

This came about because the client wanted to provide a file of sMAS90 Sales Order invoice data entry transactions (including line item costs) to a third party. My thinking was just take MAS90 Sales Order Invoice Data Entry and do an export.

That worked — except the client noticed the cost per the export I had created did not match to the cost per the Cost Journal for FIFO (and possibly other) cost types.

Here’s the Sage KB that explains it better than I probably have.

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: mas200, Sage 100 ERP Tagged With: costing, fifo, mas200, Sage 100 ERP

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021
  • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
  • Sage Announces Sage Partner Cloud December 16, 2020
  • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
  • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.