Can the cost unit desc be changed in the standard category setup?

I need to change the cost unit description to only be 4 characters so that estimates will import from SAGE Estimating 16.11. In Estimating you are limited to only 4 characters so i can not change it here.  For Labor category the unit cost desc is HOURS and it can only be 4 characters for my estimate to import.  I realize I can set the JC import settings to "Reject if different Cost Unit Description" but I am being advised against doing this since it would allow errors to pass through.  Any help would be appreciated.  Thanks. 

Parents Reply Children
  • 0 in reply to BobbyS
    In case you don't have access to the Knowledgeable, here's the text of the article:
    Cause
    If the cost unit description used on the import file differs from the existing cost unit description used on the Category or Standard Category, the Job Cost Import Estimates journal prints "Cost unit desc different on category record" as the reason for rejection for each rejected line item.



    Resolution
    In order to successfully import an estimate, the cost unit description in the import file must match the cost unit description already in Job Cost, unless your setting in Job Cost are set to allow different cost unit descriptions to import.

    Use Option A if you want to change the cost unit description in Job Cost. Use Option B if you want to change the cost unit description in the import file. Use Option C if you want to allow different cost unit descriptions to import.

    Option A
    Use this option when you want to change the cost unit description in Job Cost.

    From Job Cost, select Setup, Categories.
    Enter the Job, Cost Code and Category for which the import was rejected.
    From the General tab, note the Cost unit desc box.
    If the description in this box is correct, change the cost unit description on the import file. (See Option B below.)
    If you do not want the description found here, either change the entry in this box or delete it and leave it blank to allow the estimate to import with the cost unit description found in the import file.
    If the Cost unit desc box is unavailable on the General tab, see the attached topic below.

    Option B
    Use this option if you want to change the cost unit description in the import file.

    Have at hand the Estimate Import Report that listed the errors encountered on the previous import.
    Open the rejected records file with any text editor, such as Notepad, that retains the file in a text format. (Remember you specified a file name and path for the Rejected records file when you imported the estimate. If you do not remember the path or file name, you can do a search in Windows for files ending with extension .jce.)
    Add, change, or delete text lines as appropriate to correct the errors.
    Save the file in text format and exit the text editor.
    Backup the edited rejected records file.
    Use the edited rejected records file as the import file to Import Estimates.
    Option C
    Use this option if you want to allow different cost unit descriptions to import.

    In Job Cost, go to File, Company Settings, JC Settings, Import.
    Clear the Reject if different Cost Unit Description check box.
    Click OK twice.
    Import the file again.
    Note: If the cost unit descriptions are inconsistent in the import file, you can go back to your original estimating program to make corrections. For example, cost unit descriptions for labor may show as both "hours" and "sqft". This can be corrected in the estimating software before an import file is created.