Skip to main content

I’m trying to get BurdenedCost from the WorkTicketTimes API endpoint to tie out to the ticket level P&L view in the app.

 

On about 0.1% of tickets, I’m seeing a difference where there are extra entries in the API data that don’t exist on the ticket (at least anymore). Some of these have an ApprovedDateTime, some do not.

 

I’m wondering if anyone knows if a field or fields exist on the API side to filter out these records that look like they should be excluded. 

I’d like to get the cost here to tie out within a rounding error, if possible.

I’m also seeing something similar in ItemAllocations where the cost for materials ties out closely to the tickets Materials Cost Act, but not exactly.

Anyone have any ideas here?

I was just about to post the same issue for WorkTicketTimeIDs! I am seeing the same thing where the 2015 year pulls in 12 records but we only have 10 Time Entries that year. 

 

I also noticed the same thing for opportunities and worktickets as well and I resolved that by downloading an opportunity/Work Ticket report that has all work ticket numbers and then removing anything that is on the API but not the Aspire list.

 

I wish there were more Deleted boolean records in the API! The only one I have found in the documentation is under Opportunities > ScheduleOfValueGroups > ScheduleOfValues

https://feedback.youraspire.com/ideas/WAP-I-4924

There is an idea in the Idea portal FYI!

Hopefully we get this soon!

Reply


Community GuidelinesCookie settings