Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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.

  • 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 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans