Unable to create restriction
if _INVAMT > 0 then
else return false
When I run the map, I get errors on the negative amounts, so it doesn't appear that the restriction is working.
Can someone please let me know how i can get the restriction to work?
If you are trying to put a restriction on the "Create Transaction" node, you will get an error since SC is trying to initiate a transaction but a required node is being restricted out.
Try redoing your datasource to use an ODBC connection and then set your query to be something like "SELECT * FROM [YourSheetName$] where INVAMT>0".
Thank you for the reply Dave. I understand what you're saying, and I can use ODBC and add my filter there.
But can you please tell me what are the Restrictions intended for, if not to filter the data source?
The restrictions due cut out source data, but they are best used for line item nodes or even further down. An exmaple is a transaction that has analytical accounting info in it, but not on all the lines. You would map the AA node and put a restriction in so it only runs if the AA Code field was populated.
If the entire transaction needs to be blocked then the data source is the best spot otherwise you end up sneding in lines without a header, or sending entirely blank eConnect calls across when running the map.
If you would like to submit an answer or comment, please sign in to the eOne portal.