Good day Suite People. I need some feedback if any of you have integrated EDI while using Item Groups. Here is my issue.
We use Item Groups for some items on the Sales Order side of things. These are used to capture "extra" fees or Tariff cost were we want the item and fee to be separated on the accounting side, but combine as one on the invoice. Probably the same thing many of you are using Groups for.
On the EDI side, we have EDI set-up to receive the item number from the customer, but push into NS the internal ID of the Group. This works fine and the Group is created on the SO. The issue is price verification. Our EDI source natively checks the price on the customer PO and validates that amount against the price of the item in NS, if the Internal ID is that of an Item. As you know, grouped items do not have a value, so this validation doesn't work. Furthermore, as we are pushing in the Internal ID of the Group, the native NS price is what populates on the SO. This causes us to lose sight of the price the customer sent us. Otherwise, I would create a SS to check SO price vs Item and sub-item price.
To put a bow on this for future readers, we ran into the issue on the Item Fulfillment/ASN output side of the process too. NS is pushing out the "extra" items onto the IF record. This data is what forms the ASN in EDI. As built, EDI would send this extra item to the customer, causing the ASN to error out. Our workaround there was a list of internal ID's of the "extra" items that the EDI solution would strip out of the document before transmission. I don't like this solution because of the extra maintenance (every new item requires our EDI provider to update this list of strippable items). If anyone has a better solution for this, I am all ears.
