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?
Anyone has comments on this? It would be great a have some feedback as I'm new to CRM thanks
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.