Service | Customer Service, Contact Center, Fie...

Negative Used Qty on Work Order Product

(0) Share

Report

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.

All responses (5)

Answers (0)

Suggested answer

Thomas David Dayman 11,323 on at

Like (0)

Report

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 260 on at

Like (0)

Report

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 260 on at

Like (0)

Report

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 2,990 on at

Like (0)

Report

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 11,323 on at

Like (0)

Report

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