To have an Automatcing role like we have in 4D Pro should help.
With Automatching role, we do not need to build so many Queries if we have long Cost Code list.
Or if Modeler can have an Autoassigment logic is again better.