You can import your Excel data into a custom table in Sage.  That should be easy enough.  You can clear and re-import into this custom table every time there is a change.  

You could then join to this custom table in your crystal report.

I have thought of that, but the problem I'm having is there is over 50 records of different type of restrictions. How do  I get it to check a sales order  record for all 50+ excel lines of restrictions?

I have thought of that, but the problem I'm having is there is over 50 records of different type of restrictions. How do  I get it to check a sales order  record for all 50+ excel lines of restrictions?

A script with a loop to check all the UDT conditions for each line entered... which might slow the import down.

how you design your restrictions is the most important part of this exercise.

When your table is in SQL, you can do a lot with it.  Send me a meeting invitation - teams or zoom and i'll walk you through a few approaches.

I'll have to check with the company that does our firewall stuff and I'll let you know.

I was approved for Zoom, let me know when the best time for you would be and a email.