I've been working on an API that can import into the new Sales Prices, or Bill of Material Lines. The problem is, I can't seem to find any way to import into a primary key, which makes importing into the /child table/ of a parent/child relationship impossible. I've attached an example for sales price, but I'm running into the same problem for Bill of Materials.
The schema is Price List Header and Price List Lines. The Primary Key for Price List Lines is /Price List Code/ which references the header. But because I can't import into this field, I'm importing without a primary key. This is obviously problematic.
AL Code:
Power Automate:
Dynamics Import (successful on other fields). Second row came from adding the data through the UI.
Does anyone have any workaround? I'm using the Dynamics 365 Business Central Power Automate Connector.
I'm also brand new to the forum! Please let me know if there's other information you need or if I placed this in the wrong discussion. Happy to edit
2
Share
Report
All responses (
Answers (
