B2 Error Billing Greasemonkey Script

Share this
[featured_image]
  • Version
  • Download 156
  • File Size 1.21 KB
  • File Count 1
  • Create Date May 8, 2023
  • Last Updated May 8, 2023

B2 Error Billing Greasemonkey Script

When I add the remittance file in and settle it, it does not settle the billings that return with a code for every telephone call (B2) and video (30). I have to manually settle each one which is quite frustrating. It would be great if there was a button that you could edit in certain error codes to settle (like the billing sheet) with one click since who knows which silly error codes may be in the future!

This is the script I use to settle as quickly as possible for these codes. I will run the Invoice Report for submitted older than 1 month and two large buttons are present so I can one click settle or rebill.

Tested on Greasemonkey on FireFox

 

Comment from Ian Pun:

Here's a little query I made to find all your error codes not settled.
e.g. 30 , I2
SELECT ra.billing_no , bch.id  , bch.status , ra.error_code, bch.provider_no, bch.demographic_no as demo, bch.demographic_name  , bch.billing_date from     billing_on_cheader1  bch ,  radetail ra where ra.billing_no = bch.id   and ra.error_code <> "" and bch.status <> "S";
Modify it to clear your error 30s in the backend.

Attached Files

FileAction
billing button by BH.user.jsDownload