Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 28th, 2006, 09:58 AM
Registered User
 
Join Date: Dec 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help with allocating invoices - permutations

I have a problem I need to solve and have been trying to think of a way to use VBA to solve it. It doesn't have to be done in Excel if there's another way to do it, but I thought I'd start there.

We get lump sums paid by clients, and don't know which invoices they're paying. I'd like to find a way to go through all the permutations of their outstanding invoices to get the most likely invoices they're paying.

I've been trying to find a way to report back all possible sums given a list of, say, ten invoices. I know permutations soon reach huge numbers, but given that order wouldn't be an issue here I imagine there'd be some saving.

Does anyone have anywhere they could point me for help? I've been Googling this for a while now but am having trouble coming up with a decent search term. I'm sure this sort of thing must be well documented somewhere, if I just knew what I was searching for!

Thanks for any help you can offer
skt1974
 
Old January 10th, 2007, 09:23 AM
Registered User
 
Join Date: Jul 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Before viewing the algorithm to solve the problem, there is a need to address some possible conflict you can face.

If for instance you have three envoices of 1 euro (or dollar, pound, etc.)), 2 euro and 3 euro and ona payment of 3 euro, you don't have any chance to decide if the payment is related to the first two envoices or to the third. is my doubt clear enough?

Mario

Mario





Similar Threads
Thread Thread Starter Forum Replies Last Post
Paged Invoices - Dynamic Number Detail Lines Marga XSLT 1 May 10th, 2005 09:28 AM
Storing E-Invoices (pdf-files) in SQL-Server Gert SQL Server 2000 1 September 17th, 2004 09:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.