13 Replies Latest reply: Mar 14, 2014 6:56 PM by Praneel Ravilla RSS

Vendor Payment from different banks through APP

Hari FICO
Currently Being Moderated

Hi All,

 

I have the below Requirement, Can any body please clear me how to come across the below situation through APP.

 

 

The outstanding for vendor invoice is $1000, vendor having
three banks (HDFC, ICICI and AXIS bank). Vendor given an
instruction that out of invoice amount $ 1000,
$500 pay to HDFC bank,
$300 pay to ICICI bank
and $ 200 pay to AXIX bank.


HOW TO CLEAR THE VENDOR INVOICE THROUGH APP.

 

 

 

Thanks in Advance,

Hari

  • Re: Vendor Payment from different banks through APP
    nico dewaele
    Currently Being Moderated

    you can do a transfer posting from your one invoice for to 3 different lines on the same vendor, for those amounts and assign each line to one of the partner bank types of your vendor (under additional data of the line item)

    • Re: Vendor Payment from different banks through APP
      Hari FICO
      Currently Being Moderated

      Hi Nico,

       

       

      Thanks for your reply,

       

       

      how i can maintain the three bank types under additional data of the line item.

       

       

      Thanks,

      Hari

      • Re: Vendor Payment from different banks through APP
        nico dewaele
        Currently Being Moderated

        you maintain them in the vendor master.

         

        on general level - payment transactions, you enter the 3 banks and name them in the field bank type. Then they will appear as selection possibilities in the partner bank type field under addtional data of the line item.

        • Re: Vendor Payment from different banks through APP
          Hari FICO
          Currently Being Moderated

          Hi,

           

          Thanks for your information.

           

          Already we have maintained three banks in the bank details of the vendor master record.

           

          As per your suggestion i have tried that but in additional data i am able to select only one partner bank type, here no option to select more than that.

           

          The thing is Invoice has already been done for the 1000,  this amount we need pay 500 from the HDFC bank, 300 from the ICICI bank, 200 from the Axis bank through APP.

           

          How i can Split the amount and give the bank details against that amount line item.

           

          Requesting you to please give me some suggestion on this.

           

           

          Thanks,

          Harinath

          • Re: Vendor Payment from different banks through APP
            Julie (PHAN THI THU HUONG)
            Currently Being Moderated

            Hi Harinath,

             

            I think you don't understand Nico's idea.

             

            You maintain three bank in Bank detail of vendor master data is correct.

             

            Now, you should transfer invoice into 3 lines, and fill bank partner in each line.

             

            You can use tcode F-51, use option Transfer posting with clearing with data

            PK 27 - Vendor - 1000

            PK 31 - Vendor - 500 - Part. Bank HDFC

            PK 31 - Vendor - 300 - Part. Bank ICICI

            PK 31 - Vendor - 200 - Part. Bank AXIX

             

            Note that three Part. bank have to be maintained in vendor master data also.

             

            Julie

            • Re: Vendor Payment from different banks through APP
              Hari FICO
              Currently Being Moderated

              Hi Julie,

               

              Thanks for your Reply,

               

              Issue got resolved by your solution.

               

              I have small doubt regarding the above invoice.

               

              After posting the invoice 1000, again we should go to F-51 and make the as per our requirement.

              then run APP right..?

               

              Can you please clarify me.

               

               

              Thanks,

              Harinath

              • Re: Vendor Payment from different banks through APP
                Julie (PHAN THI THU HUONG)
                Currently Being Moderated

                Hi Harinath,

                 

                I will sumarize the step of solution for you.

                 

                There are 2 solutions in this case:

                 

                SOLUTION 1:

                - Step 1: Use tcode FB08 to reverse invoice 1 (amount 1,000)

                - Step 2: Use tcode FB70 or F-43 to create new invoice (seperate amount 500, 300, and 200)

                Example:

                Dr Expense - 1,000

                Cr Vendor - 500 - Part. Bank HDFC

                Cr Vendor - 300 - Part. Bank ICICI

                Cr Vendor - 200 - Part. Bank AXIX

                - Step 3: Run APP

                 

                SOLUTION 2:

                - Step 1: keep original invoice 1 (amount 1,000). Use tcode F-51 post as I mentioned before:

                Use option Transfer posting with clearing with data 

                PK 27 - Vendor - 1000

                PK 31 - Vendor - 500 - Part. Bank HDFC

                PK 31 - Vendor - 300 - Part. Bank ICICI

                PK 31 - Vendor - 200 - Part. Bank AXIX

                - Step 2: Use tcode F-44 to clear vendor manually.

                Choose line item Cr Vendor 1,000 (in invoice 1) and Dr Vendor 1,000 (in doc created from step 1) and clear them.

                After this step, make sure that there are only 3 open line items of vendor (500, 300 and 200) by report FBL1N

                - Step 3: Run APP

                 

                Julie

          • Re: Vendor Payment from different banks through APP
            amitash shah
            Currently Being Moderated

            Hello Harinath,

             

            In order to achieve your requirement, the original invoice need to be posted with 3 vendor line items with 500, 300 and 200. So in case your invoice is already posted with 1000, reverse the invoice and split it.

            Please ensure that you also enter the Partner bank type in each of the Document line item (e.g. in line item 1- HDFC, line 2- ICICI and line 3- AXIS). The field is available in at the Document line item level.

            In this case, during the payment run, the payment will be made with the specific bank type maintained in the line item.

             

            Hope this clarifies and helpful to you.

             

            Regards

            Amitash

  • Re: Vendor Payment from different banks through APP
    Nakula Charan Das
    Currently Being Moderated

    Hi Harinath

     

     

    T code FK02/FK03 Change vendor/Display vendor ensure all three banks details are enter vendors master record

     

    Ctry ---Bank Key ----Bank Account ---- Account Holder --- Ck -- IBAN --Bnkt

     

    Field BNKT  is important fill this field don't leave blank.

     

    Enter invoice T code F-43

     

    Enter

     

    Document data

    Posting  date

    Pstky - 31

    Account - your vendor account number

    enter

    Amount - 500

    press F7 (More data)

    Part. bank - select your bank

     

    Posting  date

    Pstky - 31

    Account - your vendor account number

    enter

    Amount - 300

    press F7 (More data)

    Part. bank - select your bank

     

    same for amount 200

     

    enter for pstky 40 (GL account0

     

    Regards

    Nakula das

  • Re: Vendor Payment from different banks through APP
    Rupesh Pillay
    Currently Being Moderated

    Hi Harinath,

     

    Original invoice:

         Exp. a/c           Dr.               1000

              Vendor a/c          Cr.                    1000

     

    Create one more invoice with three different line items by clearing the original invoice as Ms. Julie has said correctly

     

    New Invoice:

              Vendor a/c     Dr.          1000

                   Vendor a/c     Cr.          500

                   Vendor a/c     Cr.          300

                   Vendor a/c     Cr.          200

     

    Now do the payment run (F110), in the edit payment proposal list system will display three vendor line items (500, 300 & 200), instead of one (1000).

     

    Double click on individual line item and select "Reallocate" button.

     

    Enter the payment method and bank from which you want pay.

     

    Hope this will help you to resolve your issue.

     

     

    Regards,

    Rupesh Pillay

  • Re: Vendor Payment from different banks through APP
    Praneel Ravilla
    Currently Being Moderated

    Hi Harinath,

     

    This scenario may be for practice or knowledge purpose only.

     

    As Julie Phan explained the procedure is correct to follow.

     

    Single Invoice Payment should not be split and deposit into different accounts of vendor. It leads to violation of banking and the money laundering rules.

     

     

    Thanks & Regards

    Praneel

Actions