A user can't type in a non-existent Job-Phase-Category when entering a Payables invoice, because an error message will pop up that prevents them from saving.

But they CAN enter a non-existent J-P-C when entering a JobCost Cost Batch, and Adagio won't complain (the Phase and the Category do have to exist but not the J-P-C estimate).

Even worse, when the cost batch is posted, JobCost auto-adds the non-existent J-P-C to the estimate table, and then posts the transaction!

This leads to all kinds of problems. You can say they should pop the Finder to confirm that the J-P-C estimate exists, but that won't help when they import cost batches from Excel. Even with the Validate box ticked, it still allows the import and posting of invalid J-P-C transactions.

Is there are way to: 1) validate that a J-P-C estimate already exists, or failing that, 2) stop JobCost from auto-adding the J-P-C and throw the invalid transaction into an error batch?

Thanks

Steve