select open items for a settlement amount

[Former Member]

Hi All,

I have a requirement to do a clearing with situation like this,

upload a excel file contains of settlement amount.

This amount will use to clear up the payment JV save earlier (open items)

for example: settlement 57.00

then the open item documents :

doc 1 > 7.00

doc 2 >20.00

doc 3 >50.00

doc 4 >20.00

doc 5 >17.00

from example above, the settlement can clear with doc1+doc3

or doc2doc4doc5

My program is using the bdc call 'F-03' to do clearing.

how to program the logic if wan scenerio 1 or 2 based on any number of open items sum up is equal to settlement amt.

Any standard FM can use ?

Please help. << Priority removed >>

Thanks

Edited by: Rob Burbank on Sep 14, 2011 1:27 PM

[Former Member]

Hi All,

I have a requirement to do a clearing with situation like this,

upload a excel file contains of settlement amount.

This amount will use to clear up the payment JV save earlier (open items)

for example: settlement 57.00

then the open item documents :

doc 1 > 7.00

doc 2 >20.00

doc 3 >50.00

doc 4 >20.00

doc 5 >17.00

from example above, the settlement can clear with doc1+doc3

or doc2doc4doc5

My program is using the bdc call 'F-03' to do clearing.

how to program the logic if wan scenerio 1 or 2 based on any number of open items sum up is equal to settlement amt.

Any standard FM can use ?

Please help. << Priority removed >>

Thanks

Edited by: Rob Burbank on Sep 14, 2011 1:27 PM

[Former Member]

> Any standard FM can use ?
> Thanks

Sometimes you just have to bite the bullet and start coding.

Tthe answers in the forum are provided by volunteers. Please do not ask for help quickly.

Rob

[Former Member]

I already solved it my self

Rob , I only stated the matter is urgent to me, How would you know other volunteer won't help me ?

I did't ask other to help me quickly. This is your own thinking only.

I doubt you know how to code it either.

Don't just comment without any good suggestion !

[ThomasZloch]

Anything that sounds as if to make your matter look more important than the others, especially texts like "urgent", "at the earliest", "ASAP", will be removed from the posts. Please avoid these in the first place.

Thomas

[Rules of engagement|http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement]