Southware Answers
  • SouthWare
  • Events
    • 2023 User Conference
    • Webinars
    • 2022 Conference Resources
    • 2021 Conference Resources
    • 2020 Conference Review
    • 2019 User Conference Review
    • 2018 User Conference Review
  • Resources
    • StayCurrent
    • Solutions >
      • AvaTax by Avalara
      • EazyStock
      • Aptean CRM
      • Aris Power BI
      • BTM MMS - Manufacturing
      • OpusScan
      • StarShip
      • Warehouse Tracking
    • Webinar Videos
    • Year End Processing
    • Service Status Pages
  • About & Contact

News

SQLSync - Ability to Rebuild Key History Files from a Specific Date

8/20/2020

 
This new feature will allow you to rebuild key history files from a specific date so that you will no longer need to rebuild the whole file when the sync process doesn’t complete. 
The new process reads the history files in reverse order and will create SQLSync transactions that will get posted to the MSSQL tables from the SQLSync Background server.
There are two new options in the SQLSync Manager:
  • Choose "History Files to build from a specific date" to create transactions in the SQLSync transaction file that will be posted to MSSQL from the Background server.
  • Choose "Create new SQL Table from a specific date" to create the MSSQL table and create transactions in the SQLSync transaction file that will get posted to MSSQL from the Background server.
Currently, this function is limited to a select group of history files:
·         Invoice header history
·         Invoice line item history
·         Service order header history
·         Service order line history
·         Receivings header history
·         Receivings line history
·         PO header history
·         PO line history
·         Inventory Ledger

Comments are closed.

    Archives

    November 2020
    September 2020
    August 2020
    July 2020
    March 2020
    December 2019
    November 2019
    October 2019
    August 2019
    June 2019
    May 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    November 2017
    August 2017
    June 2017
    May 2017
    February 2017

    Categories

    All
    Accounts Payable
    Enhancement
    Excel
    NetLink
    Portals
    Pricing
    Resource Management
    Southware
    SQLSync
    TaskWise

    RSS Feed

The SouthWare Partner Alliance (SPA) is the premier association of SouthWare Solution Partners - providing SouthWare Solutions, Technology, Training and Support Services. For more information about the SouthWare Partner Alliance or the Southware User Conference, please contact your SouthWare partner.
SouthWare Partner Alliance
© Copyright SouthwareAnswers.com. All Rights Reserved.  Privacy

Sign-Up for our E-mail list!

  • SouthWare
  • Events
    • 2023 User Conference
    • Webinars
    • 2022 Conference Resources
    • 2021 Conference Resources
    • 2020 Conference Review
    • 2019 User Conference Review
    • 2018 User Conference Review
  • Resources
    • StayCurrent
    • Solutions >
      • AvaTax by Avalara
      • EazyStock
      • Aptean CRM
      • Aris Power BI
      • BTM MMS - Manufacturing
      • OpusScan
      • StarShip
      • Warehouse Tracking
    • Webinar Videos
    • Year End Processing
    • Service Status Pages
  • About & Contact