CCRSoftware Support

Adding Item Pictures to a Bill of Material Report

Here’s a step-by-step outline of how to add pictures of items to a Bill of Materials report with CCRQBOM. I will assume that you have SOME familiarity with editing reports in CCRQBOM.

Although QuickBooks Enterprise has a feature that lets you assign a picture to an inventory item, unfortunately they don’t let you USE that picture in ANY report. They also don’t let add-on developers (like CCRSoftware) access that data. So this is NOT going to be about using that feature in Enterprise.

We are going to assume that you have individual graphic files for each item, and that all of these are stored in one folder on your system.

To start, run CCRQBOM, then select Forms and then Bill of Material.

In the Edit Reports window select your form to work with (“Multi Level BOM” if this is the first time you’ve worked with a form) and click Edit. Note that there may be a delay before the editor opens – it starts up slowly sometimes.

The detail line band (“Detail1”) is where the BOM components are displayed, and this is set up to be an “array”. For this discussion, I want to insert the picture of the component as a column just after the “Description” column. Right-click on that column to get the popup menu, select Insert and then Column To Right.

Next, I want to increase the height of the detail line to allow space for the picture. Unfortunately, this sets aside that much space for each line no matter if there is going to be a picture or not. Select the table in this band, then go to Property Grid, expand the Size property, and change Height to be the size you want (I use 100 here).

Drag a Picture Box from the tool box and drop it on the column that you added to the Detail1 band.


Drag the corners of that picture box so that it fills the space in that column. Once you size it you can change the Anchor Vertically property of the picture box to “Both”, so that it will resize vertically if you change the height of the array later. There isn’t a way to bind the sides, just the top and bottom.

For this discussion, I have a folder in my system that contains the image files that I want to display for each item. These are JPG files, and they have a file name that matches the Item ID in QuickBooks. So, if the BOM says that it needs an item “Lens”, there is a file in this folder named “Lens.jpg”. All of the images are in the same location. In my test I’m using “C:\img”, which isn’t the best choice – you should try a location that is on a shared folder where all users can access it.




With that picture box selected, let’s go to the Property Grid and change several properties:

  • Change Sizing to be Zoom Image.
  • Expand Data Bindings (at the top of the property list), expand Image URL, click Binding and select the ItemID field. You must use the correct one – this will be found by expanding MasterData and then MasterDataAssyData, and selecting ItemID.  The most common error is not selecting the proper binding field, if the report doesn’t show the image.

  • Right under Binding, select Format String and enter this text string:   C:\img\{0}.jpg  The first part is the path to the folder for the images (remember the \ at the end of this), the last part is the file type to add on the end, and the middle is  {0} to represent the place that the ItemID will be inserted. If you happen to open the FormatString Editor for this, select a “General” format, have C:\img\ as the prefix, and .jpg as the suffix


Select File and then Save As, and give this report template a name. I’ll use “BOM WImage” for my example.

Close the editor, then exit Edit Reports.

Now let’s test this. Select BOM and select the assembly. Click the Display button, then in that window click the Print button. A Print Reports window will show, and your new template will be listed there. Click on the template name to select it, then click the Print button to preview the report.

Here’s my report. In this sample, only “Lens” had an image, the others didn’t.


There are other variations, but they are a bit more restricted. For example, if you don’t want to have the images all in one folder, you can put the path in a “custom field” for the item. Note that the path would be limited to 30 characters. You can also use a custom field for the picture name, if you don’t want to use the Item ID as the name.

Why Doesn’t My Report Show All The Info?

When you are working with a CCRQBOM or CCRQInvoice report that has a large amount of information, sometimes you may find that the report doesn’t show all of the detail lines that you expect. This most often occurs when you have created your own report definition in the form editor. Why does this happen, and what can be done about it?

Most people print reports with the “print preview” option, and if you create your own report template there is a preference setting in the report that will limit the number of detail lines that show in the preview. This is the most common reason for a large report not showing all of your information – it is limited to “100 lines” in the preview.

That is an easy issue to fix in your report definition. Edit the report, make sure that you have the “report” selected in the Report Explorer (not one of the subsections). Then in the Property Grid look for the Row Count for Preview property. If this is set to a number (typically 100), you want to change it to zero (which means unlimited), and then save the report. That should fix this problem.

