Wire report problem - D-Tools Forum

avaltdan · 04-11-2011, 05:53 PM

Hello All,

When we are closing a project we generate what we call a "What Should Be There" list, that is compared to our accounting department's actual "What IS There" list, and any discrepancies are handled as a Change Order.

This system works well for us, but I am having an odd problem with our "What Should Be There" list (which is generated out of DTools).

The report is designed to show Manufacturer & Model, Description, Quantity, and Unit price (the sell price, not the unit cost). Everything shows up properly, except all of the wire. (I have attached a page of the report)

Example of an item that IS working properly:
RCA RG59 Connector (selling for $4.00 each) shows quantity 2 (correct) and Unit Retail $4.00 (correct)

Example of an item that is NOT working properly:
14/4 speaker wire (selling for $1.10 per foot) shows quantity 150 (correct) and Unit Retail $55.00 (massively incorrect-should be $1.10)

I checked the above two items and can find no differences in how the items are set up with the exception of the product category. I know the wire has to be of the category "Wire and Cable" in order for the program to generate the head end and wire lengths screens, but it seems to be screwing up my report. Even if, for the wire items, it was multiplying the quantity by the unit price, it is still way off (in the example above it would be $165.00, not $55.00). There is NO labor associated with any of these items so that shouldn't be an issue. Again - this only happens for the wire items. All equipment and accessories show up in the report properly.

Any ideas?

Thanks in advance,

Dan

fryeguy · 04-11-2011, 11:39 PM

In your report, what is the dtr:xxx value that assigns this value to the wire?
If you want to share the report I could take a look...

I have a report that is similar to this for purchase orders.
Most of the values are calculated values not straight from the dtr:xxx...

avaltdan · 04-12-2011, 04:27 PM

Fryeguy,

Thanks for responding. I know very little about the custom reports (just enough to be dangerous).

I was able to see the dtr.xxx field is "Price". I double checked the pricing of my wire from my database and it is correct ($1.10 per foot). And all other items seem to work fine - just not the wire. We don't really use calculated values - all of our labor is hard assigned by the salesman as a separate item, not attached to wire or equipment items.

I would be glad to share this report with you. How do I go about doing that? Again, I'm a bit of a newbie when it comes to this sort of thing.

Thanks for your offer to help.

Dan

**Ryan Brown** · 04-12-2011, 04:58 PM

If you use the data field dtr:UnitPrice your wire will show up properly, otherwise it's giving the total price per wire run. ie: 100' x unit price = price

avaltdan · 04-12-2011, 05:02 PM

OK - I'll change that and see what happens. Thanks.

Edit:

Hooray! That did it.

I tried to find "UnitPrice" in the drop down menu in report designer, but I couldn't locate it. So I just went to the field and changed "Price" to "UnitPrice" by typing the word "Unit" in front of "Price", and worked!

Thanks so much - my accounting department will be very happy.