Version 5.2.3 - Restrict Exact databases with setting in XConnector.ini [SQL] SQLDatabases=[dbname1],[dbname2],[dbname3] Version 5.2.0...5.2.2 - Several small bug fixes Version 5.1.9 - Reading data from Excel performance improvements Version 5.1.8 - Items XML ItemAccount added: Account Code ItemCode ItemCodeAccount EANCode Itemcode Version 5.1.7 - maxcolidf handling - looking at maxcol indicated in the idf and overruling the max col based on the Excel - test write permission on xconnector.Ini - test write permission on target directory - with (no lock) added to several queries to prevent locking (Globe+ is locking the bedryf table in some cases) Version 5.1.6 - Sorting records in a CSV and Excel source file with import definition setting Sortfield indicating the column number (1-based) to sort on ascending Version 5.1.5 - fnConcatenate increased the number of arguments from 5 to 10 Version 5.1.3 - Financial entry XML: lnCounterQuantity added. Make it possible to create a different quantity at the counter line. Version 5.1.2 - Bugfix. Freecolumn functionality Version 5.1.1 - Financial entry line. - DateEnd added: - EntryLine.lnaAssetDateEnd - this is he best before date of a batch - EntryLine.lnAssetDateEndFormat Version 5.1.0 - Bugfix. Excel source file reading number of used columns Version 5.0.9 - Improved SQL source file reading Version 5.0.8 - Invoice XML: Additional freefields fixed Version 5.0.7 - ItemXML: added field WarehouseCostprice Version 5.0.6 - Improved Excel source file reading Version 5.0.5 - Purchase order import: Added field OrderedByCompanyName; Version 5.0.4 - Globe+ import module support: Exact.XML.Launcher.exe Version 5.0.3 - Item import: Skipline and Skiheader implemented for BOM header and BOM line. Version 5.0.1 - Item import: added fields ItemgroupGLDeferredCost ItemgroupGLAccountDiscount GLAsset GLItemsToBeReceived GLAccountDiscount - SalesPrice will also be put when there is no price but there is a VAT code or Sales unit Version 5.0.0 - Account import: Mandate PaymentCondition changed to node with property ID Version 4.9.9 - Request import: Globe Entity and Synergy Web service added 3 fields: Request;Entitlement Request;ExpiryDate Request;ExpiryDateFormat Version 4.9.8 - Bugfix. Items import was not handling the batch size correctly. Version 4.9.6 - Items import: added IntrastatEnabled Version 4.9.5 - Order import: project extended with status, type, description and account. New project is created when filled. Orderline;Project Orderline;ProjectStatus Orderline;ProjectType Orderline;ProjectDescription Orderline;ProjectAccountCode Version 4.9.4 - removing thousand separator from text source file. - number of skipped lines are reported in the log file. - logfiles moved to log sub director and naming changed to a single file per day per user. Naming: <yyyymmdd>_<userid>. log. Version 4.9.3 - Synergy webservice Request. Added request status filed import. Version 4.9.2 - bug fix. Tab character in Exact license name caused a license validation problem. Version 4.9.1 - bug fix. fnGetString. Single quote in text caused problem with SQL execution. Version 4.9.0 - bug fix. Source type setting caused problem when empty in import definition. Version 4.8.9. - Item import. Bugfix, multiple suppliers weren't handled correctly when using freefields. Version 4.8.8 Dealing with empty values: General: EmptyValuesInXML;1 Or fixed: fieldname;"|empty|" Or depending on content: fieldname;fnif({6}="","|empty|",{6}) Version 487 - Sessionid - creating by function CreateSessionId. And put in xml header. - SP execution taken out square brackets. - Item prices - assortment code and number. - Budgets - counterGl account. Version 4.8.6 - bug fix PreImportQuery was not cleared on start. Version 4.8.5 function RemovePreZero (from Exact license code) fixed fix: skip source file validation with SQL server source. Version 4.8.4 - General ledger XML: GL category description Fixed. - don't print double messages. Same message is not printed twice in a row. - Build_SQL_connection fixing finding the correct SQL driver. First ODBC Driver 17 for SQL Server}, {... Version 4.8.3 Public PreImportQuery As String 'query / sp to be execute before the import starts Items XML: Fixed multiple warehouses per item. Version 4.8.1 SQL driver ODBC set to {ODBC Driver 17 for SQL Server}. Automatic switched back to {SQL server}. Version 4.80 XMLMarkup procedure replace " by &quot; causeing problems with import of Item.xml description. Version 479 Globe entity services: Exchange rate added. Version 478 Fixing minus sign in file names. Replacing - with %%minus%%. CommandString_Create will use %%min%%. Executing it with a batch file will send %min% into the XConnector. Both %%min%% and %min% are handled by the CommandString_Read. Version 477 Logical test handling icw fngetstring with AND statement. Version 476 Introducing mail settings Fixing multiline fields (invoiceline lntext invoiceheader extratext orderheader extratext orderline lntext orderheader extratext account note internaluse note asset note project note glaccount note). Version 475 XConnector ini conversion with email settings. Version 473 SendMailOnSuccess and SendMailonError moved from ini to idf. Version 472 e-mail on error and success email report improvements. Version 471 handling minus sign in database name. Version 470 handling - and & in file paths and command strings - emailing error report. Version 469 Additional freefields added to the invoice line. Version 468 trimming the fnfunction preventing fngetstring<SPACE>("select * from.."). Version 467 Setting EveryRowIsHeader. Version 466 added command string validation messages Version 464 Commandstring bug fixes - extra space removed after EXTfipCreateMasterDataIs.. - minus sign in filenames fix Order xml: Route added to the order header Version 462 Bug fix: handling Excel cell coordinates on other tab Version 461 functions added: - fnIsEmpty({1},{2}) - fnSubstitute({1},{2},{3}) - fnUpper({1}) - fnLower({1}) - fnAbs({1}) - fnInverse({1}) - fnSum({1},{2},{3}) also support for: - AND, OR in Logical tests of the fnIf function. fnIf({1}="X" OR {2}="Y","Q01","Q02") - minus sign. Version 4.6.0 new XConnector.ini driver setting to set the SQL odbc driver. default: {SQL server} (sql 7 sql2000) also working: - driver={ODBC Driver 11 for SQL Server} - driver={ODBC Driver 13 for SQL Server} - driver={ODBC Driver 17 for SQL Server} - driver={SQL Server Native Client 11.0} not working: {SQL Native Client} Logging is showing results of the XConnector functions. Version 4.5.18 Bugfix: Items XML. Multiple BOMs per item were not handled correctly. Version 4.5.15 Bugfix: Account XML. PersonAccountManager fixed. Version 4.5.13 - Item XML. IsSalesItem default taken out - BankAccount entity service. Added bankaccount, IBAN ... - Fin entry: added lnCounterVATCode and lnCounterVATAmount - bugfix: adm settting in the Hour entry XML. - Added Copy to Clipboard button to Report screen. Version 423 Cost unit freefield adjustements Version 422 Synergy webservice - supporting empty accountnumber, Exact creates new accountnumber Webservices connection test Version 419 Item bom header and line warehouse added Bugfix filename handling in case of sql source Version 418 Bugfix handling textqualifier Version 416 BatchFillEmptyReverse added Bugfix clearing variables Version 413 LF in csv also supported, (normally it should be LfCr) Version 411 Bugfixes Command line string pipe removed. Does not work with dos prompt Lookup company handling Item BOM free fields were not put correctly in XML output Version 406 Bugfix. Error handling improved Version 398 Bugfix. fnGetstring not working on multiple records in Financial Entry Version 397 Bugfix. Item xml. Min and max stock values were missing in XML output. Version 396 Bugfix. Command line not working for multiple companies. Changed the character to separate companies into a *. Version 395 Item xml. Changed seq of element Shelflife due to problems in Synergy item import Version 394 Invoice line discount % bugfix Version 390 Bugfix. Startline setting was not working properly Bugfix Adm setting was not working properly Log=off setting introduced in XConnector.ini to disable logging in XConnector.log Version 389 Webservices introduced in XConnector Version 386 Bugfix Exact license database taken out Version 384 Bugfix Batchindicator Version 383 Accounts ExternalCode added Version 382 Accounts;VATCheckDate Accounts;VATCheckDateFormat Accounts;VATFixedYN Accounts;VATLiability Accounts;VATExemptNumber Accounts;VATServicesCode Accounts;VATServicesFixedYN Version 481 Relations added (varianten) Restructured header/sub mechanisme in the Items Version 380 Items: empty descriptions added to the GL accounts. Without they would not be imported correctly by the Asimport. Version 379 Orders: bugfix delivery address. Version 377 Empty values introduced Version 373 Bugfix. Generating multiple import files for Exact with false settings. Version 372 Financial entry added setting lnCounterDescription, with this setting the description of the counter entry line can be set. This only works when a counter line is generated. Version 371 Account contact person XML added field. PersonStatus Version 370 Target directory selection supports UNC path naming. NT username added in XConnector logging and license info screen. Item xml: default itemstatus "A" Active removed. Version 369 Requests.xml added fields. DateTimeStartRealized. DateTimeEndRealized. NumberOfHoursRealized. CurrencyRealized. AmountRealized. Version 368 Function Added: GetSetInternalUserNumber. This function gets the next internaluse number from Exact and increments the setting. Version 367 Project code changes in GL entry header. Free colum handling. Version 355 Quote handling in CSV source file with header indicator fixed. The quotes were not removed from the header indicator value from the headerindicator column. Version 354 Accounts and Contactpersons: added 4 extra addresses. The maximum total of addresses on a Account / Contactperson is eight. Version 353 Resources:added MainLocation. Improved: Skipheader and line handling. Bugfix: NoXMLEventsUpdate set to default. Version 352 Bugfix: writting filename in Exact log table XMLevents resulted in error code 6. Updating XMLevents table is disabled by default. To enable it the following setting must me used in the XConnector.ini: XMLEventsUpdate=on Resource XML: added MainLocation added (Humres;OfficeMainlocation;). Version 351 New functionality: Popupstring Version 350. Resources: changed Maindenname to Maidenname. Resources: added Contract. Resources: added CostUnit. Version 347 bugfixes: Orders: Adresses State Code. Loading available companies. Import definition loading improvement for Invoices, Orders, Entries and Accounts. Version 344 Resources: SecurityLevel added. Accounts: bugfix invoice number/code. Accounts: bugfix DebtorInvoiceCode and number. Improved ascii source file handling. Improved handling of last imports. Improved handling of file names with dots. Bugfix: 100% cpu due to corrupt log file. Version 333 Bugfix in automatic import into multiple companies fixed. Version 326 Items XML added field: DropShip. Assets XML added fields: AssetGroupDescription Asset;AssetGroupGLAccount Asset;AssetGroupGLDepreciationPL Asset;AssetGroupGLDepreciationBS Asset;AssetGroupDepreciationMethod. Version 325 XML for Cost centers and Cost units added. Versoin 324 Item prices XML: Skipline implemented. Version 323 Source file having only one entry and no header indicator can be used to generate a XML file. Use setting HeaderIndicator;"NONE". Version 321 Orders XML bugfixes. Discount percentage calcullation based on Gross and Nett amount fixes. Version 320 Item XML added fields: Shelflife Warrenty IsServiceItem PartialDelivery InvoiceCode. Version 318 Version 317 14-10-2014 GL account XML bugfix: CountGLaccount fixed Financial entry XML added fields: Entry:ProcessingDate Entry;ProcessingDateFormat Version 311 26-9-2014 Financial entry bugfix: lnPrice taken out. Amount is determined by Quantity and Price Version 309 18-8-2014 function added to determine new company code in Accounts XML Version 307 22-7-2014 General: StreamPacketSize added. This makes is possible to split the source file in multiple XML files. Financial Entry: added InvoiceDueDate Version 305 10-7-2014 Account XML: Sepa change in LclInstrm field Version 304 24-6-2014 Orders XML: added DeliverToAddresseeEmail Version 301 30-5-2014 Items/Recipe XML: BOM Freefields added Version 300 19-5-2014 small bug fixes Version 299 5-7-2014 Accounts XML DECIMALSEPARATORXML implemented Version 296 10-2-2014 Bugfix order XML: InvoiceCode Version 293 23-1-2014 Invoices XML: added fields. SerialNumber SerialNumberDescription Version 392 22-1-2014 Items xml: multiple warehouses per item enabled Version 391 20-1-2014 Account XML IBAN fields added Verion 290 17-1-2014 Source SQL Stored procedure can be used by the XConnector. Version 289 8-1-2014 fnGetString function added to the XConnector. Version 287 16-12-2014 Accounts XML: Added Sepa functionality Version 280 20-09-2013 VAT code added to import definition for Accounts Version 278 18-06-2013 XML for Recipes implemented Version 255 07-06-2012 XML for Internal uses added Version 254 07-06-2012 - Handling multiple companies in the source file Based on the setting: Adm in the import definition records from one source are split into multiple XML files. Each file can be imported automatically by the XConnector (and Asimport) into the corresponding Exact company. - Lookup account code support Synergy database - Lookup company bug fix Version 251 05-06-2012 - Handling Source- and TargetSQL server By default the SQL server mentioned in the license is used as source and target SQL server by the XConnector. The source and/or target SQL server can be changed with the setting in the import definition: SourceSQLserver TargetSQLserver - Budgets - lookupcostcenter, lookupcostunit added to the import definition - Financial entry - lookupreknr added to the import definition - Accounts - bankname added to the import definition - Invoices - selectioncode added to the import definition - Lookupaccountcode change - depending on the XML type the XConnector automatically gets the correct code from Exact FinEntry Debtor/Creditor gets the debcode/crdcode, use setting LookupAccountCode Budget Debtor/Creditor: debcode/crdcode, use setting LookuplnAccountCode Project: cmp_code, use setting LookupAccountCode Version 250 04-06-2012 String functions - nested function supported - fnConcatenate support multiple strings Accounts - Bug fix Selectioncode, Accounts,Selectioncode was not working Version 249 09-05-2012 Glaccounts import - added field IsLinked to XML definition. Use IsLinkedYN to set this field. Version 248 02-05-2012 Accounts import - element State (Dutch: provincie) changed in addresses. Old: <State>NH</State> New: <State code="NH"/> Version 246 03-04-2012 Account import - new function: fnNewCompanyCode This function gets the new company code from Exact. Accounts;Accountcode;fnNewCompanyCode Version 244 26-03-2012 Account import - bug fix - determining import topic was based on record 2 in stead of record 1. This led to error message when source file had only one record. Version 240 30-01-2012 Account import - bug fix - a non-main contactperson can not have a Invoice- and Visit address. Version 237 10-01-2012 Account import - field VatNumber added to importdefinition Version 236 29-12-2011 Invoice import - change in invoicenumbers and ourref field Version 235 12-12-2011 Bug fix: Account import. When no account code is present it resulted in an error. Version 234 31-11-2011 Fields added to the Account xml definition: ExemptNumber, PayeeName, DunsNumber Version 227 14-7-2011 Accounts import extended with Debcode: AccountCode -cicmpy.cmp_code DebtorCode - cicmpy.debcode - if not supplied then AccountCode is used AccountNumber - cicmpy.debnr - if not supplied then attribute is is skipped On Error Goto Errorhandler procedure put in LoadXlsSheet Bux fixes: Show error message when Excel source file can not be opened properly Version 223 26-5-2011 Pricelist import extended: PriceList;LineType added. --"1"=PerItem, "2"=PerItemGroup Version 185 The parameter StreamPacketSize offers the possibility to create multiple XML files during the processing of the XML-file. Exact Globe 's ASImport has difficulties to handle huge XML-files because of their size and the amount of internal memory that is necessary from the system. By decreasing the file size of the XML ASImport will be enabled to perform faster and more reliant. This functionality is only available for csv files and not applicable for xml files that contain line / sub line structures (sales order, sales invoices, purchase orders and financial entries) Items;StreamPacketSize;1000 Version 183 1-5-2010 Added elements: - Assets: CostunitCode Bug fixes: - Incorrect message "No Import" when importing files automatically into Exact. The XConnector reported falsely that No import has taken place. - "Run-Time Error 35600 Index Out Of Bounds" when importing files automatically into Exact. Version 182 26-4-2010 Added elements: - Accounts: Category fields (see: Account import IDF Debtor and Creditor or Contact import IDF) - Items: Itemgroup general ledger fields. This makes it possible to import new Itemgroup while importing Items (see Item import IDF) Version 179 20-4-2010 Added elements: - Sales and purchase order line: instruction - items: searchcode New or improved functionality: - Concatenate texts function (see the document String functions) - Using wildcards in automated XConnector (see: How to schedule XConnector activities) - Changing the connection and command timeout (see: How to use a SQL table or view as datasource) - When browsing for the import definition file the extentions txt and csv are shown by default. - + signs (plus) are removed from amounts fields. Bugfixes: CSV field seperator and textindicator fixed Hourline: Costunit element fixed Financial Entry: Yes/No fields fixed Projects: multiple projectmembers on a project fixed Version 170 4-2-2010 - Financial Entry: VAT amount added to the entry line. Until now the VAT amount was calculated during import by Exact based on the Gross Amount and the percentage from Exact of the VAT code. In some cases the supplied VAT amount (at the purchase invoice does not match the calculated VAT amount. For this the VAT amount can be put in the XML file. To use this the lnVATAmount setting can be used. - Bugfix Sales/Purchase order: discount percentage was put in XML file with comma. This should be a point. Version 162 4-12-2009 Financial Entry line: - Delivery date added to definition. Example: EntryLine;lnDeliveryDate:"31-12-2009" EntryLine;lnDeliveryDateFormat:"dd-mm-yyyy" Version 157 22-10-2009 Items: - ItemgroupCode added to the definition. Items;Itemgroup refers to the itemassorment number (ItemAssortment.Assortment field) Items;ItemgroupCode refers to the itemassortment code (ItemAssortment.Code field) At least one should be used. Version 156 19-10-2009 Bugfixes: - when source file had only one record no XML file was generated. Fixed. Items: - Multiple descriptions 1-4 added. Multiple description 0 is reservered for the standard itemdescription. - Item condition added to the definition. (A=Active, B=Blocked, D=Discontinued, E=Inactive, F=Future) - StockMin, StockMax, StatisticalNumber, StatisticalUnits added to the definition Version 154 1-8-2009 Projects: multiple project members on single project enabled. Version 152 18-7-2009 Projects: projectmembers are added to the import definition Version 151 16-7-2009 Bugfixes: - File name with automatic import into Exact not correct when deleting source file. - Error message on 0 or negative number of records to generate. This happened when startline parameter is bigger than number of records in source file. New functionality: - Number of records generated will be shown in the XML info section. Version 146 1-7-2009 Bugfixes: - JobDescription and HomePage caption error - Accounts: Addresses are put under the Contact New functionality: - Financial entry - New functionality: Entry;SKIPZEROAMOUNTLINES when set to "1" entry lines with 0 or empty amount are skipped. Version 133 14-4-2009 - String handling functions implemented fnMid(string, left, lenght) fnLeft(string, left) fnRight(string, right) More info can be found in the following document Version 126 26-1-2009 - Financial entry: Bugfix on Costcenter and Costunit in entry header Version 125 23-1-2009 - Financial entry: Bugfix on Costcenter and Costunit in entry header Version 124 22-1-2009 - Financial entry: setting Entry;HeaderRefInLine="1" copies Ourref, YourRef, PaymentReference, CostCenter, CostUnit and Project from headerline to subline. Only when the header value is filled and the line value is empty. Version 123 15-1-2009 - Financial entry: Reporting date became obsolete for the Entry Header and line. Document Date should be used instead. - Financial entry: the following fields are put under the element Payment in the entry line: lnPaymentMethod lnPaymentCondition lnPaymentReference lnOrdernumber lnOurRef InvoiceDueDate Version 121 13-1-2009 - Financial entry: added subtype for the FinEntryLine. If not supplied in import definition the XConnector will determine the subtype based on the entrytype and sign of the line amount. Entryline;lnSubType. the following codes are supported by Exact: N=Other, K=Sales invoice, C=Sales credit note, T=Purchase invoice, Q=Purchase credit note, Z=Cash receipt, Y=Payment, R=Reversal, P=Prepayment, S=Reversal credit note, D=Debit memo, F=Financial charge, M=Machine hours, L=Labor hours, E=Revaluation, I=Disposal, V=Depreciation, A=Receipt, B=Fulfillment, G=Counts, H=Return fulfillment, J=Return receipt, W=Payroll. - GLAccounts: XMLnode changed to GLAccounts - Purchase orders: XMLnode changed to Orders Version 110 20-10-2008 Element <Text> added to invoice and orderline. Version 096 16-6-2008 - Financial entry: It can be necessary to use the references (Ourref, YourRef and Payment references) from the header- in the entry line. This is analog to entering an entry manually in Exact where these fields are also entered in the header and end up at line level. The XConnector will do this when setting Entry;HeaderRefInLine;"1" in the import definition. - Financial entry: document date in the entry line added to the definition with the following two settings: Entryline;lnDocumentDate Entryline;lnDocumentDateFormat Version 095 2-6-2008 - Connecting to SQL table / view gave problems with the sortfield while reading the data. This was solved. Version 094 2-6-2008 - Financial entry xml - multicurrency enabled for entry line. For this a default currency (Defaultcurrency) element is added to the header and a rate setting (lnRate) is added to the entryline. - Resource.xml - Social security number fixed. Setting Socialsecurity was not working correctly. - Resource.xml - Settings not supplied in IDF are not put in XML file. - Resource.xml - Settings added for AccountCode and Name. By supplying these a Creditor will be created by Exact. Version 091 10-2-2008 - Financial entry xml - debtor and creditor number were not cleared when generating sales- and purchase entries in one single file. Version 090 21-1-2008 - Order xml - improved calculation of prices and amounts in orderline Version 084 7-12-2007 - Financial Entry - With the import of a FMUTA6 file the reporting date can be based on the Year and Period from the source file. The reporting date will be determined on the last day of the month. (in the XML this element DocumentDate is use for the reporting date) For this two parameters are needed in the definition: Entry;ReportYear;"2008" Entry;ReportPeriod;"1" Version 083 - 29-11-2007 - Hours - bugfix: Resource id in line was not taken into the XML file Version 080 - 11 november 2007 - validation of source values to Exact masterdata* - lookup N-to-1 (multiple source codes are mapped to one Exact code)* - SQL table / view can be used as source data* - items: bugfix supplieritemcode *) documentation will follow Version 071 - 4 juni 2007 - lookup values extended on financial entries. see doc XConnector lookup fields Version 070 - 1 mei 2007 - Order XML - resource number element in header and subline fixed. Version 069 - 19 april 2007 - request xml notes and workflownotes fields fixed - order, invoices and itemprices xml element PriceList fixed. Version 068 - 17 april 2007 - import hourline extended with costunit - lookup posibility on costunit in hourline with setting: LOOKUPCOSTUNITFROMHUMRES. example: HOURLINE;LOOKUPCOSTUNITFROMHUMRES;"YES" makes the Xconnector get costunit from the humres table based on the res_id. pls note that a company is requered at the setting: HOURS;ADM;"<Company number>" Version 066 - 19 maart 2007 - custom solutions for FMG option 19 Version 064 - 13 februari 2007 - Requests Asimport statement for Requests with -OPT22 parameter Version 062 - 12 februari 2007 - ACCOUNTS Lookup functionality added to Companysize, Companyorigin, Companysector, Companysubsector - Requests Lookup functionality added to Freetext16-25 (lookup on Absences) Needed for Guidfields Extra fields added: FreeNumber field 6-10. These are used to import FreeInteger fields 1 till 5. See Exact doc: Synergy import of Extra field and guidfields. See Exact doc 03.374.379 For lookup funcitonality see: Lookup values in XConnector Version 058 - 5 februari 2007 - Requests XML definition added - Contacts XML defition addad - Several missing field from accounts added, Account.VatCode Account.County Account.State Textfield 11 - 30 - Fixed: Request Account element - FreeGuidFields are not working. Requested at Exact Support department - Lookup in database functionality For testing only on hours XML. Import definition: Adm to define the Exact database LookupHumresid to define the reference field in the Humres table containing the Resource code from the source file LookupItemcode to define the reference field in the Item table containing the itemcode from the source file Example: HOURS;ADM;"100" HOURLINE;LNRESOURCE;2 HOURLINE;LOOKUPHUMRESID;"usr_id" HOURLINE;LNITEM;3 HOURLINE;LOOKUPITEMCODE;"UserField_06" An external Personcode is stored in column 2 of the source file. This code is also present in the usr_id" field of the Exact humres table. The XConnector will query the humres table and get the res_id. An external Item-hour code is stored in column 3 of the source file. This code is also present in the in the FreeTextField6 field of the Item table. The XConnector will query the Items table and get the Itemcode and use this in the XML file Version 050 - 21 november 2006 - itemprices import implemented. Version 049 - Itemimport: Itemaccount element is skipped in case no SUPPLIERACCOUNTCODE is present. Version 048 - import van contactpersonen op relatie ondersteund. - optie 18 FMG RMA order import Version 047 - 2 november 2006 - entrysubline van boeking code sybtype aangepast: Inkoopboeking: subtype: T alle andere subtype: K --probleem is dat op voorhand niet te bepalen welk type regel er aangeboden wordt. Version 045 - 26 october 2006 - lege elementen uit items verwijderd - projectmanager in project toegevoegd Version 044 - 20 october 2006 Import of Sales contracts supported. Additional fields: Orderline;SerialNumberDescription; Orderline;ProlongationDate; Orderline;ProlongationDateFormat;"dd-mm-yyyy" Version 042 Hour import implemented see doc: 1014 Version 040 Delimiter and Textqualifier implemented for Exact for Dos FMUTA.csv Entry;Delimiter;"," Entry;TextQualifier;""" Version 036 - option 17 for FMG see doc 982 Version 035 - invoices headerrecognition - reference and description errors in invoices - delivery date change version 034 20050517 problem with strange characters quotes and ampesants (XML markup) are solved. version 033 20050308 - Orderline XML extended with Costunit and Project. Syntax in idf: Orderline;Costunit; Orderline;Project; version 032 20050126 - entry type taken out of entryline tag - problems with variables when changing the idf version 031 20050125 option 56 for ABN AMRO Capital for this option a MDB is needed (doc: 00.000.888) import definition (doc: 00.000.889) example sourcesheet (doc: 00.000.890) version 030 2005-01-20 - CREDITOR IMPORT enabled example: Accounts;AccountType;"S" (S=supplier, C=Customer) also added: CustomerCode: Accounts;CustomerCode - InvoiceCode added to SalesOrder import example: Order;Invoicecode;"01" version 027 2005-12-29 itemimport extended with two fields: Items;sourcetype;CSV Items;delimiter;"," The sourcetype can be used to indicate the type of file the source file is. By default the source type CSV and XLS is determined by the extention. In case the extention is different the "sourcetype" needs to be used. The Delimiter for CSV files is ; (semicolon) by default. In case an other delimeter is used this field should be used. version 026 2005-12-26 -import projects added. Not functional yet: - import of images - import of projectmembers To be tested: - import of notes on projects - import of extra fields on projects version 024 2005-11-30 - import van valutakoersen (zie voorbeeld importdefinitie) - na het genereren van het xml-bestand de mogelijkheid om het direct in meerdere administraties te importeren (middels asimport) - mogelijkheid om in een memoriaalboeking een tweede regel te generen waarvan de grootboekrekening anders is en het bedrag een aantal tegengeboekt worden. 'Know issue' hierbij is dat Exact (asimport) bestands- en directories met spaties niet ondersteund. (ik zoek nog naar een oplossing hiervoor. De XML import module dient in de Rxact licentie aanwezig te zijn en de gebruiker dient rechten in Exact op de import te hebben. Nieuwe installatie nodig wegens de voorbereidingen van de tabladen (tabctrl32.ocx) version 023 2005-11-15 - Finaciale entry bug fix on Transactionnumber... and InvoiceNumber version 022 2005-11-09 new functionality: - import of General Ledger accounts. --> import of GL categories is also supported --> import of GL-CC links is also supported --> not working properly: notes and freefields are not working properly. Most likely this is not supported by Exact. bugfix: - Financial Entry XML: fields TransactionNumberSubAdministration and InvoiceNumber added to the Payment element. version 020 test version with connection timeout 5 seconds version 018 2005-10-28 bugfix: incase the no INI and ELC present application crashed. version 017 2005-10-27 - IMPORTANT: SECURITY INTEGRATED. DOES NOT WORK WITHOUT ELC FILE. - Financial entry: Debtor/Creditor code. EntryType in IDF defines the usage of the debtor/creditor from the header/subline. pls note that the XML definition for the entry header doesnot have a Debtor or Creditor. They only exist in the line. --> Entry type I (purchase journal). lineCreditor is filled with the headerCreditor. LineCreditor is neglected. --> Entry type V (sales journal). lineDebtor is filled with the headerDebtor. LineDebtor is neglected. --> Entry type else: (bank/general journal). lineDebtor and lineCreditor are taken into the line. HeaderDebtor and Creditor are neglected. version 016 2005-10-23 - Financial entry line: credit amount is placed under the element <Credit> and minus sign is removed. - markup characters & ' " < > are replaced their character references. version 015 2005-10-21 - financial entry. Fixed: resource at line level VAT codes line level. version 014 2005-10-21 - financial entry implemented. Only the Purchase entry is tested. version 013 2005-08-26 - checkbox toegevoegd om de bronbestanden te verwijderen. - de waarde van de checkbox wordt per idf en bronbestand opgeslagen in de ini. version 012 2005-07-12 - orders: idf term discount% werd niet herkend. Nu zowel "discount" als "discount%" geldig voor het aangeven van het kortingspercentage - algemeen: datum afhandeling. Indien een maand of dag slecht een cijfer bevatte werd deze niet herkend (voorloop nul ontbrak). Dit is aangepast in de datum afhandeling. - algemeen: in sommige gevallen werd de Target directory niet goed genomen voor het schrijven van de XML version 011 2005-07-11 bugfix. Orders: in de order line werd geen prijs geplaats indien er geen kortingspercentage was. version 009 2005-06-06 - after mergin the header and subline array the idf was reloaded. The reload action is taken out because this undoes the corrected fieldnumbers in the idf. version 008 2005-06-03 - read TAB separated files - read ; separated files - read ascii files - read two files (header and subline) files for orders version 007 2004-12-08 - in order line the item code was trimmed at 10 positions, this only needed for AAB option= 1 version 006 2004-11-12 - last importtype used saved in ini - last importdef by importtype save in ini - last source file and target dir by import def saved in ini - when starting these settings will be retreived - order xml: element discount always put in file (if no discount this will be 0)
Version 4.80 XMLMarkup procedure replace " by &quot; causeing problems with import of Item.xml description. Version 479 Globe entity services: Exchange rate added. Version 478 Fixing minus sign in file names. Replacing - with %%minus%%. CommandString_Create will use %%min%%. Executing it with a batch file will send %min% into the XConnector. Both %%min%% and %min% are handled by the CommandString_Read. Version 477 Logical test handling icw fngetstring with AND statement. Version 476 Introducing mail settings Fixing multiline fields (invoiceline lntext invoiceheader extratext orderheader extratext orderline lntext orderheader extratext account note internaluse note asset note project note glaccount note). Version 475 XConnector ini conversion with email settings. Version 473 SendMailOnSuccess and SendMailonError moved from ini to idf. Version 472 e-mail on error and success email report improvements. Version 471 handling minus sign in database name. Version 470 handling - and & in file paths and command strings - emailing error report. Version 469 Additional freefields added to the invoice line. Version 468 trimming the fnfunction preventing fngetstring<SPACE>("select * from.."). Version 467 Setting EveryRowIsHeader. Version 466 added command string validation messages Version 464 Commandstring bug fixes - extra space removed after EXTfipCreateMasterDataIs.. - minus sign in filenames fix Order xml: Route added to the order header Version 462 Bug fix: handling Excel cell coordinates on other tab Version 461 functions added: - fnIsEmpty({1},{2}) - fnSubstitute({1},{2},{3}) - fnUpper({1}) - fnLower({1}) - fnAbs({1}) - fnInverse({1}) - fnSum({1},{2},{3}) also support for: - AND, OR in Logical tests of the fnIf function. fnIf({1}="X" OR {2}="Y","Q01","Q02") - minus sign. Version 4.6.0 new XConnector.ini driver setting to set the SQL odbc driver. default: {SQL server} (sql 7 sql2000) also working: - driver={ODBC Driver 11 for SQL Server} - driver={ODBC Driver 13 for SQL Server} - driver={ODBC Driver 17 for SQL Server} - driver={SQL Server Native Client 11.0} not working: {SQL Native Client} Logging is showing results of the XConnector functions. Version 4.5.18 Bugfix: Items XML. Multiple BOMs per item were not handled correctly. Version 4.5.15 Bugfix: Account XML. PersonAccountManager fixed. Version 4.5.13 - Item XML. IsSalesItem default taken out - BankAccount entity service. Added bankaccount, IBAN ... - Fin entry: added lnCounterVATCode and lnCounterVATAmount - bugfix: adm settting in the Hour entry XML. - Added Copy to Clipboard button to Report screen. Version 423 Cost unit freefield adjustements Version 422 Synergy webservice - supporting empty accountnumber, Exact creates new accountnumber Webservices connection test Version 419 Item bom header and line warehouse added Bugfix filename handling in case of sql source Version 418 Bugfix handling textqualifier Version 416 BatchFillEmptyReverse added Bugfix clearing variables Version 413 LF in csv also supported, (normally it should be LfCr) Version 411 Bugfixes Command line string pipe removed. Does not work with dos prompt Lookup company handling Item BOM free fields were not put correctly in XML output Version 406 Bugfix. Error handling improved Version 398 Bugfix. fnGetstring not working on multiple records in Financial Entry Version 397 Bugfix. Item xml. Min and max stock values were missing in XML output. Version 396 Bugfix. Command line not working for multiple companies. Changed the character to separate companies into a *. Version 395 Item xml. Changed seq of element Shelflife due to problems in Synergy item import Version 394 Invoice line discount % bugfix Version 390 Bugfix. Startline setting was not working properly Bugfix Adm setting was not working properly Log=off setting introduced in XConnector.ini to disable logging in XConnector.log Version 389 Webservices introduced in XConnector Version 386 Bugfix Exact license database taken out Version 384 Bugfix Batchindicator Version 383 Accounts ExternalCode added Version 382 Accounts;VATCheckDate Accounts;VATCheckDateFormat Accounts;VATFixedYN Accounts;VATLiability Accounts;VATExemptNumber Accounts;VATServicesCode Accounts;VATServicesFixedYN Version 481 Relations added (varianten) Restructured header/sub mechanisme in the Items Version 380 Items: empty descriptions added to the GL accounts. Without they would not be imported correctly by the Asimport. Version 379 Orders: bugfix delivery address. Version 377 Empty values introduced Version 373 Bugfix. Generating multiple import files for Exact with false settings. Version 372 Financial entry added setting lnCounterDescription, with this setting the description of the counter entry line can be set. This only works when a counter line is generated. Version 371 Account contact person XML added field. PersonStatus Version 370 Target directory selection supports UNC path naming. NT username added in XConnector logging and license info screen. Item xml: default itemstatus "A" Active removed. Version 369 Requests.xml added fields. DateTimeStartRealized. DateTimeEndRealized. NumberOfHoursRealized. CurrencyRealized. AmountRealized. Version 368 Function Added: GetSetInternalUserNumber. This function gets the next internaluse number from Exact and increments the setting. Version 367 Project code changes in GL entry header. Free colum handling. Version 355 Quote handling in CSV source file with header indicator fixed. The quotes were not removed from the header indicator value from the headerindicator column. Version 354 Accounts and Contactpersons: added 4 extra addresses. The maximum total of addresses on a Account / Contactperson is eight. Version 353 Resources:added MainLocation. Improved: Skipheader and line handling. Bugfix: NoXMLEventsUpdate set to default. Version 352 Bugfix: writting filename in Exact log table XMLevents resulted in error code 6. Updating XMLevents table is disabled by default. To enable it the following setting must me used in the XConnector.ini: XMLEventsUpdate=on Resource XML: added MainLocation added (Humres;OfficeMainlocation;). Version 351 New functionality: Popupstring Version 350. Resources: changed Maindenname to Maidenname. Resources: added Contract. Resources: added CostUnit. Version 347 bugfixes: Orders: Adresses State Code. Loading available companies. Import definition loading improvement for Invoices, Orders, Entries and Accounts. Version 344 Resources: SecurityLevel added. Accounts: bugfix invoice number/code. Accounts: bugfix DebtorInvoiceCode and number. Improved ascii source file handling. Improved handling of last imports. Improved handling of file names with dots. Bugfix: 100% cpu due to corrupt log file. Version 333 Bugfix in automatic import into multiple companies fixed. Version 326 Items XML added field: DropShip. Assets XML added fields: AssetGroupDescription Asset;AssetGroupGLAccount Asset;AssetGroupGLDepreciationPL Asset;AssetGroupGLDepreciationBS Asset;AssetGroupDepreciationMethod. Version 325 XML for Cost centers and Cost units added. Versoin 324 Item prices XML: Skipline implemented. Version 323 Source file having only one entry and no header indicator can be used to generate a XML file. Use setting HeaderIndicator;"NONE". Version 321 Orders XML bugfixes. Discount percentage calcullation based on Gross and Nett amount fixes. Version 320 Item XML added fields: Shelflife Warrenty IsServiceItem PartialDelivery InvoiceCode. Version 318 Version 317 14-10-2014 GL account XML bugfix: CountGLaccount fixed Financial entry XML added fields: Entry:ProcessingDate Entry;ProcessingDateFormat Version 311 26-9-2014 Financial entry bugfix: lnPrice taken out. Amount is determined by Quantity and Price Version 309 18-8-2014 function added to determine new company code in Accounts XML Version 307 22-7-2014 General: StreamPacketSize added. This makes is possible to split the source file in multiple XML files. Financial Entry: added InvoiceDueDate Version 305 10-7-2014 Account XML: Sepa change in LclInstrm field Version 304 24-6-2014 Orders XML: added DeliverToAddresseeEmail Version 301 30-5-2014 Items/Recipe XML: BOM Freefields added Version 300 19-5-2014 small bug fixes Version 299 5-7-2014 Accounts XML DECIMALSEPARATORXML implemented Version 296 10-2-2014 Bugfix order XML: InvoiceCode Version 293 23-1-2014 Invoices XML: added fields. SerialNumber SerialNumberDescription Version 392 22-1-2014 Items xml: multiple warehouses per item enabled Version 391 20-1-2014 Account XML IBAN fields added Verion 290 17-1-2014 Source SQL Stored procedure can be used by the XConnector. Version 289 8-1-2014 fnGetString function added to the XConnector. Version 287 16-12-2014 Accounts XML: Added Sepa functionality Version 280 20-09-2013 VAT code added to import definition for Accounts Version 278 18-06-2013 XML for Recipes implemented Version 255 07-06-2012 XML for Internal uses added Version 254 07-06-2012 - Handling multiple companies in the source file Based on the setting: Adm in the import definition records from one source are split into multiple XML files. Each file can be imported automatically by the XConnector (and Asimport) into the corresponding Exact company. - Lookup account code support Synergy database - Lookup company bug fix Version 251 05-06-2012 - Handling Source- and TargetSQL server By default the SQL server mentioned in the license is used as source and target SQL server by the XConnector. The source and/or target SQL server can be changed with the setting in the import definition: SourceSQLserver TargetSQLserver - Budgets - lookupcostcenter, lookupcostunit added to the import definition - Financial entry - lookupreknr added to the import definition - Accounts - bankname added to the import definition - Invoices - selectioncode added to the import definition - Lookupaccountcode change - depending on the XML type the XConnector automatically gets the correct code from Exact FinEntry Debtor/Creditor gets the debcode/crdcode, use setting LookupAccountCode Budget Debtor/Creditor: debcode/crdcode, use setting LookuplnAccountCode Project: cmp_code, use setting LookupAccountCode Version 250 04-06-2012 String functions - nested function supported - fnConcatenate support multiple strings Accounts - Bug fix Selectioncode, Accounts,Selectioncode was not working Version 249 09-05-2012 Glaccounts import - added field IsLinked to XML definition. Use IsLinkedYN to set this field. Version 248 02-05-2012 Accounts import - element State (Dutch: provincie) changed in addresses. Old: <State>NH</State> New: <State code="NH"/> Version 246 03-04-2012 Account import - new function: fnNewCompanyCode This function gets the new company code from Exact. Accounts;Accountcode;fnNewCompanyCode Version 244 26-03-2012 Account import - bug fix - determining import topic was based on record 2 in stead of record 1. This led to error message when source file had only one record. Version 240 30-01-2012 Account import - bug fix - a non-main contactperson can not have a Invoice- and Visit address. Version 237 10-01-2012 Account import - field VatNumber added to importdefinition Version 236 29-12-2011 Invoice import - change in invoicenumbers and ourref field Version 235 12-12-2011 Bug fix: Account import. When no account code is present it resulted in an error. Version 234 31-11-2011 Fields added to the Account xml definition: ExemptNumber, PayeeName, DunsNumber Version 227 14-7-2011 Accounts import extended with Debcode: AccountCode -cicmpy.cmp_code DebtorCode - cicmpy.debcode - if not supplied then AccountCode is used AccountNumber - cicmpy.debnr - if not supplied then attribute is is skipped On Error Goto Errorhandler procedure put in LoadXlsSheet Bux fixes: Show error message when Excel source file can not be opened properly Version 223 26-5-2011 Pricelist import extended: PriceList;LineType added. --"1"=PerItem, "2"=PerItemGroup Version 185 The parameter StreamPacketSize offers the possibility to create multiple XML files during the processing of the XML-file. Exact Globe 's ASImport has difficulties to handle huge XML-files because of their size and the amount of internal memory that is necessary from the system. By decreasing the file size of the XML ASImport will be enabled to perform faster and more reliant. This functionality is only available for csv files and not applicable for xml files that contain line / sub line structures (sales order, sales invoices, purchase orders and financial entries) Items;StreamPacketSize;1000 Version 183 1-5-2010 Added elements: - Assets: CostunitCode Bug fixes: - Incorrect message "No Import" when importing files automatically into Exact. The XConnector reported falsely that No import has taken place. - "Run-Time Error 35600 Index Out Of Bounds" when importing files automatically into Exact. Version 182 26-4-2010 Added elements: - Accounts: Category fields (see: Account import IDF Debtor and Creditor or Contact import IDF) - Items: Itemgroup general ledger fields. This makes it possible to import new Itemgroup while importing Items (see Item import IDF) Version 179 20-4-2010 Added elements: - Sales and purchase order line: instruction - items: searchcode New or improved functionality: - Concatenate texts function (see the document String functions) - Using wildcards in automated XConnector (see: How to schedule XConnector activities) - Changing the connection and command timeout (see: How to use a SQL table or view as datasource) - When browsing for the import definition file the extentions txt and csv are shown by default. - + signs (plus) are removed from amounts fields. Bugfixes: CSV field seperator and textindicator fixed Hourline: Costunit element fixed Financial Entry: Yes/No fields fixed Projects: multiple projectmembers on a project fixed Version 170 4-2-2010 - Financial Entry: VAT amount added to the entry line. Until now the VAT amount was calculated during import by Exact based on the Gross Amount and the percentage from Exact of the VAT code. In some cases the supplied VAT amount (at the purchase invoice does not match the calculated VAT amount. For this the VAT amount can be put in the XML file. To use this the lnVATAmount setting can be used. - Bugfix Sales/Purchase order: discount percentage was put in XML file with comma. This should be a point. Version 162 4-12-2009 Financial Entry line: - Delivery date added to definition. Example: EntryLine;lnDeliveryDate:"31-12-2009" EntryLine;lnDeliveryDateFormat:"dd-mm-yyyy" Version 157 22-10-2009 Items: - ItemgroupCode added to the definition. Items;Itemgroup refers to the itemassorment number (ItemAssortment.Assortment field) Items;ItemgroupCode refers to the itemassortment code (ItemAssortment.Code field) At least one should be used. Version 156 19-10-2009 Bugfixes: - when source file had only one record no XML file was generated. Fixed. Items: - Multiple descriptions 1-4 added. Multiple description 0 is reservered for the standard itemdescription. - Item condition added to the definition. (A=Active, B=Blocked, D=Discontinued, E=Inactive, F=Future) - StockMin, StockMax, StatisticalNumber, StatisticalUnits added to the definition Version 154 1-8-2009 Projects: multiple project members on single project enabled. Version 152 18-7-2009 Projects: projectmembers are added to the import definition Version 151 16-7-2009 Bugfixes: - File name with automatic import into Exact not correct when deleting source file. - Error message on 0 or negative number of records to generate. This happened when startline parameter is bigger than number of records in source file. New functionality: - Number of records generated will be shown in the XML info section. Version 146 1-7-2009 Bugfixes: - JobDescription and HomePage caption error - Accounts: Addresses are put under the Contact New functionality: - Financial entry - New functionality: Entry;SKIPZEROAMOUNTLINES when set to "1" entry lines with 0 or empty amount are skipped. Version 133 14-4-2009 - String handling functions implemented fnMid(string, left, lenght) fnLeft(string, left) fnRight(string, right) More info can be found in the following document Version 126 26-1-2009 - Financial entry: Bugfix on Costcenter and Costunit in entry header Version 125 23-1-2009 - Financial entry: Bugfix on Costcenter and Costunit in entry header Version 124 22-1-2009 - Financial entry: setting Entry;HeaderRefInLine="1" copies Ourref, YourRef, PaymentReference, CostCenter, CostUnit and Project from headerline to subline. Only when the header value is filled and the line value is empty. Version 123 15-1-2009 - Financial entry: Reporting date became obsolete for the Entry Header and line. Document Date should be used instead. - Financial entry: the following fields are put under the element Payment in the entry line: lnPaymentMethod lnPaymentCondition lnPaymentReference lnOrdernumber lnOurRef InvoiceDueDate Version 121 13-1-2009 - Financial entry: added subtype for the FinEntryLine. If not supplied in import definition the XConnector will determine the subtype based on the entrytype and sign of the line amount. Entryline;lnSubType. the following codes are supported by Exact: N=Other, K=Sales invoice, C=Sales credit note, T=Purchase invoice, Q=Purchase credit note, Z=Cash receipt, Y=Payment, R=Reversal, P=Prepayment, S=Reversal credit note, D=Debit memo, F=Financial charge, M=Machine hours, L=Labor hours, E=Revaluation, I=Disposal, V=Depreciation, A=Receipt, B=Fulfillment, G=Counts, H=Return fulfillment, J=Return receipt, W=Payroll. - GLAccounts: XMLnode changed to GLAccounts - Purchase orders: XMLnode changed to Orders Version 110 20-10-2008 Element <Text> added to invoice and orderline. Version 096 16-6-2008 - Financial entry: It can be necessary to use the references (Ourref, YourRef and Payment references) from the header- in the entry line. This is analog to entering an entry manually in Exact where these fields are also entered in the header and end up at line level. The XConnector will do this when setting Entry;HeaderRefInLine;"1" in the import definition. - Financial entry: document date in the entry line added to the definition with the following two settings: Entryline;lnDocumentDate Entryline;lnDocumentDateFormat Version 095 2-6-2008 - Connecting to SQL table / view gave problems with the sortfield while reading the data. This was solved. Version 094 2-6-2008 - Financial entry xml - multicurrency enabled for entry line. For this a default currency (Defaultcurrency) element is added to the header and a rate setting (lnRate) is added to the entryline. - Resource.xml - Social security number fixed. Setting Socialsecurity was not working correctly. - Resource.xml - Settings not supplied in IDF are not put in XML file. - Resource.xml - Settings added for AccountCode and Name. By supplying these a Creditor will be created by Exact. Version 091 10-2-2008 - Financial entry xml - debtor and creditor number were not cleared when generating sales- and purchase entries in one single file. Version 090 21-1-2008 - Order xml - improved calculation of prices and amounts in orderline Version 084 7-12-2007 - Financial Entry - With the import of a FMUTA6 file the reporting date can be based on the Year and Period from the source file. The reporting date will be determined on the last day of the month. (in the XML this element DocumentDate is use for the reporting date) For this two parameters are needed in the definition: Entry;ReportYear;"2008" Entry;ReportPeriod;"1" Version 083 - 29-11-2007 - Hours - bugfix: Resource id in line was not taken into the XML file Version 080 - 11 november 2007 - validation of source values to Exact masterdata* - lookup N-to-1 (multiple source codes are mapped to one Exact code)* - SQL table / view can be used as source data* - items: bugfix supplieritemcode *) documentation will follow Version 071 - 4 juni 2007 - lookup values extended on financial entries. see doc XConnector lookup fields Version 070 - 1 mei 2007 - Order XML - resource number element in header and subline fixed. Version 069 - 19 april 2007 - request xml notes and workflownotes fields fixed - order, invoices and itemprices xml element PriceList fixed. Version 068 - 17 april 2007 - import hourline extended with costunit - lookup posibility on costunit in hourline with setting: LOOKUPCOSTUNITFROMHUMRES. example: HOURLINE;LOOKUPCOSTUNITFROMHUMRES;"YES" makes the Xconnector get costunit from the humres table based on the res_id. pls note that a company is requered at the setting: HOURS;ADM;"<Company number>" Version 066 - 19 maart 2007 - custom solutions for FMG option 19 Version 064 - 13 februari 2007 - Requests Asimport statement for Requests with -OPT22 parameter Version 062 - 12 februari 2007 - ACCOUNTS Lookup functionality added to Companysize, Companyorigin, Companysector, Companysubsector - Requests Lookup functionality added to Freetext16-25 (lookup on Absences) Needed for Guidfields Extra fields added: FreeNumber field 6-10. These are used to import FreeInteger fields 1 till 5. See Exact doc: Synergy import of Extra field and guidfields. See Exact doc 03.374.379 For lookup funcitonality see: Lookup values in XConnector Version 058 - 5 februari 2007 - Requests XML definition added - Contacts XML defition addad - Several missing field from accounts added, Account.VatCode Account.County Account.State Textfield 11 - 30 - Fixed: Request Account element - FreeGuidFields are not working. Requested at Exact Support department - Lookup in database functionality For testing only on hours XML. Import definition: Adm to define the Exact database LookupHumresid to define the reference field in the Humres table containing the Resource code from the source file LookupItemcode to define the reference field in the Item table containing the itemcode from the source file Example: HOURS;ADM;"100" HOURLINE;LNRESOURCE;2 HOURLINE;LOOKUPHUMRESID;"usr_id" HOURLINE;LNITEM;3 HOURLINE;LOOKUPITEMCODE;"UserField_06" An external Personcode is stored in column 2 of the source file. This code is also present in the usr_id" field of the Exact humres table. The XConnector will query the humres table and get the res_id. An external Item-hour code is stored in column 3 of the source file. This code is also present in the in the FreeTextField6 field of the Item table. The XConnector will query the Items table and get the Itemcode and use this in the XML file Version 050 - 21 november 2006 - itemprices import implemented. Version 049 - Itemimport: Itemaccount element is skipped in case no SUPPLIERACCOUNTCODE is present. Version 048 - import van contactpersonen op relatie ondersteund. - optie 18 FMG RMA order import Version 047 - 2 november 2006 - entrysubline van boeking code sybtype aangepast: Inkoopboeking: subtype: T alle andere subtype: K --probleem is dat op voorhand niet te bepalen welk type regel er aangeboden wordt. Version 045 - 26 october 2006 - lege elementen uit items verwijderd - projectmanager in project toegevoegd Version 044 - 20 october 2006 Import of Sales contracts supported. Additional fields: Orderline;SerialNumberDescription; Orderline;ProlongationDate; Orderline;ProlongationDateFormat;"dd-mm-yyyy" Version 042 Hour import implemented see doc: 1014 Version 040 Delimiter and Textqualifier implemented for Exact for Dos FMUTA.csv Entry;Delimiter;"," Entry;TextQualifier;""" Version 036 - option 17 for FMG see doc 982 Version 035 - invoices headerrecognition - reference and description errors in invoices - delivery date change version 034 20050517 problem with strange characters quotes and ampesants (XML markup) are solved. version 033 20050308 - Orderline XML extended with Costunit and Project. Syntax in idf: Orderline;Costunit; Orderline;Project; version 032 20050126 - entry type taken out of entryline tag - problems with variables when changing the idf version 031 20050125 option 56 for ABN AMRO Capital for this option a MDB is needed (doc: 00.000.888) import definition (doc: 00.000.889) example sourcesheet (doc: 00.000.890) version 030 2005-01-20 - CREDITOR IMPORT enabled example: Accounts;AccountType;"S" (S=supplier, C=Customer) also added: CustomerCode: Accounts;CustomerCode - InvoiceCode added to SalesOrder import example: Order;Invoicecode;"01" version 027 2005-12-29 itemimport extended with two fields: Items;sourcetype;CSV Items;delimiter;"," The sourcetype can be used to indicate the type of file the source file is. By default the source type CSV and XLS is determined by the extention. In case the extention is different the "sourcetype" needs to be used. The Delimiter for CSV files is ; (semicolon) by default. In case an other delimeter is used this field should be used. version 026 2005-12-26 -import projects added. Not functional yet: - import of images - import of projectmembers To be tested: - import of notes on projects - import of extra fields on projects version 024 2005-11-30 - import van valutakoersen (zie voorbeeld importdefinitie) - na het genereren van het xml-bestand de mogelijkheid om het direct in meerdere administraties te importeren (middels asimport) - mogelijkheid om in een memoriaalboeking een tweede regel te generen waarvan de grootboekrekening anders is en het bedrag een aantal tegengeboekt worden. 'Know issue' hierbij is dat Exact (asimport) bestands- en directories met spaties niet ondersteund. (ik zoek nog naar een oplossing hiervoor. De XML import module dient in de Rxact licentie aanwezig te zijn en de gebruiker dient rechten in Exact op de import te hebben. Nieuwe installatie nodig wegens de voorbereidingen van de tabladen (tabctrl32.ocx) version 023 2005-11-15 - Finaciale entry bug fix on Transactionnumber... and InvoiceNumber version 022 2005-11-09 new functionality: - import of General Ledger accounts. --> import of GL categories is also supported --> import of GL-CC links is also supported --> not working properly: notes and freefields are not working properly. Most likely this is not supported by Exact. bugfix: - Financial Entry XML: fields TransactionNumberSubAdministration and InvoiceNumber added to the Payment element. version 020 test version with connection timeout 5 seconds version 018 2005-10-28 bugfix: incase the no INI and ELC present application crashed. version 017 2005-10-27 - IMPORTANT: SECURITY INTEGRATED. DOES NOT WORK WITHOUT ELC FILE. - Financial entry: Debtor/Creditor code. EntryType in IDF defines the usage of the debtor/creditor from the header/subline. pls note that the XML definition for the entry header doesnot have a Debtor or Creditor. They only exist in the line. --> Entry type I (purchase journal). lineCreditor is filled with the headerCreditor. LineCreditor is neglected. --> Entry type V (sales journal). lineDebtor is filled with the headerDebtor. LineDebtor is neglected. --> Entry type else: (bank/general journal). lineDebtor and lineCreditor are taken into the line. HeaderDebtor and Creditor are neglected. version 016 2005-10-23 - Financial entry line: credit amount is placed under the element <Credit> and minus sign is removed. - markup characters & ' " < > are replaced their character references. version 015 2005-10-21 - financial entry. Fixed: resource at line level VAT codes line level. version 014 2005-10-21 - financial entry implemented. Only the Purchase entry is tested. version 013 2005-08-26 - checkbox toegevoegd om de bronbestanden te verwijderen. - de waarde van de checkbox wordt per idf en bronbestand opgeslagen in de ini. version 012 2005-07-12 - orders: idf term discount% werd niet herkend. Nu zowel "discount" als "discount%" geldig voor het aangeven van het kortingspercentage - algemeen: datum afhandeling. Indien een maand of dag slecht een cijfer bevatte werd deze niet herkend (voorloop nul ontbrak). Dit is aangepast in de datum afhandeling. - algemeen: in sommige gevallen werd de Target directory niet goed genomen voor het schrijven van de XML version 011 2005-07-11 bugfix. Orders: in de order line werd geen prijs geplaats indien er geen kortingspercentage was. version 009 2005-06-06 - after mergin the header and subline array the idf was reloaded. The reload action is taken out because this undoes the corrected fieldnumbers in the idf. version 008 2005-06-03 - read TAB separated files - read ; separated files - read ascii files - read two files (header and subline) files for orders version 007 2004-12-08 - in order line the item code was trimmed at 10 positions, this only needed for AAB option= 1 version 006 2004-11-12 - last importtype used saved in ini - last importdef by importtype save in ini - last source file and target dir by import def saved in ini - when starting these settings will be retreived - order xml: element discount always put in file (if no discount this will be 0)
Doc id: 00.001.061