Fighting with the Fee Sheet

Hi,
As we were not happy with the way we had to enter non-drug products, I created an extra set of forms and a “products” table plus “product inventory” table, to separate ND from drugs (with an addition to the Inventory menu). It works and we have now two separate drug and ND views with more columns appropriate to ND products (variation, weight color etc) and no dosage and routes…
They also show up in the fee sheet with a checkbox (when clicking the products button), but that’s about it. The ND products have their own prod_id, but the Fee Sheet, and corresponding Class and ClassHTML files don’t look for that, they just include the drug_id. So I cannot get them into the billing lines and eventually the sales and billing tables, without considerable changes to the Fee Sheet + Class code.
Does anyone have a bright idea how to accomplish that task without changing all the arrays and control mechanisms to include the new prod_id?
Or is there someone who has done that already?

thanks
Roland :paw_prints:

@Roland It seems like you took the long way around what should have already been functioning within the program.

Can you shed a lot more light on what was displeasing about the inventory setup that is currently built into the system?

How long has your office been using OEMR?