Note that this also means that your print previews can take a long time to display if you have a large report.

Alternately, instead of editing the report, use the Print option instead of Print Preview. This bypasses the limit, and prints the report directly to the printer that you choose.



How To Get The Total Cost of Shortages On A Requirements List

CCRQBOM can generate a requirements list, a report that shows what items you need to purchase if you want to build a required quantity of an assembly. I’ll show you how to add some calculated fields to the report to provide total shortage cost calculation.Here is a requirement list to build a quantity 5 of assembly Bicycle. You can see that there are shortages for two inventory parts.


This uses the standard report template that comes with CCRQBOM.

To modify this template I will select the requirements template from the forms menu.


Select the requirements list option in the edit reports window and click the edit button.


This opens (sometimes after a bit of a delay) the report designer window. Please note that this window may look a bit different with some versions of CCRQBOM, but the elements should all be the same.


Creating a Calculated Field

The first step is to add a calculated field to hold the item cost X shortage value.

In the field list find the MasterDataRequiredData section of MasterData.


Right click on this section to select Add Calculated Field. This adds a calculated field to the field list. In the property grid lower on the screen you should see the properties for this field.


Change the name of the field to ShortCost, then select expression and click the “…” symbol to open the Expression Editor.


In the expression editor select the fields section. Locate ItemCost and double click it to add it to the expression. Double click the “X” symbol to add the multiply operator. Then double click the Shortage field to add that. Click OK to save this expression.


Note that in this case I’m using the ItemCost field, which is “Cost” in QuickBooks. You might want to use AverageCost instead.

Select this ShortCost field for the data binding for the last column, as we illustrated before with the ItemCost field.

Adding Columns

I’ll add two columns, one for ItemCost and one for the calculated shortage cost. I’m not going to make the report pretty, I’m just going to add the columns. You may want to rearrange things or delete unnecessary columns.

Right click on the rightmost column in the Detail1 section, select Insert, and then Column to right. Do this again to add a second column. Repeat this with the headers in GroupHeader1. Then resized the columns to fit what you want.


Double click on each heading column and enter the column names, “Cost” and “Short Cost”.

Change the column headings by double clicking on them and typing in the text you want.

Find ItemCost in the Field List, drag it and drop it on the cell for that column in Detail1. Do the same with ShortCost for the last column.

Select each of the cells and set them to be right justified.


Select each cell, click on the “>” symbol, and set the format string to show currency.


Add the Sum to the Footer

We have a column that shows the calculated cost of the shortage. Now we want to add the sum of this to the report.

First, we want to add a GroupFooter Band to the report, to have a place to hold the sum. This will put the sum at the end of the report for each assembly. (Note: you might add a “ReportFooter” instead of a GroupFooter – that is always at the end of the report. There isn’t much difference between them in most reports, unless you have multiple groups – then you should use a ReportFooter).

Right click on the Detail band, select Insert Band and then GroupFooter.


In the field list, find the ShortCost field and drag it to the GroupFooter.

Position the field to where you want it, resize the GroupFooter as appropriate.

Next, click on the < symbol again, click the ellipsis (…) by Summary.


Select the Group option in Summary Running. Also set the format string to the currency format.


Click OK to close this window, then save your report with the File/Save As menu option and give it a name. Close the editor.

Here is our modified report, showing the unit cost for each item, the shortage cost per item, and a sum of the shortage cost at the bottom.


" Cannot Open/Create a parameter file" error

If you see an error message similar to the following:  (CCRQParmCommon:3,0) Cannot Open/Create a parameter file – there are several possible causes for the problem; Essentially, CCRSoftware programs store a parameter file named CCRQ.XML at a location that you specified (the “common location” or “common folder”). For some reason, either that location cannot be accessed or your Windows user account doesn’t have the proper permissions to access that location.

This location was specified the first time that you ran the CCRSoftware program on this computer. Note that in a multi user environment all users should be sharing this location as this is where we store your “preferences”, and where modified report templates are stored.

