Anrova 22.4

SmartLynx

• Forms
  • Support changes in font size of the SAP client.
• Mapping template
  • Make it visible if a template has ‘Namespaces’ or ‘After execution script’ defined.
    • The text on the button will appear differently.
• Task schedule
  • Added new type: Weekday X at Y (HH:MM)
    • Schedule a task at a certain day in the week, and a specific time.
• Task log
  • Adjusted the ‘Execution count’ field. It will now show the correct number of executions in case of errors.
    • Remarks:
      • Existing executed task with errors will still show an incorrect number of executions
      • Existing unexecuted tasks will show an incorrect number of executions when they are executed
• Support new target type
  • Purchase Request

Companyweb

• Created plugin for integration with Companyweb
  • (Requires an account of Companyweb)

Anrova 22.3

SmartLynx

• Import
  • Store functionality: Store a certain value to be used later on as a keyword
    • Syntax: [stored.xxx]
  • Error on value: When the field has a certain value, throw an exception
  • Do not set on value: When the field has a certain value, do not set in in the property of the object being imported
  • Added new target type:
    • DYNAMIC
      • This means that the actual target type will be retrieved from the data to import. A new field ‘Tag name for target type’ is shown to enter the tag name. This tag name will be used in the data to import to get the actual the target type.
    • Cash discount
  • Mapping filter query
    • When a query is entered in the query field, the data is skipped when that query return no results
  • Item
    • Support preferred vendor
    • Support uom + uom package
  • Support document references on documents and stock transfers
    • Only available in SBO 10 or higher!
• Export
  • New mapping type: Grouped export
    • Use this to group multiple types of export files into 1 mail
• Added starter package
  • In the SAP client you can easily add out-of-the-box templates and configurations
  • Current set
    • Exchange rate ECB through XML
    • Exchange rate ECB through REST
• Email template: Set a file name format when zipping files
• Support new target types
  • Shipping type
  • Sales person
  • Business partner catalog number

SmartOne

• Quickly create invoice template for a supplier from an existing purchase invoice
  • On the purchase invoice form, right-click for menu ‘Set as Smartdoc invoice items for this supplier’

Anrova 22.2

SmartLynx

• Mapping templates
  • Support new target type
    • Bill of Material
    • Pick list
  • Test mapping
    • Support entering a keylist when testing the mapping
  • Keep track of history of a template
    • View list of previous versions and drill down to details
    • Restore a certain version
  • On export XML/JSON
    • Hide a tag when it has a certain value
• (S)FTP
  • Use temporary files/folder on upload
• Allow to test connections on the DB Credentials form
• Added ‘Keep visible’ functionality on the selection form
  • When checked, a new form with the data is opened instead of showing the data in the current form.
• Task
  • Store the objects that have been imported.
    • These added/updated documents can be viewed in the Task log lines.
  • Allow to set certain errors where the task should not be retried.
    • Menu: Anrova –> SmartLynx –> Configuration –> Errors to skip retry
• File import
  • Allow to set an archive path per configuration
    • Available for File to DB and File to File
• Export to PDF
  • Support sending 1 mail with multiple PDF’s
    • Configuration through mapping template: Add line level query. Header query is used to group which files need to be added to the mail.
• Performance
  • Notification queue: Only add row to the table when there is an active configuration for the notification.
• Import/export tool
  • Importing a configuration will set the configuration to inactive when it is being added. When the configuration exists, the value of the active property will remain what it was.
  • Added additional column ‘Configuration type’ for the import/export of a configuration
  • Added additional column when importing something to have a link to the created data.

Anrova 22.1

SmartLynx

• Configurations
  • Hide the DB column when there is only 1 active DB configured AND it is the same DB as the logged in DB (company) in the SAP client.
  • Filter query: Allow to use keyword [taskcode].
  • Task schedule
    • Support to execute the scheduled task manually.
• Inbound webservice
  • Support endpoint without the need for a structured body. The URL contains the needed data:
    • {URL}/api/import/{actionType}/{transactionType}
    • Example: https://localhost:1234/api/import/17/A
      • This will trigger an import for action type = 17 (Sales order) and transaction type = A(dd)
  • Web request
    • Support multiple keys
      • The key names need to be present in the query in the template
  • Support calling another webservice from the inbound webservice
    • This uses the Web & DB – Notification queue configuration
    • The endpoint is {URL}/api/notificationqueue
  • Support to set customized error messages when retrieving data.
