1 min read

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

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.

Purchase Order  Sage 100 ERP resized 600

 

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.  

Purchase Order  Sage 100 ERP1 resized 600

Step Three:

Click on the Lines Tab the message displays:

Purchase Order  Sage 100 ERP2 resized 600

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

Purchase Order  Sage 100 ERP3 resized 600

 

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

Purchase Order  Sage 100 ERP4 resized 600

Step Four:

Run the Return Order Register Update:

Purchase Order  Sage 100 ERP5 resized 600

Print and update the register:

Purchase Order  Sage 100 ERP6 resized 600Purchase Order  Sage 100 ERP7 resized 600

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.

Purchase Order  Sage 100 ERP8 resized 600

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. 

Specialties

Sage 100 ERP (formerly Sage MAS90/200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant ManagementSage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.

Sage 100 ERP (MAS 90): How to Create a Receipt of Goods Entry

Sage 100 ERP (MAS 90): How to Create a Receipt of Goods Entry

Question: We own Sage 100 ERP (formerly Sage MAS90), we just added the Purchase Order and Inventory Management Modules. After we issue a Purchase...

Read More
Sage 100 ERP (formerly MAS 90): How to install the new tax table updates

Sage 100 ERP (formerly MAS 90): How to install the new tax table updates

Question: Mike, we own Sage 100 ERP (formerly Sage MAS90), we process payroll. How do we get and install the new tax table updates?

Read More
Sage 100 ERP Payroll: How do we get and install the new 941 forms?

Sage 100 ERP Payroll: How do we get and install the new 941 forms?

Question: Mike, We own Sage 100 ERP (formally Sage MAS90), we process Payroll. How do we get and install the new 941 forms?

Read More