on 07-17-2013 2:03 PM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.