• Added new mapping types
  • Direct Import
    • This mapping type will execute a query, and immediately import the data into SAP.
  • Sap xml export
    • This allows to get the XML exported by SAP
• Use a base64 string of a PDF in an export.
  • This can for instance be used to embedd the invoice in a UBL.
• B1i
  • Allow to configure tasks to be picked up by B1i
  • Requires to have B1i installed and scenario’s need to be configured to handle the tasks.
• Export
  • JSON
    • Support to have empty array in the exported JSON.
• DB to File
  • Support to delete the file after the task is executed.
• Mapping
  • Allow to set a mapping line inactive.
  • ‘Select fields’ screen can be kept visible.
  • Support a new query optimizer
    • Using the result of a parent query in child queries
  • Add new target types
    • Activity
    • Barcode
  • Support export to type long (int64)
• Email template: Support ‘Reply to’ email address.

Smartdoc

• Add a date format used in the indexes.
  • Can be changed in the settings
• Create invoice/credit note manually
  • Allow to set the remaining price in the selected row
  • Allow to divide the price equally over all rows

Anrova 21.5

SmartLynx

• Web & DB
  • Notification & Task schedule
    • Allow to set an error template
      • When this is set, and the web service call returns an HTTP Status code not in the ‘OK’ range, a new task is created with the response of the error, and linked to the error template.
• Supporting CSV import
  • Also support Header/Line
  • Allow to split up task, and provide a number of rows that can be added to a split up task
• Mapping
  • Added new Transaction override types
    • ‘Add/update’
      • This is used when a close of a document in 1 DB should trigger an add in another DB
    • ‘Delete’
      • Delete an object
    • ‘Delete line’
      • Will delete certain line(s) from an object
      • In the template it is configured which line(s) to remove
  • Support new target type
    • Internal reconciliation
      • Using the ‘internal reconciliation’ is regarded highly risky and is not recommended by SAP!
      • Please use this carefully and at own risk…
      • See SAP note 2586911 for more information.
• Email templates
  • Support embedded images in emails
    • [image.xxx] – Get the path of the image from a tag name
    • [fixedimage.yyyy] – yyyy represents the fixed path of the image
  • Allow to zip attachments
  • Allow to delete email template
  • Allow to duplicate email template

Smartdoc

• Open Smartdoc ‘Update’ form from SAP client
• Open Smartdoc ‘Search’ form from SAP client
• Support credit notes
  • Automatic import
  • Manual import

General

• License
  • Improved license logic
    • Re-importing license required!
• Installer
  • Allow to save the configuration without going through the full installation process
  • Install another environment after installation finishes
    • Avoids the need to close the setup, and restart it

Anrova 21.4

SmartLynx

• License: Show message when license is about to expire
• Task log: Additional filters:
  • Configuration
  • Mapping template
• Support new target types:
  • Draft document
    • This will allow you to create a document from a draft
    • Has the option to delete the draft after the document was created
  • Production order
• Support down payment link on a document..
• Add new FTP types: FTPS Implicit & FTPS Explicit
• Send mail on failure/success of a task
  • Needs to be set on the configuration forms
• Web & DB:
  • Call webservice and print a label (PDF or Image) from response
  • Notification & Task schedule:
    • Added ‘Follow up action type’. When filled, an additional task will be created for the response of the webservice. This task will be picked up by the ‘DB to DB – Task’ configuration.
• Export
  • Allow to call SBO method (Like getting the item price)
    • Can be done by setting a mapping template line of type ‘SBO Method’
    • Right-mouse click on option ‘Set input/output data’:
      
    • This opens a new form to enter the input/output data:
      

SmartOne

• Rebranded SmartOne to Smartdoc

General

• Runs on .NET Framework 4.8

Anrova 21.3

SmartLynx

• Added configuration for ‘File to file’
  • Moving file to another folder.
    • Possibility to have filter query to decide if move is needed or not
• DB to File
  • When sending mail, allow to set fixed files that also need to be sent as attachment. This can be set on the configuration screen. The path of the file can be customized using the [tag.xxx] functionality.
• Support new target types
  • Sales down payment invoice
  • Purchase down payment invoice
• Ftp
  • Support SSH key for authentication
• Added option to only update the object when the data has changed
  • Configurable on the Mapping Template
• CSV export
  • Allow to set the delimiter to be used
    • Use \t to set a tab delimiter
• Task log form
  • Date filters now include a time
    • Format: HH:mm or HH:mm:ss
  • Hide scheduled tasks in the future