The details of the error are found in the Error.PDF file that the program creates – the location of this file is displayed in the error window. You can also find it by scrolling through the “boring technical details” section of the error window, but that may be more difficult to see.


Common Location Doesn’t Exist

The most common error occurs when the location of the file no longer exists. We usually see this when someone has reconfigured their network or workstation, or upgraded the version of Windows. For example, in the screen shot above, the program is looking for the CCRQ.XML file at the location “Z:\”, which is a networked drive. The error is “Could not find a part of the path.” Windows is saying that “Z:\” no longer exists. Another common detail message would the “The network path was not found” without specifying what that path is.

If you are told what the path is, one way to fix this is to recreate the drive mapping to Z:, and make sure it points to the correct shared location. This is the location where the CCRQ.XML file exists.

Another way to fix this is to tell the CCRSoftware product to look at another location. Select Help and then Tech Support, and then Reset Common Location. This will open a window that lets you pick the proper location. Again, you want to pick the location where CCRQ.XML exists.


After you reset the common location you must exit the CCRSoftware product and restart it.

If you are in a multi-user environment and other workstations are running the software correctly, you can use them to determine where the “common location” is. Go to one of those workstations, select Help and then Status, and scroll down to the Common Path line. This is the location where this workstation is looking to store the preference file.


Incorrect User Permissions

CCRSoftware products need the Common Location to be a place where you have read/write/create Windows file permissions. If you don’t have full permissions here, you will get a parameter file error. The Windows error in the error window will refer to user permissions.

The simplest fix for this is to give this user read/write/create file permissions at this location.

If that is not possible, you need to create a folder where all users CAN have that permission, move the CCRQ.XML file and any files with a file type of “repx” from the old location to the new location, and change the “common” location on each installation of the CCRSoftware product to point to that new location (use the Help/Tech Support menu option as shown above).

Resolving the "There is No Disk in the Drive" Error

If you see an error “There is no disk in the drive”  when you start CCRQBOM or CCRQInvoice, you have run into a bug that actually is in QuickBooks itself. It is very annoying, and we are not sure why Intuit hasn’t fixed this yet.

Essentially, QuickBooks is doing something that makes Windows search for removable drives on your system, and if one doesn’t have any media in it, you can get this error. This could be a floppy disk drive (remember those?), a removable hard disk drive, or one of those USB multi-card readers (the most common cause).

We aren’t sure why this happens sometimes and not others, and Intuit ignores any comments on this. We have shown them exactly what call in the programming interface that Intuit provides that will cause this problem.

There are several ways to resolve this, as outlined in the article in the Accountex Report blog: Fixing the There is no disk in the drive Error.

The two options that we recommend:

  • Disable the error message in your Registry: If you are comfortable with doing Windows registry patches, the article we reference above has details on how to make a patch that will stop this error from occurring. There are no side effects that we’ve seen. This is a simple change that takes just moments. Essentially it changes the reporting mechanism in Windows to stop this particular error from displaying that warning message.
  • Request an updated version of your CCRSoftware product: We have versions of CCRQInvoice and CCRQBOM that will automatically do the equivalent of that patch internally – turn off the warning message. The drawback to this is that these versions have not (at this time) been released into full production, they are pre-release test versions. If you wish to inquire about this, please enter a support ticket through this support system requesting the update, and we will provide you with details.

80040408 and 80040401 Errors

80040408 and 80040401 errors can be frustrating, and are sometimes difficult to resolve. These relate to issues in QuickBooks itself – the programming interface that Intuit provides to us is complaining about a connectivity issue. The problem is on the QuickBooks side of things, not the CCRSoftware side.

