Universal Writeback with Acumatica

Applies to:

• Velixo NX
• Acumatica, MYOB Acumatica, Cegid, Jamis Prime, Haufe 360

Overview

Universal Writeback (previously known as Generic Writeback) is a licensed feature available in Velixo NX for those clients needing to send Excel for Windows data to pre-defined screens within their ERP.

Universal 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 Writeback option (from the New Sheet selector on the Velixo NX ribbon) starts the process of being able to create a new worksheet to write data to your ERP system.

In the Velixo NX side panel, you will be prompted 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 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.  Under certain circumstances, this may take a moment.]

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

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

You can now fill in the required data.

Once that is done, select Current Worksheet from the Perform Writeback button on the Velixo NX ribbon...

... to activate the WRITEBACK functions and write all the specified data to your ERP.

Zeros in Writebacks

Important: ... in order for zero values to be sent to the ERP, the zeros must either be contained with quotation marks ("0") or be a cell reference to a cell that contains the zero.