• Emailing
  • Allow to set multiple email accounts to send from
    • Available through menu: Administration->Setup->Anrova->Email accounts
  • On email template set the email account to be used
    • When not set, the global settings will be used
• Import/export
  • Email templates
  • Configurations
• Logging additional information on restarting service
  • CPU, RAM, ProcessorTime, Last executed query, …
  • Allow to also log this information during each loop of the service. Add this to the config file to enable it: <add key=”LogDumpInfo” value=”true”/>
• Priority
  • Added priority on a task.
    This can be set in the configuration forms.
    When creating a task, the priority of the configuration is used.
  • When tasks are executed, they are sorted by priority.
    There is also a priority timeout that can be set in the Task service controller (Administration->Setup->Anrova->Settings).
    When the execution of the current tasks exceeds this timeout, the next task is not being executed again, but a new query is run to get all tasks to be executed, order by priority.
• Support to add attachments when adding/updating a document in 1 time instead of having 2 separate configurations

SmartOne

• Create manual invoice
  • Show Smartdoc document in grid on invoice form
• Extract PDF from UBL when opening document from Smartdoc

Installer

• Added Lightweight installer
• Add ‘Test connection’ buttons

Anrova 21.2

SmartLynx

• Web to DB
  • Support posting XML
• Xml Export
  • Support DOCTYPE declaration
    • This is set on the Mapping Template:
      
  • Support ‘Self closed’ nodes
    • <xmlTag/> = Self closed; <xmlTag></xmlTag> = NOT Self closed
    • This can be set on the Mapping Template:
      
• Test mapping
  • Import: Allow to set the ‘Key’ used for an import
• Mapping template
  • Allow to change the order of the mapping query lines (Top grid)
• Task/Notification service
  • Added additional DI-API corruption detection.
• Support new target types
  • Incoming payment
  • Outgoing payment
  • Journal voucher
  • Attachments
• Allow to set DB Credentials inactive
• Inbound webservice – Import
  • Give better error message when the processing fails.

SmartOne

• Minor improvements

License

• For licences of type ‘DB’ a DB needs to be assigned.
  • When requesting an on-line license, and the requesting DB does is not assigned yet, the DB will automatically be assigned when there are still free licenses available.
  • Removing a DB can be done through the Anrova license form in the SAP client.

Anrova 21.1

SmartLynx

• Export
  • CSV export
  • Allow to optimize queries being executed
    • When nested queries exist, do not run a query per row from the parent query, but only run query once, and filter data in memory.
    • This improves performance when the parent query returns a lot of rows.
  • Allow to set the File encoding
    • When not set, UTF-8 is used
• Support new target types
  • Special prices
  • Enhanced discount groups
• Import
  • Allow to set whether a property does not need to be set during an update.
  • Support to NOT delete existing lines of an object.
    • Example: Import a business partner with 1 bank: Do not delete existing banks when they don’t match the bank from the input of the import.
• Test mapping: Support export PDF and CSV
• Web calls:
  • Support to set additional header information
    • This can be set in the request/additional templates:
      
  • Allow to set a timeout for a web call
    • Configurable on the Task service controller
  • Support new Web Request types:
    • PUT
    • PATCH
    • DELETE
• Web authentication
  • Support OAuth with Form Url Encoded content
• Support (S)FTP download
  • Allow to PGP decrypt the file being received
• Added new keyword: ‘no_error_tag’
  • This keyword will do the same as the keyword ‘tag’, but there will be no error thrown when the ‘name’ of the tag does not exist. An empty space will be used as replacement value.
• Export XML files
  • Split up export into multiple files
    • Based on the ‘Split import/scheduled task’ setting on the mapping template.
• Schedule task: DB to DB / DB to file
  • Configure a ‘Key’ to use for the task
    • This allows the use of the [key] keyword in the mapping template.

SmartOne

• Allow to create invoices from Smartdoc in SAP Client
  • Used for item/service invoices, based on goods receipt or not, …
  • New dashboard form to create the purchase invoice
  • Auto fill fields based on Smartdoc data
  • Visualize document total differences between Smartdoc and SAP
• Open document from Smartdoc in the Purchase invoice form

Anrova 20.6

SmartLynx

• Internal: Automatic testing procedure to keep providing stable builds
• Allow to test mapping in SAP client
  • On the mapping form a ‘Test mapping’ button has been added
• Allow to split import/scheduled tasks
  • Configurable on the mapping template
