Skip to main content

Feature Request: Job Cost Items need to be individual variables OR able to be exported into Excel

James Belmont

The items for Job Costs need to be separate variables in print file construction. 

The best we have is the Job Cost detail summary. Don't get me wrong, this is nice, but the data is unusable unless it can be entered into spreadsheets. 

Trust me, I've tried converting with Adobe Acrobat, copying and pasting into Excel, copying pasting into Excel and trying to delineate (that adds about 10 mins to the process fixing it), copying pasting into Word and then to Excel. 

Having each of these as individual variables would be MUCH more helpful. 

Right now, getting data for job costs and putting them into a report in any meaningful was is taking aprox 40 mins per job. 

 

0

Comments

3 comments

Date Votes
  • Becca Pound

    There is a process in Microsoft called Power Automate that can help with this in the mean time.  Go to youtube and check out the instructions.

    0
  • James Belmont

    Just going to comment on this again. I do appreciate the suggestion about Power Automate. I'm still in the learning process with that. It is just frustrating that I have to learn yet another thing from scratch to solve something that a developer at MS can fix with a minimal amount of work (I say this having done database programming). 

    Is there any chance that this feature request is at least acknowledged by MS? 

    0
  • James Belmont

    Upon some more reflection, there is a quick Band-Aid fix that MarketSharp can do in the interim. 

    The data exports out in PDF format only like the screenshot above. 

    Doors - 7/4/2021 - Labor - $350.00 - Craig Bagley - Invoice 07.04.2021

    It could be changed to use a different symbol to separate the information, such as a slash or semi-colon. Like Below: 

    Doors / 7/4/2021 / Labor / $350.00 /Craig Bagley / Invoice 07.04.2021

    Doors ; 7/4/2021 ; Labor ; $350.00 ; Craig Bagley ; Invoice 07.04.2021

    Doors | 7/4/2021 | Labor | $350.00 | Craig Bagley | Invoice 07.04.2021

    This would make cutting and pasting this into Excel much easier and eliminate SERVERAL steps.  The problem with using the dash or negative sign is that it affects negative amounts as well as invoices or reference numbers that have dashes. You spend so much time editing the information. 

    Again, just a Band-Aid fix till all of the fields are are exportable separate. 

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post