OmeLuuk
4th April 2023, 16:18
We have an interface running on Sales Orders, Item Data and Customer Data (business partner data). We enriched the standard BOD (or developed a complete customized BOD) and use triggers on "related tables" to get updates.
Focused on the SalesOrderBOD: every line added changes the order amount and thus triggers a BOD update (and yes, we did add triggering on SO status < confirmed, so we are to blame).
Focused on Item Data (for webshop) every change in the Item Data (including stock levels, pricing, ISA or IPU data) does trigger a BOD, and often they are quick one after another and (almost) identical (and also here we added additional triggering on related tables).
I tried to implement a mechanism to recognize "premature data" in the BOD (like no customer name stored yet) and in such cases do not enrich the BOD with the extension, but I was wondering, is there a way to "group" BODs in one BOD instead of have a (incomplete) BOD after each intermediate commit?
How do you cope with "redundant or premature BODs"?
Focused on the SalesOrderBOD: every line added changes the order amount and thus triggers a BOD update (and yes, we did add triggering on SO status < confirmed, so we are to blame).
Focused on Item Data (for webshop) every change in the Item Data (including stock levels, pricing, ISA or IPU data) does trigger a BOD, and often they are quick one after another and (almost) identical (and also here we added additional triggering on related tables).
I tried to implement a mechanism to recognize "premature data" in the BOD (like no customer name stored yet) and in such cases do not enrich the BOD with the extension, but I was wondering, is there a way to "group" BODs in one BOD instead of have a (incomplete) BOD after each intermediate commit?
How do you cope with "redundant or premature BODs"?