OASIS communication with HLI has allowed us to auto-apply invoices, shipping info and other items with a goal of streamlining the process and making HLI easier to do business with. We have created a way to auto-apply the commission check you receive each month from Hubbell. If you have not yet tried to auto apply your commission check from Hubbell, follow the steps below.
Applying the check
Create a new Payment
In the Payment Editor
Enter the Check number
Enter the Check Amount (the net amount after deductions). In this case, using the example below, enter the “Net Commission (All SAP Brands)” - $26,469.89
Enter in the Check Amount area.
Then set the Invoice Starting And Invoice Ending dates.
Then go to HLI, select “Get Commissions (and missing invoices)”.
OASIS will attempt to find all invoices previously downloaded automatically, any invoices manually entered and will also go to HLI – SAP system and grab any invoices needed that it has not found in OASIS.
Once completed, it will print a report of Invoices that the system found and any invoices it did not find. The invoices not found will also be attached to the printed report. A sample of this is below.
OASIS will find all the invoices payable by this check, whether in OASIS or at HLI.
The ones “FOUND” mean they are already in OASIS ready to be paid. The ones marked “NOT FOUND” will be attached to this report – a sample below. These will be Invoices as well as Credits.
Once you have the report, we suggest you print it. Then apply the “NOT FOUND” invoices/credits manually.
Open the Payment again and re-try the Commission Download in the above steps.
Once complete, it should print the report again but all the invoices should be “FOUND” and the balance at the end of the report should be zero. If they do balance, then simply “Post” the payment
NOTE (Disclaimer) – since the commission statement is generated from another system outside of SAP, the difference may not balance but should be very close.
At this point, you can research for reasons why the totals don’t balance (the Difference column is not zero)
This could be Freight Charges as shown on the Commission Statement. In the Sample below, there are:
Freight Charges - $150.00
Sample Charge - $125.41
To account for these charges, you can use the “Adjustments” tab (you can adjust for a deduction or positive such as a bonus)
Enter the charges as deductions as shown below (bonuses or additions, use the negative sign)
Notice as the deductions are entered, the difference goes to zero.
In the sample above a deduction was made for Freight.
A deduction was also made for a sample, but it was also charge to salesperson “Kyle”. This will be deducted from his check (comm. Account) as well.
Once you are finished applying, you can “Post” the check (Difference does not have to be zero to Post the check.
Once the check is posted you may run the Commission for Account report showing all payment made on invoices for the period. These are broken out into Commissioned Accounts (some agencies have these set up as “salesperson” others have “branch offices” as Sales/Commissioned Accounts.
Commission Reconciliation for this check may be printed by simply clicking Print.