Announcements
Hey Everyone:
I have a need to execute a logic app when a customer payment record is changed in Business Central. This pattern that I describe here works for other records. It does not work for customer payments, however, and I was hoping someone could either point me in the right direction, or validate that I'm not crazy?
The proposal is simple - here is the logic app:
The system correctly gives me an id when the record in Business Central changes:
So far so good. This is the record that the system just alerted me changed, as verified by the system ID in the webhook and the system ID on the screen. But when I try to get that record:
(That's the input) it gives me this:
And bombs right out. It cannot find the record, it seems. Being a (somewhat) smart man, I decided to run this through Postman, too. And I get:
This is by calling:
api.businesscentral.dynamics.com/.../{{TenantID}}/sandbox/api/v2.0/companies({{CompanyID}})/customerPayments(7e094726-36c4-ed11-9a88-002248b18ec2)
So, seemingly, what I'm faced with here is:
- record x is changed
- the webhook is updated and notifies the logic app
- the logic app initiates, takes the row number
- record x doesn't appear to exist in the same table that called it
Am I nuts? Did I do something wrong? Why on earth would this work for one type of document and not another, especially when I can clearly see the system ID on the screen? Thoughts? Advice? Bueller?
Thanks.
-J
Sorry man, that's not even close what I reported, but thank you.
If you have posted the cash receipt journal, it will not be accessed. In that case you logic app can only be work if its not posted.
Hello,
We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.
I will open this up to the community in case they have something to add.
Thanks.
No one has responded yet, but I've made a discovery. In the case of cash receipts journals (at least) the subscription / get record combination only seems to work when it comes to posting in a cash receipt journal that was created **AFTER** the subscription has been created. It seems that any cash receipt entered in a journal that precedes the creation of the subscription fails, but works the other way around.
If anyone has any insight on this and could validate / verify / laugh at me, I'd appreciate it.
Thanks!
-J
André Arnaud de Cal...
294,135
Super User 2025 Season 1
Martin Dráb
232,871
Most Valuable Professional
nmaenpaa
101,158
Moderator