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 following four areas in Sage 300 CRE

Confirm entries in Billing and related applications

See how to quickly 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 and then a separate entry line to reverse it from Job Cost. Billing receives both entities, resulting in no change in Job Cost or General Ledger since both entries are in and out, netting 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, such as 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