Schulz Consulting

Consulting and Upgrades

  • 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:

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

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located 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 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Will There Be A Sage Summit for Sage 100 Users in 2022
  • Avalara Outlines Setup for July 1, 2022 Colorado Retail Delivery Fee
  • Sage 100 API Offered by ROI Consulting
  • Sage 100 Paperless Electronic Delivery Via Gmail Requires App Password or OAuth Starting May 30, 2022
  • Best Practices for Sage 100 Security
  • SPS Commerce MAPADOC EDI for Sage 100 2022 Due for June 22, 2022 Release
  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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