Release:
August 1, 2022
SouthWare
Connector 4.0.031
-
Revised Journal Entry stored procedure Inventory Transfers to use the Clearing
Inventory Account when it is present. Also revised Journal Entry stored procedure
Assembly Work Orders to override the Item Category Inventory Account from the
Order Line Inventory Account when it is present. The latter revision has since
been removed.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised script is (SQL scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
Release:
February 3 , 2022
SouthWare
Connector 4.0.030
-
Revised Receiving Export script to truncate Item Description columns to 30 characters
each.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised script is:
ExSwRecvL.SQL
Release:
January 28, 2022
SouthWare
Connector 4.0.029
-
Revised Cash Flow stored procedure to connect write-offs individually rather
than batched together.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (SQL
scripts denoted with * need to be updated to the database):
SWCFExpSP.SQL*
Release:
April 19, 2021
SouthWare
Connector 6.8.000
-
Major revision for compatibility with FrontLine 6.8.
- Function ACCTCONV.SQL has to be revised and updated to the database
to reformat the GL Account Number for SouthWare compatibility.
- Program
FLXRUP68 has to be run to change the SouthWare Connector FLCTL and FLXRF files
to refer to "CodeGL" rather than "Account".
- Program
FLAPOEXP has to be run to connect open AP to FrontLine.
- Program
FLPEREXP has to be run to connect vendors that do not have the Manufacterer
flag to FrontLine.
- NOTE: When
executing SWJESetup.SQL and SWCFSetup.SQL, be sure to delete any SWJE*.* and
SWCF*.* tables before creating new ones.
Prerequisites: FrontLine 6.8.023 or above.
- This
revision applies to SouthWare 14 and 15, and the new revised programs, scripts,
programs, and reports are (SQL scripts denoted with * need to be updated to the
database):
ACCTCONV.SQL*
DTU_FLAPOEXP.INI
FLAPOEXP.OBJ
FLCFIMP.OBJ
FLPEREXP.OBJ
FLXRUP68.OBJ
GLACTMNT.OBJ
JEReconnect.SQL
SWCFExp.SQL
SWCFExpSP.SQL*
SWCFSetup.SQL*
SWJEExpD.SQL
SWJEExpH.SQL
SWJEExpSP.SQL*
SWJESetup.SQL*
SWJETagSP.SQL*
SWJEUnTag.SQL
Z_SWJE_GL_Totals.SQL
(report)
Release:
July 26, 2021
SouthWare
Connector 4.0.028
-
Revised Journal Entry stored procedure to accommodate deposits with NULL
VerifyAuths.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This revision
applies to SouthWare 14 and 15, and the revised script is (SQL scripts denoted
with * need to be updated to the database):
SWJEExpSP.SQL*
Release:
July 8, 2021
SouthWare
Connector 4.0.027
-
Revised Cash Flow stored procedure to connect ACH, EFT, and WIRE tender types
individually, and not batched together.
-
NOTE: ACH, EFT, and WIRE tender types must be set up in the LISTVALS table,
with ACH, EFT, and WIRE as LISTVALS.StrValue.
-
NOTE: Tables SWCF and SWCFMAP1 must be dropped and recreated, since they have
new or altered columns.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (SQL
scripts denoted with * need to be updated to the database):
SWCFExpSP.SQL*
SWCFSetup.SQL
(find portion related to table SWCF and drop and recreate the table)
Release:
October 02, 2020
SouthWare
Connector 4.0.026
-
Revised Journal Entry stored procedure for write-offs to accommodate negative
invoices.
-
Includes Invoice Reconnect stored procedure with a few minor tweaks.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (SQL
scripts denoted with * need to be updated to the database):
InvoiceReconnectSP.sql*
SWJEExpSP.SQL*
Release:
October 15, 2020
SouthWare
Connector 4.0.025
-
Revised Periodic Export program to include a /N switch to connect only vendors
that do not have their Manufacturer's flag set to "Y".
- This
revision applies to SouthWare 14 and 15, and the revised program is:
FLPEREXP.OBJ
Release:
August 18, 2020
SouthWare
Connector 4.0.024
-
Revised Journal Entry stored procedure to accommodate UserCancel and Substitute
payments entered after the invoice has been connected. Payments entered at this
stage connect with a different SyncSet than their related order and invoice.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This revision
applies to SouthWare 14 and 15, and the revised script is (SQL scripts denoted
with * need to be updated to the database):
SWJEExpSP.SQL*
Release:
May 20, 2020
SouthWare
Connector 4.0.023
-
Revised Recurring Billing Journal Entry stored procedure to calculate End Date
for 5, 10, 15, 18, 36, 48, and 60 Month billing frequencies. The latter three
were omitted from 4.0.020. Revised
Unearned Revenue import program to accommodate 5, 10, 15, and 18
Month billing frequencies.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised scripts and programs
are (SQL scripts denoted with * need to be updated to the database):
FLUEIMP.OBJ
FLUEIMP_NoCF.OBJ
(If the site does not have Cash Flow, copy this file and rename to FLUEIMP.OBJ)
SWJEExpRBUESP.SQL*
Release:
October 10, 2019
SouthWare
Connector 4.0.022
-
Revised Recurring Billing Journal Entry stored procedure, Recurring Billing
Unearned Revenue export script, Cash Flow Export stored procedure and import
program to allow integration with the Cash Flow. Also revised corresponding
DbTxUtil configuration files.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
NOTE: Do not overwrite
pre-existing .INI files. Instead, add to the pre-existing lines to each file,
and then update the paths on those lines.
- This
revision applies to SouthWare 14 and 15, and the revised scripts and programs
are (SQL scripts denoted with * need to be updated to the database):
DTU_FLJEIMPRB.INI*
(do not overwrite pre-existing)
DTU_FLUEIMP.INI*
(do not overwrite pre-existing)
DTU_FLUEIMP_NoCF.INI*
(If site does not have Cash Flow, copy this file and rename to DTU_FLUEIMP.INI,
then make appropriate patch revisions)
FLCFIMP.OBJ
FLJEIMP.OBJ
FLUEIMP.OBJ
FLUEIMP_NoCF.OBJ
(If the site does not have Cash Flow, copy this file and rename to FLUEIMP.OBJ)
SWCFExpSP.SQL*
SWJEExpRBSP.SQL*
SWJEExpRBUESP.SQL*
Release:
June 12, 2019
SouthWare
Connector 4.0.021
-
Fixed: The Unearned Revenue export script was calculating the billing period
End Date incorrectly. The script now subtracts one day from the previously
calculated End Date.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised script is (scripts
denoted with * need to be updated to the database):
SWJEExpRBUESP.SQL*
Release:
May 13, 2019
SouthWare
Connector 4.0.020
-
Revised Unearned Revenue import program to accommodate FrontLine 6.6.049
revision that implemented 36
Month (3 year), 48
Month (4 year), and 60 Month (5 year) billing frequencies.
Prerequisites: FrontLine 6.6.046 or above, though
for this feature, 6.6.049.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
FLUEIMP.OBJ
Release: December 5, 2018
SouthWare Connector 4.0.019
- Revised Journal Entry Export stored procedure
to accommodate FrontLine revision that removed negative sign on
TRXRESOURCE.ItemCost for Returns.
Prerequisites: FrontLine 6.6.046 or above.
- This
revision applies to SouthWare 14 and 15, and the revised script is (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
Release: November 30, 2018
SouthWare Connector 4.0.018
- Revised Journal Entry Export stored procedure
to use the Order Line TrxType Return flag to determine the sign of Invoice Cost
on Inventory and Physical Adjustment journal entries.
Prerequisites: FrontLine 6.6.000 or above.
NOTE: This release builds on 4.0.015a.
- This
revision applies to SouthWare 14 and 15, and the revised script is (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
Release: September 18, 2018
SouthWare Connector 4.0.015a
- Revised Journal Entry Export stored procedure
to consider cancellation and substitute payments in Deposit Payments debit and
credit queries.
Prerequisites: FrontLine 6.6.000 or above.
Note: This release bypasses releases 4.0.016,
4.0.016a, and 4.0.017 that are yet to be reviewed and tested for deployment. If
it decided that those releases will be deployed, some consolidation will be
required.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: June 22, 2018
SouthWare Connector 4.0.017 - OBSOLETE
- Revised
SouthWare Receivings Cost and Receivings Cost History files to accommodate 6-digit
FrontLine PO line numbers.
Note #1: Prior
to testing this revision, the SouthWare Receivings Cost (SRCC1.FIL) and
Receivings Cost History (SRCCH.FIL) files need to be backed up manually and
reformatted with programs FLRCCREF.OBJ and FLRCHREF.OBJ. These programs will
automatically back up the files, but for first testing it would be best to do
this manually.
Note #2: If
the client has a custom version of APTRXMNT.OBJ for laser printed checks, a
recompiled version of their custom program will need to be created before
updating.
- This
revision applies to SouthWare 14 and 15, and the new and revised programs are:
APTRXMNT.OBJ
FLCOSEXP.OBJ
FLRCCREF.OBJ
FLRCHREF.OBJ
FLRECUPD.OBJ
RSRCCENT.OBJ
Release: May 16, 2018
SouthWare Connector 4.0.016a - OBSOLETE
- Revised
Receivings and Invoice Reconnect stored procedures due to tagging revisions in
4.0.016.
Note: Please
test in a copy of the database before using in a live database.
- This revision
applies to SouthWare 14 and 15, and the revised scripts are (scripts denoted
with * need to be updated to the database):
InvoiceReconnectSP.SQL*
RecvReconnectSP.SQL*
pgInvoiceReconnectSP.SQL*
pgRecvReconnect.SQL*
Release: May 1, 2018
SouthWare Connector 4.0.016 - OBSOLETE
- Revised
Journal Entry tagging and connector stored procedures to include journal
entries from purchase orders.
- Revised Receivings connector tagging and export
scripts to connect Inventory Clearing account as SouthWare Receivings Cost File
PO-RCOST-INV-CLEAR-ACCOUNT.
NOTE: FrontLine Purchase Orders are now being
connected in two different connections and at different intervals. The Journal
Entry connector continues to use the SyncSet column in various tables to
synchronize the connection. However, the Receivings connector now uses the
SyncSet column only for the vendor connection and a new APSync column for the
receivings connection. Before the new APSync column can be implemented the
database must be updated. The database updates and notes are found in a script
named DBUpdate_4.0.016.SQL.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
DBUpdate_4.0.016.SQL
ExSwRecvL.SQL
SWJEExpSP.SQL*
SWJETagSP.SQ*
TagNewExpRecv.SQL
pgExSwRecvL.SQL*
pgExSwRecvLC.SQL
pgSWJEExpSP.SQL*
pgSWJETagSP.SQ*
pgTagNewExpRecv.SQL*
pgTagNewExpRecvC.SQL
Release: March 1, 2018
SouthWare Connector 4.0.015
- Revised AP Vendor
Maintenance program to no longer connect contacts.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
APVNDMNT.OBJ
Release: February 26, 2018
SouthWare Connector 4.0.014
- Revised GL
Account Maintenance program to connect accounts that are updated as inactive to
FrontLine with the List Values Display column = DO NOT USE.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
GLACTMNT.OBJ
Release: January 15, 2018
SouthWare Connector 4.0.013
- Revised
Journal Entry Import program to not display the closed period message when an
import GL date is in a future period.
- Added
scripts for reconnecting Cash Flow entries missed due to missing BankID
cross-references.
NOTE: The Cash
Flow reconnection must be performed by experienced personnel at this time! There are not detail instructions yet.
- This
revision applies to SouthWare 14 and 15, and the revised programs are:
FLJEIMP.OBJ
FLJEIMP_NoCF.OBJ
SWCFReconnEX.SQL
SWCFReconnExp.SQL
SWCFReconnSP.SQL
Release: January 11, 2018
SouthWare Connector 4.0.011a
- Revised
Journal Entry connector to detect a FrontLine AvaTax configuration based on the
presence of a specific company setup. If the setup configuration is present,
the connector connects tax journal entries from the invoice line table.
Note: Since
AvaTax does not use the tax detail table, the tax account must be hard-coded in
the COALESCE of the LISTVALS join that is labeled 4.0.011. For sites that do not
use AvaTax, this is not required. Feel free to request help if needed.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJEExpRBSP.SQL*
SWJEExpRBUESP.SQL*
pgSWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJEExpRBUESP.SQL*
Release: December 11, 2017
SouthWare Connector 4.0.012
- Revised
Journal Entry Import program to display a user message when an import GL date
is in a closed period. The import record will also create an error in
ImportMate as before.
- This
revision applies to SouthWare 14 and 15, and the revised programs are:
FLJEIMP.OBJ
FLJEIMP_NoCF.OBJ
Release: November 17, 2017
SouthWare Connector 4.0.011
- Revised Journal
Entry connector to accommodate use of the FrontLine AvaTax feature. When
FrontLine AvaTax is used, the connector connects tax from the invoice line
table rather than the order line tax table.
Note: Since
this method of obtaining tax cannot make use of the tax detail table, the tax
account must be hard-coded in the COALESCE of the LISTVALS join that is labeled
4.0.011. Feel free to request help if needed.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJEExpRBSP.SQL*
SWJEExpRBUESP.SQL*
pgSWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJEExpRBUESP.SQL*
Release: November 15, 2017
SouthWare Connector 4.0.010
- Revised
Periodic Connector program FLPEREXP, disabling the following obsolete export
modes: <E>ntity, <F>ull, <S>erial, and <C>ategory.
- Revised
DbTxUtil INI file, removing connection of obsolete files created by the
obsolete export modes in FLPEREXP.
- This
revision applies to SouthWare 14 and 15, and the revised programs and files
are:
DTU_FLPEREXP.INI
FLPEREXP.OBJ
Release: October 6, 2017
SouthWare Connector 4.0.009
- Fixed:
Unearned Recurring Billing connector output Tax Account and Tax Amount incorrectly.
This was caused by a bug that caused the unearned work table to inherit the
data layout of the stored procedure temporary table. This has been fixed to
retain the definition of the setup table.
- Added a
modifiable script to add a single entry into the Cash Flow Cross-Reference
Table.
Note: If this
issue is found at a site, you must drop and recreate the unearned work table,
SWJEUE, since it will have been corrupted by the bug that was fixed.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
DTU_FLUEIMP.INI
(client file must be updated)
SWCFAddXR.sql
SWJEExpRBUESP.SQL*
pgSWCFAddXR.sql
pgSWJEExpRBUESP.SQL*
Release: July 26, 2017
SouthWare Connector 4.0.008
- Fixed:
Payments On Account connected with incorrect GL account number. Revised Journal
Entry Export stored procedure to the following hierarchy: 1) Payment Order Line
AR Account, 2) AR table Receivable being paid AR Account.
- Removed
4.0.007 revisions.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: June 7, 2017
SouthWare Connector 4.0.007
- Revised Journal Entry and Unearned Recurring
Billing connectors to prevent concurrent runs. If another user is already
running the connector, the program will display a user message and exit.
Note: This
release should be tested with both a normal Journal Entry connection, and also
by placing the file FLJEIMP_log.txt (or FLJEIMPRB_log.txt for Recurring Billing
or FLUEIMP_log.txt for Unearned Revenue) in the FLCONN folder, and attempting a
normal connection. The latter should display a user message and exit the run,
without connecting to back office.
- This
revision applies to SouthWare 14 and 15, and the revised programs are:
FLJEIMP.OBJ
(Standard program to connect both regular and recurring billing journal
entries, as well as Cash Flow)
FLJEIMP_NoCF.OBJ
(Same as above, but no Cash Flow)
FLUEIMP.OBJ
(Standard program to connect Unearned Revenue journal entries)
Release: May 12, 2017
SouthWare Connector 4.0.006
- Revised Journal Entry Unearned Recurring
Billing connector to accommodate taxes in separate lines in order to prevent
duplicate entries. Also revised to connect journal entries for Monthly bill
frequency as regular recurring billing regardless of presence of Unearned
Revenue account.
- Revised Journal Entry Regular and Recurring
Billing Detail scripts to strip carriage return and line-feed characters from
the Memo2 field.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
DTU_FLUEIMP.INI
(client file must be updated)
FLUEIMP.OBJ
SWJEExpD.SQL
SWJEExpRBD.SQL
SWJEExpRBUE.FMT
SWJEExpRBUE.SQL
SWJEExpRBUEEX.SQL
SWJEExpRBUESP.SQL*
SWJESetup.SQL
SWJETagRBSP.SQL*
SWJETagRBUE.SQL*
pgSWJEExpD.SQL
pgSWJEExpRBD.SQL
pgSWJEExpRBUESP.SQL*
pgSWJEExpRBUESPC.SQL
pgSWJEExpRBUE2SP.SQL*
pgSWJEExpRBUE2SPC.SQL
pgSWJESetup.SQL
pgSWJETagRBSP.SQL*
pgSWJETagRBUESPC.SQL
pgSWJETagRBUESP.SQL*
Release: May 4, 2017
SouthWare Connector 4.0.005
- Revised Journal Entry and Cash Flow Export stored
procedures to accommodate Non-AR orders (FrontLine 6.6.013) and to eliminate
zero amounts from journal entry transaction line assignment.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWCFExpSP.SQL*
SWJEExpSP.SQL*
SWJETagSP.SQL*
pgSWCFExpSP.SQL*
pgSWJEExpSP.SQL*
pgSWJETagSP.SQL*
Release: April 13, 2017
SouthWare Connector 4.0.004
- Revised Journal Entry Export stored procedure
to accommodate FrontLine revision 6.6.008 that added cost for intangibles. This
revision had caused an adverse affect on assembly journal entries.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: March 3, 2016
SouthWare Connector 4.0.003
- Revised Vendor Export script to accommodate
VendStatus datatype int in FrontLine 6.6.010.
- This revision
applies to SouthWare 14 and 15, and the revised scripts are:
ExSwVend.SQL
pgExSwVend.SQL
Release: December 16, 2016
SouthWare Connector 4.0.002
- Revised Journal Entry Export stored procedure
to remove inventory transfer and assembly work order journal entries from
3.0.074 summation.
- Revised Journal Entry Export script to filter
out journal entries with zero amounts.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: December 16, 2016
SouthWare Connector 3.0.076
- Revised Journal Entry Export stored procedure
to remove inventory transfer and assembly work order journal entries from
3.0.074 summation.
- Revised Journal Entry Export script to filter
out journal entries with zero amounts.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: November 30, 2016
SouthWare Connector 3.0.075
- Revised Journal Entry Tagging and Export stored
procedures to include cancellation and substitute payments.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJETagSP.SQL*
pgSWJEExpSP.SQL*
pgSWJETagSP.SQL*
Release: November 30, 2016
SouthWare Connector 4.0.001
- Revised Journal Entry Tagging and Export stored
procedures to include cancellation and substitute payments.
Prerequisites: FrontLine 6.6.000 or above.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJETagSP.SQL*
pgSWJEExpSP.SQL*
pgSWJETagSP.SQL*
Release: November 8, 2016
SouthWare Connector 4.0.000
- Revised Journal Entry and Cash Flow Setup
scripts and Export stored procedures to expand Line from datatype smallint to
int.
Note: If the client site has custom FrontLine
reports, these should be upgraded when they receive this revision.
Prerequisites: FrontLine 6.6.000 or above.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWCFSetup.SQL
SWJEExpSP.SQL*
SWJEExpRBSP.SQL*
SWJESetup.SQL
pgSWCFSetup.SQL
pgSWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJESetup.SQL
pgSWJESetup.SQL
Release: October 24, 2016
SouthWare Connector 3.0.074
- Revised Journal Entry Export stored procedure to
retain detail of inventory and physical adjustments, inventory transfers, and
assembly work orders.
- Added new table SWJELRBMAP to Journal Entry
Setup script.
- Revised Recurring Billing Journal Entry Export
stored procedure to use new table SWELRBMAP to make it independent from revised
tables in Journal Entry Export stored procedure.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJEExpRBSP.SQL*
SWJESetup.SQL
pgSWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJESetup.SQL
Release: September 8, 2016
SouthWare Connector 3.0.073
- Revised the
Receivings Export script to always code Receiving Cost records as ItemType =
Inventory instead of either Inventory or Catalog. There are no longer receiving
records that are considered Catalog in SouthWare.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
ExSwRecvL.SQL
pgExSwRecvL.SQL
Release: August 31, 2016
SouthWare Connector 3.0.072
- Fixed: The
SouthWare Cash Flow Import program reported duplicate key errors when users ran
the process in consecutive minutes. This was found to be a rounding error in
the Cash Flow Export script, and has now been fixed to retain the seconds
portion of the time when generating the batch number.
- This
revision applies to SouthWare 14 and 15, and the revised script is:
SWCFExp.SQL
Release: August 15, 2016
SouthWare Connector 3.0.071
- Revised Cash
Flow stored procedure to summarize each Tender Type into a separate batch
within Bank ID and Doc Date when Bank Deposit ID is not present.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWCFExpSP.SQL*
pgSWCFExpSP.SQL*
Release: July 18, 2016
SouthWare Connector 3.0.070
- Fixed: Cost
records were duplicated in SouthWare when warranty invoices were present for a customer
sales order. Warranty invoices are now filtered out in affected queries.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: June 2, 2016
SouthWare Connector 3.0.069
- Fixed:
Write-offs that were applied to finance charges, connected to SouthWare with
zero amounts. Revision 3.0.056 related to write-offs required specificaton of
AR DocType to determine the sign of the amount. It did not include finance
charges when specifying the receivable being written off. Finance charges are
now included.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: May 19, 2016
SouthWare Connector 3.0.068
- Fixed:
Revision 3.0.060 introduced tagging of uninvoiced deposit payments.
Unfortunately, payments on recurring bill returns fit the same criteria and were
inadvertently tagged. The Journal Entry Tagging stored procedure has been
revised to filter out recurring bill returned payments from the tagging of
uninvoiced deposit payments.
- This
revision applies to SouthWare 14 and 15, and the revised script is (scripts
denoted with * need to be updated to the database):
SWJETagSP.SQL*
Release: May 13, 2016
SouthWare Connector 3.0.067
- Fixed:
SouthWare Receivings Unit Cost field was displaying as 2dp, when it was 3dp in
FrontLine. Revised Receivings Update program to preserve 3dp when updating
SouthWare Receivings Cost File Unit Cost field.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
FLRECUPD.OBJ
Release: May 10, 2016
SouthWare Connector 3.0.066
- Revised
programs that connect GL Account Numbers to connect all accounts where the
Active Flag does not equal uppercase N or lowercase n.
- This
revision applies to SouthWare 14 and 15, and the revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
GLACTMNT.OBJ
Release: April 26, 2016
SouthWare Connector 3.0.065
- Fixed:
Release 2.0.038 caused the SouthWare
AP Transaction Maintenance program to sometimes complain that the transaction
header Post Date was outside of the GL period. It has now been removed.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
RSRCCENT.OBJ
Release: April 6, 2016
SouthWare Connector 3.0.064
- Fixed: The
SouthWare Cash Flow Import sometimes displayed duplicate key errors. The way in
which the key of the SouthWare Cash Flow Header File was being populated did
not accomodate connection of transactions with a BankID and DocDate that has
been connected previously at exactly the same hour and minute of the day. The
current date of the connection is now being included in the key field Check
Number. Both the Cash Flow Export script and import program have been revised.
- This
revision applies to SouthWare 14 and 15, and the revised program is:
FLCFIMP.OBJ
Release: March 30, 2016
SouthWare Connector 3.0.063
- Removed Cash
Flow section from Journal Entry Export procedure and placed in a separate
procedure. This will make it easier to set up, particularly when a site does
not use the SouthWare Cash Flow module.
Note: For
sites that use the SouthWare Cash Flow module, configure DTU_FLJEIMP.INI. For
sites that do not use the SouthWare Cash Flow module, configure
DTU_FLJEIMP_NoCF.INI, renaming it DTU_FLJEIMP.INI.
- Restored
SWJEDTL reconciliation table from 3.0.053 and added additional columns to key
for uniqueness.
Note: Drop the
SWJEDTL table (if it exists), then open SWJESetup.SQL (or pgSWJESetup.SQL if
pgSQL) and create the last table in the script (SWJEDTL).
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
DTU_FLJEIMP.INI
SWCFExpEX.SQL
SWCFExpSP.SQL*
SWJEExpSP.SQL*
SWJESetup.SQL
pgSWCFExpSPC.SQL
pgSWCFExpSP.SQL*
pgSWJEExpSP.SQL*
pgSWJESetup.SQL
Release: March 4, 2016
SouthWare Connector 3.0.062
- Fixed:
Revision 3.0.060 did not exclude cancelled payments. Added exclusion of these
payments to this query, as well as the query for over/underpayments.
- Simplified
Item Category joins for inventory transactions since EntityID, AgentCat, and Department
will always be -1 (=ANY=) for the inventory item categories.
- Added COS
Account as a second option for Physical Adjustment COS transactions when
PhyAdjOffset account is not set up.Counter discounts sometimes resulted in
overstatement of amounts in journal entries.
- Renumbered
JETypes to allow for insertion.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWCFExp.SQL
SWCFSetup.SQL
SWJEExpRBSP.SQL*
SWJEExpSP.SQL*
SWJESetup.SQL
pgSWCFExp.SQL
pgSWCFSetup.SQL
pgSWJEExpRBSP.SQL*
pgSWJEExpSP.SQL*
pgSWJESetup.SQL
Release: March 2, 2016
SouthWare Connector 3.0.061
- Fixed:
Counter discounts sometimes resulted in overstatement of amounts in journal
entries. This was caused by duplicate rows coming from older joins to the
TRXDTL, ITEMDTL, and UIDS tables, that dated to earlier generation invoice
connection. These were no longer needed and so have been removed.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: February 26, 2016
SouthWare Connector 3.0.060
- Revised to facilitate
connection of uninvoiced deposit payments, and subsequent application to an
invoice.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: February 25, 2016
SouthWare Connector 3.0.059
- Fixed: The
Journal Entry Export stored procedure contained a bug that could potentially
cause duplication of inventory and physical adjustment, transfer, and assembly
work order journal entries. The join for invoice cost has been refined to
prevent this.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: February 23, 2016
SouthWare Connector 3.0.058
- Revised
initial, periodic, and GL Account Maintenance connectors to connect only active
GL accounts.
- Revised
initial and periodic connectors to connect only active salepersons and restored
connection the SouthWare Customer Statement Frequency flag. Exceptions are Disc
and Semi-Annually, which connect as None.
- This
revision applies to SouthWare 14 and 15, and the revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
GLACTMNT.OBJ
Release: February 22, 2016
SouthWare Connector 3.0.057
- Revised
Journal Entry connector stored procedure for Cash Flow to summarize cash flow
by Tender Type and PersonID when Bank Deposit ID is not populated.
- Revised
initial, periodic, and GL Account Maintenance connectors to format the
FrontLine StrValue using the SouthWare GL Control File format. These progams
were already formatting Display with this format, but StrValue was connected
either with leading zeroes or without leading zeroes. All the programs are now connecting
both columns using the SouthWare GL Control File format.
- Revised all
connector scripts that connect GL Accounts to SouthWare, to remove the
SouthWare GL Control File formatting.
Note: It is
important that these steps be taken before running a connection with this
update. 1. The SouthWare GL Account File must be updated with a current date,
so that FLPEREXP will reconnect all records to FrontLine. 2 Use FLPEREXP/L to
reconnect List Values, which includes all accounts. Check FrontLine> List
Values> Ledger Accounts to ensure that all accounts now have the GL Control
File formatting in both the Key Code and Display. 3. Modify script
SWCFSetup.SQL to drop and recreate the Cash Flow Cross-Reference Table with
account numbers that have the GL Control File formatting.
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database):
FLINIEXP.OBJ
FLPEREXP.OBJ
GLACTMNT.OBJ
ExSwVend.SQL
ExSwRecvL.SQL
SWCFExp.SQL
SWCFSetup.SQL
SWJEExpD.SQL
SWJEExpRBD.SQL
SWJEExpRBUE.SQL
SWJEExpSP.SQL*
SWJESetup.SQL
SWJETagSP.SQL*
pgExSwVend.SQL
pgExSwRecvL.SQL
pgSWCFExp.SQL
pgSWCFExpC.SQL
pgSWCFSetup.SQL
pgSWJEExpD.SQL
pgSWJEExpRBD.SQL
pgSWJEExpRBUE.SQL
pgSWJEExpSP.SQL*
pgSWJESetup.SQL
pgSWJETagSP.SQL*
Release: February 10, 2016
SouthWare Connector 3.0.056
- Revised
Journal Entry connector stored procedure for tax write-offs.
- Fixed: The
Journal Entry tagging stored procedure reset the tagged count when tagging inventory
adjustments. It has been fixed to continue to accumulate the count.
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJETagSP.SQL*
pgSWJEExpSP.SQL*
pgSWJETagSP.SQL*
Release: February 8, 2016
SouthWare Connector 3.0.055
- Revised
Journal Entry connector stored procedure for Cash Flow to summarize cash flow
by Bank Deposit ID rather than Tender Type and Person ID. Added Bank Confirmation
to Journal Entry and Cash Flow Reference2 columns. Added new Deposit ID field
to Cash Flow export script.
- Revised Cash
Flow Import program to import Deposit ID field.
- Fixed: The
Journal Entry Import program still called the GL update program which should
have been removed in 3.0.054. This has now been removed. Also fixed the Journal
Entry Import program for sites with no Cash Flow in back office in the same
manner.
Note: This
revision requires that database tables SWCF and SWCFMAP1 be dropped and
recreated manually using those sections of SWCFSetup.SQL or pgSWCFSetup.SQL.
Don't execute the entire script! Also, this revision requires FrontLine version
6.5.052 or later, or at a minimum, the execution of the Bank Deposits script
file in that revision!
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database):
FLCFIMP.OBJ
FLJEIMP.OBJ
FLJEIMP_NoCF.OBJ
SWCFSetup.SQL
SWJEExpSP.SQL*
pgSWCFSetup.SQL
pgSWJEExpSP.SQL*
Release: December 7, 2015
SouthWare Connector 3.0.054
- Added
Inventory Adjustments, Inventory Transfers, and Assembly Work Orders to the
Journal Entry connector stored procedure, and removed the GL update program
that ran at the end of SouthWare EOD program RSBILUP2.
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database):
RSBILUP2.OBJ
(generic SW version)
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
- The following
Ormandy programs and scripts are no longer active connector programs and
scripts for this revision:
DTU_FLGLTEXP.INI
FLGLTUPD.OBJ
ExSwAssemL.SQL
ExSwInvAdjL.SQL
ExSwTransL.FMT
ExSwTransL.SQL
TagNewExpInvAdj.SQL
Release: December 2, 2015
SouthWare Connector 3.0.053
- Added
Journal Entry detail table to Journal Entry export stored procedures for
reconciliation purposes. Currently, this table will not contain journal entries
for Assembly Work Orders, Inventory Adjustments, Transfers, and Unearned
Revenue. These may be added at a later date.
Note:
SWJESetup.SQL (or pgSWJESetup.SQL if pgSQL) should be opened and the last table
in the script (SWJEDTL) created before running the revised Journal Entry export
stored procedures.
- Added
optimizing locking hints to other selected connection scripts.
Note: The
scripts revised for optimization only are not mandatory when updating this
release, though it would be good to update them when it is convenient.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
Scripts
revised for JE detail table:
SWJEExpRBSP.SQL*
SWJEExpSP.SQL*
SWJESetup.SQL
pgSWJEExpRBSP.SQL*
pgSWJEExpSP.SQL*
pgSWJESetup.SQL
Scripts revised
for optimization only:
ExSwAssemL.SQL
ExSwInvAdjL.SQL
ExSwRecvL.SQL
ExSwTransL.SQL
SWCFExp.SQL
SWJEExpD.SQL
SWJEExpH.SQL
SWJEExpRBD.SQL
SWJEExpRBH.SQL
SWJEExpRBUE.SQL
SWJETagRBSP.SQL*
SWJETagRBUE.SQL
SWJETagSP.SQL*
TagNewExpInvAdj.SQL
TagNewExpRecv.SQL
Release: November 13, 2015
SouthWare Connector 3.0.052
- Revised Cash
Flow connector to include write-offs.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
SWCFExp.SQL
SWJEExpSP.SQL*
pgSWCFExp.SQL*
pgSWJEExpSP.SQL*
Release: November 12, 2015
SouthWare Connector 3.0.051
- Revised
Receivings connector script to include FrontLine Cost Option Receiving Landed that
was added in FrontLine 6.1.081 (01/12/2012) when determining the value of the
Costing Flag to be connected.
Note: For
sites that use the Receiving Landed cost option, this revision will result in
the connection of receivings with a different Costing Flag value, and
subsequently that Unit Cost will be connected as NULL from SouthWare AP to
FrontLine for those receivings. It will not affect the receivings that are
already in the SouthWare Receivings Cost file.
- This
revision applies to SouthWare 14 and 15, and the revised scripts are (scripts
denoted with * need to be updated to the database):
ExSwRecvL.SQL
pgExSwRecvL.SQL*
Release: October 26, 2015
SouthWare Connector 3.0.050
- Fixed: The
Journal Entry Import program called the Cash Flow Import program when no cash
flow records were exported and also when the user was connecting Recurring
Billing journal entries. It no longer does this in these cases.
Note: As a
reminder, when the client has the SouthWare Cash Flow module licensed, but does
not use it, the Bank ID records in SouthWare should be created and the Bank ID
Cross-Reference table entries set up in the FrontLine database. When the client
does not have the SouthWare Cash Flow module licensed at all, SWCFSetup.SQL
should still be executed, but the Bank ID Cross-Reference table entries do not
need to be set up in the FrontLine database, and FLJEIMP_NoCF.OBJ and
DTU_FLJEIMP_NoCF.INI should be used (renamed to standard names on the site,
i.e., remove the _NoCF suffix).
- This
revision applies to SouthWare 14 and 15, and the revised program is:
FLJEIMP.OBJ
Release: September 8, 2015
SouthWare Connector 3.0.049
- Fixed: The
Journal Entry Tagging script filtered out deposit invoices where Total Items = 0.
This was introduced in 3.0.039, in an attempt to filter out vendor invoices.
The script has been revised to include all non-zero invoices as well as zero
non-vendor ones.
- Included the
3.0.047 versions of the Journal Entry Import program and DbTxUtil configuration
file, to be used when a client does not have Cash Flow in SouthWare. The
program and script have the added suffix _NoCF, and will need to be added to
the client's SW and SW programs overlay files with their standard names when
used.
Note: In the
case described above, where the client does not have Cash Flow in SouthWare,
the FrontLine Cash Flow tables should still be created, since the Journal Entry
procedure will still attempt to create a Cash Flow table. However, it will
never be exported when this program and configuration file are used.
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database):
FLJEIMP_NoCF.OBJ
DTU_FLJEIMP_NoCF.INI
SWJETagSP.SQL*
pgSWJETagSP.SQL*
Release: August 27, 2015
SouthWare Connector 3.0.048
- Added Cash
Flow connection to Journal Entry connector stored procedure, as well as Cash
Flow Export script.
- Removed
3.0.016 revisions from SouthWare GL Journal Post program.
- Revised
Journal Entry Import program to call new Cash Flow Import program.
Note: Please
check with Judi about which sites are ready for this Cash Flow connection
release. There is a setup script that creates tables used by the Cash Flow
connection which will need to be manually executed in steps. During this setup,
BankID cross reference records will need to be inserted, based on SouthWare
BankID values.
- Fixed: The
Receivings Cost Entry program did not populate the AP Operator Code or GL Post
Date correctly. The AP Operator Code is now populated by repositioning the
Ormandy startup routine. The GL Post Date is now populated by circumventing the
SouthWare code that required that the Costed With Quantity Flag be something
other that Y, which all FrontLine Receivings record have.
Note: All
sites should get the revision of RSRCCENT, since their Receivings Cost File
records are not currently being populated correctly!
- This
revision applies to SouthWare 14 and 15, and the revised programs and scripts
are (scripts denoted with * need to be updated to the database). Please note
that the SW14a folder is not named SW15, and SW 15a, used only by Savannah, is
no longer being supported as of this revision:
FLCFIMP.OBJ
FLJEIMP.OBJ
GLJNLPST.OBJ
RSRCCENT.OBJ
DTU_FLJEIMP.INI
SWCFExp.FMT
SWCFExp.SQL
SWCFSetup.SQL
SWJEExpSP.SQL*
pgSWCFExp.SQL
pgSWCFExpC.SQL
pgSWCFSetup.SQL
pgSWJEExpSP.SQL*
Release: August 17, 2015
SouthWare Connector 3.0.047
- Revised initial
connector program to restore removal of leading zeroes from List Value StrValue
for GL Account Number.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised program is:
FLINIEXP.OBJ
Release: July 14, 2015
SouthWare Connector 3.0.046
- Revised
Journal Entry connector stored procedure to eliminate cancelled payments.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
SWJEExpSP.SQL*
pgSWJEExpSP.SQL*
Release: July 8, 2015
SouthWare Connector 3.0.045
- Fixed:
Journal Entry connector stored procedure missed AR entry for vendor credit
memos. It now includes AR records with Doc Type = Credit which have a vendor
invoice.
- Revised
PostgreSQL Journal Entry connector stored procedures to accommodate Vendor
Invoicing.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
SWJEExpSP.SQL*
SWJETagSP.SQL*
pgSWJEExpSP.SQL*
pgSWJETagSP.SQL*
Release: June 22, 2015
SouthWare Connector 3.0.044
- Revised
receivings connection export script to reverse the sign on Unit Cost for Return
Authorizations.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised scripts are
(scripts denoted with * need to be updated to the database):
ExSwRecvL.SQL
pgExSwRecvL.SQL*
Release: April 16, 2015
SouthWare Connector 3.0.043
- Revised
receivings connection export script to replace miscellaneous item descriptions
with NOTES.Subject when ITEMS.Desc1 is blank.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised scripts are
(scripts denoted with * need to be updated to the database):
ExSwRecvL.SQL
pgExSwRecvL.SQL*
Release: March 26, 2015
SouthWare Connector 3.0.042
- Revised
invoice, recurring bill, and receivings reconnect procedures and scripts to
allow a minimum of supplied data to untag an invoice, bill, or receiving for
subsequent reconnection. The procedures can be run either from SQL Management
Studio or pgAdmin using the _manual or calling (C) scripts with supplied data
in the scripts, or from the FrontLine Db Console using the following syntax:
For sales
invoices: EXEC InvoiceReconnect 100000001, 1
For recurring
bills: EXEC BillReconnect 80000001
For
receivings: EXEC RecvReconnect 100000001, 1
Note: For
existing systems, the stored procedures will need to be altered using the
revised versions. For new systems, the stored procedures should be created as
part of the setup.
- Revised
SouthWare GL Journal Entry Posting program to filter journal entries with
Transaction Type = G from the custom cashflow summarization.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
GLJNLPST.OBJ
BillReconnect.SQL*
BillReconnect_manual.SQL
InvoiceReconnect.SQL*
InvoiceReconnect_manual.SQL
RecvReconnect.SQL*
RecvReconnect_manual.SQL
pgBillReconnect.SQL*
pgBillReconnectC.SQL
pgInvoiceReconnect.SQL*
pgInvoiceReconnectC.SQL
pgRecvReconnect.SQL*
pgRecvReconnectC.SQL
Release: March 4, 2015
SouthWare Connector 3.0.041
- Revised
receivings connector to accommodate international currency. The connector will
now populate International Currency Code, Rate, and Unit Cost in the Receivings
Cost File in SouthWare.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
FLRECUPD.OBJ
ExSwRecvL.FMT
ExSwRecvL.SQL
pgExSwRecvLC.SQL
pgExSwRecvL.SQL*
Release: March 2, 2015
SouthWare Connector 3.0.040
- Fixed: The
initial connector program connected negative non-serialized On-Hand quantities as
positive quantities. Negative quantities are not allowed in FrontLine, so the
program was attempting to connect in such a way that these quantities would be
nullified. However, a link between two connected details was missing. The
program has been revised to no longer connect these details at all.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised program is:
FLINIEXP.OBJ
Release: January 30, 2015
SouthWare Connector 3.0.039
- Revised
Journal Entry connector stored procedure to accommodate Vendor Invoicing.
- Revised
Periodic Connector program interal progam security.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
FLPEREXP.OBJ
SWJEExpSP.SQL*
SWJETagSP.SQL*
Release: November 25, 2014
SouthWare Connector 3.0.038
- Revised
initial connector program to no longer connect Available detail parents for
Sold serialized units. Instead, the program now adds the Customer Equipment
DtlStatus flag (262144) to the Sold flag for a total value of 262148. This
could precipitate some changes to open and historical order import and item
detail resequencing, though those changes should be toward less complexity.
- This revision
applies to SouthWare 14a, 15, and 15a:
FLINIEXP.OBJ
Release: November 14, 2014
SouthWare Connector 3.0.037
- Fixed: The
revision in 3.0.032 that was to fix truncation of the Vendor default ShipTo
AddressID, inadvertently caused a single SouthWare ShipTo ID to always be
populated in this field. This has been fixed.
- This
revision applies to SouthWare 14a, 15, and 15a:
APVNDMNT.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: October 17, 2014
SouthWare Connector 2.0.104
- This release
replaces 2.0.103, which was determined to be an incomplete solution to the
issues it was attempting to resolve. On-going customer connections, from
SouthWare to FrontLine and from FrontLine to SouthWare, will continue to
connect BillTo and ShipTo addresses, since these addresses and cross-references
are critical to customer record defaults. All programs and scripts that were
revised in 2.0.103 release were reset to 2.0.102 before this release.
- Fixed: The
BillTo and ShipTo address import program failed to write some BillTo
cross-references records, and incorrectly wrote them for BillTo-ShipTo
combination addresses. The program also did not format redirected Bill To
Customer numbers according to the SouthWare Control File setting. These issues
have been corrected.
- Fixed: The
BillTo and ShipTo address export script always inserted a dash for all zip
codes, rather than just doing this for U.S. zip codes that were longer that 5
characters. This has been removed for 5 character U.S. zip codes.
Please note that
Release 2.0.103 has been labeled, "Do Not Use".
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
FLADDIMP.OBJ
ExSwAddr.FMT
ExSwAddr.SQL
pgExSwAddr.SQL*
Release: October 15, 2014
SouthWare Connector 2.0.103 - Do Not Use
- Revised
on-going customer connections from SouthWare to FrontLine and from FrontLine to
SouthWare to no longer connect BillTo and ShipTo addresses.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
DTU_FLCUSEXP.INI
FLADDIMP.OBJ
FLCUSEXP.OBJ
ExSwAddr.SQL
pgExSwAddr.SQL*
Release: October 2 , 2014
SouthWare Connector 3.0.36
- Revised
periodic connection /L (List Values) option to only connect list values for GL
account numbers.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs are:
FLPEREXP.OBJ
Release: September 8, 2014
SouthWare Connector 2.0.102
- Fixed:
Address3 had been omitted from the BillTo/ShipTo address import program in a
previous update. The field was being exported from FrontLine by the address
connection script. This caused the addresses imported into SouthWare to be
incorrectly formatted in the fields after Address2. It is possible that this
may have caused cross-referencing issues as well, since the FrontLine AddressID
was near the end of the record. Address3 has been restored to the program.
- This revision
applies to SouthWare 14a, 15, and 15a, and the revised programs are:
FLADDIMP.OBJ
Release: September 4, 2014
SouthWare Connector 3.0.035
- Fixed: The
3.0.032 journal entry connection revision that was designed to eliminate
duplication of journal entries that resulted when a site had both specific
Department and generic Department (-1) encoded Item Category records set up for
a unique ItemCat-LocationID combination caused accounts to be exported as NULL
when the site had only generic EntityID, AgentCat, and Department encoded
records. The joins to retrieve item categories have been elaborated to
accomodate every possible combination of specific and generic combinations of
these columns.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
SWJEExpRBSP.SQL*
SWJEExpRBUE.SQL
SWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJEExpRBUE.SQL*
pgSWJEExpRBUEC.SQL
pgSWJEExpSP.SQL*
SWJETagRBSP.SQL*
SWJETagRBUE.SQL*
Release: August 21, 2014
SouthWare Connector 3.0.034
- Removed Job
Cost connection and maintenance features from AP programs.
- Removed Job Cost
maintenance features from custom versions of APTRXMNT used to facilitate check
printing requirements at DFW, Digitcom, NAM, REM, and TAC.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs are:
APTRXMNT.OBJ (custom versions found in each customer's SD
SW15\3.0.034 folder)
APTRXPST.OBJ
Release: August 21, 2014
SouthWare Connector 2.0.101
- Removed Job
Cost connection and maintenance features from AP and IS EOD programs. This
excludes versions of these same programs currently being used by ASRI, which
can be found unchanged in their SD SW15\2.0.101 folder.
Note: With the
exception of ASRI, there is no longer a need to set up Extended Data XD158 or
configure it in ImportMate template FLORDHDR RS08. Also there is no need to
configure the Job Cost Control File for the Cost Code.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs are:
APTRXMNT.OBJ
APTRXPST.OBJ
RSBILREG.OBJ
Release: August 7, 2014
SouthWare Connector 3.0.033
- Fixed: The
unearned revenue journal entry connector incorrectly connected credit amounts.
This has been fixed.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised program is:
FLUEIMP.OBJ
Release: August 1, 2014
SouthWare Connector 3.0.032
- Fixed: The
initial connector program populated standalone Available item details
erroneously, rather than using the Serial Tracking Updated Date. This has been
fixed.
- Fixed: The
AP Vendor Maintenance connector truncated the default ShipTo AddressID in the
vendor connection. This has been fixed.
- Fixed: The journal
entry connection scripts created duplicate entries when the client had both
specific department and generic department records set up for a unique
ItemCat-LocationID combination. The joins to item categories have been revised
to accomodate this condition.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs and
scripts are (scripts denoted with * need to be updated to the database):
APVNDMNT.OBJ
FLINIEXP.OBJ
SWJEExpRBSP.SQL*
SWJEExpRBUE.SQL
SWJEExpSP.SQL*
pgSWJEExpRBSP.SQL*
pgSWJEExpRBUE.SQL*
pgSWJEExpRBUEC.SQL
pgSWJEExpSP.SQL*
Release: June 5, 2014
SouthWare Connector 3.0.031
- Revised
initial connector program to restore the connection of the SouthWare Customer
Tax ID in the FrontLine Exempt Code field.
- Revised initial
connector program to connect SouthWare Item Order Code = “Y” as FrontLine Item
Status = Discontinued (256).
- Revised
initial connector program to include all customer notes.
- Removed
3.0.030 revision from AR Open connection program, since it did not work as
desired.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised programs are:
FLAROEXP.OBJ
FLINIEXP.OBJ
Release: May 28, 2014
SouthWare Connector 3.0.030
- Revised AR Open
connection program to change the DocType for invoices with negative amounts and
credit memos with positive amounts. Invoices with negative amounts now become
DocType=3, and credit mememos with positive amounts now become DocType=0.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised program is:
FLAROEXP.OBJ
Release: May 27, 2014
SouthWare Connector 3.0.029
- Revised
script that untags an entire SyncSet to untag additional tables used in journal
entry connection. Removed untagging of tables that are obsolete or no longer
used in the journal entry connection.
- This
revision applies to SouthWare 14a, 15, and 15a, and revised scripts are:
UnTagExp.sql
pgUnTagExp.sql
Release: May 5, 2014
SouthWare Connector 3.0.028
- Revised the
GL Account Maintenance program to format the connected GL account number
display field according to the SouthWare GL Control File defined structure.
- This
revision applies to SouthWare 14a, 15, and 15a, and the revised program is:
GLACTMNT.OBJ
Release: April 18, 2014
SouthWare Connector 3.0.027
- Revised
FLPEREXP periodic connector program to connect vendors with the /V option.
- Revised
inventory adjustment journal entry connection script to use Item Category table
Physical Adjustment Offset account for physical inventory adjustments.
- This
revision applies to SouthWare 14a, 15, and 15a, and revised programs and
scripts are (scripts need to be
updated to the database):
FLPEREXP.OBJ
ExSwInvAdj.SQL
pgExSwInvAdj.SQL
Release: January 29, 2014
SouthWare Connector 3.0.026
- Fixed: The
AP vendor connection did not accommodate Canadian zip codes. It now
accommodates these, as well as US 5-digit and Plus4 zip codes.
- Fixed: The
AP vendor tagging script did not tag the vendor when the vendor record was not
updated, but the corresponding address record was updated. The script now tags
vendors in this case.
- This
revision applies to SouthWare 14a, 15, and 15a, and revised scripts are (scripts need to be updated to the database):
ExSwVend.FMT
ExSwVend.SQL
pgExSwVend.SQL
pgTagNewExpRecv.SQL
TagNewExpRecv.SQL
Release: December 4, 2013
SouthWare Connector 3.0.025
- Fixed: The
journal entry connection for prepayments on partial invoices did not include
On-Account type payments in the payment summarization which it used in the
calculation to determine whether a journal entry should be created. On-Account
type payments are now included in this calculation.
- This
revision applies to SouthWare 14a, 15, and 15a, and revised scripts are (scripts need to be updated to the
database):
SWJEExpSP.SQL
pgSWJEExpSP.SQL
Release: November 25, 2013
SouthWare Connector 3.0.024
- Revised
unearned recurring billing journal entries to connect tax journal entries to debit
Account Receivable account and credit Tax account. Note: This revision assumes one tax account
number per order. If the client needs more tax accounts per order, more
elaboration will be needed.
- Fixed: The
SouthWare GL journal posting program displayed an error message when running in
a company that did not have FrontLine licensed. This was caused by a misplaced
period in the code.
- This
revision applies to SouthWare 14a, 15, and 15a, and revised programs and
scripts are (scripts need to be
updated to the database):
FLUEIMP.OBJ
GLJNLPST.OBJ
SWJEExpRBUE.FMT
SWJEExpRBUE.SQL
pgSWJEExpRBUE.SQL
pgSWJEExpRBUEC.SQL
Release: November 11, 2013
SouthWare Connector 3.0.023
- Revised the
initial connector program to format the GL account number display according to
the SouthWare GL Control File defined structure.
- Revised
unearned recurring billing journal entries to connect payment journal entries
to credit Account Receivable account and debit Cash or Credit Card account.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (scripts need to be updated to the
database):
FLINIEXP.OBJ
FLUEIMP.OBJ
SWJEExpRBUE.FMT
SWJEExpRBUE.SQL
pgSWJEExpRBUE.SQL
pgSWJEExpRBUEC.SQL
Release: October 21, 2013
SouthWare Connector 3.0.022
- Revised
unearned recurring billing journal entries to populate RefDesc1 with customer
name, and RefDesc2 with customer number and order number (same as previous
RefDesc1).
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (scripts need to be updated to the
database):
FLUEIMP.OBJ
SWJEExpRBUE.FMT
SWJEExpRBUE.SQL
pgSWJEExpRBUE.SQL
pgSWJEExpRBUEC.SQL
Release: October 17, 2013
SouthWare Connector 3.0.021
- Fixed: Revision
3.0.017 for order prepayments produced incorrect credit entries due to the
summarized payment amount not summarizing as intended. The journal entry export
script has been revised to summarize in a different manner. The script produces
these entries when the sum of the payments for the OrderID, InvSeq, and SyncSet
is greater than the sum of the invoice total items plus total taxes for the
same OrderID, InvSeq, and SyncSet. The amount exported for each payment is the
payment amount * -1.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (scripts need to be updated to the
database):
SWJEExpSP.SQL
pgSWJEExpSP.SQL
Release: September 23, 2013
SouthWare Connector 3.0.020
- Revised journal entry export scripts to summarize by
DocDate, DocID, InvSeq, Account, and PType to facilitate summarizing to
separate records, based on payment type, in SouthWare cashflow.
NOTE: Tables
SWJE, SWJELMAP, and SWJERB, and stored procedures SWJEExp and SWJEExpRB will
need to be dropped and recreated.
This revision
applies to SouthWare 14a, 15, and 15a, and revised scripts are:
SWJEExpSP.SQL
SWJEExpRBSP.SQL
SWJESetup.SQL
Release: September 16, 2013
SouthWare Connector 3.0.019
- Fixed: The recurring billing unearned revenue update
program did not accommodate returns of recurring billing unearned revenue. The
program now creates reversing journal entries for all the entries that were
created from the recurring billing.
This revision applies
to SouthWare 14a, 15, and 15a, and revised programs are:
FLUEIMP.OBJ
Release: September 9, 2013
SouthWare Connector 2.0.099
- Fixed: The recurring billing line export scripts limited
the Unit Price to numeric(8,3). It has now been expanded to numeric(9,3).
- Fixed: RCV’s custom recurring billing line export script
did not incude the PayTo AddressID. This field has now been included.
This revision
applies to SouthWare 14a, 15, and 15a, and revised scripts are:
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLRBC.SQL
Release: August 30, 2013
SouthWare Connector 3.0.018
- Fixed: Miscellaneous item details were being connected with
a blank date. This date should now be populated with the current date when
missing.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: August 9, 2013
SouthWare Connector 3.0.017
- Revised
journal entry connection export scripts to connect a credit entry to the deposit
account for order prepayments, for the amount that the customer pays over the
amount of an invoice, and the related order is left partially invoiced. The
script was also revised to connect a debit entry to the deposit account, for
this amount, when the subsequent invoice is connected.
- Revised
journal entry connection export scripts to accommodate additional key columns
that were added to the FrontLine ITEMCATS table (a few more instances were
found where these columns needed to added).
- Fixed: The
revision to accommodate multiple invoicings of the same order in the same day
was not fully implemented. Additional columns were added to some join
statements where appropriate.
- Also this
revision includes revised order import scripts segregated by both type of order
(Regular Sales (R), Service (S), Purchase (P)) and type of import (Open (O),
History (H)). These are for MS-SQL only.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (PG scripts and some MS scripts need to be
updated to the database):
OrderImportCreateTables.SQL
OrderImportPO.SQL
OrderImportRestart.SQL
OrderImportRH.SQL
OrderImportRO.SQL
OrderImportSH.SQL
OrderImportSO.SQL
OrderInsertRHEvents.SQL
OrderInsertSHEvents.SQL
SWJETagRBSP.SQL
SWJEExpSP.SQL
pgSWJEExpRBSP.SQL
pgSWJEExpSP.SQL
Release: July 22, 2013
SouthWare Connector 3.0.016
- Revised
journal entry payment connection export scripts to connect FrontLine PType as
textual code in first three characters of RefDesc2.
- Revised SouthWare
program GLJNLPST to summarize the back office posting to Cashflow by DocDate,
Transaction Number, Account, and PType in textual code format.
- Revised
journal entry connection export scripts to accommodate additional key columns
that were added to the FrontLine ITEMCATS table.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (PG scripts and some MS scripts need to be
updated to the database):
GLJNLPST.OBJ
ExSwAssemL.SQL
ExSwInvAdjL.SQL
ExSwRecvL.SQL
ExSwTransL.SQL
SWJEExpRBSP.SQL
SWJEExpRBUE.SQL
SWJEExpSP.SQL
SWJETagRBSP.SQL
SWJETagRBUE.SQL
pgExSwAssemL.SQL
pgExSwInvAdjL.SQL
pgExSwRecvL.SQL
pgExSwTransL.SQL
pgSWJEExpRBSP.SQL
pgSWJEExpRBUE.SQL
pgSWJEExpRBUEC.SQL
pgSWJEExpSP.SQL
pgSWJETagRBSP.SQL
pgSWJETagRBUE.SQL
Release: July 18, 2013
SouthWare Connector 3.0.015
- Revised
journal entry connection export script to connect credit entry for deposit
payments based on presence of payment and zero invoice amount.
This revision
applies to SouthWare 14a, 15, and 15a, and revised scripts are (scripts are for stored procedures and need
to be updated to the database):
SWJEExpSP.SQL
pgSWJEExpSP.SQL
Release: July 15, 2013
SouthWare Connector 3.0.014
- Revised initial
connector when connecting parts to populate vendor part number with related
stock number when vendor part number is blank.
This revision
applies to SouthWare 14a, 15, and 15a, and revised program is:
FLINIPEXP.OBJ
Release: July 11, 2013
SouthWare Connector 3.0.013
- Revised
journal entry payment connection export scripts to connect FrontLine PType in
first portion of RefDesc2.
- Revised
SouthWare program GLJNLPST to summarize the back office posting to Cashflow by
DocDate, Transaction Number, Account, and PType.
This revision
applies to SouthWare 14a, 15, and 15a, and revised programs and scripts are (PG scripts and some MS scripts need to be
updated to the database):
GLJNLPST.OBJ
SWJEExpSP.SQL
SWJEExpRBSP.SQL
pgSWJEExpSP.SQL
pgSWJEExpRBSP.SQL
Release: July 2, 2013
SouthWare Connector 2.0.098
- Revised
SouthWare program RSBILREG to cycle through up to 20 tax codes, rather than 9,
when processing taxes.
This revision applies
to SouthWare 14a, 15, and 15a, and revised program is:
RSBILREG.OBJ
Release: July 1, 2013
SouthWare Connector 3.0.012
- Fixed: The
assembly work order export script exported duplicate lines when exporting
multiple check outs for the same order. Revised to qualify the assembled item
cost joins using invoice sequence.
This revision
applies to SouthWare 14a, 15, and 15a, and revised scripts are (PG scripts need to be updated to the
database):
ExSwAssemL.SQL
pgExSwAssemL.SQL
Release: June 26, 2013
SouthWare Connector 3.0.011
- Revision
primarily to summarize journal entry connection by DocDate, DocID, InvSeq, and
Account, and to summarize the back office posting to Cashflow by DocDate,
Transaction Number, and Account.
- Revised AR
Open initial connection to populate GL Account Number on all records, rather
than just on payments.
- Fixed:
Return of a payment produced a journal entry with an incorrect sign. Write-off
of a credit memo or a payment produced a journal entry with an incorrect sign.
- FLJEIMP.OBJ
and FLUEIMP.OBJ replace FLARDIST.OBJ and FLARDISR.OBJ respectively.
-
DTU_FLJEIMP.INI, DTU_FLJEIMPRB.INI, and DTU_FLUEIMP replace DTU_FLARDIST.INI,
DTU_FLARDISTRB.INI, and DTU_FLARDISR.INI respectively.
- SWJE*.SQL scripts
replace ExSWARDist*.SQL scripts.
- These is a
new ImportMate template named FLJEIMP, that is just like FLARDIST, except that
GL06 Line Number (Field 2) is imported from import detail file field 2 rather
than assigned from it, and the import file names are now SW_JEH.TXT and
SW_JED.TXT. Recurring billing import file names are SW_RB_JEH.TXT and
SW_RB_JED.TXT. Unearned revenue import file name is SW_RB_JEUE.TXT.
-
SWJESetup.SQL should be executed before beginning.
-
SWJETagSP.SQL, SWJETagRBSP.SQL, SWJEExpSP.SQL, and SWJEExpRBSP.SQL should be
executed to place stored procedures in the database.
Note: The
portions of this version that are for connection of journal entries from
customer orders are live at Comm Group Red Deer and Ormandy Live, however portions
for recurring billing and unearned revenue have not yet been tested.
There is a
script, ApplyARCredits.SQL, that can be used with manual intervention after the
initial connection to find unapplied credits and attempt to apply them.
This revision
applies to SouthWare 14a, 15, and 15a, and new and revised programs and scripts
are (PG scripts and some
MS scripts need to be updated to the database):
FLAROEXP.OBJ
GLJNPST.OBJ
DTU_FLJEIMP.INI
DTU_FLJEIMPRB.INI
DTU_FLUEIMP.INI
FLJEIMP.OBJ
FLUEIMP.OBJ
ApplyARCredits.SQL
SWJEExpD.FMT
SWJEExpD.SQL
SWJEExpEX.SQL
SWJEExpH.SQL
SWJEExpRBD.SQL
SWJEExpRBEX.SQL
SWJEExpRBH.SQL
SWJEExpRBSP.SQL
SWJEExpRBUE.FMT
SWJEExpRBUE.SQL
SWJEExpSP.SQL
SWJESetup.SQL
SWJETagEX.SQL
SWJETagRBEX.SQL
SWJETagRBSP.SQL
SWJETagRBUE.SQL
SWJETagSP.SQL
pgSWJEExpC.SQL
pgSWJEExpD.SQL
pgSWJEExpDC.SQL
pgSWJEExpH.SQL
pgSWJEExpHC.SQL
pgSWJEExpRBC.SQL
pgSWJEExpRBD.SQL
pgSWJEExpRBDC.SQL
pgSWJEExpRBH.SQL
pgSWJEExpRBHC.SQL
pgSWJEExpRBSP.SQL
pgSWJETagRBUE.SQL
pgSWJETagRBUEC.SQL
pgSWJETagRBUESub.SQL
pgSWJETagRBUESubC.SQL
pgSWJESetup.SQL
pgSWJEExpSP.SQL
pgSWJETagC.SQL
pgSWJETagRBC.SQL
pgSWJETagRBSP.SQL
pgSWJETagRBUE.SQL
pgSWJETagRBUEC.SQL
pgSWJETagSP.SQL
- The following
Ormandy programs and scripts are no longer active connector programs and
scripts for this revision:
DTU_FLARDISR.INI
DTU_FLARDIST.INI
DTU_FLARDISTRB.INI
FLARDISR.OBJ
FLARDIST.OBJ
ExSwARDistD.FMT
ExSwARDistDAR.SQL
ExSwARDistDARWO.SQL
ExSwARDistDCOS.SQL
ExSwARDistDINC.SQL
ExSwARDistDINCRB.SQL
ExSwARDistDINV.SQL
ExSwARDistDP.SQL
ExSwARDistDPRB.SQL
ExSwARDistDRBUE.FMT
ExSwARDistDRBUE.SQL
ExSwARDistDT.SQL
ExSwARDistDTRB.SQL
ExSwARDistDWO.SQL
ExSwARDistH.SQL
ExSwARDistHRB.SQL
TagNewExpbyLoc.SQL
TagNewExpRBbyCat.SQL
TagNewExpRBbyCatUE.SQL
pgExSwARDistDAR.SQL
pgExSwARDistDARC.SQL
pgExSwARDistDARWO.SQL
pgExSwARDistDARWOC.SQL
pgExSwARDistDCOS.SQL
pgExSwARDistDCOSC.SQL
pgExSwARDistDINC.SQL
pgExSwARDistDINCC.SQL
pgExSwARDistDINCRB.SQL
pgExSwARDistDINCRBC.SQL
pgExSwARDistDINV.SQL
pgExSwARDistDINVC.SQL
pgExSwARDistDP.SQL
pgExSwARDistDPC.SQL
pgExSwARDistDPRB.SQL
pgExSwARDistDPRBC.SQL
pgExSwARDistDRBUE.SQL
pgExSwARDistDRBUEC.SQL
pgExSwARDistDRBUESub.SQL
pgExSwARDistDRBUESubC.SQL
pgExSwARDistDT.SQL
pgExSwARDistDTC.SQL
pgExSwARDistDTRB.SQL
pgExSwARDistDTRBC.SQL
pgExSwARDistDWO.SQL
pgExSwARDistDWOC.SQL
pgExSwARDistH.SQL
pgExSwARDistHC.SQL
pgExSwARDistHRB.SQL
pgExSwARDistHRBC.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpbyLocC.SQL
pgTagNewExpRBbyCat.SQL
pgTagNewExpRBbyCatC.SQL
pgTagNewExpRBbyCatUE.SQL
pgTagNewExpRBbyCatUEC.SQL
Release: May 17, 2013
SouthWare Connector 3.0.010
- Fixed: A
previous revision had caused Price Levels Price Percent to be connected as NULL
in the initial connector. This has been restored.
- Fixed: The
AR distribution connector programs did not delete their log and error files
after updating. This has been corrected.
- Revised
existing scripts and created separate scripts for connection of non Unearned
Revenue recurring billing, and revised existing recurring billing connection
scripts to connect only Unearned Revenue recurring billing.
- Revised the
standard sales and service AR distribution connector to include a recurring
billing mode with the /R option. Revised the same program to call the inventory
adjustment GL journal entry connection program only when the program is running
in the standard mode.
- Revised the
import file name in the Unearned
This revision
applies to SouthWare Rev 14a, 15, and 15a, and new and revised programs and
scripts are (PG scripts need to be
updated to the database):
DTU_FLARDISR.INI
DTU_FLARDIST.INI
DTU_FLARDISTRB.INI
FLARDISR.OBJ
FLARDIST.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
ExSwARDistDINCRB.SQL
ExSwARDistDPRB.SQL
ExSwARDistDRBUE.SQL
ExSwARDistDTRB.SQL
ExSwARDistHRB.SQL
TagNewExpRBbyCat.SQL
TagNewExpRBbyCatUE.SQL
pgExSwARDistDINCRB.SQL
pgExSwARDistDINCRBC.SQL
pgExSwARDistDPRB.SQL
pgExSwARDistDPRBC.SQL
pgExSwARDistDRBUE.SQL
pgExSwARDistDRBUEC.SQL
pgExSwARDistDRBUESub.SQL
pgExSwARDistDRBUESubC.SQL
pgExSwARDistDTRB.SQL
pgExSwARDistDTRBC.SQL
pgExSwARDistHRB.SQL
pgExSwARDistHRBC.SQL
pgTagNewExpRBbyCat.SQL
pgTagNewExpRBbyCatUE.SQL
pgTagNewExpRBbyCatUEC.SQL
Release: May 10, 2013
SouthWare Connector 3.0.009
- Revised initial
and periodic connector programs to connect SouthWare Inventory Item File Order
Code Flag as FrontLine ITEMS.ItemStatus = Special Order (32).
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: April 22, 2013
SouthWare Connector 3.0.008
- Fixed: The
AR side of write-off journal entries sometimes did not have an AR account
number. Refined AR write-off export script to include four options for
population of this field. Also revised SouthWare to FrontLine connection of AR
Open File to include the AR Account Number on receivable records.
Note: For
sites where the FrontLine AR table cannot be replaced from the SouthWare AR
Open File, a script will need to be used to populate AR.Account.
- Fixed:
Write-off export scripts did not include AR DocType 6. It is not included.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be
updated to the database):
FLAROEXP.OBJ
ExSwARDistDARWO.SQL
ExSwARDistDWO.SQL
TagNewExpbyLoc.SQL
pgExSwARDistDARWO.SQL
pgExSwARDistDWO.SQL
pgTagNewExpbyLoc.SQL
Release: April 18, 2013
SouthWare Connector 3.0.007
- Revised
journal entry export scripts to eliminate zero amount lines and to include
order line GL account number overrides.
- Revised
journal entry tagging and export scripts and created new export scripts to
accommodate write-offs.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised and new scripts are (PG scripts need to be updated to the
database):
ExSwARDistDARWO.SQL
ExSwARDistDCOS.SQL
ExSwARDistDINC.SQL
ExSwARDistDINV.SQL
ExSwARDistDT.SQL
ExSwARDistDWO.SQL
ExSwARDistH.SQL
TagNewExpbyLoc.SQL
pgExSwARDistDARWO.SQL
pgExSwARDistDARWOC.SQL
pgExSwARDistDCOS.SQL
pgExSwARDistDINC.SQL
pgExSwARDistDINV.SQL
pgExSwARDistDT.SQL
pgExSwARDistDWO.SQL
pgExSwARDistDWOC.SQL
pgExSwARDistH.SQL
pgTagNewExpbyLoc.SQL
DTU_FLARDIST.INI
Release: April 2, 2013
SouthWare Connector 2.0.097 and 3.0.006
- Bug fix for
programs revised in 2.0.096 and 3.0.006. Setup File parameter retrieval routine
failed to open Setup File.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
APTRXMNT.OBJ
APTRXPST.OBJ
FLSUMNT.OBJ
RSBILREG.OBJ
(2.0.097 only)
Note: Some of
the revised programs can be found in the folder labeled Job Cost Overlay. These
are noted below.
Revised Job
Cost Overlay programs are:
GLJNLMNT.OBJ
GLJNLPST.OBJ
SWGLIFLS.OBJ
Release: March 27, 2013
SouthWare Connector 3.0.005
- Revised internal
SouthWare security program (module) numbers in programs.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLARDISR.OBJ
FLARDIST.OBJ
FLCOSEXP.OBJ
FLCTLMNT.OBJ
FLRECUPD.OBJ
FLSUMNT.OBJ
FLXRFEXP.OBJ
ORLICMNT.OBJ
ORSUMNT.OBJ
Release: March 26, 2013
SouthWare Connector 2.0.096 and 3.0.004
- Revised
connector setup program to include a setting for Ormandy Job Cost. When set to
Y, Ormandy Job Cost features are enabled.
- Revised programs
containing 2.0.043 Ormandy Job Cost features. These features are now only
enabled when the connector setup file setting for these features is set to Y.
Note: The AP
programs and setup program have been revised since 2.0.043. If updating them on
a system using the connector prior to 2.0.089, please see the list of other
related programs and scripts needed.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
APTRXMNT.OBJ
APTRXPST.OBJ
FLSUMNT.OBJ
RSBILREG.OBJ
(2.0.096 only)
Note: Some of
the revised programs can be found in the folder labeled Job Cost Overlay. These
are noted below.
Revised Job
Cost Overlay programs are:
GLJNLMNT.OBJ
GLJNLPST.OBJ
SWGLIFLS.OBJ
Other related
programs and scripts that are needed on systems older than 2.0.089:
FLCOSEXP.OBJ
RSRCCENT.OBJ
ExSwRecvL.SQL
pgSwRecvL.SQL
Release: March 22, 2013
SouthWare Connector 3.0.003
- Fixed: The AR
distribution export script for payments considered Pay Type 2 to be Check, when
it should have been Pay Type 1. Also NULL values in Check Number or Account
Number could have caused blank reference descriptions to be exported. These are
not coalesced to appropriate defaults.
- Fixed: The tagging
script for inventory adjustments, transfers, and assembly work orders didn’t
accumulate the count of records tagged correctly.
- Revised tagging
script for invoices to remove requirement of only one invoice per day being
tagged. Now all invoices for a given invoice in a given day are tagged.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised scripts are (PG
scripts need to be updated to the database):
ExSwARDistDP.SQL
TagNewExpbyLoc.SQL
TagNewExpInvAdj.SQL
pgExSwARDistDP.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpInvAdj.SQL
Release: March 4, 2013
SouthWare Connector 3.0.002
- Revised standard AR
Distribution update program to call GL transaction update for stock transfers,
assemblies, and inventory transactions. The transactions will be updated at the
end of the AR distribution update.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised program is:
FLARDIST.OBJ
Release: January 31, 2013
SouthWare Connector 2.0.095
- Revised Order Update
program to accommodate FrontLine operations where a partially invoiced order is
invoiced again with a different Customer Number. The program will now update
the pre-existing back office Order Header with the new Customer Number. It will
do this from a new XD156 Field 14 (Field Desc=Customer Number, Slot#=9,
Type=ALPH, Size=10). After adding the field, also add a mapping for it in
ImportMate template FLORDHDR RS07 from Order Header import file field 7.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised program is:
FLORDUPD.OBJ
Release: January 17, 2013
SouthWare Connector 3.0.001
- First release of an
update for compatibility with FrontLine 6.4.x with Accounts Receivable.
- Sales orders and
recurring billing are no longer connected to SouthWare, and are now replaced by
AR distributions.
- Revised the Product Category Maintenance to include a
Connect To FL flag.
- Revised the initial connector program to include filtering
of product categories and items based on the Product Category File Connect To
FL flag.
Note: There is a new
SouthWare ImportMate template, FLARDIST, to import AR distributions into GL05
and GL06.
Note: Programs
FLARDIST (standard distributions) and FLARDISR (recurring billing
distributions) will need to be set up on a SW menu button, and executed when
desired.
Note: This release is
NOT for use with ASRI unless all the functionality now in the custom ASRI
connector for periodic invoicing are now in FrontLine!
- The following Ormandy
programs and scripts are no longer active connector programs and scripts for
this revision:
DTU_ARSMADEL.INI
DTU_ARSMANMN.INI
DTU_ARCODE.INI
DTU_FLLOCUPD.INI
DTU_FLORDEXP.INI
DTU_FLORDEXL_ASRI.INI
DTU_FLORDEXLPV.INI
DTU_FLORDUPD.INI
DTU_FLRBEXP.INI
DTU_FLRBLEXP.INI
DTU_FLRECBIL.INI
DTU_FLTXCEXP.INI
FLADDIMP.OBJ
FLCUSEXP.OBJ
FLCUSXRF.OBJ
FLLINUPD.OBJ
FLNOTIMP.OBJ
FLORDEXP.OBJ
FLORDUPD.OBJ
FLRBEXP.OBJ
FLRECBIL.OBJ
FLSQLIMP.OBJ
FLTAXIMP.OBJ
FLTXCIMP.OBJ
REPRINT2.OBJ
cnDeleteAgent.def
DeleteAgent.SQL
ExSwAddr.FMT
ExSwAddr.SQL
ExSwAddrPV.SQL
ExSwCust.FMT
ExSwCust.SQL
ExSwCust_CN.SQL
ExSwCustPV.SQL
ExSwNote.FMT
ExSwOrdH.SQL
ExSwOrdHPV.SQL
ExSwOrdHRB.SQL
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
ExSwOrdLXRPV.SQL
ExSwOrdNH.SQL
ExSwOrdNHPV.SQL
ExSwOrdNL.SQL
ExSwOrdP.SQL
ExSwOrdPPV.SQL
ExSwOrdPRB.SQL
ExSwOrdT.FMT
ExSwOrdT.SQL
ExSwOrdTE.SQL
ExSwOrdTERB.SQL
ExSwOrdTPV.SQL
ExSwOrdTRB.SQL
ExSwOrdTRBPV.SQL
ExSwTaxC.FMT
ExSwTaxC.SQL
TagNewExportTC.SQL
pgDeleteAgent.SQL
pgDeleteAgentC.SQL
pgExSwAddr.SQL
pgExSwAddrC.SQL
pgExSwAddrPV.SQL
pgExSwAddrPVC.SQL
pgExSwCust.SQL
pgExSwCust_CN.SQL
pgExSwCust_CNC.SQL
pgExSwCustC.SQL
pgExSwCustPV.SQL
pgExSwCustPVC.SQL
pgExSwOrdH.SQL
pgExSwOrdHC.SQL
pgExSwOrdHPV.SQL
pgExSwOrdHPVC.SQL
pgExSwOrdHRB.SQL
pgExSwOrdHRB_RCV.SQL
pgExSwOrdHRBC.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLPVC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLRBPVC.SQL
pgExSwOrdLXRPV.SQL
pgExSwOrdLXRPVC.SQL
pgExSwOrdNH.SQL
pgExSwOrdNHC.SQL
pgExSwOrdNHPV.SQL
pgExSwOrdNHPVC.SQL
pgExSwOrdNL.SQL
pgExSwOrdNLC.SQL
pgExSwOrdP.SQL
pgExSwOrdPC.SQL
pgExSwOrdPPV.SQL
pgExSwOrdPPVC.SQL
pgExSwOrdPRB.SQL
pgExSwOrdPRBC.SQL
pgExSwOrdT.SQL
pgExSwOrdTC.SQL
pgExSwOrdTE.SQL
pgExSwOrdTEC.SQL
pgExSwOrdTERB.SQL
pgExSwOrdTERBC.SQL
pgExSwOrdTPV.SQL
pgExSwOrdTPVC.SQL
pgExSwOrdTRB.SQL
pgExSwOrdTRBC.SQL
pgExSwOrdTRBPV.SQL
pgExSwOrdTRBPVC.SQL
pgExSwTaxC.SQL
pgExSwTaxCC.SQL
pgTagNewExportTC.SQL
pgTagNewExportTCC.SQL
- The following SouthWare
programs are no longer active connector programs for this revision:
ARCUSTMN.OBJ
ARSHDRMN.OBJ
ARSHIPVM.OBJ
ARSMANMN.OBJ
ARTAXCDM.OBJ
ARTERMSM.OBJ
R1BILPRT.OBJ
RSBILCST.OBJ
RSBILENT.OBJ
RSBILPRT.OBJ
RSBILREG.OBJ
RSBILUP1.OBJ
RSBILUP2.OBJ
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the new and revised scripts and
programs are:
DTU_ARDISR.INI
DTU_ARDIST.INI
FLARDISR.OBJ
FLARDIST.OBJ
FLINIEXP.OBJ
RSCATMNT.OBJ
ExSwARDistD.FMT
ExSwARDistDAR.SQL
ExSwARDistDCOS.SQL
ExSwARDistDINC.SQL
ExSwARDistDINV.SQL
ExSwARDistDP.SQL
ExSwARDistDRB.SQL
ExSwARDistDT.SQL
ExSwARDistH.SQL
TagNewExpbyLoc.SQL
TagNewExpRBbyCat.SQL
pgExSwARDistDAR.SQL
pgExSwARDistDARC.SQL
pgExSwARDistDCOS.SQL
pgExSwARDistDCOSC.SQL
pgExSwARDistDINC.SQL
pgExSwARDistDINCC.SQL
pgExSwARDistDINV.SQL
pgExSwARDistDINVC.SQL
pgExSwARDistDP.SQL
pgExSwARDistDPC.SQL
pgExSwARDistDRB.SQL
pgExSwARDistDRBC.SQL
pgExSwARDistDRBSub.SQL
pgExSwARDistDT.SQL
pgExSwARDistDTC.SQL
pgExSwARDistH.SQL
pgExSwARDistHC.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpRBbyCat.SQL
Release: December 18, 2012
SouthWare Connector 2.0.094
- Fixed: Revision that
was made to the Order Line Export script for agent connection was left out of
the Recurring Billing version of this script. It has not been added to that
script.
- Added new program
for updating the back office FrontLine Cross-Reference File (FLXREF) SouthWare
Key from a comma-delimited file using a supplied FrontLine Key.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised scripts and programs
are:
FLXRFUPS.OBJ
ExSwOrdLRB.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
Release: December 10, 2012
SouthWare Connector 2.0.093
- Revised inventory
transfer script for Tri-Co, to use ITEMCATS Allow Damage account for both the
From and To account numbers. Revision is trigger by the string value of ‘Tri-Co
Comm’ in company setting LValue=900.
- This revision
applies to SouthWare Rev 15, and the revised script is:
ExSwTransL.SQL
Release: November 29, 2012
SouthWare Connector 2.0.092
- Revised AWC custom
customer connector export program to no longer connect customer 65540 as
Express Repairs order status.
- This revision
applies to SouthWare 15 and the revised program is:
FLCUSAWC.OBJ (renamed
as FLCUSEXP.OBJ on AWC system)
Release: November 26, 2012
SouthWare Connector 2.0.091
- Fixed: The Address
Import program always right-justified customer and BillTo customer numbers when
updating back office AddressID cross-references and address records. It now
uses the AR Control File setting to determine whether the customer number
should be right or left justified.
NOTE: There have not
been any reported issues from this bug, though there is the possibility that
some AddressID cross-references could be corrupted at sites where customer numbers
are left-justified. At those sites, we should first check for right-justified
AddressID cross-references, and correct them, before upgrading the program.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised program is:
FLADDIMP.OBJ
Release: November 1, 2012
SouthWare Connector 2.0.090
- Revised Address
Import program to update AddressID cross-reference if it already exists in back
office cross-reference file. This is to facilitate FrontLine replacement AddressIDs
that replace existing cross-references in back office.
- Revised Export
Tagging scripts to tag FrontLine addresses, contacts, and address related
records that have been changed or added and have a NULL
ENTITYADDRESSES.ReplaceBy field, regardless of whether their related customer
record has been changed. Also revised these scripts to update ExtRefs in any
replacement addresses, in order to bring original ExtRefs forward to their
respective replacement addresses. Subsequent connections to back office will
update the correct cross-reference record. Also revised to update ExtRef in any
other FrontLine created addresses that have a related BillTo or ShipTo flag,
and do not exist as a CUSTOMERS.SoldTo or ENTITYADDRESSES.ReplaceBy, and have
not yet had an ExtRef assigned.
- Revised Address
Export script to filter out any addresses that have been replaced.
- Revised MS-SQL
Customer Export scripts to truncate ExemptCode to 15 characters in connection
from FrontLine to SouthWare.
- Revised Customer
Export program to no longer connect TaxID, OfficialID, and ExemptCode from
SouthWare to FrontLine.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts
are (PG scripts need to be updated to the database):
FLADDIMP.OBJ
FLCUSEXP.OBJ
ExSwAddr.SQL
ExSwCust.SQL
ExSwCust_CN.SQL
ExSwCustPV.SQL
TagNewExpbyLoc.SQL
TagNewExpbyLocASRI.SQL
TagNewExpbyLocPV.SQL
pgExSwAddr.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpbyLocPV.SQL
Release: October 19, 2012
SouthWare Connector 2.0.089
- Revised the MS-SQL
order export scripts to export the Agent Initials when Agents ExtRef is blank.
This condition was found to occur for agents that are now being added in
FrontLine.
- Revised the Order
Line Update program to create FrontLine cross-reference records for agents that
are not found in the SouthWare Salesman File. This will facilitate them having
the correct FrontLine cross-reference ID when reconnected from SouthWare to
FrontLine.
Note: This required adding Agent PayTo
AddressID to all order line export scripts, which will in turn require that
ImportMate template FLORDHDR RS08, that uses Field 49 (Line Number, XR Line
Number), be updated to Field 50.
- Fixed: Vendor
cross-reference records for vendors connecting from FrontLine were created with
incorrect justification of the Vendor Number due to the incorrect control file
being referenced. These incorrect cross-reference numbers were removed at
customer sites, and the Vendor Update program revised to use the correct
control file.
- Fixed: The AP
Costing Update program did not always connect AP Costing information back to
FrontLine. It was determined that this was because the Operator codes being
used for selection did not always match. Modified the Receivings Cost record to
include an AP Operator Code field. Modified the AP Transaction Maintenance
program to pass the AP Operator Code to the Receivings Cost Entry program.
Modified the Receivings Cost Entry program to update the passed operator code
to the new AP Operator Code in the Receivings Cost record. Modified the AP
Costing Update program selection criteria to use the new AP Operator Code in
comparison for operator specific export and added ability to update all
invoiced records when selected by the user.
- Fixed: When a
FrontLine user overrode the Inventory Account Number on a
- Added two new
utility programs to export and update the FrontLine Cross-Reference File
(FLXREF) for reconciliation purposes.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts
are (PG scripts need to be updated to the database):
APTRXMNT.OBJ
FLCOSEXP.OBJ
FLFIXXR4.OBJ
FLLINUPD.OBJ
FLVNDUPD.OBJ
FLXRFEXP.OBJ
RSRCCENT.OBJ
ExSwOrdH.SQL
ExSwOrdHPV.SQL
ExSwOrdHRB.SQL
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
ExSwRecvL.SQL
pgSwRecvL.SQL
Release: October 5, 2012
SouthWare Connector 2.0.088
- Fixed: The Order
Update program applied a deposit whenever the order deposit balance field was
greater than zero. It now only does this when the field is greater than zero
and the order is not designated as partially invoiced.
- Fixed: Special
program MOFIRCOM sometimes incorrectly formatted the Sell Price field and wiped
out the Reseller Price field on some items with negative reseller prices. This
issue has been found and corrected.
- Revised the MOL
import scripts to accommodate labeling of package member groups. This revision
requires FrontLine 6.3.020 or greater, and setup of the appropriate package
member groups in List Values. A utility script is provided to populate an
initial list. Also refined temp table existence testing and the package update
section in the PG version of the MOL and Vertex import scripts.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts
are (PG scripts need to be updated to the database):
FLORDUPD.OBJ
MOFIRCOM.OBJ
MOL_PopulatePkgGrps.sql
MOL_Update.SQL
pgMOLUpdate.SQL
pgVERUpdate.SQL
Release: September 17, 2012
SouthWare Connector 2.0.087
- Replaced programs
that were revised in Revision 2.0.084 back to their 2.0.083 state. The line based
Intercompany Location identifier implementation was determined not be the
desired FrontLine solution at Tri-Co.
- Reinstated Revision
2.0.085 to Recurring Billing Order Line script after replacing this script to
its 2.0.083 state.
- This revision applies
to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts are (PG
scripts need to be updated to the database):
FLLINUPD.OBJ
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.FMT
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLPVC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLRBC.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLRBPVC.SQL
Release: September 12, 2012
SouthWare Connector 2.0.086
- Revised MOL Update script
for compatibility with FrontLine 6.3.020. The script now matches the MOL Model
Option File Option Class field to the FrontLine PkgGrp List StrValue to assign
Package Group ID.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised script is:
MOL_Update.SQL
Release: September 5, 2012
SouthWare Connector 2.0.085
- Revised Recurring
Billing Update program and Line Export script to accommodate Bi-Annually
Billing Frequency for Unearned Revenue.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts
are:
FLRECBIL.OBJ
ExSwOrdLRB.SQL
Release: August 28, 2012
SouthWare Connector 2.0.084
- Revised Order Line
Export scripts to accommodate Intercompany Location identifier (11000) for Tri-Co.
All line scripts were revised to accommodate this field, since all use the same
record format. Only ExSwOrdL.FMT, ExSwOrdL.SQL, and ExSwOrdLRB.SQL are relevant
to Tri-Co.
Note: This required adding an identifier field
to all order line export scripts, which should be imported from field 48 into
an Extended Data field on an Extended Date record that is related to the order
line item record. This will in turn require that ImportMate template FLORDHDR
RS08, that uses Field 49 (Line Number, XR Line Number), be updated to Field 50.
If any other templates are using Field 48 (Item Number), it should be updated
to Field 49 (I could not find it being used in FLORDHDR).
- Revised
documentation in program FLLINUPD to show the addition of this identifier
field, though it was not necessary to handle it specifically in the program.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs and scripts
are (PG scripts need to be updated to the database):
FLLINUPD.OBJ
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.FMT
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLPVC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLRBC.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLRBPVC.SQL
Release: August 23, 2012
SouthWare Connector 2.0.083
- Fixed: Customer,
vendor, and related address records could be truncated when updating IDs in the
connector cross reference file. This could result in invalid AddressID cross-references.
The issue was due a record size limitation in several original connector
programs. It could occurr in the FrontLine to SouthWare EOD and AP Receivings
connections, but would only become evident when AR Customer or AP Vendor
records where subsequently connected from SouthWare to FrontLine. It could appear to be duplicate ContactIDs in
FrontLine, but would actually be unique ContactIDs related to multiple
duplicated address records which carried different AddressIDs.
Note: This fix can be tested by EOD connection of customers
and AP Receiving connection of vendors.
Also, it does not address existing FrontLine and connector
cross-reference data, which may need to be fixed when reported.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs is:
FLADDIMP.OBJ
FLCUSXRF.OBJ
FLVNDXRF.OBJ
Release: August 1, 2012
SouthWare Connector 2.0.082
- Fixed: Issues that
was introduced in 2.0.073. Price Level Price Percent was still not connecting
as NULL when Price Type = Flat Rate. These now all connect with Price Percent =
NULL. Also, offsetting Available parent details were connecting with the
current date, rather than a date prior to the Sold Date of their corresponding
child detail. These now connect with their Created date one day before the date
of the Sold child.
- Fixed: Issue that
was introduced in 2.0.076. For Price Levels by Location, the LocationID column
was connecting with trailing spaces. These spaces have been removed.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and the revised programs is:
FLINIEXP.OBJ
Release: May 31, 2012
SouthWare Connector 2.0.081
- Revised SouthWare
Stock Location Maintenance program to specify whether location is to be
connected to FrontLine. Blank or Y = Connect to FrontLine, N = Do not connect
to FrontLine.
- Revised initial
connector program to filter item categories, stock locations, stock items, and
stock cross-reference parts records based on the above flag in the Stock
Location File.
- This revision applies
to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
RSLOCMNT.OBJ
Release: May 8, 2012
SouthWare Connector 2.0.080
- Fixed: Compiled the
AP transaction maintenance program without custom libraries to eliminate
asterisks causing line wrapping on the check form.
- Revised custom AWC
versions of the customer and periodic connector programs to connect the
SouthWare customer Group Number to the FrontLine CUSTOMERS SIC column.
- This revision
applies to SouthWare Rev 15 and revised programs are (all but APTRXMNT are in
the AWC Overlay folder):
APTRXMNT.OBJ
FLCUSEXP.OBJ
FLPERAWC.OBJ
Release: March 26, 2012
SouthWare Connector 2.0.079
- Revised SouthWare
EOD program RSBILREG to preface GL transaction Reference Description 1 with
Customer Number when the Periodic Invoicing flag = “Y”. This program revision
is solely for ASRI at this time, but if other sites need it, then a dedicated
setup setting will be added for this feature.
- Fixed: The minimal connection
of salespersons that was added to program FLLINUPD in revision 2.0.018 did not
create corresponding cross-reference records to facilitate subsequent FrontLine
to SouthWare connections. These cross-reference records are now created.
Note: This required adding AgentID to all
order line export scripts, which will in turn require that ImportMate template
FLORDHDR RS08, that uses Field 48 (Line Number, XR Line Number), be updated to
Field 49. If any other templates are
using Field 47 (Item Number), it should be updated to Field 48 (I could not
find it being used in FLORDHDR).
- Fixed: The
connection of FrontLine-created customers during regular order connection still
did not right-justify and zero-fill short FrontLine IDs correctly. The program
now right-justifies and zero-fills these IDs before creating the cross
reference records.
- Fixed: The
connection of FrontLine-created vendors may have had the same issues as the
customer program, so was revised in the same manner.
Note: Databases with CustomerIDs or
VendorIDs less than 9 digits could have existing cross-reference issues due to
this program bug. This could happen where customers or vendors have been
imported directly into FrontLine with IDs in the 70 workstation range. If there
are issues, the situation should be carefully analyzed, and then a special fix
program designed to update the cross-reference file. There is currently a fix
program, FLFIXXR3, that fixes cross-reference CustomerIDs for sites that don’t
continually connect customers from the AR Customer File to FrontLine. This
program replaces all SouthWare resident cross-reference IDs with those found in
FrontLine.
Note: The revisions to FLCUSXRF and
FLLINUPD need thorough testing to prevent serious data issues!
- This revision applies
to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts need to
be updated to the database):
FLCUSXRF.OBJ
FLFIXXR3.OBJ
FLLINUPD.OBJ
FLVNDXRF.OBJ
RSBILREG.OBJ
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.FMT
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLPVC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLRBC.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLRBPVC.SQL
Release: March 14, 2012
SouthWare Connector 2.0.078
- Revised sales order
line export script to output resource cost only when the line transaction type
is Miscellaneous, Service, or Charge.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.SQL
pgExSwOrdL.SQL
pgExSwOrdLPV.SQL
Release: March 9, 2012
SouthWare Connector 2.0.0077
- Fixed: The customer
connector program sometimes truncated part of customer note. The initial,
periodic, and customer connector programs have been revised to accommodate the
SouthWare maximum note length of 5000 characters.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLCUSAWC.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPERAWC.OBJ
FLPEREXP.OBJ
Release: February 29, 2012
SouthWare Connector 2.0.076
- Revised the
FrontLine Setup program to include a setting for whether the site uses Price
Levels by Location. If the setting is Y, the Initial Connector program will
create a set of Price Level records for each location in which a stock item is
set up. In this case, the program will still create one set of generic Price
Level records for the stock item from the first location of the stock item,
with the addition of a LocationID column whose value is always zero. When the
setting is N, the program will create one set of generic Price Level records
for each stock item from the first location of the stock item, as it did
before, but with the addition of a LocationID column whose value is always
zero.
- Fixed: The Order
Header Export script did not export the ApplyTo Number correctly on credit
memos and returns. This was due to an incorrect flag value and has now been
corrected.
Note: This version of
the connector is required for new installations that are to use FrontLine
6.2.002 or later.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLSUMNT.OBJ
FLINIEXP.OBJ
ExSwOrdH.SQL
pgExSwOrdH.SQL
Release: February 9, 2012
SouthWare Connector 2.0.0075
- Fixed: The Clearing
Account had been omitted from the PostgreSQL receivings export script in the
changes from 2.0.066 to 2.0.069.
- Fixed: The Amount field
in the assembly export script sometimes defaulted to the invoice line Effective
amount when one of the accumulated actual cost amounts was returned as NULL.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwAssemL.SQL
pgExSwAssemL.SQL
pgExSwRecvL.SQL
Release: February 6, 2012
SouthWare Connector 2.0.074
- Fixed: Order line
connection fix from 2.0.060 was previously omitted from Rev 14a. The fix was
for a string concatenation issue in the line update program that was triggered
by AWC item descriptions with as many as 10 or more embedded spaces. The issue
occurred at Diversified in Rev 14a due to embedded spaces in customer names.
- This revision
applies to SouthWare Rev 14a and revised program is:
FLLINUPD.OBJ
Release: January 17, 2012
SouthWare Connector 2.0.073
- Revised initial
connection program to connect Stock Item Standard Cost to FrontLine ITEMCOST table
StdCost for compatibility with FrontLine 6.1.181.
- Fixed: Initial
connection program was connecting Price Level Price Percent as zero when Price
Type was Flat Rate. FrontLine wants to see a NULL in this column.
- Fixed: Initial
connection program created an extra Available item detail for available
serialized units. This was introduced in the 2.0.072 revision.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
Release: January 11, 2012
SouthWare Connector 2.0.072
- Revised AR Customer
connection programs to only connect BillTo addresses when the BillTo Customer
field is blank or is the same as the AR Customer Number field.
- Revised initial
connection program to restore the code that creates offsetting available parent
item details for sold serialized units.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: December 28, 2011
SouthWare Connector 2.0.071
- Fixed: Price Levels
connection Price Percent was not being left justified and was being truncated
during connection.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: December 21, 2011
SouthWare Connector 2.0.070
- Revised AP
Transaction Entry program to validate PO Number and Vendor Number to the PO
Receivings Cost File. This validation includes whether the PO exists and
whether the Vendor Number is valid for the
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised program is:
APTRXMNT.OBJ
Release: December 15, 2011
SouthWare Connector 2.0.069
- Revised Receivings
Export script to exclude 2.0.066 revision and include AP Discrepancy account in
export file as an additional field.
- Added AP Discrepancy
account field to Receivings Cost File record, and revised Receivings Cost File
Update program to update this field.
- Revised Receivings
Cost Entry program to update AP Transaction Distributions File account from
Receivings Cost File AP Discrepancy account.
- Revised Inventory
Adjustment Export script to differentiate between normal and physical inventory
adjustments.
- Revised GL Transaction
Update program to update physical inventory adjustment descriptions with
ADJ-PH#, instead of the usual ADJ-PO#.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLCOSEXP.OBJ
FLRECUPD.OBJ
RSRCCENT.OBJ
ExSwInvAdjL.SQL
ExSwRecvL.SQL
pgExSwInvAdjL.SQL
pgExSwRecvL.SQL
pgExSwRecvLC.SQL
Release: December 2, 2011
SouthWare Connector 2.0.068
- Revised order line
export scripts to change sign on resource cost for returns.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdL.SQL
ExSwOrdLASRI.SQL
ExSwOrdLPV.SQL
pgExSwOrdL.SQL
pgExSwOrdLPV.SQL
Release: November 17, 2011
SouthWare Connector 2.0.067
- Revised recurring
billing order line export script to include lines for inventory items and
exclude lines where quantity is zero.
- Revised order line
export scripts to change sign on resource cost for returns.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdLRB.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
Release: November 10, 2011
SouthWare Connector 2.0.066
- Revised order export
script to format last digit of SouthWare credit memo ApplyTo Number with InvSeq
of the invoice that was credited. This occurs only if the credit memo is
returning only one InvSeq. If there are multiple InvSeqs being returned, the
ApplyTo Number is left blank. InvSeqs
greater than 9 in the ApplyTo Number connect as A, B, C, etc., the same as
InvSeqs in invoice numbers.
- Revised recurring
billing order export script to format last digit of SouthWare credit memo
ApplyTo Number with InvSeq=1.
- Revised receivings
export script to output the AP Discrepancy account in place of the Inventory
Clearing account.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdH.SQL
ExSwOrdHRB.SQL
ExSwRecvL.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
pgExSwRecvL.SQL
Release: November 8, 2011
SouthWare Connector 2.0.065
- Fixed: Removed the
recurring billing invoice pre-processing program’s tax recalculation routine that
was missed in the .061 revision. Execution of this routine seemed to result in
the GL tax amount sometimes being one cent off when posted to GL.
- Fixed: String
concatenation issue in the receivings update program that was missed in the
.0060 revision. An issue with flagging
the receiving records as updated to the receivings cost file could sometimes be
caused by AWC item descriptions with as many as 10 or more embedded spaces.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs:
FLRECBIL.OBJ
FLRECUPD.OBJ
Release: November 2, 2011
SouthWare Connector 2.0.064
- Fixed: GL
transactions from assembly work orders did not balance. Revised assembly work
order export script to include assembly service amounts in the accumulated
assembled item cost amount. These were found not to be in the TRXINVCOST table
as are other component items.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG script needs to be updated to the database):
ExSwAssemL.SQL
pgExSwAssemL.SQL
Release: October 20, 2011
SouthWare Connector 2.0.063
- Fixed: The variance
between the accumulated component costs and the assembled unit cost in the
assembly work order export script created out of balance GL transactions when
imported to SouthWare. This was due to 4dp amounts in the FrontLine TRXINVCOST
table and only 2dp in the SouthWare GL transaction detail file, so some
rounding was occurring. The component costs are now rounded and accumulated to
produce the assembled item cost, rather than using the cost from TRXINVCOST for
the assembled item.
- Revised receivings
update program to update PO-RCOST-COSTED-WITH-QTY-FLAG.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG script needs to be updated to the database):
FLRECUPD.OBJ
ExSwAssemL.SQL
pgExSwAssemL.SQL
Release: October 18, 2011
SouthWare Connector 2.0.062
- Revision for
INVOICES.EntityID and BillTo carried through to other scripts where
appropriate.
- Fixed: Columns that
had been added in .054 were missing from RCV’s custom PG recurring billing line
script.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
ExSwOrdH.SQL
ExSwOrdHPV.SQL
ExSwOrdLPV.SQL
ExSwOrdLRB_RCV.SQL
ExSwOrdLXRPV.SQL
ExSwRecvL.SQL
TagNewExpbyLocASRI.SQL
TagNewExpRecv.SQL
pgExSwOrdH.SQL
pgExSwOrdHPV.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLXRPV.SQL
pgExSwRecvL.SQL
pgInvoiceReconnect.SQL
pgTagNewExpRecv.SQL
Release: October 14, 2011
SouthWare Connector 2.0.061
- Fixed: Columns that
had been added in .054 where missing from the PG recurring billing line script.
- Fixed: Mismatch between
field format in the PG receivings export script and its calling script.
- Fixed: The order tax
import program left the order tax override flag set to Yes. Set this to No, and
removed the invoice pre-processing program’s tax recalculation routine, that
was being triggered as well by this flag. Execution of this routine seemed to
result in the GL tax amount sometimes being one cent off when posted to GL.
- Fixed: The AP Post
Date in the receivings connection from SouthWare was sometimes zero. This resulted
in rejected updates in FrontLine. The program now fills with the current date
when this occurs.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLCOSEXP.OBJ
FLORDUPD.OBJ
FLTAXIMP.OBJ
pgExSwOrdLRB.SQL
pgExSwRecvL.SQL
pgExSwRecvLC.SQL
Release: September 30, 2011
SouthWare Connector 2.0.060
- Added custom
customer connector export program with separate file for BillTo address
connection for Advanced Wireless.
- Added custom
periodic connector export program with separate file for BillTo address
connection for Advanced Wireless.
- Modified custom
initial connector export program with separate file for BillTo address
connection for Advanced Wireless.
- Revised MS-SQL order
header export script to accommodate new INVOICES.EntityID and BillTo columns.
- Fixed: String
concatenation issue in the line update program triggered by AWC item
descriptions with as many as 10 or more embedded spaces.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts
are:
FLCUSAWC.OBJ (named as
FLCUSEXP.OBJ on AWC system)
FLINIAWC.OBJ
FLLINUPD.OBJ
FLPERAWC.OBJ
ExSwOrdH.SQL
InvoiceReconnect.SQL
Release: September 2, 2011
SouthWare Connector 2.0.059
- Fixed: BillTo and
ShipTo Addresses were exporting with a truncated Address3 field. Added DbTxUtil
.FMT file for proper formatting of address export file. This required changes
to all the configuration files that referenced the address export script.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts
are:
DTU_FLORDEXL.INI
DTU_FLORDEXL_ASRI.INI
DTU_FLORDEXLPV.INI
DTU_FLORDEXP.INI
DTU_FLRBEXP.INI
DTU_FLRBLEXP.INI
ExSwAddr.FMT
Release: August 17, 2011
SouthWare Connector 2.0.058
- Added special
version of FLINIEXP, named FLINIAWC, to filter out specific customers from the
serial sold item detail connection and also to connect the FrontLine ShipTo
AddressID in item details for sold customer equipment.
- This revision
applies to SouthWare Rev 15, and revised programs:
FLINIAWC.OBJ
Release: July 20, 2011
SouthWare Connector 2.0.057
- Revised: ASRI
regular order tagging script now only tags invoices where Customer Number does
not begin with R.
- Revised: ASRI
regular order line export script now includes Job Number and Cost Code.
- Revised: ASRI
regular order tagging script now references the above ASRI-specific scripts.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts
are:
DTU_FLORDEXL_ASRI.INI
ExSwOrdLASRI.SQL
TagNewExpbyLocASRI.SQL
Release: July 18, 2011
SouthWare Connector 2.0.056
- Revised order connection
process to connect FrontLine InvSeqs greater than 9 as A through Z. SouthWare
invoice numbers created from this connection will have the alpha character in
the last position. If an order rejects, the alpha character will be converted
to its corresponding FrontLine InvSeq.
- Fixed: Revision
2.0.022b inadvertently caused program FLLINUPD to truncate line fields after
the item type flag. This was because item type was the same as the delimiter
used for record parsing in FLLINUPD. This was non-fatal until we added
additional fields after the flag, at which point these fields went missing. The
workaround is the item type flag for service has been changed to V, rather than
S. SouthWare Workflows using this field will have to be changed accordingly.
- Fixed: Revision
2.0.051 had a SyncSet variable syntax that was incompatible with PostgreSQL.
This has been corrected.
- Revised all line
related scripts to use one script rather than two as before.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLORDUPD.OBJ
DTU_FLGLTEXP.INI
DTU_FLGLTEXP.INI (RCV
version)
DTU_FLORDEXL.INI
DTU_FLORDEXLPV.INI
DTU_FLRECEXP.INI
ExSwAssemL.SQL
ExSwInvAdjL.SQL
ExSwOrdH.FMT
ExSwOrdH.SQL
ExSwOrdL.SQL
ExSwOrdLPV.SQL
ExSwOrdLRB.SQL
ExSwOrdLRBPV.SQL
ExSwRecvL.SQL
ExSwTransL.SQL
pgExSwAssemL.SQL
pgExSwInvAdjL.SQL
pgExSwOrdH.SQL
pgExSwOrdL.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRB_RCV.SQL
pgExSwOrdLRBPV.SQL
pgExSwRecvL.SQL
pgExSwTransL.SQL
ExSwAssemLIP.SQL (now
obsolete)
ExSwInvAdjLIP.SQL (now
obsolete)
ExSwOrdLIP.SQL (now
obsolete)
ExSwOrdLIPPV.SQL (now
obsolete)
ExSwRecvLIP.SQL (now
obsolete)
ExSwTransLIP.SQL (now
obsolete)
pgExSwAssemLIP.SQL
(now obsolete)
pgExSwAssemLIPC.SQL
(now obsolete)
pgExSwInvAdjLIP.SQL
(now obsolete)
pgExSwInvAdjLIPC.SQL
(now obsolete)
pgExSwOrdLIP.SQL (now
obsolete)
pgExSwOrdLIPC.SQL (now
obsolete)
pgExSwOrdLIPPV.SQL
(now obsolete)
pgExSwOrdLIPPVC.SQL
(now obsolete)
pgExSwRecvLIP.SQL (now
obsolete)
pgExSwRecvLIPC.SQL
(now obsolete)
pgExSwTransLIP.SQL
(now obsolete)
pgExSwTransLIPC.SQL
(now obsolete)
Release: July 5, 2011
SouthWare Connector 2.0.055
- Fixed: The inventory
adjustment, transfer, assembly work order, and recurring billing GL update
programs were still not working correctly with regard to GL transaction number
assignment and GL Control File updating. Hopefully, we have found the issue
this time.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLGLTUPD.OBJ
FLRECBIL.OBJ
Release: June 28, 2011
SouthWare Connector 2.0.054
- Revised order
connection process to allow it to be used for both regular and periodic
invoices on the same system. Having periodic invoicing set up in the back
office connector setup program (FLSUMNT), no longer prevents a user from
running the regular order connector. Only when periodic invoicing is set up
will the user be asked if they want to connect regular or periodic invoices.
When running in periodic mode, the connector file names with be prefixed with
SW_PV_ rather than SW_ as in regular mode.
Note: Both types of
connections should not be run at the same time, since they share some reporting
files. A run of either type of invoices should be completed through EOD before
running the other type.
Note: Since this
release builds on revisions made in 2.0.051, setup for that revision applies to
this one as well. Periodic invoices will not make use of XD160, though regular
orders will. Also, because both types of connections use a common ImportMate
template (FLORDHDR), line field sequence must be consistent. This means that
the template will have to be changed to the new line format, which adds
periodic invoice fields to the end of the order line, and a cross-reference
line number as the last field.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLADDIMP.OBJ
FLCUSXRF.OBJ
FLLINUPD.OBJ
FLORDEXP.OBJ
FLORDUPD.OBJ
FLNOTIMP.OBJ
FLTAXIMP.OBJ
FLTXCIMP.OBJ
DTU_FLORDEXLPV.INI
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLPV.FMT
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
Release: June 24, 2011
SouthWare Connector 2.0.053
- Revised AR Open File
connection to connect GL Posted Date when present, rather than AR Posted Date.
- Revised periodic
invoice order header export script to include OrderID, to be connected to SW
order header Extended Data. This was for
ASRI only.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts
are:
FLAROEXP.OBJ
ExSwOrdH.FMT
ExSwOrdHPV.SQL
Release: June 23, 2011
SouthWare Connector 2.0.052
- Fixed: The recurring
billing pre-process program was still not updating the GL Control File
properly. It has not been revised with the same revision as was earlier made to
FLGLTUPD.
- Revised MOL catalog
update script to not update the item type when updating pre-existing items that
match catalog part numbers. Also modified script to contain three costing
variables that will need to be manually updated for each site, based on their
costing requirements.
- Revised AP check
printing copy library and recompiled three programs that use it. This was for
ASRI only.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG script needs to be updated to the database):
APCHKPRT.OBJ
APMNCHKM.OBJ
APTRXMNT.OBJ
FLRECBIL.OBJ
MOL_Update.sql
pgMOLUpdate.sql
Release: June 14, 2011
SouthWare Connector 2.0.051
- Revised assembly,
transfer, and inventory adjustment tagging scripts to tag TRXINVCOST records
related to lines to be connected.
- Revised assembly,
transfer, and inventory adjustment export scripts to connect amount as the SUM
of TRXINVCOST.Unit Cost * TRXINVCOST.InvQty from related TRXINVCOST rows.
- Revised sales and
service order line scripts, notes scripts, and connector programs, to renumber order
lines for compatibility between FrontLine (5 digits) and SouthWare (4 digits
max). Line numbers in SouthWare will no longer match the FrontLine line number,
which is now stored only in Extended Data for reference and for updating to
FrontLine when needed.
Note: To
facilitate this connection, set up XD160 (FL XREF LINE), related to the order
line (XD104), with Field 1 (Order Number,ALPH,10), Field 2 (FL Line,ALPH,5),
Field 3 (XR Line,ALPH,4). Modify ImportMate template FLORDHDR RS08 to import
RS08 Field 2 from import file field 43, XT60 Field 1 from import file field 1,
XT60 Field 2 from import file field 2, and XT60 Field 3 from import file field
43.
Note: Because
recurring billing shares some programs with sales and service order line
scripts, its connection will also populate XD160, though the “renumbered” line
number will be the same as the FrontLine line number.
- Revised GL journal
entry import program to set transaction header Added-In-GL flag to “Y”. Renamed
this program from FLGLPIMP.OBJ to FLGLIMP.OBJ, since it is no longer being used
exclusively for GL payroll import.
- Fixed: AP
transaction posting program was overwriting reference key field on header
distributions.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
APTRXPST.OBJ
FLGLIMP.OBJ
FLLINUPD.OBJ
FLNOTIMP.OBJ
FLORDUPD.OBJ
FLRECBIL.OBJ
ExSwOrdL.FMT
ExSwNote.FMT
ExSwAssemL.SQL
ExSwAssemLIP.SQL
ExSwInvAdjL.SQL
ExSwInvAdjLIP.SQL
ExSwTransL.SQL
ExSwTransLIP.SQL
pgExSwAssemL.SQL
pgExSwAssemLIP.SQL
pgExSwInvAdjL.SQL
pgExSwInvAdjLIP.SQL
pgExSwTransL.SQL
pgExSwTransLIP.SQL
pgTagNewExpInvAdj.SQL
pgTagNewExpTrans.SQL
TagNewExpInvAdj.SQL
TagNewExpTrans.SQL
Release: May 18, 2011
SouthWare Connector 2.0.050
- Revised periodic
invoice tagging script to tag only customers and related records that have a
Billing POC address, that have had either their customer, Billing POC address,
or Billing POC contact (with Attributes = Primary POC contact) added or changed.
- Revised customer
export script to connect only tagged customers that have had their customer
record, Billing POC address, or Billing POC contact (with Attributes = Primary
POC contact) added or changed.
Note: As of this
release, periodic invoicing revisions are not being made to PG scripts, since
they are ASRI-specific.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are:
ExSwCustPV.SQL
ExTagNewExpbyLocPV.SQL
Release: May 16, 2011
SouthWare Connector 2.0.049
- Fixed: Journal
entries created in AP did not get their subsystem field populated with T when
posted, as is necessary for Job Cost journal entries.
- Added import of
header description to Payroll GL journal entry import.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs:
FLGLPIMP.OBJ
GLJNLMNT.OBJ
Release: April 26, 2011
SouthWare Connector 2.0.048
- Revised periodic
invoice tagging script to update SYNCLOG PSet records (SyncType=1008),
initially created by FL, to SyncStatus=1 after connection to back office. The
connector will now only connect the maximum numbered PSet where SyncStatus is
blank or zero. When testing, and resetting SyncSets on FrontLine invoices and
orders that are part of a periodic invoice connection, this SyncStatus will
also need to be reset to blank or zero.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG script
needs to be updated to the database):
ExTagNewExpbyLocPV.SQL
pgExTagNewExpbyLocPV.SQL
Release: April 22, 2011
SouthWare Connector 2.0.047
- Fixed: The periodic
invoice line sequencing script had a flaw that incorrectly sequenced lines when
a Customer/BillTo had multiple bills and invoices. This caused some lines to be
overwritten on import to SouthWare.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdLPV.SQL
ExSwOrdLIPPV.SQL
ExSwOrdLRBPV.SQL
ExSwOrdLXRPV.SQL
ogExSwOrdLPV.SQL
pgExSwOrdLIPPV.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLXRPV.SQL
Release: April 18, 2011
SouthWare Connector 2.0.046
- Revised address
connection to connect customer ShipTo addresses in a separate file. This is to
prevent Phone3 and Email from being overwritten when updated in FrontLine.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts
are:
APVNDMNT.OBJ
ARSMANMN.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
DTU_FLCUSEXP.INI
DTU_FLINIEXP.INI
DTU_FLPEREXP.INI
Release: April 7, 2011
SouthWare Connector 2.0.045
- Fixed: The GL
transaction update program inadvertently cleared out the transaction number to
be tested for uniqueness before the test. This may have contributed to reports
of duplicate transaction numbers, since the test was not working as designed.
- Fixed: The ASRI
historical GL import program was incrementing the GL control file transaction
number even though it did not need to use these transaction numbers. This had
no affect other than to waste GL transaction numbers.
- Added an ASRI
payroll GL import program.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLGLPIMP.OBJ (Rev 15
only)
FLGLTIMP.OBJ (Rev 15
only)
FLGLTUPD.OBJ
Release: March 21, 2011
SouthWare Connector 2.0.044
- Fixed: The periodic
invoice tagging script did not take into account that the latest periodic
invoice PSet may have been voided. The script now qualifies that the SyncStatus
for the latest periodic invoice PSet must be greater than or equal to zero, in
order for invoices and orders related to it be tagged.
- Fixed: For periodic
invoicing, program FLORDEXP called out to program FLLINUPD to pre-process
exported lines regardless of whether or not there was new periodic invoice data
to export. When there was none, FLLINUPD displayed a file open error, and gave
a misleading message about successfully exporting periodic invoices. FLORDEXP
now checks for the presence of the order line export file as a condition for
calling FLLINUPD, and if the file is not present, it displays that there is no
new periodic invoice data to export.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG script needs to be updated to the database):
FLORDEXP.OBJ
ExTagNewExpbyLocPV.SQL
pgExTagNewExpbyLocPV.SQL
Release: February 22, 2011
SouthWare Connector 2.0.043
- Release for
new ASRI features.
- Added
connection of periodic invoices. There is one periodic invoice per connection,
per Customer Number and BillTo. Since periodic invoices are collections of
FrontLine invoices and recurring bills, order numbers do match FrontLine
orders, and the line numbers have been re-sequenced. This connection includes
connection of two Job Cost fields, Job Number and Cost Code, from FrontLine
Order Header identifiers 10010 and 10011 respectively, and the original
FrontLine OrderID, InvSeq, and Line to SouthWare order line XD158 fields.
Periodic invoices must be exported, imported, and updated in separate steps,
because there can be no recirculation error routine as with the standard
invoice processing. Any import errors found, will need to be corrected before
running AR-01-04-01-04.
Note: To
facilitate this connection, the following SouthWare setups are required:
Also the
following script setups are required:
- Modified SouthWare
EOD program RSBILREG to update Job Number and Cost Code from the order line XD
to custom fields the SW GL Interface File.
- Modified
SouthWare AP Transaction Posting to populate Job Number and Cost Code to custom
fields in the SW GL Interface File.
- Modified
SouthWare GL Journal Posting to populate Job Number and Cost Code to custom
fields in the YTD GL Transaction File.
- Modified
SouthWare GL Interface File Posting to populate Job Number and Cost Code to
custom fields in the GL Transaction Detail File.
- Modified
SouthWare AP Transaction Maintenance and GL Journal Maintenance to facilitate
maintenance of Job Number and Cost Code.
- Added a
SouthWare GL transaction import program to import historical journal entries
with Job Cost data.
Note: This
release is essentially the same as .0042 with the exception of the ASRI Job
Cost and periodic invoice features. So, this it can be skipped for clients
other than ASRI. However, future releases will contain some of these programs,
so this release should be tested to ensure compatibility with clients other
than ASRI.
This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
APTRXMNT.OBJ
APTRXLST.OBJ
APTRXPST.OBJ
FLGLTIMP.OBJ
FLORDEXP.OBJ
FLORDUPD.OBJ
FLSUMNT.OBJ
GLJNLMNT.OBJ
GLJNLPST.OBJ
RSBILREG.OBJ
SWGLIFLS.OBJ
ExSwAddrPV.SQL
ExSwOrdHPV.SQL
ExSwOrdLPV.SQL
ExSwOrdLIPPV.SQL
ExSwOrdLRBPV.SQL
ExSwOrdLXRPV.SQL
ExSwOrdNPV.SQL
ExSwOrdPPV.SQL
ExSwOrdTPV.SQL
ExSwOrdTRBPV.SQL
ExTagNewExpbyLocPV.SQL
pgExSwAddrPV.SQL
pgExSwAddrPVC.SQL
pgExSwOrdHPV.SQL
pgExSwOrdHPVC.SQL
pgExSwOrdLPV.SQL
pgExSwOrdLPVC.SQL
pgExSwOrdLIPPV.SQL
pgExSwOrdLIPPVC.SQL
pgExSwOrdLRBPV.SQL
pgExSwOrdLRBPVC.SQL
pgExSwOrdLXRPV.SQL
pgExSwOrdLXRPVC.SQL
pgExSwOrdNPV.SQL
pgExSwOrdNPVC.SQL
pgExSwOrdPPV.SQL
pgExSwOrdPPVC.SQL
pgExSwOrdTPV.SQL
pgExSwOrdTPVC.SQL
pgExSwOrdTRBPV.SQL
pgExSwOrdTRBPVC.SQL
pgExTagNewExpbyLocPV.SQL
pgExTagNewExpbyLocPVC.SQL
DTU_FLORDEXL_PV.INI
Release: February 3, 2011
SouthWare Connector 2.0.042
- Fixed: The 2.0.0035
revision for PricePercent and PriceType caused a mismatch issue between the
column header and data columns in the item price levels connection. This issue
only affected initial and periodic batch connections.
- Fixed: The 2.0.0039
revision to the PG Receivings Cost Export scripts caused a RETURN NEXT error.
The columns affected by this revision now require that their output be
explicitly CAST as numeric datatype.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are (PG scripts
need to be updated to the database):
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
pgExSwRecvL.SQL
pgExSwRecvLIP.SQL
Release: January 19, 2011
SouthWare Connector 2.0.041
- Revised to connect
FrontLine Assembly Work Orders to SouthWare GL transactions. This release requires FrontLine 6.0.096 (to
be released as of this writing) or later and ITEMCATS.AssemblyWO must be
populated.
- Revised initial and periodic
connector programs to change item category connector text file column label
from AllowMisc to AssemblyWO, to match ITEMCATS.AssemblyWO column. Disabled
connection of SouthWare Product Category File field CAT-VRA-MISC-ALLOW-ACCT.
These programs should only be used with FrontLine 6.0.096 and later.
Note: Inventory
adjustment and transfers should also be tested with this release, to confirm
that they have not been adversely affected.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
DTU_FLGLTEXP.INI
FLGLTUPD.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
ExSwAssemL.SQL
ExSwAssemLIP.SQL
ExSwTransL.FMT
TagNewExpInvAdj.SQL
pgExSwAssemL.SQL
pgExSwAssemLC.SQL
pgExSwAssemLIP.SQL
pgExSwAssemLIPC.SQL
pgTagNewExpInvAdj.SQL
Release: January 18, 2011
SouthWare Connector 2.0.040
- Revised Order Header
Export script to change Order Type and ApplyTo Number to R and blank, respectively,
for return orders that have positive amounts on any lines. This was required
because SouthWare does not allow on positive line amounts on type C (credit)
orders. This release should be used with FrontLine 6.0.091 and later, and
applies to both regular and recurring billing order header exports.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdH.SQL
ExSwOrdHRB.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
Release: December 20, 2010
SouthWare Connector 2.0.039
- Revised Receivings
Cost File update program to populate Ledger Date from Received Date.
- Revised Receivings
Cost export scripts to calculate received quantity as FrontLine checked-in
quantity divided by related UOM conversion factor and to populate unit cost as
checked-in effective cost times related UOM conversion factor divided by
checked-in quantity, rather than FrontLine line unit cost.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLRECUPD.OBJ
ExSwRecvL.SQL
ExSwRecvLIP.SQL
pgExSwRecvL.SQL
pgExSwRecvLIP.SQL
Release: December 6, 2010
SouthWare Connector 2.0.038
- Revised AP
Transaction Maintenance and Receivings Cost Entry programs to replace the GL
Post Date with the Receivings Cost File Received Date. It replaces using the
date from the last receivings cost record for the specified
- This revision applies
to SouthWare Rev 14a, 15, and 15a, and revised programs are:
APTRXMNT.OBJ
RSRCCENT.OBJ
Release: December 3, 2010
SouthWare Connector 2.0.037
- Fixed: The
Receivings Cost History File update produced duplicate key write errors. This
was due to the dynamic nature of sequence number assignment in the open file,
and the possibly that sequence numbers could be reused for a particular PO
Number, Item Number, Location combination when the earlier occurrence of the
sequence number had been purged. The history file needed to allow these records
to coexist, and therefore needed to re-sequence when duplication occurred.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLCOSEXP.OBJ
Release: December 1, 2010
SouthWare Connector 2.0.036
- Fixed: The MS-SQL
order export line script did not truncate all ShipTo Name and Address data to
match SouthWare field specifications, resulting in non-fatal import errors.
This fix has also been retrofitted to 2.0.034 and .035, to minimize import
errors in those versions.
- Fixed: XD157 Field 7
(Item Number) did not accommodate FrontLine-entered item numbers that were over
15 characters long, resulting in non-fatal import errors. It has been expanded
to 30 characters. This fix should be done at all 2.0.0031 and newer sites.
- Fixed: The Customer
Cross-Referencing program did not function properly for FrontLine-entered
customer numbers that were less than 10 digits. The FrontLine cross-reference
numbers that resulted had their last digit truncated, resulting in
cross-referencing issues with other customers. This issue dates back to when
FrontLine CUSTOMERS.CustomerID was named CUSTOMERS.ExtRef, and was not exposed
for user entry. At that time, all customer numbers for all FrontLine originating
customers were constructed as CUSTOMERS.CustomerID + “0”, but now a user can
enter any length number.
- Fixed: The Vendor
Cross-Referencing program was suspected of having the same problems as the
customer program, since it was cloned from it. This was fixed to prevent future
cross-referencing issues with vendors.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLCUSXRF.OBJ
FLVNDXRF.OBJ
ExSwCust.FMT
ExSwCust.SQL
ExSwCust_CN.SQL
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
ExSwVend.FMT
ExSwVend.SQL
pgExSwCust.SQL
pgExSwCustC.SQL
pgExSwCust_CN.SQL
pgExSwCust_CNC.SQL
pgExSwVend.SQL
pgExSwVendC.SQL
Release: November 23, 2010
SouthWare Connector 2.0.035
- Fixed: The
Receivings Cost History File format had not been updated for the Costing Flag
that was added to the Receivings Cost File format in 2.0.030.
- Added PricePercent
and PriceType to the price levels connection routine, and adjusted other fields
appropriately.
Note: FLCOSEXP should
be distributed to client sites as soon as possible since history records are
unreliable in the latter portion of the record. This will not affect our
clients adversely, but could make troubleshooting a little more difficult,
should we need to do that.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLCOSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: November 2, 2010
SouthWare Connector 2.0.034
- Fixed: The initial connector
was attempting to connect ITEMBINS records even when there was no Bin ID in the
SouthWare Stock File record.
- Fixed: The recent
addition of Unit of Measure to the connection of cross-reference parts was not
truncating spaces from the UOM LValue.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: October 27, 2010
SouthWare Connector 2.0.033
- Revised the initial
and periodic connectors to connect Purchasing Unit of Measure and associated
conversion factors. Any Unit of Measure found in the SouthWare Conversion Units
of Measure File for Purchasing is connected to the FrontLine LISTVALS table.
Its associated conversion factor is connected to LISTVALS.CalcValue. Also
revised connection of parts, to connect the Unit of Measure LValue to
PARTS.UOM. All programs using the LISTVALS connection routine where also
recompiled.
Note: Due to an
incompatibility between the FrontLine design and SouthWare, any Units of Measure
that have multiple conversion factors (SouthWare allows for the same Unit of
Measure to have different conversion factors on different items) will have to
be renamed. Example: Item ABC, PK=5, Item DEF, PK=10, must be changed to Item
ABC, 5P=5, Item DEF, 10P=10. Of course, references to this Unit of Measure on
their respective items, throughout SouthWare, must be changed as well.
- Fixed: In the AP
costing connection, when the item was costed at receiving, the Unit Cost was
connected as zero. This caused multiple FrontLine TRXINVCOST records for the
Invoice and Line, since FrontLine had already created one for the line. Revised AP costing connection to connect Unit
Cost as NULL when costed at receiving, to trigger procedure CostInvoice to
update rather than insert.
Note: This revision
requires the FrontLine 6.0.070 CostInvoice script.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
APVNDMNT.OBJ
ARSHIPVM.OBJ
ARTERMSM.OBJ
FLCOSEXP.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLORDEXP.OBJ
FLPEREXP.OBJ
FLRBEXP.OBJ
FLSQLIMP.OBJ
GLACTMNT.OBJ
RSCATMNT.OBJ
Release: October 25, 2010
SouthWare Connector 2.0.032
- Fixed: Negative
FrontLine amounts in GL transactions were being left negative, which caused out
of balance journal entries. The sign has now been reversed on these
transactions.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised program is:
FLGLTUPD.OBJ
Release: October 19, 2010
SouthWare Connector 2.0.031
- Revised Recurring Billing
export scripts to connect Recurring Billing credits along with Recurring Bills.
Recurring billing credits, which have no FrontLine invoice, were part of a
recent revision of FrontLine. Since FrontLine has no invoice for Recurring
Bills, they have always connected with Invoice Number = FrontLine OrderID + 1.
Recurring Billing credits will connect with Invoice Number = FrontLine OrderID
+ 2, so that they will not produce a duplicate invoice in SouthWare.
- Fixed: ImportMate
truncated the order line Item Number to 10 characters, since it validates to
the Service Code File. This has been addressed by importing the Item Number
into XD157 Field 2 (Item Number, ALPH, 15 characters), and updating it to the
order line Stock Use Number field in program FLORDUPD.
Note: The connector
revision folders have been restructured, to hopefully make it easier to find
things.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs and scripts are
(PG scripts need to be updated to the database):
FLORDUPD.OBJ
ExSwOrdHRB.SQL
ExSwOrdTRB.SQL
ExTagNewExpRB.SQL
ExTagNewExpRBByCat.SQL
pgExSwOrdHRB.SQL
ogExTagNewExpRB.SQL
pgExTagNewExpRBByCat.SQL
Release: October 8, 2010
SouthWare Connector 2.0.030
- Added a CostingFlag to
the receivings export scripts, and added new CostingFlag field in the SouthWare
Receivings Cost File. This flag is exported as Y if the FrontLine company
setting for Costing is set to Costed at time of receiving, otherwise it is
blank. Modified the Receivings Cost File Update program to update this field
during import. Modified the Receivings Costing File Export program to export
Unit Cost as zero when this flag is set to Y.
- Added connection of
SouthWare Stock File Bin ID to FrontLine table ITEMBINS. The previous
connection of Stock File Bin ID to ITEMS.Bin is still connected as before.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
FLCOSEXP.OBJ
FLINIEXP.OBJ
FLRECUPD.OBJ
ExSwRecvL.FMT
ExSwRecvL.SQL
ExSwRecvLIP.SQL
pgExSwRecvL.SQL
pgExSwRecvLC.SQL
pgExSwRecvLIP.SQL
pgExSwRecvLIPC.SQL
Release: October 1, 2010
SouthWare Connector 2.0.029
- Fixed: When users
partially entered an AP invoice costing transaction, then used the F8 key to
exit from the transaction, and then came back to work on it later, the
receivings cost lines were missing. This is because F8 does not clear invoice
information from the lines, and another user posted AP invoice costing
transactions before they returned to the transaction. The program now posts and
deletes receivings cost records by operator, so that another operator can not
post their unfinished records.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
APTRXPST.OBJ
FLCOSEXP.OBJ
Release: September 29, 2010
SouthWare Connector 2.0.028
- Added an Order Type
flag field to the order header export. Values are S=Sales, V=Service. This field
can be imported to an order header XD record/field of choice (excluding XD156),
and used as desired.
Note: The revision
number is now a sequential number, and is no longer based upon the FrontLine
revision number. Trying to keep the two product’s numbers in sync did not work
so well, and they were most often out of sync.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdH.SQL
ExSwOrdHRB.SQL
pgExSwOrdH.SQL
pgExSwOrdHC.SQL
pgExSwOrdHRB.SQL
pgExSwOrdHRBC.SQL
Release: September 19, 2010
SouthWare Connector 2.0.050e
- Fixed: The MS-SQL
customer order line in-process export script had an incorrectly coded JOIN
statement, causing duplicate rows to be exported.
- Fixed: The
checked-in receivings tagging script did not tag partially checked-in lines
after the first check-in of a particular line.
- Fixed: The
checked-in transfer tagging script did not tag partially checked-in lines after
the first check-in of a particular line.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised scripts are (PG scripts
need to be updated to the database):
ExSwOrdLIP.SQL
TagNewExpRecv.SQL
TagNewExpTrans.SQL
pgTagNewExpRecv.SQL
pgTagNewExpTrans.SQL
Release: September 8, 2010
SouthWare Connector 2.0.050d
- Fixed: FLGLTUPD had
not had its CREATE-REQUIRED-DIRECTORIES routine revised for thin client.
FLCUSXRF and FLPEREXP had code omissions that adversely affected backup of the
FrontLine ID Control File.
- This revision
applies to SouthWare Rev 15a, and revised programs are:
FLCUSXRF.OBJ
FLGLTUPD.OBJ
FLPEREXP.OBJ
Release: September 1, 2010
SouthWare Connector 2.0.050c
- Fixed: FLORDUPD and
FLRECBIL did not parse the default path which was needed for subsequent
ACUCOBOL library calls. FLORDUPD, FLRECBIL, and FLRECUPD did not reference the
new reconstructed path when calling ImportMate. FLGLTUPD and FLRECUPD attempted
to open the FrontLine Setup File twice. FLCUSXRF and FLTXCIMP did not handle
deletion of the connector text file properly.
- Fixed: DbTxUtil
configuration files DTU_FLGLTEXP.INI and DTU_FLRECEXP.INI did not have
lowercase connector file names as required on Linux. DTU_FLRECEXP.INI also had an
incorrect vendor export PostgreSQL calling script name.
- This revision
applies mostly to SouthWare Rev 15a, but the configuration files could affect
any version on PostgreSQL. The revised
programs and scripts are:
FLCUSXRF.OBJ
FLGLTUPD.OBJ
FLORDUPD.OBJ
FLRECBIL.OBJ
FLRECUPD.OBJ
FLTXCUPD.OBJ
DTU_FLGLTEXP.INI
DTU_FLRECEXP.INI
Release: August 25, 2010
SouthWare Connector 2.0.050b
- Fixed: RSBILREG
produced errors when attempting to open the FrontLine Setup File and when
attempting to read the standalone XD file that contains tax GL overrides. Also,
the override GL account number was not right justified in the returned variable
after performing the override. These problems have been fixed.
- Revised connector
address export script to output BillTo Customer from ADDRESSES.BillToEntity
when present.
- This revision
applies to SouthWare Rev 14a, 15, and 15a, and revised programs are:
RSBILREG.OBJ
ExSwAddr.SQL
pgExSwAddr.SQL
Release: August 19, 2010
SouthWare Connector 2.0.050a (Rev 15a)
- Added compatibility
with AcuThin configurations where the operating system current directory is
redefined from the standard SouthWare current directory that is specified by
the FILE-PREFIX parameter in the ACUCOBOL cblconfig file. When executing ACUCOBOL
library routines that use the operating system current directory to change
directory, get information about a file, copy and/or delete a file, this
version reconstructs the file paths before execution back to the standard
SouthWare current directory as defined by the Default Path in the program
FLSUMNT.
- For AcuThin
configurations described above, in addition to this version, DbTxUtil.exe and
all its configuration files (DTU*.INI) should be copied to the directory that
is defined for SWENV-STARTING-DIR. They should also remain in the SouthWare
directory for use by non thin client users.
- Currently this
release is only for sites using AcuThin in the configuration described above.
Theoretically, it should work on non AcuThin sites, but should not be released
there until it has adequate time to be proven at a mixed site.
Note: Since this
revision affected almost every program in the connector, it should be
thoroughly tested before releasing to any client sites. To prove that it is
working, tests should involve logging in with a new workstation number, making
sure the connector workstation directory does not pre-exist, and then
connecting a data record from SouthWare to FrontLine. If working, the program
should create the workstation directory, create the connector text files,
connect them to FrontLine, and then move them to the /FLCONN/ARCHIVE directory.
When completed, there should be no files remaining in the connector workstation
directory.
This revision applies
to all COBOL connector programs in SouthWare Rev 15a.
Release: August 16, 2010
SouthWare Connector 2.0.050a
- Fixed: FLSUMNT did
not allow the user to maintain the new XD for Tax GL Override field due to a
field number error. RSBILREG crashed because this field had not been setup.
FLSUMNT now shows the correct field number and forces the XD for Tax GL
Override to zero if it is not numeric. RSBILREG now also forces the XD for Tax
GL Override to zero if it is not numeric, and only runs the tax GL override
routine when the XD record number for this purpose is not zero.
Note: These programs
should be tested before releasing to any client sites.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
FLSUMNT.OBJ
RSBILREG.OBJ
Release: August 11, 2010
SouthWare Connector 2.0.050
- Fixed: When users
abandoned an AP invoice costing transaction, the program did not clear the
invoice data from the cost record and so the transaction was connected and
deleted. The program now clears the invoice data. Also, when the user used the
F8 key to exit from an AP transaction header, it left the invoice data as well.
It now clears the invoice data in this case. The SouthWare message that allowed
the user to not delete the invoice information after first selecting to abandon
the transaction has been removed.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
APTRXMNT.OBJ
RSRCCENT.OBJ
Release: August 10, 2010
SouthWare Connector 2.0.046
- Fixed: FrontLine
ExemptCats sometimes were too long to fit into SouthWare AR Customer Tax Type.
This caused SouthWare EOD errors when importing customers. Revised MS customer
export script to truncate ExemptCat to 5 characters. Revised PG customer export
script to increase exported length from 3 to 5 characters. The length of 3 was
based on a suggested list in 1.5.172.
Note: At some time in
the near future, the issue of setup and connection of this field between the
two systems should be addressed, as the current arrangement could cause
FrontLine ExemptCats to go missing. Based on 1.5.172 notes, these should be set
up in SouthWare but it appears they are being set up in FrontLine.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs and scripts are (PG
scripts need to be updated to the database):
ExSwCust.SQL
ExSwCust_CN.SQL
pgExSwCust.SQL
pgExSwCustC.SQL
pgExSwCust_CN.SQL
pgExSwCust_CNC.SQL
Release: August 9, 2010
SouthWare Connector 2.0.045b
- Added receivings cost
history file (SRCCH.FIL). Fully invoiced cost records are now written to this
file before deleting. The entire receivings cost file is no longer archived
before the deletion.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
FLCOSEXP.OBJ
FLRECUPD.OBJ
RSRCCENT.OBJ
Release: August 9, 2010
SouthWare Connector 2.0.045a
- Fixed: When working
in SouthWare AP Transaction Maintenance, receivings cost records were sometimes
deleted before they should have been, and also it seemed that other records
were missing from the cost file. The problem was two-fold. Program FLCOSEXP did
not account for partial invoicings, and SouthWare program RSRCCENT qualified
and filtered other records when displaying in the grid. This caused certain records
to appear to be missing, when in fact, they weren’t. FLCOSEXP now accommodates
partial invoicings, and some of the SouthWare filtering in RSRCCENT has been
removed to allow all records to display in the grid when applying subsequent
invoices for lines that were partially invoiced before. RSRCCENT has also been
modified to prevent the ‘Invoice remaining quantity later?’ question when
invoiced in full.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
FLCOSEXP.OBJ
FLRECUPD.OBJ
RSRCCENT.OBJ
Release: July 30, 2010
SouthWare Connector 2.0.045
- Revised SouthWare
EOD program RSBILREG to allow tax GL account number overrides. These should
first be set up in an XD master record of choice, with the following fields defined:
1. Tax Code, internal field 6, 10 characters, 2. Location, internal field 7, 3
characters, 3. GL Account, internal field 1, 18 characters, and populated with
the desire data. The XD used needs to be configured in FLSUMNT, as field 7, XD
for Tax GL Ovr. During processing of taxes, if the program finds a
corresponding Tax Code and Location record in the XD file, then it overrides
with the corresponding GL account number.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
FLSUMNT.OBJ
RSBILREG.OBJ
Release: July 28, 2010
SouthWare Connector 2.0.043b
- Added SouthWare
Product Category Maintenance, RSCATMNT, so that category mappings can be
configured before connection of a pre-existing SouthWare site.
- Fixed: Connection of
contact addresses AgentID sometimes caused errors because the AgentID was not
in FrontLine. This was due to an initial attempt to connect a blank sales
person number and assignment of a cross-reference ID to it. Connection of
contact addresses no longer populates AgentID when the sales person number is
blank.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
APVNDMNT.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSCATMNT.OBJ
Release: July 23, 2010
SouthWare Connector 2.0.043a
- Removed revision
from 2.0.042a for recurring billing GL account override.
- Revised special RCV
version of PG recurring billing order line script to override GL income account
based on related service code.
- Added description to
recurring billing GL transaction details.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs and scripts are (PG
scripts need to be updated to the database):
FLRECBIL.OBJ
ExSwOrdHRB.FMT
ExSwOrdHRB.SQL
pgExSwOrdHRB.SQL
pgExSwOrdHRBC.SQL
pgExSwOrdLRB_RCV.SQL
Release: July 22, 2010
SouthWare Connector 2.0.043
- Revised receivings
line export to filter out package item lines.
- Fixed: Credit memos
created in the same day as their related invoice connected, but without their
lines. This was because the tagging script expected to find untagged lines, and
FrontLine credit memos use the same lines as the original invoice, which had
already been tagged for the invoice export.
The tagging script no longer uses TRX[IP].SyncSet = NULL as a line
tagging criteria.
- This revision
applies to SouthWare Rev 14a and 15, and revised scripts are (PG scripts need
to be updated to the database):
ExSwRecvL.SQL
ExSwRecvLIP.SQL
ExSwTagNewExp.SQL
ExSwTagNewExpbyLoc.SQL
pgExSwRecvL.SQL
pgExSwRecvLIP.SQL
pgExSwTagNewExp.SQL
pgExSwTagNewExpbyLoc.SQL
Release: July 21, 2010
SouthWare Connector 2.0.042a
- Revised recurring
billing order header export script to accommodate non-standard Equipment Set
detail setup where maintenance contract units carry amounts. The related
service code is connected as an additional field in the order header, imported
in an Extended Data field of choice, and WorkFlow used to convert the GL
accounts to those of the service code.
- This revision
applies to SouthWare Rev 14a and 15, and revised scripts are (PG scripts need
to be updated to the database):
ExSwOrdHRB.FMT
ExSwOrdHRB.SQL
pgExSwOrdHRB.SQL
pgExSwOrdHRBC.SQL
Release: July 21, 2010
SouthWare Connector 2.0.042
- Fixed: AP invoice costing
connection was truncating the last digit from SouthWare right-justified
- This revision
applies to SouthWare Rev 14a and 15, and revised program is:
FLCOSEXP.OBJ
Release: July 15, 2010
SouthWare Connector 2.0.040
- Revised recurring
billing order header export script to convert the order header customer to the
BillTo address BillTo Other customer when BillTo Other is populated.
- This revision
applies to SouthWare Rev 14a and 15, and revised scripts are (PG scripts need
to be updated to the database):
ExSwOrdHRB.SQL
pgExSwOrdHRB.SQL
Release: July 14, 2010
SouthWare Connector 2.0.029c
- Fixed: Problem with
tagging of sales orders was caused by incorrectly coded DbTxUtil configuration
file. Tagging script should have been in second section of script but that
section marker had gone missing. This should not affect customers who are
running the newer configuration file, DTU_FLORDEXL.INI.
Note: There could be a
potential problem with tagging orders for connection if users run AP-01-01 (AP
Transaction Maintenance) at the same time as they run AR-01-04-01-04 (AR
Invoicing Adapter). This is because both tagging scripts share the same
SYNCLOG.SyncType and SyncSet column in invoices and orders. To make
sales/service order and purchase order tagging completely independent, we would
need to change purchase order tagging to use another SyncType and possibly add
another SyncSet column in the invoice and order tables. This was not a problem
when users got everyone out of their systems when they ran EOD, but they no
longer seem to do that.
- This revision
applies to SouthWare Rev 14a and 15 on MS-SQL, and revised configuration file
is:
DTU_FLORDEXP.INI
Release: July 8, 2010
SouthWare Connector 2.0.029b
- Fixed: Problem with
inventory adjustments that caused out of balance GL transactions had been fixed
in Rev 14a in 2.0.0001, but not moved to Rev 15. The fix is now in Rev 15.
- This revision
applies to SouthWare Rev 15, and revised program is:
FLGLTUPD.OBJ
Release: June 24, 2010
SouthWare Connector 2.0.029a
- Fixed: Vendor
connections were still assigning terms code in the old way, which usually
resulted in no AP terms code assignment. Programs now assign AP terms code IDs
that began to be connected in 1.6.010.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs are:
APVNDMNT.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: June 16, 2010
SouthWare Connector 2.0.029
- Revised recurring billing
update program to perform unearned revenue routine only when the unearned
revenue account (XD157 Field 11) is present. The recurring billing order line
script now exports this field as blank unless modified to export the unearned
revenue account.
- This revision
applies to SouthWare Rev 14a and 15, and revised programs and scripts are (PG
scripts need to be updated to the database):
FLRECBIL.OBJ
ExSwOrdLRB.SQL
pgExSwOrdLRB.SQL
Release: June 16, 2010
SouthWare Connector 1.5.241
- Revised recurring
billing update program to perform unearned revenue routine only when the
unearned revenue account (XD157 Field 11) is present. The recurring billing
order line script now exports this field as blank unless modified to export the
unearned revenue account.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (PG scripts need to be updated to the database):
FLRECBIL.OBJ
ExSwOrdLRB.SQL
pgExSwOrdLRB.SQL
Release: June 8, 2010
SouthWare Connector 2.0.022b
- The order line item
export script now has an additional field, ItemTypeFlag, which will be used by
SouthWare WorkFlow to reassign GL account numbers based on item type. This was
required because all lines are not being connected as service item type, and
pre-existing workflows no longer worked. The item type flags are I=Inventory,
N=Non-Stock, S=Service, C=Charge.
Note: This revision
requires a revision to the ImportMate FLORDHDR template to import field 41 of
the order line import file to RS08 Field 83 (BOM Kit ID). The latter is one of
very few fields to which we could import this data, and was not an active
field.
- This revision
applies to SouthWare Rev 14a and 15, and revised scripts are (PG scripts need
to be updated to the database):
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
Release: June 8, 2010
SouthWare Connector 1.5.240b and 2.0.022a
- Fixed: The order
header export script output credit memos as partially invoiced. It should now
output them as fully invoiced.
- This revision
applies to SouthWare Rev 11, 12, 13, 14a and 15, and revised scripts are (PG
scripts need to be updated to the database):
ExSwOrdH.SQL
pgExSwOrdH.SQL
Release: June 2, 2010
SouthWare Connector 2.0.022
- Fixed: The SouthWare
Receivings Cost Entry and Edit program did not allow the user to modify the
invoiced quantity. This has been fixed.
- Fixed: The AP
invoice cost connector gave an error when the Receivings Cost File contained
both right and justified
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs are:
FLCOSEXP.OBJ
RSRCCENT.OBJ
Release: May 18, 2010
SouthWare Connector 2.0.019
- Fixed: Order
discounts were connecting without GL account numbers. This is because FrontLine
order discounts are not related to an item, so with no ItemCat, queries were
unable to retrieve GL account numbers. Discounts now use the ItemCat Z01, which
should always be added to the ITEMCATS table for each location that uses order
discounts. The description of this ItemCat should be Adjustments. The location
used for retrieval of the account number is the order header location.
- Fixed: The order
update program was reconnecting all invalid short order numbers (less than 10
digits) as if they were credit memos. This was true in the past, but now that
open orders are being imported into FrontLine from SouthWare or other back
office, there are additional short order numbers that are not credit memos.
Credit memos still connect with 9 digit order numbers, and the program expects
them to always be in the workstation range of 79.
- Fixed: PG recurring
billing scripts still had some problems which have been resolved.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PG scripts need to be updated to the database):
DTU_FLRBLEXP.INI
FLORDUPD.OBJ
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
Release: May 17, 2010
SouthWare Connector 2.0.018
- Added minimal
connection of salespersons from FrontLine to the SouthWare Salesman File prior
to import of FrontLine orders. If the salesperson does not exist in SouthWare,
it is created as an active Salesman with only the Salesman Code and Initials
fields populated.
- Fixed: PG scripts
were connecting order discounts as *ORDDISC, instead of ORDDISC.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PostgreSQL scripts need to be updated to the database):
FLLINUPD.OBJ
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
Release: April 27, 2010
SouthWare Connector 2.0.001
- Added connection of inventory
adjustments to SouthWare GL. This connection takes place at the end of the
SouthWare End of Day process. For systems already running 2.0.x,
pgTagNewExpInvAdj.SQL replaces pgTagNewExpTrans.SQL, which has been eliminated.
- Fixed problem with
sales/service order connection of non-stock lines. These lines are still
converted to Service type as before, and the part number changed to CATALOG.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PostgreSQL scripts need to be updated to the database):
DTU_FLGLTEXP.INI
FLGLTUPD.OBJ
FLLINUPD.OBJ
ExSwInvAdjL.SQL
ExSwInvAdjLIP.SQL
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
TagNewExpInvAdj.SQL
pgExSwInvAdjL.SQL
pgExSwInvAdjLC.SQL
ogExSwInvAdjLIP.SQL
ogExSwInvAdjLIPC.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
pgTagNewExpInvAdj.SQL
pgTagNewExpInvAdjC.SQL
Release: April 23, 2010
SouthWare Connector 2.0.000
- Revised the
receivings connection to right justify the PO Number and Document Number for
compatibility with pre-existing records in the SouthWare Receivings Cost File.
Also modified APTRXMNT to right-justify the PO Number displayed after entry.
- Revised receivings
cost connection to left justify the PO Number before connecting unit cost to FrontLine.
- Added import flag to
the receivings export file to prevent duplicate import.
- Revised order line,
receivings, and inventory transfer export scripts to override Inventory and
ClearInventory accounts retrieved using ItemCat and LocationID during export,
with ones found on FrontLine order line, when present.
- Added connection of
Agent email address from SouthWare to FrontLine Agent PayTo address.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PostgreSQL scripts need to be updated to the database):
APTRXMNT.OBJ
ARSHDRMN.OBJ
ARSMANMN.OBJ
FLCOSEXP.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLRECUPD.OBJ
FLSQLIMP.OBJ
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
ExSwRecvL.FMT
ExSwRecvL.SQL
ExSwRecvLIP.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
pgExSwRecvL.SQL
pgExSwRecvLC.SQL
pgExSwRecvLIP.SQL
pgExSwRecvLIPC.SQL
Test Release: April 6, 2010
SouthWare Connector 1.6.025a
- To document naming
changes made to the back office order conversion scripts. See 1.6.017e for the
initial release of these scripts. Note that there are some additional
PostgreSQL functions and that there are no longer any C calling scripts. All
scripts are now executed interactively and incrementally.
- This revision
applies to SouthWare Rev 14a and 15, and new and revised scripts are
(PostgreSQL scripts need to be updated to the database):
OrderCreateTables.SQL
OrderImport.SQL
OrderValidate.SQL
pgOrderCreateTables.SQL
pgOrderImport.SQL
pgOrderValidate.SQL
pgOrdImpEquipDtlID.SQL
(new function)
pgOrdImpEquipUI.SQL
(new function)
pgOrdImpNonserialDtlID.SQL
(new function)
pgOrdImpOrderID.SQL
(new function)
pgOrdImpSerialDtlID.SQL
(new function)
pgOrdImpSerialUI.SQL
(new function)
DTU_OrderImport.INI
Test Release: March 25, 2010
SouthWare Connector 1.6.025
- Revised the initial
connector to only connect SouthWare sold serial units when the sold customer
specified is a valid AR Customer.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled program is:
FLINIEXP.OBJ
Test Release: March 18, 2010
SouthWare Connector 1.6.017h
- Revised the initial
connector to connect the SouthWare Stock File Average and Last Cost fields to
the corresponding fields in the FrontLine ITEMCOST table, and also to connect
the Sell Cost Method to the FrontLine ITEMS table Costing field. This revision
is part of the process that is run using the /I option.
- Revised the periodic
connector to connect the SouthWare Stock File Average and Last Cost fields to
the corresponding fields in the FrontLine ITEMCOST table, and also to connect
the Sell Cost Method to the FrontLine ITEMS table Costing field. This revision
is part of the process that is run using the /C option, and expects that stock
items and locations have been connected previously.
- Note: Although the
ITEMCOST table can be updated using FLPEREXP/C, this revision also requires
that all stock items be reconnected (FLPEREXP/I), since the Sell Cost Method is
a column in the ITEMS table. Remember to tag the stock records with a new
update date so that FLPEREXP will see them as having been updated.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are:
FLINIEXP.OBJ
FLPEREXP.OBJ
DTU_FLINIEXP.INI
DTU_FLPEREXP.INI
Test Release: March 15, 2010
SouthWare Connector 1.6.017g
- Revised the periodic
connector to connect the SouthWare Product Category File to the FrontLine
ITEMCATS table on systems that are already connected to FrontLine. Location
codes and GL account numbers must have already been connected in order to have
a successful connection. The Product Category File must also be configured with
necessary flags and fields to connect ITEMCATS TaxCat, UISet, and ItemType.
This connection is performed with the /C option.
- Fixed: The DbTxUtil
configuration script for FLINIEXP for PostgreSQL was missing the entries for
this connection.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are:
FLPEREXP.OBJ
DTU_FLINIEXP.INI
(pgSQL)
DTU_FLPEREXP.INI
Test Release: March 11, 2010
SouthWare Connector 1.6.017f
- Revised customer
export script to no longer reconnect the customer record to SouthWare when a
FrontLine contact is added or changed. The contact fields still export whenever
a customer record reconnects, but need to have their update disabled in the
SouthWare FLCUST ImportMate template. Remove Contact and Phone Number (in
fields 8 and 9 of customer import file).
- Revised customer
cross-referencing program to no longer create a cross-reference record for
contacts.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PostgreSQL scripts need to be updated to the database):
FLCUSXRF.OBJ
ExSwCust.SQL
ExSwCust_CN.SQL
pgExSwCust.SQL
pgExSwCust_CN.SQL
Release: March 11, 2010
SouthWare Connector 1.5.240a
- Revised customer
export script to no longer reconnect the customer record to SouthWare when a
FrontLine contact is added or changed. The contact fields still export whenever
a customer record reconnects, but need to have their update disabled in the
SouthWare FLCUST ImportMate template. Remove Contact and Phone Number (in
fields 8 and 9 of customer import file).
- Revised customer
cross-referencing program to no longer create a cross-reference record for
contacts.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised and recompiled
programs and scripts are (PostgreSQL scripts need to be updated to the
database):
FLCUSXRF.OBJ
ExSwCust.SQL
ExSwCust_CN.SQL
pgExSwCust.SQL
pgExSwCust_CN.SQL
Test Release: March 10, 2010
SouthWare Connector 1.6.017e
- Added utility
scripts to connect delimited files, prepared from SouthWare open and history sales,
service, and purchase orders to corresponding FrontLine orders. History orders
also create FrontLine invoices. No partially fulfilled sales or service order
lines, or partially received purchase orders will be created in FrontLine, so
any partial fulfillments or receivings need to be completed, invoiced, and
posted in SouthWare before creating the delimited files.
- Excel templates for
creation of the delimited files are in the connector documentation folder as:
OrderHeaders.XLS
OrderLines.XLS
OrderUnits.XLS
- There is a text file
with additional information about the layouts, named OrderLayouts.TXT
- Taxes on open orders
should be recalculated when the order is opened in FrontLine.
- Note: Missing is a
script to relate new item details to their appropriate pre-existing parent
detail in FrontLine.
- This revision
applies to SouthWare Rev 14a and 15, and new scripts are (PostgreSQL scripts
need to be updated to the database):
OrderCreateTables.SQL
OrderValidate.SQL
OrderImport.SQL
pgOrderCreateTables.SQL
pgOrderCreateTablesC.SQL
pgOrderValidate.SQL
pgOrderValidateC.SQL
pgOrderImport.SQL
pgOrderImportC.SQL
DTU_OrderImport.INI
Test Release: March 8, 2010
SouthWare Connector 1.6.017d
- Revised to no longer
connect the primary UIType of the ItemCat in LISTVALS.Attributes, since this
field is now under FrontLines’s control. Also removed this field in the order
line export script when outputting the equipment serial number.
- This revision
applies to SouthWare Rev 14a and 15, and revised and recompiled programs and
scripts are (PostgreSQL scripts need to be updated to the database):
APVNDMNT.OBJ
ARSHIPVM.OBJ
ARTERMSM.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLORDEXP.OBJ
FLPEREXP.OBJ
FLRBEXP.OBJ
FLSQLIMP.OBJ
GLACTMNT.OBJ
ExSwOrdL.SQL
pgExSwOrdL.SQL
Test Release: March 1, 2010
SouthWare Connector 1.6.017c-15
- Upgraded for
compatibility with SouthWare Rev 15.
- This revision
applies to SouthWare Rev 15, and includes the same programs as 1.6.017c, with
the exception that RSBILPYM has been dropped from FrontLine distribution.
Test Release: February 18, 2010
SouthWare Connector 1.6.017c
- Fixed: Recurring
billing connection did not create back office service items on the fly.
FLRECBIL now calls out to FLLINUPD to do this.
- This revision
applies to SouthWare Rev 14a, and revised and recompiled programs are:
FLLINUPD.OBJ
FLRECBIL.OBJ
Test Release: February 16, 2010
SouthWare Connector 1.6.017b
- Revised the initial
connector to allow for connection of inventory data (FLINIEXP/I). This option
will be used with the client has a pre-existing SouthWare I/S system. The /I
option replaces the FLXREF file and deletes pre-existing connector files, the
same as the /R option.
- Revised the initial
connector to connect the SouthWare Product Category File to the FrontLine
ITEMCATS table. The Product Category File must be configured with necessary
flags and fields to connect ITEMCATS TaxCat, UISet, and ItemType.
- This revision
applies to SouthWare Rev 14a, and revised and recompiled programs and scripts
are:
APTRXMNT.OBJ
FLADDIMP.OBJ
FLCUSEXP.OBJ
FLCUSXRF.OBJ
FLINIEXP.OBJ
FLLINUPD.OBJ
FLORDEXP.OBJ
FLPEREXP.OBJ
FLRBEXP.OBJ
FLSQLIMP.OBJ
FLTAXIMP.OBJ
FLVNDXRF.OBJ
RSBILENT.OBJ
RSBILREG.OBJ
RSBILUP1.OBJ
RSRCCENT.OBJ
DTU_FLINIEXP.INI
Release: February 15, 2010
SouthWare Connector 1.5.240
- Revised SouthWare to
FrontLine customer connection to not populate CUSTOMERS.ExemptCode with the AR
Customer Tax Number.
- Revised recurring
billing connection to ensure that GL transaction number has not been previously
used.
- Revised recurring
billing connection to use ORDERS.Placed as the Invoice Date, and to create GL
transactions for monthly bill frequency. All clients must now need to use
unearned revenue.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (PostgreSQL scripts need to be updated to the database):
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLRECBIL.OBJ
FLSQLIMP.OBJ
ExSwOrdHRB.SQL
ExSwOrdLRB.SQL
pgExSwOrdHRB.SQL
pgExSwOrdLRB.SQL
Test Release: February 12, 2010
SouthWare Connector 1.6.017a
- Revised SouthWare to
FrontLine customer connection to not populate CUSTOMERS.ExemptCode with the AR
Customer Tax Number.
- Revised GL transaction
creation programs to ensure that GL transaction number has not been previously
used. Also modified inventory transfer program to create one transaction header
per FrontLine invoice (
- Revised recurring
billing connection to use ORDERS.Placed as the Invoice Date, and to create GL
transactions for monthly bill frequency. All clients must now need to use
unearned revenue.
- Revised transfer
connection script to use presence of ORDERS.SourceLocation as part of selection
criteria.
- This revision applies
to SouthWare Rev 14a, and revised programs and scripts are (PostgreSQL scripts
need to be updated to the database):
FLCUSEXP.OBJ
FLGLTUPD.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLRECBIL.OBJ
FLSQLIMP.OBJ
ExSwOrdHRB.SQL
ExSwOrdLRB.SQL
ExSwTransL.SQL
ExSwTransLIP.SQL
TagNewExpTrans.SQL
pgExSwOrdHRB.SQL
pgExSwOrdLRB.SQL
pgExSwTransL.SQL
pgExSwTransLIP.SQL
pgTagNewExpTrans.SQL
Test Release: February 9, 2010
SouthWare Connector 1.6.017
- Revised connection
of costing information from SouthWare payables for compatibility with FrontLine
CostInvoice procedure.
- Revised connection
of unit cost from FrontLine to use new TRXINVCOST table as source table.
- Fixed: The MSSQL
format file used by DbTxUtil for receivings connection had an extra field that
shifted output.
- Fixed: SouthWare
service codes the connector creates on the fly were created with some fields
incorrectly formatted. Also added inventory account to fields being updated.
- Fixed: The order
update program was still updating order line item back ordered quantity even
though service codes should not have this.
- This revision
applies to SouthWare Rev 14a, and revised programs and scripts are (PostgreSQL
scripts need to be updated to the database):
FLCOSEXP.OBJ
FLLINUPD.OBJ
FLORDUPD.OBJ
DTU_FLCOSEXP.INI
ExSwOrdL.SQL
ExSwOrdLIP.SQL
TagNewExp.SQL
TagNewExpbyLoc.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgTagNewExp.SQL
pgTagNewExpbyLoc.SQL
Test Release: January 18, 2010
SouthWare Connector 1.6.016a
- Added connection of
SouthWare AR Customer Tax ID field. Connection routine strips any special
characters and alphas, compresses, and left justifies the field. If the first 9
characters of the resulting field are numeric, the field is connected to FrontLine
CUSTOMERS.TaxID.
- This revision
applies to SouthWare Rev 14a, and revised programs are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: January 18, 2010
SouthWare Connector 1.5.226g
- Added connection of SouthWare
AR Customer Tax ID field. Connection routine strips any special characters and
alphas, compresses, and left justifies the field. If the first 9 characters of
the resulting field are numeric, the field is connected to FrontLine
CUSTOMERS.TaxID.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Test Release: January 15, 2010
SouthWare Connector 1.6.016
- Revised 1.6 to
support PostgreSQL.
- This revision applies
to SouthWare Rev 14, and new and revised programs and scripts are (PostgreSQL
scripts need to be updated to the database):
DTU_APTRMMNT.INI
DTU_FLCOSEXP.INI
DTU_FLGLTEXP.INI
DTU_FLRECEXP.INI
pgCreateTaxAdj.SQL
pgCreateTaxAdj_manual.SQL
pgExSwAddrV.SQL
pgExSwAddrVC.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
pgExSwRecvL.SQL
pgExSwRecvLC.SQL
pgExSwRecvLIP.SQL
pgExSwRecvLIPC.SQL
pgExSwTransL.SQL
pgExSwTransLC.SQL
pgExSwTransLIP.SQL
pgExSwTransLIPC.SQL
pgExSwVend.SQL
pgExSwVendC.SQL
pgTagNewExp.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpRecv.SQL
pgTagNewExpRecvC.SQL
pgTagNewExpTrans.SQL
pgTagNewExpTransC.SQL
Release: January 14, 2010
SouthWare Connector 1.5.226f
- Fixed: The program
to connect special orders was incorrectly handling the exported miscellaneous
Unit Cost field.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised program is:
FLSPOUPD.OBJ
Test Release: December 17, 2009
SouthWare Connector 1.6.014
- Added GL transaction
update for stock transfers. These are updated at the end of the End of Day
process.
- This revision
applies to SouthWare Rev 14, and new and revised programs and scripts are:
FLGLTUPD.OBJ
RSBILUP2.OBJ
DTU_FLGLTEXP.INI
DTU_FLORDEXP.INI
DTU_FLORDEXL.INI
ExSwTransL.FMT
ExSwTransL.SQL
ExSwTransLIP.SQL
TagNewExpTrans.SQL
Test Release: November 17, 2009
SouthWare Connector 1.6.010
- Major update for
compatibility with FrontLine 5.6.0010 which includes Purchasing and Receiving.
Inventory files are no longer stored in SouthWare, but are stored and
maintained solely in FrontLine. FrontLine sales orders and stock transfers are
now connected to SouthWare using the A/R Invoicing Adapter (AR-01-04-01-04).
FrontLine receivings are connected to SouthWare whenever a user starts up A/P
Transaction Maintenance (AP-01-01). A/P vendor invoice and cost information is
connected to FrontLine whenever a user posts A/P transactions (AP-01-03).
- The initial connector
no longer connects stock locations, product categories, warranty types, unit of
measure codes, stock items, cross-reference parts, and service codes from
SouthWare to FrontLine, nor are these items connected by their respective
maintenance programs. Locations and items used in FrontLine are now connected
from FrontLine to SouthWare as required for validation during the sales order
import process. The required services CATALOG and ORDDISC are created
automatically, and no longer require manual creation. Vendors are now connected
from FrontLine to SouthWare as required for validation during the receivings
import process.
- Note: SouthWare
Inventory/Sales files required by the A/R Invoicing Adapter must be added to
the company folder. These can be found in the corresponding Beta company folder
for the connector program objects.
- Note: There are now
additional fields being connected for sales/service order lines. These fields
need to be modified as Import in the FLORDHDR ImportMate template for RS08, and
are Description 1 from field 33, Description 2 from 34, Description 3 from 35,
Unit Cost from 36, Sales Acct from 37, Inventory Acct from 38, Cost of Sales
Acct from 39, NSPartNumber from 40. NS Part Number needs to be set up as a new
XD157 field (15, ALPH, 30).
- Note: AP Terms codes
are now connected, and requires distinction from AR Terms codes as follows: For
AR Terms LISTVALX.LCat = 0, For AP Terms LISTVALX.LCat = 1. To ensure proper
function on all previously installed systems, all pre-existing AR Terms codes
in FrontLine must be updated to LISTVALX.LCat = 0.
- Note: Population of
the FrontLine LOCATIONS, ITEMCATS, and ITEMS tables must be performed before
running the sales order export process.
- Note: AP-07-02 Field
7 (Interface to Purchasing?) must be set to N in order for AP-01-01 to work
correctly without SouthWare Purchasing.
- The following
Ormandy programs are no longer active connector programs:
FLBKOUPD.OBJ
FLCQUPD.OBJ
FLI21EXP.OBJ
FLIMAPMN.OBJ
FLINIEX2.OBJ
FLINVEXP.OBJ
FLMOLMOP.OBJ
FLMOLUPD.OBJ
FLSERUP1.OBJ
FLSERUPD.OBJ
FLSERXRF.OBJ
FLSPOUPD.OBJ
- The following
SouthWare programs are no longer active connector programs, and need to be
replaced by generic SouthWare programs:
ARPROMNT.OBJ
POAUTLPS.OBJ
RSBOUPD.OBJ
RSCATMNT.OBJ
RSLOCMNT.OBJ
RSSTKMNT.OBJ
RSUMMNT.OBJ
RSXRFMNT.OBJ
SVSVCMN1.OBJ
- The following
SouthWare programs are no longer active connector programs, and need to be
replaced by non-FrontLine custom Ormandy versions:
RSRECPST.OBJ
RSTRXLST.OBJ
RSTRXMNT.OBJ
- There is a new
SouthWare ImportMate template, FLVEND, which is used by program FLRECUPD.
- Fixed: Entry of all
categories did not work in the recurring billing export. This has been fixed.
- Note: This version
works only with FrontLine on Windows and MS-SQL.
- This revision
applies to SouthWare Rev 14, and new and revised programs and scripts are:
APTRMMNT.OBJ
APTRXMNT.OBJ
APTRXPST.OBJ
ARSHIPVM.OBJ
ARTERMSM.OBJ
FLADDIMP.OBJ
FLCOSEXP.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLLINUPD.OBJ
FLORDEXP.OBJ
FLORDUPD.OBJ
FLPEREXP.OBJ
FLRBEXP.OBJ
FLRECBIL.OBJ
FLRECUPD.OBJ
FLSQLIMP.OBJ
RSBILCST.OBJ
RSBILENT.OBJ
RSBILREG.OBJ
RSBILUP1.OBJ
RSBILUP2.OBJ
RSRCCENT.OBJ
DTU_APTRMMNT.INI
DTU_FLCOSEXP.INI
DTU_FLORDEXL.INI
DTU_FLRECEXP.INI
ExSwAddrV.SQL
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
ExSwRecvL.FMT
ExSwRecvL.SQL
ExSwRecvLIP.SQL
ExSwTransL.FMT
ExSwTransL.SQL
ExSwTransLIP.SQL
ExSwVend.FMT
ExSwVend.SQL
TagNewExp.SQL
TagNewExpbyLoc.SQL
TagNewExpRecv.SQL
TagNewExpTrans.SQL
Release: September 17, 2009
SouthWare Connector 1.5.226e
- Revised earlier
1.5.0195 recurring billing
import/update program revision to create GL journal transactions rather than
recurring transactions.
- Fixed: The program
to export recurring billing by ES category did not work when selecting all
categories.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
FLRBEXP.OBJ
FLRECBIL.OBJ
Release: August 24, 2009
SouthWare Connector 1.5.226d
- Fixed: The order tax
export script reversed the sign on the credit memo taxable and tax amounts. It
didn’t need to do that, and has been fixed.
- Fixed: The order
update program failed due to a disparity between the justification of the
Extended Data invoice number and the actual imported order number.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (PostgreSQL scripts need to be updated to the database):
FLORDUPD.OBJ
ExSwOrdT.SQL
pgExSwOrdT.SQL
Release: August 18,
2009
SouthWare Connector 1.5.226c
- Fixed: Connecting
*-misc items with quantity of 999,999,999 caused a PostgreSQL numeric overflow.
These quantity connections have been trimmed back to 999,999.
- Fixed: When an order
and its related credit memo were entered in the same day, the credit memo
preceded the earlier order in chronological day’s connections. This has been
fixed to connect the minimum non-credit memo InvSeq, as well as any credit
memos. This revision needs to be thoroughly tested!
- This revision applies
to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts are
(PostgreSQL scripts need to be updated to the database):
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
TagNewExp.SQL
pgTagNewExp.SQL
Release: August 10, 2009
SouthWare Connector 1.5.226b
- Fixed: When a credit
memo (9-digit Order Number) occurred as the first order in the order import
file, the routine to verify the success of the import failed. The routine now
unstrings based on the delimiter rather than assuming a 10-digit Order Number.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
FLORDUPD.OBJ
Release: July 15, 2009
SouthWare Connector 1.5.226a
- Fixed: When a
customer Name2 was added in FrontLine, but prior to connection of it to
SouthWare, the customer was reconnected from SouthWare, it caused the FrontLine
field to be wiped out. Connection of ADDRESSES.Name2 existed to satisfy a
requirement by a former client. It has now been removed. No ADDRESSES records
connect the Name2 field from SouthWare to FrontLine.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
APVNDMNT.OBJ
ARSMANMN.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSLOCMNT.OBJ
Release: July 6, 2009
SouthWare Connector 1.5.226
- Revisions to credit
memo connection. Revised tagging script to populate the new INVOICES.CreditID
field when appropriate. Revised to concatenate INVOICES.CreditID plus 0 when
constructing the SouthWare Order Number, INVOICES.OrderID plus INVOICES.InvSeq
* -1 when constructing the SouthWare ApplyTo Number, and INVOICES.CreditID plus
INVOICES.InvSeq * -1 when constructing the SouthWare Invoice Number. Revised to
connect real FrontLine OrderID and InvSeq when reconnecting error invoices.
Also revised to allow credit memos to connect when entered in the same day as
the original invoice.
Note: CreditID can be
set to assign in any non-workstation counter space as long as it does not
conflict with normal workstation orders and recurring bills. Currently it is
set to assign at 79, producing Order Numbers 79000000 through 79999999. A
script change is required to make this change.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (PostgreSQL scripts need to be updated to the database):
FLORDUPD.OBJ
TagNewExp.SQL
pgTagNewExp.SQL
ExSwOrdH.SQL
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdP.SQL
ExSwOrdS.SQL
ExSwOrdT.SQL
pgExSwOrdH.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdP.SQL
pgExSwOrdS.SQL
pgExSwOrdT.SQL
Release: June 24, 2009
SouthWare Connector 1.5.218b
- Revised to connect
the PO Number for SouthWare auto-generated purchase orders that represent
FrontLine special orders, to a FrontLine order identifier. The revision requires
that a FrontLine order identifier be set up for the PO Number. It also uses a
record in the existing XD Mapping File with the File Name = IV06 and Field
Number = 1, and the Identifier Number set to the appropriate FrontLine order
identifier for PO Number. This revision is a workaround to have the PO Number
visually referenced to the related FrontLine order until purchasing is in
FrontLine.
- This revision
applies to SouthWare Rev 13 and 14, and the revised programs and scripts are
(both the MS-SQL and PostgreSQL scripts need to be updated to the database):
POAUTLPS.OBJ
DTU_POAUTLPS.INI
UpdateOrdUI.SQL
pgUpdateOrdUI.SQL
Release: June 9, 2009
SouthWare Connector 1.5.218a
- Fixed: The Blanket
PO connection routine produced an error when multiple customer Extended Data
mappings were configured and the customer record did not have a related
Extended Data record.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised program is:
FLCUSEXP.OBJ
Release: June 1, 2009
SouthWare Connector 1.5.218
- Revised to
accommodate negative FL InvSeqs for credit memos. FrontLine InvSeqs -1 through
-9, corresponding to credit memos for InvSeqs 1 through 9, convert to A through
I for SouthWare and become the 10th character of the SouthWare Invoice
Number (Example: FrontLine OrderID 101000023, InvSeq -3 becomes SouthWare
Invoice Number 10100023C). Reconnected
credit memos, from SouthWare to FrontLine convert in reverse fashion, with the
SouthWare Invoice Number 10th character A through I converting to
FrontLine InvSeqs -1 through -9 respectively.
- Revised to connect
recurring bills invoice date as FrontLine ORDERS.Scheduled, instead of
ORDERS.Placed. This date is the same as the FrontLine Next Bill Date, and is a
better candidate to become the SouthWare GL Post Date.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised programs and
scripts are (update PostgreSQL scripts to database):
FLORDUPD.OBJ
ExSwOrdH.SQL
ExSwOrdHRB.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
Release: June 1, 2009
SouthWare Connector 1.5.211f
- Fixed: The
connection of the SouthWare AR Open Posted Time field was incompatible with SQL
when the seconds portion of the time was equal to 60. This has been revised to
convert seconds=60 to seconds=00.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised program is:
FLAROEXP.OBJ
Release: May 18, 2009
SouthWare Connector 1.5.211e
- Adds a program and
related scripts to fix the stock file problem caused by the committed quantity update
bugs of 1.5.0196. This program is to be run one time on systems that have been
using 1.5.0196 or later versions of the connector. It zeroes out all SouthWare
stock file committed quantities and then resets them from previously connected
quantities on FrontLine orders that are still pending.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised programs and
scripts are (update PostgreSQL scripts to database):
FLCQFIX.OBJ
DTU_FLCQFIX.INI
TagNewCQFIX.SQL
pgTagNewCQFIX.SQL
pgTagNewCQFIXC.SQL
Release: May 11, 2009
SouthWare Connector 1.5.211d
- Fixed: A bug in some
old pager code caused sites without SX006.FIL to encounter an error when
attempting to close that file.
- Fixed: A PostgreSQL
helper script was missing a comma after one of the field names in the SELECT
list.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised programs and
scripts are (update PostgreSQL scripts to database):
RSTRXLST.OBJ
pgExSwOrdLIPC.SQL
Release: April 30, 2009
SouthWare Connector 1.5.211c
- Fixed: Revision
1.5.211a had failed to resolve the issue with reversal of committed quantities.
The program was still not reversing quantities after a return line due the
quantity sign not being reset after the return. This problem has now been
fixed.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised program is:
FLLINUPD.OBJ
Release: April 29, 2009
SouthWare Connector 1.5.211b
- Fixed: The DbTxUtil configuration
file used in connecting the back office AR Open File in PostgreSQL was
referencing an incorrect SQL file. This caused the process to fail to clear the
FrontLine AR table before adding new entries.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised configuration file
is:
DTU_FLAROEXP.INI
Release: April 24, 2009
SouthWare Connector 1.5.0211a
- Fixed: Some
committed quantities were not being reversed in the back office before the
normal order import. This was due to a bug that prevented quantities after a
return line from being seen by the program.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and the revised program is:
FLLINUPD.OBJ
Release: April 17, 2009
SouthWare Connector 1.5.0211
- Replaced references
to TRX (and TRXIP).Account in order line scripts with AccountREV.
- Added connection of
TRX (and TRXIP).AccountCOS to Extended Data XD157 Field 14, as well as added
override of Line Item COS Account after import when populated. This revision
requires the addition of XD157 Field 14 as numeric, 12 digits, and update of
the FLORDHDR ImportMate template to import the appropriate connector delimited
file field to this XD field.
- Revised PostgreSQL
order line scripts for updates related to Stock Number (20) and
- Added new utility
program, FLSVCCNV, to convert SouthWare Services Module data to the
Inventory/Sales Module. Included in this process is the conversion of customer
equipment records to serial tracking records, and conversion of service codes
to stock items. The program assumes some previous setup, including a generic
equipment stock record assigned to the appropriate category and vendor, and
category codes (X,Y,Z) for all the services with GL account numbers that
correspond to those in the service code records. The program backs up files
that will be modified (Serial Tracking File, Stock File, XD006) and creates an
audit spool file.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (update PostgreSQL scripts to database):
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
FLORDUPD.OBJ
FLSVCCNV.OBJ
Release: March 23, 2009
SouthWare Connector 1.5.209
- Motorola MOL scripts
now truncate the third place past the decimal on List Price and Your Price
fields.
- This revision applies
to all versions, and revised scripts are (update PostgreSQL scripts to
database):
pgExSwMOLCat.SQL
pgExSwMOLMO.SQL
MOL_Connect.SQL
MOL_CreateTables.SQL
Release: March 19, 2009
SouthWare Connector 1.5.0200a
- Fixed: The connector
created WARRANTIES records when there were no warranty end dates. It now only
creates a record when there is either a Parts or Service End Date.
- Fixed: Some versions
of PostgreSQL did not allow the use of SUBSTRING with integer fields. This was
overlooked because MS-SQL and other versions of PostgreSQL allow this
condition. All SUBSTRING references were fixed to CAST integer fields to
varchar.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (update PostgreSQL scripts to database):
pgExSwAddr.SQL
pgExSwCust.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
pgExSwOrdNH.SQL
pgExSwOrdS.SQL
pgExSwOrdT.SQL
pgExSwOrdTRB.SQL
pgExSwTaxC.SQL
FLINIEXP.OBJ
FLPEREXP.OBJ
RSBILUP1.OBJ
Release: January 27, 2009
SouthWare Connector 1.5.0200
- Added connection of
SouthWare Extended Data defined for customer Blanket PO Numbers to the
FrontLine BLANKETPO table. There can be as many 20-character alphanumeric
blanket POs set up in AR Customer Extended Data as needed, and then mapped
using program FLXDMPMN. Mapping setup fields are XD RM Field Name (Ex. XD02),
XD Field Number, FL Table Name (=BLANKETPO), and FL Field Name (=EntityOrder).
The Blanket PO Numbers connect when the customer record is connected.
Additional FrontLine BLANKETPO fields, not present in SouthWare, can be
populated in FrontLine. Removal of a PO Number should be performed in both
FrontLine and SouthWare, as there is no delete function from SouthWare.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
DTU_FLCUSEXP.INI
DTU_FLINIEXP.INI
DTU_FLPEREXP.INI
Release: January 12, 2009
SouthWare Connector 1.5.198a
- Fixed: The SouthWare
Receivings Posting Program, RSRECPST, would close files unexpectedly. Also the
program would post receivings twice to the stock file. These problems were
caused by misplaced custom code and standard SouthWare code that had
inadvertently been left active. Both problems have now been corrected.
- This revision
applies only to SouthWare Rev 14 RSRECPST.OBJ.
Release: December 19, 2008
SouthWare Connector 1.5.198
- Added connection of
FrontLine order line item GL Account Number override to SouthWare.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (update PostgreSQL scripts to database):
FLORDUPD.OBJ
ExSwOrdL.SQL
ExSwOrdLIP.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
Release: December 19, 2008
SouthWare Connector 1.5.196
- Added connection of
FrontLine open order line item commited quantity changes to SouthWare. Assuming
that all committed quantities have been connected prior to connection of
orders, the quantities represented in orders are uncommitted prior to importing
the orders. There is a script (OpenOrdersCQ.SQL or pgOpenOrdersCQ.SQL) that
must be run prior to beginning use of FrontLine 5.5.196, which connects all
committed quantities on open orders.
- Program FLCQUPD
should be set up as SouthWare menu button IS-03-01-51. It can be run as needed
before purchasing, and will also run automatically before the EOD FrontLine
order import.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts are
(update PostgreSQL scripts to database):
FLCQUPD.OBJ
FLLINUPD.OBJ
FLORDUPD.OBJ
ExSwCQ.FMT
ExSwCQ.SQL
TagNewExpCQ.SQL
pgExSwCQ.SQL
pgExSwCQC.SQL
pgTagNewExpCQ.SQL
pgTagNewExpCQC.SQL
DTU_FLCQEXP.INI
Release: December 18, 2008
SouthWare Connector 1.5.195
- Added connection of
several new fields for recurring billing to facilitate conversion of GL account
from revenue to unearned revenue when the billing frequency is greater that
Monthly. Also added the creation of recurring journal entries in recurring
billing EOD pre-processing for these billing frequencies.
XD157 should be
revised as follows:
Field 10: Billing Frequency, NUMA, 4
Field 11: Account, NUMA, 12
Field 12: Start Date, DATE, 8
Field 13: End Date, DATE, 8
These fields need to
be updated to import in ImportMate template FLORDHDR as Fields 28, 29, 30, and
31 of the order line item import file.
If the client does not
the require the Unearned Revenue feature use the standard ExSwOrdLRB.SQL (or
pgExSwOrdLRB.SQL for PostgreSQL) queries.
If the client requires
the Unearned Revenue feature:
- Modify
ExSwOrdLRB.SQL (or pgSwOrdLRB.SQL if PostgreSQL), commenting the last four
fields (as named above) and uncommenting the subsequent four with the same
names. Enter the Unearned Revenue Account Number in the line where it says, put Unearned Revenue Account Number here,
and resave the query. If PostgreSQL, make sure that the function is updated in
the database.
- Using program
FLCTLMNT, add a new entry to the FL Control File with Label Name = LastGLTrx, and Last Value = 50.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (update PostgreSQL scripts to database):
FLRECBIL.OBJ
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
pgExSwOrdLRBSub.SQL
DTU_FLRBEXP.SQL
(PostgreSQL)
DTU_FLRBLEXP.SQL
(PostgreSQL)
Release: December 3, 2008
SouthWare Connector 1.5.194
- Added connection of SouthWare
Split Commission Headers to the FrontLine AGENTS table. Once in FrontLine,
these records will connect back to SouthWare during order connection in the
same manner as any other salesperson.
- Fixed: Some OB10
code had been missed in the 1.5.191 upgrade and has now been restored. This was
required since some sites may have both FrontLine and OB10.
- Fixed: Revised MOL
export DbTxUtil IniFile to use catalog .FMT file for packages. It was
referencing a non-existent .FMT file.
- This portion of the revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are:
ARSHDRMN.OBJ
ARSMANMN.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
DTU_FLMOLEXP.INI
- The revision to
RSBILUP1.OBJ applies only to SouthWare Rev 13 and 14.
Release: November 24, 2008
SouthWare Connector 1.5.192a
- Revised PostgreSQL
script syntax for SUBSTRING and LPAD commands that had been working, but began
to cause errors at Diversified. This seems to be due to the version of
PostgreSQL that is installed there.
- This revision
includes revised scripts (update PostgreSQL scripts to database):
pgExSwAddr.SQL
pgExSwBO.SQL
pgExSwCust.SQL
pgExSwCust_CN.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLRB.SQL
pgExSwOrdNH.SQL
pgExSwOrdNL.SQL
pgExSwOrdP.SQL
pgExSwOrdPRB.SQL
pgExSwOrdS.SQL
pgExSwOrdT.SQL
pgExSwPO.SQL
Release: November 10, 2008
SouthWare Connector 1.5.192
- Revised to
facilitate recurring billing export by ESet Category (ESCat). There is a new
program, FLRBEXP, and a new tagging script, pgTaxNewExpRBbyCat.SQL, for this
purpose.
- Revised to expand
the Setup File DSN field from 50 to 100 characters. This is to accommodate
longer DSNs plus Username and Password on *nix systems, since we do not want
the password in DbTxUtil configuration files. The Setup File has now been
padded with extra filler to accommodate future additions without recompiling
programs. However, this revision still requires that the Setup File
(FLSETUP.FIL) be renamed and then recreated using the new FLSUMNT program.
- Revised order
payment SQL script to include payment type ATM.
- Revised order line
SQL scripts to default to items destination as INVENTORY instead of mixed which
included SERVICES.
- Fixed: PostgreSQL
order tax SQL scripts were omitting the leading zero from TaxType in
concatenated tax codes.
- Fixed: PostgreSQL
order tagging by location SQL script had invalid syntax that was introduced in .0182.
- Fixed: PostgreSQL
recurring billing tagging script still had untested invalid syntax in UPDATE
statements.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and includes all .OBJ files.
- This revision also
includes revised configuration files and scripts (update PostgreSQL scripts to
database):
DTU_FLCATUPD.INI
DTU_FLRBLEXP.INI
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdP.SQL
TaxNewExpRBbyCat.SQL
pgExSwOrdL.SQL
pgExSwOrdLIP.SQL
pgExSwOrdP.SQL
pgExSwOrdTRB.SQL
pgTaxNewExpRB.SQL
pgTaxNewExpRBbyCat.SQL
pgTaxNewExpRBbyLoc.SQL
Release: November 5, 2008
SouthWare Connector 1.5.191a
- Upgraded to latest
SouthWare Rev 14 code.
- This revision
applies to SouthWare Rev 14 only and includes all .OBJ files.
Release: November 4, 2008
SouthWare Connector 1.5.191
- Upgraded to latest
SouthWare Rev 13 code.
- This revision
applies to SouthWare Rev 13 only and includes all .OBJ files.
Release: October 29, 2008
SouthWare Connector 1.5.188b
- Fixed XD Control
File open/close issue in RSBILUP1 that was introduced in .0188. Program should
be upgraded at all sites.
- Revised export
scripts to truncate
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs and scripts
are (update PostgreSQL scripts to database):
RSBILUP1.OBJ
ExSwOrdL.SQL
ExSwOrdLIP.SQL
ExSwOrdLRB.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
Release: October 22, 2008
SouthWare Connector 1.5.188a
- Revised file open
logic in several programs due to problem found in compatibility with Red Hat 9
at Frontier. These three programs were programmed by another programmer and
used unnecessary directory change logic to open files. The old logic had always
worked on all platforms until Red Hat. This revision occurred in two attempts,
and first attempt programs were broken with regard to the file open of
recurring billing addresses, customers, and taxes. Sites that were upgraded to
the first attempt programs should be upgraded immediately to avoid time
consuming back office data fixes.
- Fixed issue with
successive embedded spaces in item numbers. The connector previously truncated
item numbers at one space, and now allows three successive embedded spaces.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
FLADDIMP.OBJ
FLCUSXRF.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
FLTAXIMP.OBJ
Release: October 15, 2008
SouthWare Connector 1.5.188
- Extended XD mapping
capability to include Serial Item Extended Data. Program FLXDMPMN is used to
set up mappings for Serial Item Extended Data fields to FrontLine identifiers.
The FrontLine identifiers must first be set up in FrontLine. For existing
sites, any Serial Item Extended Data mappings that are in FLIMAP.FIL (FLIMAPMN)
should be removed and added to FLXDMAP.FIL (FLXDMPMN). Mappings related to the
Serial Item Serial Number or for FrontLine preset identifiers for stock items
should remain in FLIMAP.FIL.
This revision makes it
easier to connect customer-owned equipment and associated Extended Data that
will all be assigned to the same Stock Item. The Ormandy Equiv Cat (RSCATMNT,
Field 22) for the Product Category of stock items used in this way should be
MRE. To facilitate warranty date connection for this type of equipment, the
Parts Warranty End Date should be imported to the Serial Item Purchase Date
field, and the Services Warranty End Date should be imported to the Serial Item
Floor Plan Date Field. If Floor Plan Vendor is required for import, use the
Motorola Vendor Number.
- This revision
applies to SouthWare Rev 11, 12, 13, and 14, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
RSBILUP1.OBJ
RSCATMNT.OBJ
RSRECPST.OBJ
Release: October 6, 2008
SouthWare Connector 1.5.184b
- Added connector code
to SouthWare Rev 14.
- This revision
applies to SouthWare Rev 14 only and includes all .OBJ files.
Release: October 6, 2008
SouthWare Connector 1.5.184a
- Revised to eliminate
GEN from connection of SouthWare problem codes to FrontLine list values. This
problem code seems to be generated by SouthWare and is present even when the
Services Module is not licensed.
- This revision applies
to SouthWare Rev 11, 12, and 13, and revised programs are:
FLINIEXP.OBJ
FLPEREXP.OBJ
Release: September 25, 2008
SouthWare Connector 1.5.184
- Revised to connect
SouthWare non-taxable stock items as FrontLine ITEMS.TaxCat = 21.
- Revised tax scripts
to convert TaxCats 21 and 22 to N and I respectively in SouthWare tax locality
codes.
- Revised to connect
SouthWare Stock Item Standard Cost to FrontLine ITEMS.Cost.
Note: If updating an
existing system, all Stock Item records must be reconnected to connect the Cost
field to FrontLine.
- Fixed: All programs
have been recompiled due to changes in FLSETUP.FIL that were made in 1.5.0182,
but were not compiled into all the required programs.
- This revision
applies to SouthWare Rev 11, 12, and 13, and revised programs and SQL scripts
are (update PostgreSQL scripts to database):
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
ExSwOrdT.SQL
ExSwOrdTRB.SQL
ExSwTaxC.SQL
pgExSwOrdT.SQL
pgExSwOrdTRB.SQL
pgExSwTaxC.SQL
*** PLEASE NOTE THAT ALL
PROGRAMS HAVE BEEN RECOMPILED, SO ALL .OBJ FILES SHOULD BE UPGRADED!!! ***
Release: September 18, 2008
SouthWare Connector 1.5.182
See related FrontLine Release Notes
- Revised to connect
SouthWare AR Terms codes to the FrontLine LISTVALX table with Due Days,
Discount Days, and Discount Percent. The order connector also uses this table
when exporting the order Terms code.
Note: If updating an
existing system, all AR Customer records must be reconnected to connect to
Terms code to FrontLine.
- Revised to
accommodate running the FrontLine order export by Stock Location. There is a
new setup field to designate if this feature is to be used, and if so, the
order export is directed by the user from the SouthWare EOD rather than by
using a scheduled task or crontab job. The user may specify either one location
or all locations to be exported.
Note: Before
upgrading, use SouthWare program FLSUMNT to access the setup file and manually
record the setup information. Then rename FLSETUP.FIL to FLSETUP_0179.FIL,
upgrade the programs, then recreate the setup file with the recorded
information.
- This revision
applies to SouthWare Rev 11, 12, and 13, and revised programs and SQL scripts
are (update PostgreSQL scripts to database):
ARPROMNT.OBJ
ARSHIPVM.OBJ
ARTERMSM.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLLOCUPD.OBJ
FLORDEXP.OBJ
FLPEREXP.OBJ
FLSUMNT.OBJ
FLSQLIMP.OBJ
RSBILUP1.OBJ
DTU_FLARCODE.INI
DTU_FLCUSEXP.INI
DTU_FLLOCUPD.INI
DTU_FLORDEXL.INI
ExSwCust.SQL
ExSwCust_CN.SQL
ExSwOrdH.SQL
ExSwOrdHRB.SQL
TagNewExpbyLoc.SQL
pgExSwCust.SQL
pgExSwCust_CN.SQL
pgExSwOrdH.SQL
pgExSwOrdHRB.SQL
pgTagNewExpbyLoc.SQL
pgTagNewExpbyLocC.SQL
Release: September 9, 2008
SouthWare Connector 1.5.179
- Revised to include
connection of AR customer and AP vendor contacts from email addresses in
EMAIL.FIL. These contacts are connected without Preferences since those fields
are maintained in FrontLine. Also revised all contact connections to eliminate
the Attributes field, since it equates to Contact Preferences and does not
exist in SouthWare.
- This revision
applies to SouthWare Rev 11, 12, and 13, and revised programs are:
APVNDMNT.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: August 22, 2008
SouthWare Connector 1.5.174b
- Fixed: Conversion of
the connected Stock Number before import on returns of Vendor Catalog items
that are not stocked now includes serial item lines as well. This revision also
either updates or creates a sold serial tracking record in SouthWare before
import. There is a new program, FLSERUPD, for this revision.
- Revised SouthWare
programs and MS-SQL and PostgreSQL scripts for this revision are (update
PostgreSQL scripts to database):
FLORDUPD.OBJ
FLSERUPD.OBJ
ExSwOrdS.FMT
ExSwOrdS.SQL
pgExSwOrdS.SQL
Release: August 19, 2008
SouthWare Connector 1.5.174a
- Revised SouthWare
Rev 11 with latest connector code. Program objects for this release are in the
Beta\SW Connector\SW11 folder.
Release: August 14, 2008
SouthWare Connector 1.5.174
- Fixed: FLINIUPD was
incorrectly rebuilding the delimited record after converting the Stock Number
on return of Vendor Catalog items that are not stocked. It now rebuilds the delimited
record correctly after converting the Stock Number. FLINIUPD.OBJ has been
revised.
Release: August 1, 2008
SouthWare Connector 1.5.172a
- Fixed: Customer
Terms were being cleared when ExemptCat was connected. Proper connection of
Terms has been restored.
- Revised SouthWare
programs for this revision are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
NOTE: After this point, this document is
not comprehensive as it was compiled from available email correspondence. There
are many more revisions documented in the programs themselves.
SouthWare Connector 1.5.172
See
related FrontLine Release Notes
- Added connection of SouthWare miscellaneous items as
FrontLine ITEMS.ItemType = Miscellaneous.
- Connection of FrontLine TRXRESOURCE.ItemCost when present
to SouthWare Order Line XD157 Field 9 (Unit Cost). This cost is then
updated to the Line Item Unit Cost after import. Import field 27 of the import
file to XD157 Field 9.
- Connection of
FrontLine TRXRESOURCE.VendorID, SourcePart, and ItemCost when present to Vendor
Number, Vendor Part Number, and Unit Cost in the SouthWare Purchase Order Work
File.
- Conversion of the
connected Stock Number before import on returns of Vendor Catalog items that
are not stocked. The Stock Number is replaced with the Default
Miscellaneous Part Number from the corresponding Product Category record. There
is a new program, FLLINUPD, called from FLORDUPD for this purpose. This
program unstrings the import text record by delimiter + R + delimiter to
identify the line item code.
- Connection of the
SouthWare AR Customer Sales Tax Type Field (#19) to the FrontLine LISTVALS
Table and CUSTOMERS.ExemptCat and vice-versa connection from CUSTOMERS when
updated in FrontLine. Import field 35 of the import file to AR Customer Tax
Type.
NOTE: The built-in
ExemptCats of FrontLine should not be assigned to FrontLine customers at this
time, nor should new ExemptCats be added in FrontLine. Ideally, to use this
feature, valid ExemptCats should first be set up and maintained in a SouthWare
Field Filter to AR Customer Field 19, and assigned to SouthWare AR Customer records. A
working list of ExemptCats for this purpose is as below:
Government (GOV)
Reseller (RES)
Wholesale (WHO)
Non-Profit (NPR)
Public Service (PSV)
Armed Forces (ARM)
Veteran (VET)
Disability (DIS)
Low Income (LOW)
When FLINIEXP/R is run
these will be cross-referenced and connected as they are encountered in
SouthWare AR Customer records and create ExemptCat LISTVALS in
FrontLine. Additions to the field filter later in SouthWare will not
update FrontLine until a customer containing the new value is connected.
- Fixed FLCUSXRF to
use revised Linux-compatible emailing routine and changed email to use
SM_CUST.IN so that customer import error alerts are sent to the client.
- Revised SouthWare
programs and utilities, MS-SQL and PostgreSQL scripts for this revision are
(update PostgreSQL scripts to database):
FLCUSEXP.OBJ
FLCUSXRF.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLLINUPD.OBJ
FLORDUPD.OBJ
FLPEREXP.OBJ
FLRECBIL.OBJ
FLSPOUPD.OBJ
FLSQLIMP.OBJ
FLCUST (ImportMate
template modified to import Field 35 to Tax Type)
XD157 (Added Field 9,
Unit Cost)
FLORDHDR (ImportMate
template modified to import line item Field 27 to XD157 Field 9)
ExSwCust.FMT
ExSwCust.SQL
ExSwCust_CN.SQL
ExSwOrdL.FMT
ExSwOrdL.SQL
ExSwOrdL_services.SQL
ExSwOrdLIP.SQL
ExSwOrdLIP_services.SQL
ExSwOrdLRB.SQL
ExSwPO.SQL
pgExSwCust.SQL
pgExSwCustC.SQL
pgExSwCust_CN.SQL
pgExSwCust_CNC.SQL
pgExSwOrdL.SQL
pgExSwOrdLC.SQL
pgExSwOrdLIP.SQL
pgExSwOrdLIPC.SQL
pgExSwOrdLRB.SQL
pgExSwOrdLRBC.SQL
pgExSwPO.SQL
pgExSwPOC.SQL
Release: June 4, 2008
SouthWare Connector 1.5.160
- Fixed: Modified
format of TaxGeoDesc field in Tax
Code Export script.
- Fixed: Removed
population of TAXDTL.ExpRef before exporting tax codes in tagging scripts. This
scripting was causing problems and is no longer needed.
- Revised MS-SQL and
PostgreSQL scripts for this revision are (update PostgreSQL scripts to
database):
ExSwTaxC.SQL
TagNewExp.SQL
TagNewExpRB.SQL
TagNewExpTC.SQL
pgExSwTaxC.SQL
pgTagNewExp.SQL
pgTagNewExpRB.SQL
pgTagNewExpTC.SQL
Release: May 19, 2008
SouthWare Connector 1.5.158
- Fixed: Modified the
SouthWare inventory receivings program to connect the vendor stock number
(ItemID) to FrontLine for non-stock purchase-for receivings. This allows
the FrontLine user to look up the serial number and fulfill the order. When the
fulfilled order is connected to SouthWare, the cost is correct in SouthWare.
- SouthWare program RSRECPST.OBJ has been
revised.
Release: April 11, 2008
SouthWare Connector 1.5.150
- Added MOL and IMPACT21 functionality for PostgreSQL.
IMPACT21 includes the minimum enhancements to connect FrontLine IMPACT21 Order
Header identifiers to SouthWare Order Header Extended Data. These
identifiers should be set up in the Orders Document Template as identifiers
Types 10004 = Unit Allocation, 10005
= Marketing Method, 10006 = Order Type (require all at time of
sale). From there IMPACT21 is still run as before in SouthWare. This
feature should be tested at an IMPACT21 site before further roll-out.
- Fixed: SouthWare Product Category OPT is not a FrontLine Service Item Type.
- Revised SouthWare
programs, PostgreSQL scripts and configuration files for this revision are
(update PostgreSQL scripts to database):
FLI21EXP.OBJ
FLMOLMOP.OBJ
FLMOLUPD.OBJ
I2REFUPD.OBJ
RSCATMNT.OBJ
DTU_FLI21EXP.INI
pgDeleteI21Lists.SQL
pgDeleteI21ListsC.SQL
pgExSwOrdH.SQL
pgExSwOrdHC.SQL
pgMOLCreateTables.SQL
pgMOLCreateTablesC.SQL
pgMOLConnect.SQL
pgMOLConnectC.SQL
pgExSwMOLMO.SQL
pgExSwMOLMOC.SQL
pgExSwMOLCat.SQL
pgExSwMOLCatC.SQL
pgExSwMOLPkg.SQL
pgExSwMOLPkgC.SQL
Release: February 15, 2008
SouthWare Connector 1.5.142
- Item connection modified to set TaxCat=1 when category
record has no item type flags at all (or just vendor catalog flag) and
TaxCat=0.
- Fixed: Bug in AR
codes connection.
- Fixed: Issue of different
operating systems returning different success exit codes from DbTxUtil.
- Revised SouthWare
programs for this revision are:
ARPROMNT.OBJ
ARSHIPVM.OBJ
ARTERMSM.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
All other programs
using DbTxUtil
Release: February 8, 2008
SouthWare Connector 1.5.140
- Fixed: Problem with reconnection of error orders.
- Revised SouthWare
programs for this revision:
FLMOLUPD.OBJ
FLORDUPD.OBJ
FLSPOUPD.OBJ
FLRECBIL.OBJ
Release: January 21, 2008
SouthWare Connector 1.5.137
- Revision to allow a
more user-friendly way to set up FrontLine item mappings in SouthWare. Users
define FrontLine item types using fields and check boxes in SouthWare Product
Category Maintenance (IS-07-02) Field +22. Some training will still be
required. Identifier mappings are not affected by this revision. They
are still performed using FLIMAPMN.OBJ, and will continue to require Ormandy
involvement in both FrontLine and SouthWare. Fortunately identifier maintenance
should happen more infrequently than maintenance of item product categories.
- There is a new
conversion program, FLRFIMAP, to convert existing sites’ item mappings from
FLIMAP.FIL to the standard SouthWare Product Category File. Another conversion
program, FLFIXCAT, adds category/location combinations that exist in stock
items, but were not in the Product Category File. Any mappings found in
FLIMAP_ERR.CSV, that the client uses, will have to be manually added to the
Product Category File using IS-07-02.
- Revised SouthWare
programs for this revision are:
APVNDMNT.OBJ
ARPROMNT.OBJ
ARSHIPVM.OBJ
ARSMANMN.OBJ
ARTERMSM.OBJ
FLAROEXP.OBJ
FLCUSEXP.OBJ
FLFIXCAT.OBJ
FLIMAPMN.OBJ
FLINIEX2.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLRFIMAP.OBJ
FLSQLIMP.OBJ
GLACTMNT.OBJ
RSBILENT.OBJ
RSBILUP1.OBJ
RSCATMNT.OBJ
RSLOCMNT.OBJ
RSRECPST.OBJ
RSUMMNT.OBJ
RSTRXLST.OBJ
RSXRFMNT.OBJ
Release: December 7, 2007
SouthWare Connector 1.5.132
- Fixed: Recurring
billing issue where connector needed to vary depending upon whether the client has
the SouthWare Services module or not. Previously, recurring billing invoices
were always being coded as 4 (Service Module). Now, the default is 2 (IS
Module), and all that has to be done when a client has the Services module is
to modify ExSwOrdHRB.SQL (or pgExOrdHRB.SQL for pgSQL) to export EntryType as
4.
- Revised SouthWare
programs and utilities, MS-SQL and PostgreSQL scripts for this revision are
(update PostgreSQL scripts to database):
FLRECBIL.OBJ
XD156 (Added Field 8,
Entry Type)
FLORDHDR (ImportMate
template modified to import header Field 41 to XD156 Field 8)
ExSwOrdH.FMT
ExSwOrdH.SQL
ExSwOrdHRB.SQL
pgExSwOrdH.SQL
pgExSwOrdHC.SQL
pgExSwOrdHRB.SQL
pgExSwOrdHRBC.SQL
Release: December 4, 2007
SouthWare Connector 1.5.130
- Revision to connect
bar code parts. The connector will now connect any parts cross-reference types
that are referenced in the SouthWare I/S Control Record (IS-08-02) Field 26
(Bar Code Types) and also found in the Inventory Parts Cross-Reference File
(IS-07-06) to the FrontLine table PARTS. The EntityID of these records
will be -2147483647 per FrontLine specifications. This value of
PARTS.EntityID means the part number is not entity-specific.
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
Release: November 13, 2007
SouthWare Connector 1.5.128
- Revision to rename
MS-SQL SQL scripts to conform more closely to the PostgreSQL names (though
those are prefixed with pg), and to
make the shared .FMT files more closely match the script names regardless of
database type. All order export scripts now have the string Ord immediately following the prefix ExSw (header and line scripts already
had this).
ExSwOPmt.SQL renamed
to ExSwOrdP.SQL
ExSwOPmt.FMT renamed
to ExSwOrdP.FMT
ExSwOPmtRB.SQL renamed
to ExSwOrdPRB.SQL
ExSwLTax.SQL renamed
to ExSwOrdT.SQL
ExSwLTax.FMT renamed
to ExSwOrdT.FMT
ExSwLTaxRB.SQL renamed
to ExSwOrdTRB.SQL
ExSwHNote.SQL renamed
to ExSwOrdNH.SQL
ExSwLNote.SQL renamed
to ExSwOrdNL.SQL
ExSwUDtl.SQL renamed
to ExSwOrdS.SQL
ExSwUDtl.FMT renamed
to ExSwOrdS.FMT
ExTagNewTXC.SQL
renamed to ExTagNewTC.SQL
- Revised
configuration files for this revision are:
DTU_FLORDEXP.INI
DTU_FLORDEXP_TS.INI
DTU_FLRBEXP.INI
DTU_FLRBEXP_TS.INI
DTU_FLTXCEXP.INI
Release: October 26, 2007
SouthWare Connector 1.5.126
- Revised program
FLTAXIMP to remove all references to the ZZDUMMY
Tax Code after import. This includes from the Order Header default Tax
Code field as well as from all Tax Code 1 fields. The connected FrontLine
tax codes have been moved back to begin in Tax Code field 1 rather than
beginning in field 2. There is also a revision of ExSwOrdH.SQL to export
the FL Order Header Tax Code to facilitate importing into XD156.
- SouthWare program
FLTAXIMP.OBJ and MS-SQL script ExSwOrdH.SQL have been revised.
Release: October 15, 2007
SouthWare Connector 1.5.120a
- Revision to upgrade
connector to SouthWare Revision 13. All programs and scripts should be
upgraded.
Release: October 9, 2007
SouthWare Connector 1.5.120
- Fixed: Revised
program FLAROEXP to handle zero value Due Date.
- SouthWare program
FLAROEXP.OBJ has been revised.
Release: September 13, 2007
SouthWare Connector 1.5.111
- Added functionality
of connection of transfer sales orders using inventory receivings (RSRECPST)
when the OE Control File setting Use In-Transit File=Y, and also added this
functionality to RSBILUP1 when the OE Control File setting Use In-Transit
File=N.
- SouthWare programs
RSBILUP1.OBJ and RSRECPST.OBJ have been revised.
Release: September 7, 2007
SouthWare Connector 1.5.109
- Revised inventory
connection to make serialized miscellaneous items connect the same way as other
serialized items, and not with the 999,999 quantity.
- Added S mode to periodic connector. This mode
connects serialized items that have never been connected for any stock number.
- Revised SouthWare
programs and configuration files for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
DTU_FLPEREXP.INI
Release: August 30, 2007
SouthWare Connector 1.5.107a
- For
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: August 29, 2007
SouthWare Connector 1.5.107
- Revision to connect
warranty information.
- Revised SouthWare
programs and configuration files for this revision are:
FLINIEX2.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSBILUP1.OBJ
RSRECPST.OBJ
RSTRXLST.OBJ
DTU_FLINIEXP.INI
DTU_RSBILUP1.INI
Release: August 21, 2007
SouthWare Connector 1.5.104
- Revision to remove
Equiv Cat SV, SER and C99, and replace
with X99 and Z99.
- Revised SouthWare
programs for this release are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: August 2, 2007
SouthWare Connector 1.5.102
- Fixed: FLPEREXP now
reconnects all the BillTo and ShipTo Addresses when a customer is modified in
SouthWare.
- Revised recurring
billing export program and recurring billing tax script, but no details
available.
- Revised SouthWare
programs and MS-SQL scripts for this revision are:
FLPEREXP.OBJ
FLRECBIL.OBJ
ExSwLTaxRB.SQL
Release: July 27, 2007
SouthWare Connector 1.5.101
- Added ADDRESSES.UI
to addresses connection.
- Revised SouthWare
programs for this revision are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: July 18, 2007
SouthWare Connector 1.5.064
- Revised due to
requirement to populate ADDRESSES.Phone2, which does not connect back to
SouthWare. SouthWare should then not wipe out values that are populated
in FrontLine, so hence the need for the modification.
- Revised SouthWare
programs for this revision are:
APVNDMNT.OBJ
ARSMANMN.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSLOCMNT.OBJ
Release: July 10, 2007
SouthWare Connector 1.5.061
- Revised FLTAXIMP to
perform better error messaging with more details. The program now displays each
non-matched code. The program also archives the file regardless of whether it
has errors or not, rather than leaving it in the FLCONN folder.
- SouthWare program
FLTAXIMP.OBJ has been revised.
Release: July 6, 2007
SouthWare Connector 1.5.058a
- Revised FLINVEXP to
reconnect any customer, vendor or alternate stock cross-reference parts.
- SouthWare program FLINVEXP.OBJ
has been revised.
Release: July 5, 2007
SouthWare Connector 1.5.058
- Revised script
ExSwLTaxRB.SQL to reflect the new tax code export structure.
Release: May 14, 2007
SouthWare Connector 1.5.037
- Fixed: Bug when FrontLine
Setup File has a FrontLine Start Order Number less than 1000000000. All
programs recompiled.
Release: May 9, 2007
SouthWare Connector 1.5.029
- Revised to put the
Default BillTo Address BillTo Customer (if present) in the FrontLine address that
is generated from the SouthWare AR Customer record, and not to connect BillTo
addresses that have a BillTo Customer present.
- Revised SouthWare
programs for this revision are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: December 20, 2006
SouthWare Connector 1.4.060
- Revised customer
connector to update the credit limit in FrontLine with zero if the customer is
on CASH status in SouthWare.
- Revised SouthWare
programs for this revision are:
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: November 28, 2006
SouthWare Connector 1.4.052
- Revision required by
Kelley mapping requirements.
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSBILUP1.OBJ
RSRECPST.OBJ
RSTRXLST.OBJ
Release: November 26, 2006
SouthWare Connector 1.4.050b
- Revised programs due
to Applied Technologies requirements.
- Revised SouthWare
programs for this revision are:
APVNDMNT.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSCATMNT.OBJ
RSRECPST.OBJ
RSTRXLST.OBJ
Release: November 23, 2006
SouthWare Connector 1.4.050a
- Revised programs due
to revision to FLADDR.PL copy library.
- Revised SouthWare
programs for this revision are:
APVNDMNT.OBJ
ARSMANMN.OBJ
FLCUSEXP.OBJ
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
RSLOCMNT.OBJ
Release: November 16, 2006
SouthWare Connector 1.4.050
- Revised to connect
ITEMS.VendorID.
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: November 8, 2006
SouthWare Connector 1.4.048a
- Fixed: Miscellaneous
serial items now connect correctly.
- SouthWare programs
RSBILUP1.OBJ and RSTRXLST.OBJ have been revised.
Release: November 3, 2006
SouthWare Connector 1.4.048
- The connector now
connects all of the SouthWare Stock Item pricing methods as amounts, using the
SouthWare method of calculating the price level amounts.
- FLPEREXP now has
four export modes available:
/E = Entity (Customers,
Agents, Vendors, Stock Locations, and any prerequisite List Values)
/F = Full (Customers,
Agents, Vendors, Stock Locations, Inventory Items, Parts, Services, and all
List Values)
/I = Inventory (Stock
Locations, Inventory Items, Parts, Services, and any prerequisite List Values)
/L = List Values (List
Values Only)
The program exports
only records that fall within the specified modes that have changed since the
last date recorded in a FrontLine Control File entry. The FrontLine
Control File entries are LastExportE,
LastExportF, LastExportI, and LastExportL.
When you view these records in FLCTLMNT, you will not be able to see the date,
as it is in the internal date-timestamp of the record. You can see it
when using Alfred. For information, FLINIEXP now creates these entries,
so in a new system, they will get initialized with the data and time of the
initial connection.
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
FLINVEXP.OBJ
FLPEREXP.OBJ
FLSQLIMP.OBJ
Release: November 1, 2006
SouthWare Connector 1.4.045
- FLAROEXP no longer
archives the archive error file when there are no errors.
- RSBILUP1 no longer
connects SouthWare sales of miscellaneous item serial units.
- RSBILUP2 no longer replaces
the FrontLine AR table when the EOD switch is SV.
- Revised SouthWare
programs for this revision are:
FLAROEXP.OBJ
RSBILUP1.OBJ
RSBILUP2.OBJ
Release: October 30, 2006
SouthWare Connector 1.4.044
- RSBILUP2 revised to
call FLAROEXP to connect the SouthWare AR Open File at the end of EOD.
- RSBILUP.OBJ has been
revised.
Release: October 5, 2006
SouthWare Connector 1.4.04x
- Fixed: The connector
now handles the SouthWare 30-character serial number (was a SouthWare Rev 9
enhancement that was missed).
- Revised SouthWare
programs for this revision are:
FLINIEXP.OBJ
RSBILUP1.OBJ
RSRECPST.OBJ
RSTRXLST.OBJ
Release: September 15, 2006
SouthWare Connector 1.4.04x
- Revisions to
connection of recurring billing. Details not available.
Release: August 23, 2006
SouthWare Connector 1.4.04x
- Revised FLORDUPD for
tax import sequence.
Release: October 13, 2005
SouthWare Connector 1.2.0xx
- FrontLine connection
added to the following SouthWare maintenance programs:
AR-07-02 - ARTERMSM -
Terms codes
AR-07-03 -
ARSALESM - Salespersons
AR-07-05 - ARSHIPVM -
Ship Via codes
GL-07-01 -
GLACTMNT - GL Account numbers
IS-07-05 - RSLOCMNT -
Stock Locations
SV-07-11 -
ARPROMNT - Service Problem codes
- Revised SouthWare programs
and configuration files for this revision are:
ARTERMSM.OBJ
ARSALESM.OBJ
ARSHIPVM.OBJ
GLACTMNT.OBJ
RSLOCMNT.OBJ
ARPROMNT.OBJ
DTU_ARSMANMN.INI
DTU_FLARCODE.INI
DTU_GLACTMNT.INI
DTU_RSLOCMNT.INI