The MRSweb Sales Import process supports importing multiple file types, and overlaying updates and new information for already existing entries in the system. Here are some examples of types of files you might receive on a regular basis:
|
|
- Order Acknowledgements
Import an Order report, POS report, or Order Acknowledgement report from your manufacturers or other business partners. New entries will be added to the system; entries that match existing PO Numbers will be updated or added to.
- Invoice Shipping Report
When the merchandise leaves the warehouse an Invoice is generated for the shipped goods. If you received this report, you can import it into your system. Just as Orders match up to POs, Invoices match up to Orders. Shipping Quantities can be confirmed and Anticipated Commissions matched up for accuracy.
- Commission Statements
When the commission check comes, import the report that comes along with it. Confirm paid Invoices on the Payment Entry, reconcile commissions, forecast outstanding commissions due.
Any of these reports are optional -- you could import the first and last, skipping the middle, and still have a complete picture of the process. Likewise, you can skip right to the end and just import the Commission Statement to track payments across multiple lines. And, of course, each manufacturer will send you different combinations of these reports, so each line could have any or all of these that are imported as they are received.
|
There is no wrong answer with the Sales Importer, anything is sees it can enter, match, and update as appropriate depending on what kind of report it is. To discuss the specific reports your agency receives, and the data challenges you face, set up a call and web conference time to take a look at the MRSware solution.
|