Error received containing verbiage - Rule: ER101_OrderInternalISEmpty RowKey

Rule: ER101_OrderInternalISEmpty RowKey: - if you see this error then see the below.

Dev has created the below statement, note that this statement assumes that none of the customer's booking rate items should be internal.

UPDATE ER205_INVOICE_DTL SET ER205_INTERNAL = 'N' WHERE ER205_INTERNAL IS NULL OR ER205_INTERNAL = '' OR ER205_INTERNAL = ' '
UPDATE ER101_ACCT_ORDER_DTL SET ER101_INTERNAL = 'N' WHERE ER101_INTERNAL IS NULL OR ER101_INTERNAL = '' OR ER101_INTERNAL = ' '

If they use internal bookings then they should fix the flag manually instead since they know which ones should be internal and we don't.  The main problem causing the error message is that the "internal" flag on order items was being set to NULL which is effectively making them unchecked. But we have no way of knowing what it "should" be on a per customer basis
The above SQL just resets all of them to unchecked or FALSE essentially

Examples of this issue are tickets: #291536 and #294790 and #293982 #297824 and #297834

Please see Teams Post: Cathy Herrick: Rule: ER101_OrderInternalISEmpty RowKey: - if you see this error t...

posted in Global Support Services / Global Enterprise on Wednesday, November 15, 2023 8:57 AM