Start a new topic

Unit Cost per Manufacturer Part Number

I am trying to create an agreement and need to add certain unit prices based on the manf part number, but the formulas that I am trying is causing an error in QW and then the program shuts down.


.if.documentitems->manufacturerpartnumber=HE_10GB_1YR.total-of.documentitems->unitprice


I am assuming that there is a problem in the formula. When I copy and paste an external formula the system continues.

What would be the correct formula to use in this instance?


Try this:

.if.documentitems->manufacturerpartnumber="HE_10GB_1YR".then.documentitems->ExtendedPrice at the line item (detail section) level.


Then copy that into one of the footer sections and double-click on it.

you should then be able to set the summarisation type to Total.


Hi Matt... it works!


Thank you so much!

You're most welcome! :)

Login or Signup to post a comment