Universal Writeback
Created by Harry Lewis, Modified on Mon, 26 Aug at 6:07 PM by Harry Lewis
Applies to:
- Velixo NX
- Acumatica, MYOB Acumatica, Cegid, Jamis Prime, Haufe 360
Overview
Universal Writeback (formerly 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 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:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000196882/original/69sz4AmlGdrN-Zfy9GN3wsz9k10V1FnAWw.png?1694670522)
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:
![Acumatica Import Scenarios screen](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000196885/original/VoTIADUkM6Qu1KqhkaPeQMvjU35M4aFrBA.png?1694670522)
[ 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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article