Back

When trying to update the transaction posting date in a SOP transaction, you cannot find a parameter to map it to.

Published: Dec 08, 2011
Post Author Written by eOne Solutions

When trying to update the transaction posting date in a SOP transaction, you cannot find a parameter to map it to. This occurs because eConnect does not provide a parameter that updates the posting date in the standard eConnect nodes.

There is a template script attached to this article that can update the transaction posting date if GP is set up correctly to allow the posting date to be set on a per transaction basis, rather than having it based off of the batch.

  1. To ensure that GP is set up correctly, go to Tools – Setup – Posting – Posting. Select “Sales” from the Series dropdown list.
  2. Select “Sales Transaction Entry” from the Origin dropdown list.
  3. Mark the radio button next to “Transaction” in the “Posting Date From” field.  
  4. Click Save and OK to close the window when it is set up correctly.
  5. Once GP is set up correctly in order to allow the posting date to be set for each SOP transaction the following script can be configured with the map to allow it to be set.

Click here to download the script.

NOTE: Scripts are provided as is. Assistance with installation or modification of the scripts is available as a billable service from our professional services team.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.