Generic Writeback

Created by Harry Lewis, Modified on Wed, 13 Mar 2024 at 11:49 AM by Harry Lewis

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:

 

Acumatica Import Scenarios screen

 

[ 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


{FUNCTIONNAME}(Connection, ...)

Parameters


The {FUNCTIONNAME}  function uses the following parameters:


Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

...


* 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)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article