[JB] Missing Bills in Job Billing

Created by Crystal Ann Harvey, Modified on Tue, 22 Jul at 8:54 AM by Crystal Ann Harvey

Bills that are missing in Job Billing are either in a JB Interface Batch or have been deleted.

Identify the Bill Month & Bill Number, then use one of the methods below to find what BatchId the bill is in.

If you know the Bill Month & Bill Number, in JB Progress Billing or JB T&M Billing:

  1. Enter the Bill Month
  2. Enter the Bill Number
  3. Tab off
  4. A pop up message should appear with the information about what BatchId the bill is in. Bill is currently in an interface BatchMth for ##/## BatchID ## and cannot be edited

If you know the Bill Month, but not the bill number, in JB Progress Billing or JB T&M Billing:

  • Enter the Bill Month
  • Press F4 from the Bill Number
  • Scan the list in the lookup to find the bill
  • The BatchId is listed.

If you don't know the Bill Month or the Bill Number:

  1. Run the JB List of Bills per Contract (This will allow you to see if the billing does exist in JB). Locate the Bill Month & Bill Number of the missing bill.
    1. If the bill does not show on this report, then it has been deleted from Job Billing
  2. Open JB Progress Billing or T&M Bill Edit and enter the month and bill number from the previous step. When you tab off the bill number the system will give you the error "Bill is currently in an interface BatchMth for ##/## BatchID ## and cannot be edited." Make a note of the Month and BatchId number

Once you have found the bill:

  1. Open JB Batch Process and enter in the Batch Month and BatchID and either clear the billing or post the billing in the batch.
  2. If there is an error that the batch is in use, open HQ Batch Control for that Month & BatchId and clear out the user id in the "In Use/Posted By:" field, then save,
  3. Return to JB Batch Process to clear or validate & post the batch.
Cause

Open Batch that was not posted, or properly cleared.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article