Skip to Content
avatar image
Former Member

F110-Multiple Credit to One Time Vendor having different Bank Accounts

We have to pay compensation payment to farmers towards damages of crop during work.

we get payment list from executing site and paid by us. We post document using Excel File Upload facility. Accounting entry is like

Expenditure Account Dr. 100

To Bank (Outgoing)A/c Cr. 10

To Bank (Outgoing) A/c Cr. 20

To Bank (Outgoing) A/c Cr. 40

To Bank (Outgoing) A/c Cr. 30

Here we use "TEXT" field to fill payee details. Payment made by manual system ( no DME)

by this way we facing problem at processing Budget Report, is not capturing Profit Center against payment (Cr. entry)

so, we change accounting entry like below.

Expenditure Account Dr. 100

To One Time Vendor A/c Cr. 10

To One Time Vendor A/c Cr. 20

To One Time Vendor A/c Cr. 40

To One Time Vendor A/c Cr. 30

by this way Budget Report Problem Solved but, when we Use F110 to post payment voucher having multiple credits in Single Document , One Time Vendor's Bank Details (Payee's acct no) remain same for all Credit entries if we uploaded excel file,

but same time if we use F-43 for same entries it show different bank A/c details for each OTV credit line.

Please help to resolve this issue so we can use F110 for Bulk posting & use DME to pay in bulk.

f110-otv.jpg (552.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 04, 2016 at 10:21 AM

    Hi Manoj,

    If you are using 'one time' vendors, you should be entering bank details in the FI posting line item i.e. being able to enter different bank details for each One time vendor item.. I suggest to simulate first manually your posting and adjust the .xls upload pgm if required.

    Regards,

    MY

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Manoj

      You need to get your upload program checked. There is no issue with SAP Program, but your upload program, which is a custom object which seems to have an issue, which needs to be checked by an ABAPER

      regards

      Sanil Bhandari

  • Nov 08, 2016 at 05:03 AM

    Hi

    You should be able to enter the bank details as well in when you are booking the expenditure and creating a liability. If the farmers in your case will have regular transactions, you may want to create a regular vendor for all the farmers with Bank Account details updated as well. After that if you run F110, the beneficiary details will have individual bank accounts as well.

    Check with your paying bank on what file format they will accept and you can always create a DMEE File as per the format accepted by the paying bank. I do not see any issue in there

    regards

    Sanil Bhandari

    Add comment
    10|10000 characters needed characters exceeded

    • So Sir please have your custom excel upload program checked. There is absolutely no issue with the SAP Product functionality. You need to make sure that you are able to key in Different bank account details for every vendor line item in the excel sheet and the same is replicated through the program in SAP. You need to sit together with an ABAP Colleague and check it out. I would suggest test it together

      Regards

      Sanil Bhandari