You’re offline. This is a read only version of the page.
Announcements
Hi,
I have a scenario where we have added Work Order Products to a Work Order which have been passed through integration to an external system. (Product Code,Used Qty,Total Amount)
Legitimately, later in the process it is determined that these were the incorrect products for billing and so we need to send another record through the integration to Credit these products on the external system and add the new 'correct' ones in D365. (to pass though the integration)
However, OOB the Total Amount field will not calculate a negative value and the only way the external system has of crediting these is by receiving a negative qty and a negative amount.
Any help appreciated.
Im not suggesting that you need a customer total amount field. Im assuming that you need this negative sum for this external system and you can turn the total amount number to negative in the integration if the WOP is marked as 'Credit' = Yes
Or if you cant change the total amount in the integration. You can have a custom total amount field but have a workflow to copy the value of the normal total amount when it changes. If the WOP is marked as Credit then change the custom total amount to negative.
I need to send a negative qty and negative amount for a work order product through an integration but also have the total amount on the work order respect these credited lines
I had thought of that but then I would also need a custom total amount field on the Work Order and write plugins to calculate which I was hoping to avoid
Are you sending just the work order products to this external system? Is the external system in charge of invoicing the customer?
You may want to just a a field on the WOP form called 'Credit' Yes/No and through the integration give the total amount as negative if Credit = Yes
#1
André Arnaud de Cal...
293,440
Super User 2025 Season 1
#2
Martin Dráb
232,575
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
