topic select open items for a settlement amount in Application Development and Automation Discussions

select open items for a settlement amount

Former Member — Wed, 14 Sep 2011 16:57:45 GMT

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

Re: select open items for a settlement amount

Former Member — Wed, 14 Sep 2011 17:27:12 GMT


> 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

Re: select open items for a settlement amount

Former Member — Fri, 16 Sep 2011 08:17:29 GMT

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 !

Re: select open items for a settlement amount

ThomasZloch — Fri, 16 Sep 2011 11:02:27 GMT

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]