Description

The WRITEBACKARGUMENTS function returns an Excel array containing the necessary values (those not automatically assigned by Acumatica) which need to be included in a writeback for the specified Acumatica Import Scenario.

Syntax

WRITEBACKARGUMENTS(Connection, ImportScenarioName)

The WRITEBACKARGUMENTS function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ImportScenarioName

Required

The name of the Import Scenario corresponding to the Acumatica screen name for which data is being sent.

The name of the Import Scenario can be found by navigating to Acumatica's Import Scenarios screen (SM206025):

Note that an Acumatica Screen Name can have more than one Import Scenario.

Example

=WRITEBACKARGUMENTS("Demo", "ACU Import AP Payments with Applications")

Description

Returns the non-defaulted field mappings that are configured in Acumatica for the specified Import Scenario.

Result

writebackarg02.png

writebackarg03.png

By using Excel's TRANSPOSE function, the results can be formatted as the header for an area ready to be used by the Velixo WRITEBACK function:

writebackarg05.png

Did this answer your question?