on 05-19-2010 10:05 AM
Dear All,
I want to return the material to vendor after invoice verification and before payment.
So entered the credit memo, Return material 122 mov type, Create Excise Invoice.
Now in my Excise Invoice print format i want CST and VAT to be printed.
Now my query is i want the table from which i can fetch the CST or VAT amount which i posted in credit memo.
Regards.......
Edited by: akshay sonurkar on May 19, 2010 11:15 AM
the table name u want is BSET
hear u will have to give Accounting document number and year FOR THE CREDIT MEMO
BSET-KSCHL will give the condition type CST or VAt condition type
BSET-HWSTE u will get LC tax amount amount for cst or vat condition type
hope not things are clear
account document and MIRO document link u can get in BKPF
AWKEY will be ur MIROnumber + year
and BELNR is ur account document number for MIRO
hope now u got the answer and it helped u
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Umakant,
Thanks for the valuable reply.
Now i came to some conclusion.
But in table BKPF i am seeing two document for MIRO transaction. One is original invoice document and second is Credit memo.
Now want to know how do i differentiate between these two numbers?
I want to choose Credit Memo doc no.
Please suggest...........
Edited by: akshay sonurkar on May 19, 2010 1:41 PM
Thanks Umakant,
I have solved the queries. The solution is:
If Invoice
RBKP-XRECH - X
RSEG u2013TBTKZ - blank
If Credit Memo
RBKP-XRECH - blank
RSEG u2013TBTKZ - blank
If Subsequent Debit
RBKP-XRECH - X
RSEG u2013TBTKZ - X
If Subsequent Credit
RBKP-XRECH - Blank
RSEG u2013TBTKZ u2013 X.
Regards
Akshay
Edited by: akshay sonurkar on May 21, 2010 7:28 AM
Hi,
For the table fields and details u can get more details from your abaper , if you creating excise invoice , the billing document is generated and when the billing document is generated the table VBRK - For header details and VBRP for line item details are updated,
So as per your requirement From the Table VBRK select field KNUMV by given the billing document number in VBELN filed from VBRK u will get KNUMV number with that number from table KONV select the KBETR and WAERS fileds for tax amount and currency also give the Condition which is indicating the tax type while selecting data from KONV.
regards,
zafar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.