Update cost for 4" ped poles in Data Tracker damage reports

[atdservicebot]

What application are you using?

Data Tracker

Describe the problem.

There is not a cost listed for 4" ped poles when you "Add Replacement Equipment" to a Damage Report. The poles are included in the COA Cost Estimate Items ($110- which is correct- see screenshot 1) but no cost is associated with the item when a pole is added for replacement equipment (see screenshot 2). Can we please get that cost updated so our cost estimates will be more accurate? Thanks!

How soon do you need this?

Flexible — An extended timeline is OK

Requested By Erin B.

Attachment (10.65kb)

Request ID: DTS21-102415

[amenity]

@dianamartin - is this a bug?

[amenity]

And it looks like only one of the screenshots came through. I'll ask Erin for the other.

[dianamartin]

It's not a bug, I think the inventory planners just don't have a unit cost for the item. Erin will want to talk to Ray F. or Johnny P. about it as they can update the Finance and Purchasing system and it'll come over to the Data Tracker.

[amenity]

Aha! Cool. I'll let them know.

[johnclary]

@dianamartin Here's the inventory item. You can just edit the unit cost to the correct number. However, for the damage items on existing damage reports, you'll have to find a way to update the unit cost snapshot.

[dianamartin]

@amenity did you say Erin said the item unit cost was $110/per pole? I'lll message Erin to confirm.

[dianamartin]

Received confirmation from Erin that the unit cost is $110.

object: inventory_items

• Unit Cost - #
  • Enter $110 here

object: inventory_transactions

• UNIT COST CURRENT - text formula (brings in unit cost from inventory_items)
• UNIT COST CURRENT NUMBER - #
• UNIT COST FINAL - # (references UNIT COST CURRENT NUMBER, when transaction is completed)

There are only 73 transactions of the 4" pipe pole.

[dianamartin]

@johnclary I was able to update 66 of the 73 records.

• 7 records came out blank and strange I don't know why it's coming in that way = $2,642,007,942.6800.

[johnclary]

@dianamartin it's multiplying by the quantity—is that high?

In any case—remember that the damage report items need to be updated as well.

[dianamartin]

@johnclary the quantities weren't that high so that's why it looked wrong to me

[johnclary]

strange. @dianamartin i ran the batch update again and it seems to have cleared up the issue. all completed transactions for 4" pipe pole.

I see the damage items are all updated. I think this can be closed?

[dianamartin]

@johnclary Then maybe they were just stuck yesterday? I'll let the user know and close this.

[dianamartin]

Messaged user 8/13

Hi Erin, your request to "Update cost for 4" ped poles in Data Tracker damage reports" is done. 

User replied

Fantastic! Thank you so much for doing that! It will impact a lot of damage reports!

[johnclary]

Double checked damage items and updated a few more. We're good now!