UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Search For A Match, Access 2010    
 
   
ScorpDevil
post Feb 27 2019, 11:50 AM
Post#1



Posts: 637
Joined: 3-June 11
From: Miami, FL


Hi Guys -

I'm looking for a solution to the following scenario.

I have a table named "Outstanding" with a column named "Balance".

ID Balance
1 5
2 10
3 25

Then a payment of 15 is received. Explanation is not included with the payment. We know there are 3 invoices pending and the group of invoices balance cannot be greater than the payment.

Is there a way to run a subroutine to Test combinations of grouped invoices that match the payment amount?

Thanks,
SD

--------------------
What I cannot build, I do not understand.
Go to the top of the page
 
theDBguy
post Feb 27 2019, 12:43 PM
Post#2


Access Wiki and Forums Moderator
Posts: 75,549
Joined: 19-June 07
From: SunnySandyEggo


Hi. If it was me, I would just say you owe me 40 and gave me 15, so you still owe me 25. I wouldn't care which of the three invoices you paid, just that you didn't pay all of them and by how much. One issue with the approach you're thinking is what if the invoice were something like:

1, 5
2, 10
3, 5
4, 20

Would you just assume invoices 1 & 2 were paid although invoices 2 & 3 also match the criteria?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
ScorpDevil
post Feb 27 2019, 01:43 PM
Post#3



Posts: 637
Joined: 3-June 11
From: Miami, FL


Hi DB -

That's exactly what I'm looking for. I want to have a group of invoices that feet within the payment amount. Then i can go back to client and question them.
I know it's can be done manually but what is the invoices are within the 100s and counting.
I'm trying to simplify the process of guessing what are they paying.
I know this should be straight forward process but nothing never is in the accounting world.

SD

--------------------
What I cannot build, I do not understand.
Go to the top of the page
 
ScorpDevil
post Feb 28 2019, 08:57 AM
Post#4



Posts: 637
Joined: 3-June 11
From: Miami, FL


Found my answer here

https://dba.stackexchange.com/questions/296...hout-repetition

Thanks for the help DB
SD

--------------------
What I cannot build, I do not understand.
Go to the top of the page
 
theDBguy
post Feb 28 2019, 11:58 AM
Post#5


Access Wiki and Forums Moderator
Posts: 75,549
Joined: 19-June 07
From: SunnySandyEggo


Hi. Congratulations! Glad to hear you found a solution. Good luck!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th June 2019 - 12:36 AM