MRSware Sales and Commissions
  • MRSware
    • About
  • Sales & Commissions
    • Sales Reps
    • Manufacturers
  • CRM
  • Blog
  • Pricing
  • Support
    • Training >
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Login
  • Free Trial

ChangeLog: Batch Number added for Easy Filtering of Imports

12/27/2021

0 Comments

 
The Batch Number field was added to the Sales Import screen, as well as the Order, Order Line Item, Invoice, and Invoice Line Item screens.  Assigning a unique Batch Number to a file that is being imported allows the User to easily filter by Batch Number in any of the related screens to find all related items.

Think of the case where there is a Commission Statement being imported, and that statement includes Invoices across multiple months.  To otherwise filter in the Invoices screen after import, the Created On date range would have to be used to pull up all the entries.  Using the Batch Number instead, all entries, regardless of input time or occurrence date, can be pulled up with a simple text filter.

Unique Batch Numbers

Users will want to make sure that Batch Numbers are unique -- don't use the same name for multiple imports.  When the same name is used, the filtering purpose of the field is eliminated. 

To help keep the entries unique, an empty Batch Number field will automatically be filled in with a unique Number.  In this way, it is not necessary for the User to enter anything at all in this field and still make use of it.  If the User chooses to enter their own number, a combination of the file name and date with time of the import is usually sufficient to make the entry unique.  
0 Comments

Import Any or All: Orders, Invoices, Commission Statements

5/26/2021

0 Comments

 
​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.

Read More
0 Comments

    MRSware Blog

    contains updates for shows and conferences we will be attending, product releases and enhancements (the changelog), and general market engagement articles

    Categories

    All
    Account Numbers
    Analytics
    Apple Mac
    Calendar
    ChangeLog
    Conferences
    CRM
    Customers
    Data Analysis
    Database Features
    Data Import
    Email
    File Share
    Free Community
    Invoices
    IOS
    ISSA
    Marketing
    Mobile Computing
    MRSware Desktop
    MRSweb
    New Features
    Outlook
    Passwords
    Payments
    Permissions
    Projects
    Reports
    Sales
    Sales Force Automation
    Sales Import
    Sales Reps
    Scheduling
    Security
    Sync
    Timely Commissions
    Tips & Tricks
    Tools
    Updates
    Web Client

    Archives

    February 2023
    January 2023
    October 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    December 2021
    October 2021
    September 2021
    May 2021
    February 2021
    July 2020
    June 2020
    May 2020
    April 2020
    October 2019
    September 2019
    June 2019
    April 2019
    August 2018
    March 2018
    January 2018
    December 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    June 2015
    May 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    January 2014
    December 2013
    September 2013
    July 2013
    June 2013
    April 2013
    March 2013
    February 2013
    December 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    January 2012
    December 2011
    February 2011
    January 2011
    December 2010
    April 2009
    May 2008

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
sales@MRSware.com     (866)795-8386 x1
Copyright (c) 2002-2023 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
made in Austin, TX  USA