Sage 100 ERP (MAS 90): Secure Inventory Posting History

Question: We own Sage 100 ERP (formerly Sage MAS 90); we previously received goods that had been on a Purchase Order. We would like to return the goods to the vendor. Is it possible to delete the item off the inventory list like QuickBooks allows or are there other steps required?

Answer: First, Sage 100 ERP is a Batch Processing Accounting system, unlike QuickBooks. So for transactions to be posted into the system they must be inputted, printed, reviewed and then posted. This goes back to the early design of MAS 90 in the 1980’s. Below you will see how this works for Return of Goods.

Step One: 

To be safe we want to first check the quantity level of the inventory item we are returning, in this case from the screenshot below you can see that item STORAGE CUBE has quantity 28 at Whse 000 and 00 on PO’s.

Step Two:

Go to Purchase Order>Mat. Req/Return>Return of Goods Entry, click on the icon and entry the original PO that is being returned, in this case 0010019.  

Step Three:

Click on the Lines Tab the message displays:

Click yes, the Lines Tab will display with the Original Goods displayed.

Click Accept, and you can then view the Return Order as shown:

Step Four:

Run the Return Order Register Update:

Print and update the register:

Click yes, this will update the register and history, finally print and update the Daily Transaction Register.

Step Five:  You can now verify the PO has been returned and the quantity in Whse 000 is 27.

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services 

Mike is and expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.