| I need an PL/SQL algorithm to hand combination searching [message #370497] |
Mon, 06 December 1999 16:22 |
older-wheel-user
Messages: 2
Registered: December 1999
|
Junior Member |
|
|
AP matching algorithm
I had a task to write an algorithm which will be able to match following cases:
I had 6 receipts with the 4 fields: PO, PO line, part id and unit of purchase match a single invoice record with same above 4 fields (except one quantity field). But the total line quantities for the 3 receipts totals more than the invoice quantity, then I have to check to see if the sum of 2 or more of quantity of the above 6 receipts will equal the invoice quantity. If so, then mark the receipts as been matched to the invoice.
Basically, I need an algorithm to handle the combination search in PL/SQL script. I do not like to reinvent the wheel since I assume somebody already done it or due day is pressing me to hard. I can not use the AP interface since our client do not have oracle financial staff.
Good luck to myself.
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
