How to get missing costs from other applications into Billing
Description
Cause

Cost-based billing incorrectly set up before posting costs to Billing.

Resolution

Review the steps below to resolve the missing costs in Sage 300 CRE.

Check for ungenerated items

Check for entries that didn't generate to the work-in-progress.

Confirm entries in Billing and related applications

See how to check if I have unposted transactions in Sage 300 CRE.

Void and reenter the transactions

  1. Verify and fix the issue if Billing didn't receive the transactions from the interfacing application. See the Billing Help topic "Send cost to Billing - transaction was not sent to Billing".
  2. Void the transaction in the application of origin.
  3. Re-enter the cost and post it.

NOTE:

For costs originating from the Accounts Payable invoices, you can change the invoice accounting date by one day to generate new cost entries. This will generate offsetting +/- entries in Billing and then delete the reversing entry in Change Work In-Progress.

Record cost entries in Job Cost

NOTE:

This workaround works if the invoice format or rate tables don't require AP, EQ, SM or PR-specific information (pay ID, certified class, vendor, etc.)

  1. From the Job Cost Tasks menu, select Enter Direct Costs.
  2. Enter a detail line for each missing entry. Enter a separate entry line to reverse it from Job Cost. Billing receives both sets of entries. This results in no change in Job Cost or General Ledger because the entries net to zero.
  3. Generate a Work-in-progress.
  4. From the Billing Tasks menu, select Change Work-In-Progress.
  5. Delete the row for the reverse entry / second line. Now bill the positive cost line on your cost-based invoice.

Use Change Work-In-Progress to enter the Work-In-Progress records

NOTE:

This workaround works if the invoice format doesn't require AP, EQ, SM or PR-specific information. For example, pay ID, certified class, vendor, etc., or JC-specific information, such as cost code or category.

  1. From the Billing Tasks menu, select Cost-Based Invoices, Change Work-In- Progress.
  2. Select the Contract and click OK.
  3. Enter the Work-In-Progress items and click Finish.

See how Billing receives transactions from the interfacing applications for more information.

[BCB:156:Chat 300 CRE US:ECB]

 

Steps to duplicate
Related Solutions