JacobsonRemodel

Members
  • Posts

    5
  • Joined

  • Last visited

Posts posted by JacobsonRemodel

  1. 1 hour ago, Alaskan_Son said:

     

    You are trying to prevent coding a solution?  Did I read that correctly?

     

    Yes, I already have enough bespoke code and processes to manage and maintain. Spending time now changing that master list will save multiples of that time later.

     

    I am trying to move beyond tweaking a Material List at all once it is generated.  Yes, I absolutely could make changes at this stage, but that step should not be necessary.

     

    Thank you for the list and your responses.  It's very helpful.  I understand I am coming at this from a different direction of a typical user. 

     

    Quote

    yes, you could change the master list so that it will automatically update all the appropriate codes to match yours

     

    Where/how do I go about doing this?

  2. 18 hours ago, Alaskan_Son said:

     

     

    Can you elaborate on these?  What exactly are you updating in each scenario?

     

    My cost/accounting codes do not necessarily align with those in CA.  I am trying to prevent coding a solution between CA and my other software that would change the built-in codes.

     

    By knowing how many codes there are, and what they are, I can better understand the scope and logic behind everything.  The next step would be to change the master list to my own codes.

     

  3. I am working on integrating CA x14 into our broader workflow and bookkeeping and want to be able to use the Accounting Codes.  In order to do this I need to be able to do two things:

     

    1 - See all of the Accounting Codes for all of the objects/materials/etc.  (Every possible iteration)

    2 - Mass update this information (via query, file replacement, export/import, etc.)

     

    I have been working on this for a few hours and have searched this forum but haven't found what I'm looking for. It is not practical to take the material lists and manually update every row whenever it is generated.  

     

    I know they have an integration agreement with Buildertrend, who is probably responsible for these codes.  Since these appeared to be defined on the library-level I started digging into the various CALIB (SQLite3) files but haven't found references to the codes in the tables.  That makes me think this information is actually a level higher up.