We have a client who long story short we need to change the Category settings in PJC without starting a new Contract. Specifically, and for example, we have a default Labor category that is set up for an existing job that has current settings of:
Labor Type = Flat Rate Per Labor Hour/Unit (set in table as LABOR = 2)
Labor Rate = 10.0000 (set in table as LABORRATE = 10.0000)
Overhead Type = Percentage of Cost (set in table as OVERHD = 5)
Overhead % = 15.0000 (set in table as HEADPER = 15.0000)
What we want to do for the above setting is set the Labor Type to 1 (a setting of None), change the Labor Rate to 0.0000, change Overhead Type to 1 (None setting) and Overhead % to 0.0000.
We tracked down the information in the database table i.e. PMCATGT and PMCTG and made the appropriate changes and yet regardless of what we do the Category tab within the Contract does not reflect those changes. It maintains the initial ones set up.
Does anyone know what tables these settings are contained in so when we change them and check within Accpac the changes we made are reflected.
Thanks in advance for any information.
Labor Type = Flat Rate Per Labor Hour/Unit (set in table as LABOR = 2)
Labor Rate = 10.0000 (set in table as LABORRATE = 10.0000)
Overhead Type = Percentage of Cost (set in table as OVERHD = 5)
Overhead % = 15.0000 (set in table as HEADPER = 15.0000)
What we want to do for the above setting is set the Labor Type to 1 (a setting of None), change the Labor Rate to 0.0000, change Overhead Type to 1 (None setting) and Overhead % to 0.0000.
We tracked down the information in the database table i.e. PMCATGT and PMCTG and made the appropriate changes and yet regardless of what we do the Category tab within the Contract does not reflect those changes. It maintains the initial ones set up.
Does anyone know what tables these settings are contained in so when we change them and check within Accpac the changes we made are reflected.
Thanks in advance for any information.