There are instances when one wants to figure out which elements of a set of numbers (amounts) total to a target value.
One instance where this may be necessary is for a company that receives a check for outstanding accounts receivable (A/R) bills but doesn't have matching documentation indicating what bills are being paid.
This program tells you the total # of matches in the red box and if there is more than 1 match then you press the “Show other Matches” button to see the other matches.
An accounts receivable department receives a check from a customer for $4,556.92. Upon looking in the accounting system, there are 54 unpaid invoices, ranging from $77.74 to $5,465.45. The payment must be for some exact combination of entire invoices. The challenge is determining which invoices the customer is paying.
In accounting, payments will be represented by negative numbers so it has to work with negative values.
Let’s say account “A” has three invoices in the amounts of $5, $3, $9. If a partial payment in the amount of $2 comes in on Monday it gets placed on the account as -$2. Now there are 4 invoices on Account “A” in the amounts of -$2, $5, $3, $9. If Another partial payment in the amount of $3 comes in Friday it gets placed on the account as -$3 and the two negative amounts -$2 and -$3 cancels out the $5 invoice and now only two invoices remain on account “A” for $3, $9
This program is to analyzes a list of numbers and finds combinations that sum to a given total.
The user should be able to paste a list of numbers (dollars) and enter a total. The program should highlight, embolden, underline, or do something to point out to the user which numbers in the list equal the total.
Hopefully this can be done in using visual basics as that’s the only language I’m familiar with but if not C#, or anything to get the job done is fine Just so long as I'm able to use Microsoft Visual Studio to change things like adding my company logo and copyright information.
Attached is some Visual Basics code in Microsoft excel that might help with the coding. The problem with this approach was the limitations. After only entering about 25 lines or so the whole program freezes. I need the program to be able to handle huge amounts, in the millions of dollars along with negative numbers and the user should be able to paste in almost 100+ line items.
The reason I have this listed as a simple project is because the attached file basically has all the code and format to be followed easily and it is a basic calculations program.
Also this program will be for my company’s private use and you must agree to relinquish all rights. My company will become the sole owner of the program and code with copyright protections. You must delete all copies and code created once you are paid in full for your services.