Lookup table vs drop down list (option set)

(1) Share

Report

Posted on by Samantha73

3,297

Hi Guys

I'm having a hard time synchronising dynamic Sales options sets to Business Central. For example if I create price discount code as global option set then I can use it in Products. Also I have custom table for each code with % discount and min qty so discount logic is in a table . Now I can apply the logic in sales quote products screen. This works fine until we want to add another value. Here you have to open the customisation and another value to global option set. You don't want the end users to do this. The other option is using lookup tables. Which works except "name" column is what is shown and not a unique key. Back end will use GUID so querying new extra bit of code. Syncing to ERP needs another field as primary code. What are pros and cons of each approach and any specific considerations for integrations?

I have the same question (0)

All responses (1)

Answers (0)

Samantha73 3,297 on at

Like (0)

Report
Copy link

Link copied!

Anyone has comments on this? It would be great a have some feedback as I'm new to CRM thanks

Was this reply helpful? Yes No