Here are some things that you can check to try to resolve these issues:

  1. Make sure that you have the latest revision of your QuickBooks product installed. Older revisions sometimes have problems. If you don’t know what revision you have, press the F2 key while in QuickBooks and look at the info in the “product” line at the top. If you aren’t sure what is current, you can ask in the CCRSoftware support forum. If you use the “Automatic Update” feature in QuickBooks then you should have the current release.
  2. Please make sure that your CCRSoftware product has been authorized to access this QuickBooks company file. Close the CCRSoftware program, open the QB file with the “Admin” user account. Start the CCRSoftware product. If a security window pops up from QuickBooks, make sure that you allow the CCRSoftware product to access the file.
  3. You can check CCRSoftware permission in QuickBooks by opening the QuickBooks file with the Admin account in single-user mode. Select Edit -> Preferences-> Integrated Applications-> Company Preferences, and look for the CCRSoftware product in the list. Confirm that it is listed and that the program has permission to access the file.
  4. If you still have the problem, the next step is to remove the product from that list and then add it back again. Sometimes QuickBooks gets a bit confused. Log in as the Admin user in single user mode. Go to the Edit menu -> Preferences -> Integrated Applications -> Company Preferences tab -> highlight and remove the CCRSoftware program that you are having trouble with.  Exit QuickBooks, then open it again with the Admin account. Start the CCRSoftware product – you will be asked if it is OK to allow the file to access the data, and you must enter the proper response.

    If this does not work, here are some additional steps that we have found will often work.
  5. With Windows Vista, Windows 7, Windows 8 and Windows 10: If the User Account Control (UAC) is set to “OFF” or to a low level, you will not be able to run most add-on products. Make sure that UAC is enabled properly, reboot your system, and try again.
  6. In some cases QuickBooks gets confused about UAC. Turn it off, reboot your computer, turn it back on, reboot your computer, try the software again. This often resolves the problem.
  7. If your QuickBooks file resides anywhere other than the PUBLIC folder in a network environment or the PRIVATE (Your User Name) folder in a single user environment you will find that many add-on products won’t work.
  8. Both QuickBooks and the CCRSoftware  application should have been installed and run with Standard User Permissions (NOT elevated to run as Administrator). If this is not the case, add-on products might not work.

If you still have problems, refer to the article by Sunburst Software Solutions, which goes into more detail and gives you some other things to work with.

If Something Goes Wrong – Providing us with Diagnostic Info

If your CCRSoftware product runs into a problem it can’t resolve, you will get an error window that displays a message describing the error. To be able to quickly diagnose the problem our technical support staff needs detailed information on the problem – here are some tips on how to best get that to us.

Don’t Send Summaries

If an error window like this appears, people often send us a screen shot or a just the first line or two of the error message. , that doesn’t always provide us with all the details that  we need. The error window contains some detailed technical information, but it might not all be shown in a screen shot.


A complete copy of the error message, along with all of the technical details, is saved as a PDF file named Error.PDF. This is usually stored in a Computer Consulting Resources folder found in your My Documents folder. Rather than send a screen shot, please locate that PDF file and send that as an attachment to us in a support ticket or a forum posting here.

Note that in some versions of our software this window may have a different appearance, but the basic information is still there.

Greater Technical Detail

In some cases we may need even more technical detail than what is provided in the Error.PDF file. We may ask you to enable a tech support feature and send us additional files. To do this:

  1. Start the CCRSoftware product.
  2. Select the Help menu.
  3. Select the Tech Support option.
  4. Change the Logging option to Verbose.

  5. Select Clear Log to clear out older information.
  6. Run the function that has been causing problems. If you have an option to select data, please select the smallest amount of data possible that will generate the error. If you select a large amount of data to process the log becomes very difficult to analyze.
  7. As soon as the error displays, select the Save Support Files option from the Help/Tech Support menu. DO THIS BEFORE YOU CLICK “Continue” in the error window, because if you do then another error.pdf file may be created which replaces the one we need to see. Note that  in some versions of some CCRSoftware products you may have to click the “Continue” button first, to be able to access the Help menu – in this case please select the Save Support Files option as soon as you are able to.If you are working with a situation where an error window doesn’t open, save the support files as soon as the processing has completed.
  8. This will save a number of files to the folder that is displayed on the screen. There will be at least three files, possibly more. Attach ALL of these files to a support ticket in this website.

It is also helpful if you can tell us what operating system you are using and what version/edition/release/nationality of QuickBooks you are using.

Product Updates

Once you have registered a copy of any CCRSoftware product you are eligible for product updates at no additional charge for as long as you are using the product. This does not guarantee that the product will be updated, nor does it guarantee that the product will remain compatible with future updates of the operating environment (such as Microsoft Windows) or products that it integrates with (such as QuickBooks).