web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Negative Used Qty on W...
Service | Customer Service, Contact Center, Fie...
Suggested answer

Negative Used Qty on Work Order Product

(0) ShareShare
ReportReport
Posted on by John Holmes 260

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.

I have the same question (0)
  • Suggested answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Negative Used Qty on Work Order Product

    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.

  • John Holmes Profile Picture
    John Holmes 260 on at
    RE: Negative Used Qty on Work Order Product

    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

  • John Holmes Profile Picture
    John Holmes 260 on at
    RE: Negative Used Qty on Work Order Product

    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

  • Fannie30 Profile Picture
    Fannie30 2,990 Moderator on at
    RE: Negative Used Qty on Work Order Product

    Are you looking to adjust work order product quantity or what is invoiced to the customer?  What’s the problem you’re trying to resolve?  

  • Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: Negative Used Qty on Work Order Product

    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

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.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 100 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 72 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 54

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans