Generic Writeback

Applies to:

• Velixo NX
• Every ERP

Overview

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.

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 Generic 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 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.  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.

Note:  If you only want to write certain rows from your writeback worksheet to the ERP, select those cells and then  select Selected Cells from the pulldown on the Perform Writeback button:

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.

TABLE OF CONTENTS

• Syntax
• Parameters
• Examples
  • Example 1

Syntax

{FUNCTIONNAME}(Connection, ...)

Parameters

The {FUNCTIONNAME}  function uses the following parameters:

* see Filtering Techniques for Velixo Functions

Note: 

Examples

Example 1

{FUNCTIONNAME(Connection, ...)

Description

Returns .....

Result

<screenshot>

(cell references have been used for some parameters in this example)