SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Best practice to discover billing and invoicing errors

Go to solution
robert_straubinger
Advisor
Advisor

‎03-18-2020 8:42 PM

0 Kudos

An IS-U customer asked us, what are others doing to find wrong invoices? The billing group is producing about 50-60k invoices every day and discovers on average 20-30 wrong documents per day. An invoice is considered wrong when the SAP document does not match an external calculation using an external tool to scan the SAP invoices.

The errors found are:

- wrong rounding

- wrong prices

- wrong proration

What have you seen that other IS-U customers do to find those type of inconsistencies or errors?

1 ACCEPTED SOLUTION

Go to solution
former_member230926
Active Participant

‎03-19-2020 7:22 AM

0 Kudos

Hi Robert,

For the companies who are moving from old legacy systems to SAP, during the implementation phase we normally perform "Parallel bill test" where we do mass billing on both the system (SAP and legacy) for a good chunk of customers (making sure data set is covering all sorts of rate-categories or scenarios) with the same billing parameters (Quantity and other required parameters) and later compare the billing amount or line-items wise between SAP and legacy and expectation is it should match $ to $.

View solution in original post

2 REPLIES 2

Go to solution
former_member230926
Active Participant

‎03-19-2020 7:22 AM

0 Kudos

Hi Robert,

For the companies who are moving from old legacy systems to SAP, during the implementation phase we normally perform "Parallel bill test" where we do mass billing on both the system (SAP and legacy) for a good chunk of customers (making sure data set is covering all sorts of rate-categories or scenarios) with the same billing parameters (Quantity and other required parameters) and later compare the billing amount or line-items wise between SAP and legacy and expectation is it should match $ to $.

Go to solution
EMMAX-Hans
Discoverer

‎03-19-2020 8:48 AM

0 Kudos

Hi Robert,

We (Excimp) have created a check framework for the Meter Reading area that can identify deviations between SAP data and checks that are configured by the customer based on business rules. The check is done on the fly when meter readings are written to the database. If a deviation is identified, a BPEM case is created that is processed and handled in our SAP Certified EMMAX product. The reads are saved as implausible, but in the same framework they can be released automatically (and of course the case completed) again based on business rules. This might be suited for Billing errors too.

So fully integrated flexible solution and no external tool (NO MODIFICATIONS!).

The result of this provides insights in where the weak spots are and it ideally should end with an improved configuration of the system and with no or a very limited number of cases created.

Hope this helps and happy to discuss and help.

Best Regards and Keep healthy,

Hans