---
title: "Tips & Tricks #47 - Out of Balance Inventory Inquiries | BCS ProSoft"
description: Incorrect quantities for “On Purchase Order” or “On Sale Order” appear when performing an inventory inquiry. This problem is resolved by rebuilding the application sort files for the appropriate module and and answering the question […]
---
Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)
[](https://www.bcsprosoft.com/)
- Products
- Deltek
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/)
- [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/)
- [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/)
- [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/)
- Sage
- [Sage Intacct](https://bcsprosoft.com/sage-intacct/)
- [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/)
- [Sage CRM](https://www.bcsprosoft.com/sage-crm/)
- [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral)
- [Services](https://www.bcsprosoft.com/services/)
- Resources
- Blog
- [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/)
- [Sage Blog](https://blog.bcsprosoft.com/tag/sage)
- [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite)
- Whitepapers
- [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/)
- [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/)
- [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/)
- Product Guides
- [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/)
- [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/)
- [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/)
- Webinars
- [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/)
- [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/)
- [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/)
- Company
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/bcs-referral/)
- [Contact Us](https://www.bcsprosoft.com/contact/)
# Tips & Tricks #47 – Out of Balance Inventory Inquiries
By [lcordova](https://blog.bcsprosoft.com/author/lcordova) | Jul 21st, 10 | Categories: [MAS 90](https://blog.bcsprosoft.com/tag/mas-90), [Tips & Tricks](https://blog.bcsprosoft.com/tag/tips-tricks), [MAS 200](https://blog.bcsprosoft.com/tag/mas-200), [BCS ProSoft](https://blog.bcsprosoft.com/tag/bcs-prosoft), [Laura Cordova](https://blog.bcsprosoft.com/tag/laura-cordova), [Out of Balance](https://blog.bcsprosoft.com/tag/out-of-balance), [Pending Update](https://blog.bcsprosoft.com/tag/pending-update)
Incorrect quantities for “On Purchase Order” or “On Sale Order” appear when performing an inventory inquiry.
- This problem is resolved by rebuilding the application sort files for the appropriate module and and answering the question “Would you like to recalculate open PO/SO quantities in the Inventory Masterfile also?”
To run this utility, perform the following steps:
- Select Library Master | Utilities | Rebuild Application Sort Files.
- Choose Purchase Order or Sales Order.
- Input your three-character company code and select the Rebuild Button.
- Answer Yes to all the questions.
**Want to view more Tips & Tricks for MAS 90/200? Visit our Tips & Tricks** [**Blog**](http://www.bcsprosoft.com/blog/sage-100/)**.**
## About the Tips & Tricks Series
BCS ProSoft is proud to offer you these Tips & Tricks for MAS 90 and MAS 200. These tips were drawn from our extensive technical support knowledge base as well as from the comprehensive experience or our team. Each tip is outlined in detail, including pictures and or drawings where appropriate. There are a couple of things to note in order to use these tips effectively. All tips are written for Sage MAS 90 and Sage MAS 200 versions 4.1 and higher. Some tips should be used with great care and caution. If you are ever in any doubt as to how to use the information provided, please contact our Award Winning Support Center. [Click here](http://www.bcsprosoft.com/support/) for options on contacting our Support Center.
| [](https://www.bcsprosoft.com/category/rental/) | [View Other Tips & Tricks](http://www.bcsprosoft.com/blog/sage-100/) |  | Follow Us on Twitter |
| --- | --- | --- | --- |
| [](http://www.linkedin.com/ppl/webprofile?vmi=&id=48273840&pvs=pp&authToken=bux9&authType=name&locale=en_US&trk=ppro_viewmore&lnk=vw_pprofile) | [Join us on Linked-In](http://www.linkedin.com/companies/251171) | [](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/hatRSS_50X50-May-18-2021-05-52-11-72-PM.png) | [Subscribe to our Feed](http://feeds.feedburner.com/BcsProsoft/Xutx) |
## About the Author
[](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/LauraCordova-1.jpg)Senior Consultant, Laura Cordova has been an important member of the BCS ProSoft team since 2006. Laura grew up in Juarez, Mexico and came to the U.S. to attend college. She got her BS in Computer Sciece from UT El Paso and remained in the U.S. to work in the accounting and business management field. According to Laura, “I love my job because every day I get to work with new clients and help solve new problems!”
Laura’s family still lives in Mexico and she enjoys visiting as often as she possibly can. When she’s not traveling to Juarez, she loves to read (primarily self improvement books) and also enjoys movies (but nothing scary, thank you!). Spanish is Laura’s first language, which can be a blessing and a curse, “There are many Spanish speakers in South Texas and I enjoy working with them, but I learned accounting and computers in English, so if I’m working with a Spanish speaker, sometimes I struggle to translate the MAS 90 words into Spanish!”
#### Share this post with a friend or coworker!
-
-
-
- [mailto:?subject=Tips%20&%20Tricks%20#47%20–%20Out%20of%20Balance%20Inventory%20Inquiries&body=https://blog.bcsprosoft.com/tips-tricks-47-out-of-balance-inventory-inquiries](mailto:?subject=Tips%20&%20Tricks%20#47%20–%20Out%20of%20Balance%20Inventory%20Inquiries&body=https://blog.bcsprosoft.com/tips-tricks-47-out-of-balance-inventory-inquiries)
### Related posts
[Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/extend-the-functionality-of-your-sage-intacct-solution-learn-more-at-wednesday-wisdom)
Mar 24th, 21
[Services Sales Tax Spreads Through States](https://blog.bcsprosoft.com/services-sales-tax-spreads-states)
Feb 8th, 21
[The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/sage-intacct-budgeting-planning-series)
Nov 19th, 20
[Survey Results, Expert Speakers, and Industry Insights – Sage Intacct Hospitality Hangout Has It All](https://blog.bcsprosoft.com/hospitality-hangout)
Sep 17th, 20
[The Sage Intacct Healthcare Hangout is Back!](https://blog.bcsprosoft.com/healthcare-hangout-2)
Sep 15th, 20
[Hurricane Laura – Is Your Business Prepared?](https://blog.bcsprosoft.com/hurricane-laura-is-your-business-prepared)
Aug 26th, 20
This is a search field with an auto-suggest feature attached.
- There are no suggestions because the search field is empty.
### Recent Posts
### Who is BCS ProSoft?
We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/)
BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico.
### **Products**
- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/)
- [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/)
### **Company**
- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/calendar/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/)
© Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/)
- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)