Verify there's a valid rate or markup table - In Contracts, from the File menu, select Open Contract.
- Select the Contract for the entry that rejected during Generate WIP.
- Highlight the appropriate Contract Item.
- Select the Billing tab.
- Verify that there's a Markup table or Rate table selected on each contract item.
- For each contract item, click the Billing tab and make note of the cost type, rate table, or markup.
- In Billing, from the Setup menu, select Rate Tables.
- Select the appropriate rate table, by selecting the Cost Type and Table ID.
- Verify the table's Cost Type, Table ID, and Effective date match those identified in step 6 on the contract item.
- Confirm that the Cost Type of the Rate Table matches the Cost Type of the Job Cost Category.
Example: You have a Category of LB for Labor Burden. In Job Cost, verify that the Accumulate As in Category Setup matches with the Cost Type on the Rate Table. In this example, the Labor Burden Category can be classified as Other or Overhead. The BL Rate Table needs an applicable rate table value for the Other or Overhead JC Category Accumulate As type. - It's possible to have more than one rate table with the same name and cost type. You can also have more than one markup table with the same name. It's important to verify the Effective Date on the table.
- Verify the transaction dates on the rejected cost entry are between the Effective date and Through date.
NOTE: You can update the Through date, or create a new table with different dates, depending on the information you need on the table. - Click Table.
- Verify the rejected cost entry meets the criteria of a detail line.
- Enter the cost entry detail on the table if it is not already there.
- You can use an asterisk * as a wildcard value that allows a single rate line to apply to multiple detail fields. Use this if no other line applies.
- Go to Inquiry, Transactions, and add a condition for the job. Add columns from the rate table key columns to compare the transaction to the rate table. Do this to determine what doesn't match or is missing so it can't generate.
- Click Close twice.
- From the Setup menu, select Markup Tables.
- Select the appropriate markup table, by selecting the Table ID.
- Verify the table's Table ID, Cost Type, and Effective date match those identified in step 6 on the contract item. Billing compares the transaction date to the table's Effective date and Through date. If the date falls within those cutoffs, Billing matches a Markup rate for the cost type of the transaction.
- Verify the transaction dates on the rejected cost entry are equal to or greater than the Effective date.
- Verify that you've selected Markups in the lower right corner and click Close.
Once you make corrections to the contract item, rate table, or markup table, run the Generate Work-In-Progress task to process the rejected entries. If you find the entry is wrong, correct it in the application of origin and then Generate Work-In-Progress again. |