Using the object model we are importing Purchase Orders from another system into Solomon. We are see the following error behavior:
-
When a Po already exists in the system, we search the detail grid to see if the item has already been entered
-
If found we will update it, if not we will create it.
-
Per the example given in the Object Model documentation, we first see if the Purchase order has any records using the following code
-
bRecordFound = (solomonOMSPOConnect.First(StrDataEntity) = sivRecFndFound)
-
The problem is that it appears that solomonOMSPOConnect.First(StrDataEntity) will sometimes return false even when the PO item grid has one of more detail records. This results in us creating a new item (since we don't think there is anything in the Grid) when in fact there is already an irtem in the grid, in other words a duplicate.
Has anyone else seen this behavior? Is there an effective workaroud
*This post is locked for comments