Adding Price/Cost Charges To Jobs

[nmfujimoto]

There are multiple issues when adding Default or Location based Price/Cost charges to a job where only the price or cost record is added. This is repeatable in all environments of the code. The price and cost charges are identical and should be treated in the same manner when adding to any job. If a price charge is added, then a cost charge is added or vice versa.

Please look at the stored procedures as there is discrepancies in an ELSE clause related to Default location:

• GetCostCodeListByProgramId
• GetPriceCCodeListByProgramId

Please look into why the Price and Cost tables have different constraints:

• JOBDL061BillableSheet (contains a constraint on the Program PrcChargeID)
• JOBDL062CostSheet (NO constraint on CstChargeID)

Missing Charge records (Repeatable): AWC:

• Default charges
  • Add Price charge with rate of $0, Cost charge is added
  • Add Cost charge with rate of $0, Price charge is NOT added
• Location charges
  • Add Price charge with rate, Cost charge added (needed to refresh page to see record)
  • Add Cost charge with rate (needed to refresh page to see cost record), Price NOT added

Electrolux

• Location charges
  • Add Price charge with rate, Cost charge NOT added
  • Add Cost charge with rate, Price charge added

[prashantaggarwal1999]

@nmfujimoto this has been partially corrected on the production server, please have a look at all the functionalities mentioned here and confirm if all are working as expected.

[Madhusmi]

@nmfujimoto Testing completed in Staging server and Verified from Database and It is working as expected.