Qty at jobsite by office

#1

How can I get the Qty at jobsite of all the part numbers using C#. If possibleI need this summarized to the blue roof or using detail and we can roll up. if I can get the blueroof that it is under as part of the detail.

#2

Is there any update on this. How can I get the Qty at jobsite of all of the part numbers. Is there a way I can include the jobsite name/number with that report.

#3

Hi, Chris.shumaker.
You may get the details of a job and all parts stocked like below, which may be consolidated into any preferred format.

//GET JOB
var job = StockingLocation.GetStockingLocation(Job-Site-Stocking-Location-ID, false);
Console.WriteLine($"{job.Name}-{job.Number}");

//GET PARTS AT THE JOB
var stockedProducts = StockedProductList.GetStockedProductList(job.StockingLocationID, Guid.Empty, ProductType.Product);

//PRINT PART DETAILS
foreach (var part in stockedProducts)
{
Console.WriteLine($“PART-NUMBER: {part.PartNumber} DESCRIPTION: {part.Description} QTY-ON-RENT: {part.QuantityOnRent}”);
}

Thanks for posting.

#4

We need this for all jobs so the job-site-location-id is not a variable that we can use so how do we get those in a full list

#5

Hi, Chris.shumaker.

You could get the list of jobs with code similar to the one below -

//GET ACTIVE JOBS
StockingLocationList jobs = StockingLocationList.GetActiveJobsites(false, JobTreeNodeDisplayType.Name, Guid.Empty, false);

Thanks for posting.

#6

I know it has been a while but I need to get the Qty at all jobsites and the get active jobs code you gave me doesn’t work. Get Active jobsites throws a compile error. Please provide a solution instead of me having to piece meal this together.

#7

Hi Chris. Can you be specific in what the compile error is? This code works for all of our developers. Maybe you’re missing the dll references? Not sure, can only guess without more details.

#8

The error I am getting is CS0117 StockingLocationLIst does not contain a definition for GetActiveJobsites

What I am looking for is The job number, job name, part number, Quantity in the yard, qty in repair, qty damaged, qty for rent, qty available
This is for all active jobs and blue roofs.

#9

Hi Chris. I’ve modified the C# sample project to show this. Attached here.

Quantify.API-chris.zip (5.2 KB)

#10

thank you but I am still getting error CS0117: ‘StockingLocationList’ does not contain a definition for ‘GetActiveJobsites’
I must be missing a dll or something. Please ltt me know which dll I am missing and I will see if I can find it.

#11

Could be. You need to reference the 3 dll’s from the install folder.

image

#12

I have those three DLLs. Is there a certain version that I need to be on in order to make this work? I was going to run an update this weekend.

#13

That’s odd. So even the sample project has issues? The current version is 9.0.1526.126. I believe those methods have been in Quantify for a very long time though. We typically try and avoid breaking code like this.

When you highlight one of the dll’s do you have Copy Local set to true?

Only other thing I can think of is a bad Visual Studio installation? Maybe do a repair?

#14

We ended up updating to 9.01526.126 and it started working. Thanks.