This website is not affiliated with, sponsored by, or approved by SAP AG.

Update payment blocks in F110 proposal through a BDC/BAPI

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, darkduck, Baz

Update payment blocks in F110 proposal through a BDC/BAPI

Postby bahetiumesh » Thu Dec 12, 2013 1:46 pm

Hello all,

Good Morning.

We are working on creating a custom utility to update Payment Blocks at Vendor level after F110 Payment Proposal is created & before payment run is executed . We created a BDC recording for the transaction FBZ0. While executing the BDC in background mode, it was not updating the payment blocks at the vendor level. The BDC session appears to update the payment blocks only in foreground. BAPI_ACC_PYMNTBLK_UPDATE_POST was also checked but it did not seem to be useful for updating payment blocks at vendor level in the payment proposal.

Any inputs/clues on this subject would be deeply appreciated.

Regards,
Umesh
Umesh Baheti
bahetiumesh
 
Posts: 57
Joined: Fri Feb 11, 2005 8:03 am

Re: Update payment blocks in F110 proposal through a BDC/BAPI

Postby darkduck » Fri Dec 13, 2013 6:56 am

Could you please explain the process and the reasons for it?

PS. FBZ0 has nothing to do with blocks in vendor master data.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2459
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Update payment blocks in F110 proposal through a BDC/BAPI

Postby bahetiumesh » Fri Dec 13, 2013 12:41 pm

Hey there,

I did not mention payment blocks update in vendor master data via transaction FBZ0. We have a requirement to update payment blocks at vendor level (i.e. all documents of the vendor in a company code) in the Payment proposal generated by transaction F110 after the proposal is created and before the payment run is executed. The reasons of updating the payment blocks are vendors having master data issue or custom validations being failed.

We created a BDC recording the transaction F110 and another BDC for transaction FBZ0 to edit the payment proposal by specifying the Run Date and Run ID. However the background execution of either of the BDCs is not able to update the payment blocks.

Please let me know if you have any questions/comments. Thanks for your reply as well.

Regards,
Umesh
Umesh Baheti
bahetiumesh
 
Posts: 57
Joined: Fri Feb 11, 2005 8:03 am

Re: Update payment blocks in F110 proposal through a BDC/BAPI

Postby darkduck » Mon Dec 16, 2013 6:38 am

Hi,
I would say that blocking payments at the payment proposal is a slightly late stage.

If vendor has wrong master data, then block its master record, and its items will go to exceptions directly.
Custom validations? What are they? May they make line item or master record blocked?

As a workaround, you can do the following.
1. Run Payment Proposal and get a list of items to be paid.
2. Run a custom program to update all the items in the proposal with a certain value. For example, Assignment = payment proposal run ID/date.
3. Edit items removing/adding assignment.
4. Delete proposal and re-run it with a filter by assignment. This ensures that only "approved" item get into the second proposal, hence to real payment run.

As an additional benefit, you will be able to see in the assignment by which payment run the invoice was paid.

SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2459
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Update payment blocks in F110 proposal through a BDC/BAPI

Postby bahetiumesh » Thu Dec 19, 2013 1:40 pm

Thanks so much for your response. It is really appreciated.
Umesh Baheti
bahetiumesh
 
Posts: 57
Joined: Fri Feb 11, 2005 8:03 am


Return to Financials

Who is online

Users browsing this forum: No registered users and 10 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.