Changing Ready for Transfer status SAP ByD

[former_member1174202]

Hello all,

I am using an external system to Query against the Query Company Payment File Register Outgoing Files Integration web service. It returns all payment files in 'Ready for Transfer' status. Is there a way to synchronously update the status so the same file is not picked up again on the next web service request?

I was not able to find a solution so far.

Any help is appreciated.

Regards,

Mickie

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards,

Mariah

SAP Community moderator

[former_member1174202]

Hi Frank,

Thank you kindly for your response and for the workaround. To the best of my knowledge, any file in 'Released for Transfer' status will remain in that status and needs to be manually confirmed after collection. I thought there may be a synchronous way of updating the status after the files are collected by the request.

Are the files in a processed batch sequential? If so, then your workaround sounds like a good option.

Regards,

Mickie

[frank_jahnigen]

Hi Mickie,

We assume the scenario is to have file(s), e.g. Outgoing Bank Transfer, in status 'Released for Transfer' or 'In Transfer'.

With parameters as <Company><LowerBoundaryFileCreationDate>, etc. - The query would search according to:

If the file is 'Released for Transfer' <ReleasedOnlyIndicator>false</ReleasedOnlyIndicator> <FileStatus>5</FileStatus>.

Once the file is confirmed the same query should not return this file again.

If the file is 'In Transfer' <ReleasedOnlyIndicator>false</ReleasedOnlyIndicator> <FileStatus>7</FileStatus>.

Once the file is confirmed the same query should not return this file again.

If <ReleasedOnlyIndicator>true</ReleasedOnlyIndicator> - all subsequent status are ignored and the same file would show again regardless of a changed status.

Depending how you use the query a workaround to avoid the same file showing could be to take note of the latest relevant File ID XXX in a processed batch and to fill the 'LowerBoundaryFileID' with the next sequential File ID (<LowerBoundaryFileID>XXX+1</LowerBoundaryFileID>).

Hope this helps,

Frank