• Source key lookup can be configured to always use a table to store the link instead of a UDF on the object. This is helpful when a copy to/from is used to create new objects => The master key UDF is also copied when doing this, resulting into wrong lookup of the object.
  • Configurable in the Anrova Setting -> Task service
• Added check for database consistency.
  • Useful for when a backup/restore is done from Production to Test. The DB credentials are linking to the Production environment if this is not adjusted. To avoid this situation a check for this has been added. When starting the add-on a warning is shown and the user is requested to update the credentials + confirming the database.
  • When the task or notification service is started, and there is an inconsistent database detected, the service will not continue.
• Support new target types
  • States
  • Uom
  • Uom group
  • Banks
  • UDO
  • UDT
  • Price list
• Define a script to be run after Success or Failure of a task
  • This script can be set on the Mapping template
  • Please use this option with caution! Only for updating UDF or UDT!
• Error handling:
  • When importing an object, and an error is thrown: Logging the XML string in the Task Log Line.
• Documents import/export
  • Support Special lines
  • Support Additional Expenses (Header)
  • Support Additional Expenses (Line)
• Task log form: Support auto refresh
  • Number of seconds between refresh can be set in the Task service settings
• Support dynamic (parent) tags on export
  • Uses keywords like [tag.xxx], [date.yyyyMMdd], …
• Support (S)FTP upload
  • Allow to PGP encrypt the file being sent

Installer

• Created the notion of ‘Environment’
  • Create as many environments as needed
  • Settings/Databases can be set for an environment
• Allow to set user name and password to use to execute the service
• Allow to set the startup type of the service:
  • Automatic (Delayed)
  • Automatic
  • Manual
• At the end whith the option to save the configuration, the user needs to either press ‘Save’ or ‘Don’t save’ to be able to finish the installation

SmartOne

• Double-click on picturebox opens the thumbnail

Anrova 20.5

SmartLynx

• Support SAP 10.0
  • Support SQL server 2019
• Created installer
• Export files
  • Allow to build the foldername dynamically using keywords
    • This is similar to the fucntionality for the file format
    • Uses [tag.FieldName] or [date:yyMMdd] keywords
• Inbound webservices
  • Import a task
    • Creates a task to perform the import
  • Request data
  • Import data
    • Performs the import directly
• Import
  • Allow to set whether an UPDATE of an object may result in an ADD in case the object cannot be found.
    • Can be configured in the template
• Support new target types
  • Purchase return
  • Sales return
  • Sales quotation
  • Bank statement
  • Inventory counting

SmartOne

• Created installer

Anrova 20.4

SmartLynx

• Supporting new target type
  • Exchange rates
• Add possibility to call webservices
  • Document (XML)
  • SOAP 1.1
  • SOAP 1.2
  • REST
• Template mapping -> Select fields
  • Add possibility to search for a certain field
• Allow to send mail without an attachment

Anrova 20.3

SmartLynx

• Supporting new target types
  • Warehouse transfers
  • Item prices
    • This is part of the ‘Item’ target type. Add a new row of type ‘Line’ to add item prices
  • Sales delivery
  • Purchase goods receipt
  • Production goods receipt
  • Production goods issue
  • Purchase orders
  • Stock transfer request
  • Sales forecast
• Add possibility to create draft documents
  • Configurable on the Mapping template
• Add more schedule types
  • EveryMonthAtDayX
    • When X is larger than the number of days in the month, the last day of the month is used
  • EveryYearAtDayX
    • When X is larger than the number of days in that year, the last day of the year is used
  • EveryYearAtDateY
    • Y needs to be filled
    • Example: 31/03
      • This will create a task for each year at 31/03
    • Default format is “dd/MM”
      • This can be customized
      • Example: 03/31|MM/dd
        • Data is split by pipe
        • First part is the date
        • Second part is the date format that needs to be used
        • So this example will also result in 31 of march of each year
• Support printing to printer (PDF from report)
• Allow to set the log file of the add-on
  • Configurable in the settings (Administration=>Setup=>Anrova=>Settings)
• Allow to open the log file from the SAP menu
  • Administration=>Setup=>Anrova=>Open log file
• Added primary key search logic
  • By master key
  • By primary key
  • First master key, then primary key

SmartOne

• Add possibility to create the purchase invoice as draft
• Allow to set the log file of the add-on
  • Configurable in the settings (Administration=>Setup=>Anrova=>Settings)
• Allow to open the log file from the SAP menu
  • Administration=>Setup=>Anrova=>Open log file