sales order – Schulz Consulting

Amazon Marketplace Integration to Sage 100 ERP (with or without EDI)

May 31, 2013 by Wayne Schulz

Are you using the online retailing power of Amazon.com to sell your products directly to customers? The Amazon Marketplace Connector for EDI Advantage gives you the ability to automatically integrate Amazon Marketplace orders with your Sage 100 ERP system.

The Amazon Marketplace Connector for EDI Advantage brings Amazon Marketplace orders right into Sage 100 and notifies Amazon when orders have been fulfilled (so you can get paid). It can be automated or initiated on demand.

Automatically downloads Amazon Marketplace orders
You receive orders in your Document Express inbox
Integrates orders into Sage 100 ERP as Sales Orders
Automatically sends shipping acknowledgement to Amazon.com
Includes connectivity services, training, and support

Want more information – Contact Us

Double Posting From Sage 100 ERP (Formerly Sage ERP MAS 90 and 200) Sales Order – Fixed

February 1, 2012 by Wayne Schulz

Sage have issued program fix SO4081-T which resolves a rather serious Sales Order double posting issue which my 90 Minds Consulting Group first spotted back in December 2011.

The program issue was:
Daily Transaction Register doubles the amount of one or more invoices from Sales Order Invoice Journal

Until Sage issued their program fix the only workaround was to preview the posting registers before updating.
Possible Workaround:

Expand Modules, Sales Order, Main, Daily Sales Reports/Updates
Preview the Daily Sales Journal and exit.
Answer No to Print the other reports (Gross Profit, Sales Recap, etc..)
Answer No to Update the Daily Sales Journal

Expand Modules, Sales Order, Main, Daily Sales Reports/Updates
Print the Daily Sales Journal as well as all subsequent reports
Answer Yes to Update
Print the Daily Transaction Register – it should reflect the correct detail and total information.

How to configure MAS90 Sales Order entry so it will automatically backorder items that are not on hand

January 2, 2012 by Wayne Schulz

Several consultants in my 90 Minds Consulting Group were just comparing notes about a question that one of them had asked. The question was “Is there a way to configure MAS90 and MAS200 so that inventory items not in stock will automatically be back ordered on the order?”.

After some debate about potential ways to accomplish this task – Dawn Anastasi – of C&G Consulting offered up this best practice:

Yes that is possible, you want to turn off the quantity checking in S/O first of all. Second, you want to turn OFF the setting in Role Maintenance for “allow to exceed qty on hand” on tab #3.