Using Universal/Generic Writeback

Applies to:

• Velixo NX
• Velixo Classic
• Acumatica, MYOB Acumatica, Cegid XRP Flex

Overview 

Velixo Classic Generic Writeback and Velixo NX Universal Writeback are licensed features available in Velixo for those clients needing to send Excel for Windows data to pre-defined screens within their ERP.

Universal/Generic Writeback can work with any active Import Scenario that is already defined within the ERP and to which the user has access rights.

Choosing the Universal or Generic option (from the New Sheet selector) starts the process of being able to create a new worksheet to write data to your ERP system.

Velixo will prompt you to select the Connection to which data will be sent and which of your EPR's active, pre-defined Import Scenarios you want to use for writing the data:

The Universal/Generic Writeback feature requires that the Import Scenario you want to use is already active within your ERP and that you have access to that Import Scenario.

Here you can see the Import Scenarios defined in a sample Acumatica:

[ Note that the first step that must take place is for all active Import Scenarios to be retrieved from the ERP.  This may take a moment. ]

Once that is complete, you can select the active Import Scenario you want to use:

Velixo will then create a new worksheet using the writeback fields associated with the Import Scenario you selected:

The worksheet includes the Writeback Status column which contains the WRITEBACK functions that will be used to send your data to the ERP:

 You can now fill in the required data.

Note: The ScreenID parameter can be specified with or without dots.

e.g.,

or

Once that is done, click Perform Writeback on the Velixo ribbon to activate the WRITEBACK functions and write all the specified data to your ERP:

Notes: 

If you only want to select a single (or multiple) worksheets, ensure that worksheet is displayed and select Current Worksheet from the pulldown on the Perform Writeback button:


If you only want to import specific rows, first select them, then click Selected Cells or Worksheets from the Perform Writeback pulldown.

This feature can also be used to select multiple writeback worksheets and perform all writebacks defined on those worksheets.

Writing Back with Attachments

By default, the WRITEBACK functions are configured to use the provided grid.  However, you are welcome to create your own form and WRITEBACK function.

For example, let's consider that we are performing a Writeback to the Acumatica Bills and Adjustments page (screen AP301000) using an Import Scenario named Velixo Import Bill.

That Import Scenario is configured to provide the ability to attach a document:

Important: ...

*** Excel for Windows ONLY ***

Velixo Classic for Excel for Windows supports the ability to access the computer's file system to support this attachment functionality.  Currently, Velixo NX does not support being able to access the computer's file system.

Here is a simple Writeback worksheet with the information we want to send to Acumatica, and the WRITEBACK function to accomplish that:

We will be sending data for the Vendor, Vendor Reference, and Amount fields, and attaching a file to the record.

Once the Writeback is performed, all the data - including the attachment file - is present in the Bills and Adjustments page:

Notes:     If your Velixo license does not include use of Universal/Generic Writeback, you will see this message when you select Universal or Generic from the New Sheet option:   Click Upgrade to start the process of upgrading your Velixo license to include this feature. When used with Acumatica 2022R1 or higher, Universal/Generic Writeback can be used with either username/password authentication or Single Sign-on authentication.   Note that using multi-factor authentication (MFA) requires that OAuth2 (aka SSO) be enabled.  This does *not* require an SSO/Advanced Authentication License with Acumatica (which is only required if you want to link Acumatica to ActiveDirectory, Okta, or another provider). For older versions of Acumatica, multi-factor authentication (MFA) and single sign-in (SSO) are not supported.