How To Resolve Invoice Error ~ ORA-20099: Weight Measure

 
The error message will present itself while coding the RFP invoice.

 Cause: when the Subcontract and Bid Items (budget) have different values in the Weight Measure (WM) field under the same Phase Code string

Ask the ticket Requester which WM they want – Subcontract? or the one in the Budget (Bid Items)?

 



Find the WM value in the Subcontract and in the Budget 

a) Open the Subcontract > SOV section > find the phase code and the assigned WM
b) For the Budget, go to Bid Items > find the phase code and the assigned WM
    NOTE: if they did not import their budget into Bid Items, go to the PCI Log and open the PCI with their budget

If they want the Weight Measure to match the one in the Subcontract

1. Go to Enterprise > Job Costing > Assign Phases
2. Enter Company > Enter Job# > PageDown
3. Find the Phase Code and change the WM to match the Subcontract

 
If they want the Weight Measure to match the one in their Budget
1. Create a "Transfer" PCI
    a. Enter 0.00 in the Sub Quoted Amount and Cost Budget Amount Fields (DO NOT leave these fields blank)
    b. Enter the negative / positive in the Revenue Budget Amount field – Revenue drives billing
   PCI Detail section
    a. Enter Vendor / Phase / [incorrect WM] MO / 0.00 in Sub Quoted & Cost Budget / Negative amount in Revenue
    b. Enter Vendor / Phase / [correct WM] LS / 0.00 in Sub Quoted & Cost Budget / Positive amount in Revenue

2. Create a SCO
    a. In Scope of Work field add notes to explain SCO, making it internal so it does not go out to the sub
    b. Post