Home » RDBMS Server » Server Administration » I need an PL/SQL algorithm to hand combination searching
I need an PL/SQL algorithm to hand combination searching [message #370497] Mon, 06 December 1999 16:22
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.

Previous Topic: Re: CLOB to VARCHAR2
Next Topic: trigger with warning message
Goto Forum:

Current Time: Tue Dec 06 19:17:48 CST 2022