06-20-2008 7:15 AM
Hi all,
I have got the requirement from the Client ( Utility Company ). He wants to print the TOTAL INVOICE AMOUNT in smartform for this they have given following
Tex Number /Field Name.............Description...............Screen Field Value......From Transaction
_______________________________________________________________________________
Invoice Amount............................Total Amount Due....Invoice Amount............CAA3
Now when i gone to CAA3 Tcode i did not found total amount.
From where will i get it............should i ask for anything else from the client.
Regards,
Mohsin
06-20-2008 7:27 AM
Hello,
If you want to view the account balance of the Customer, use T-Code FPL9.
You can also use EA60 to view the Invoice amount.
Alternatively you can also use the FM 'BAPI_ACCOUNT_GETBALANCES' to view the account balance.
What I understand from your requirement is that you need to print a customized Inv. For that you need to overwrite the standard application form for Invoice and apply your code
Hope this helps
Rgds
Rajendra
06-20-2008 7:27 AM
Hello,
If you want to view the account balance of the Customer, use T-Code FPL9.
You can also use EA60 to view the Invoice amount.
Alternatively you can also use the FM 'BAPI_ACCOUNT_GETBALANCES' to view the account balance.
What I understand from your requirement is that you need to print a customized Inv. For that you need to overwrite the standard application form for Invoice and apply your code
Hope this helps
Rgds
Rajendra
06-20-2008 7:43 AM
Hello,
The application form you need to use is ''IS_U_BILL''.
You need to copy this as 'Z' form and you need to put your code in it.
You can also have your client's logo in it for that you need to upload it using SE78.
Do remember that the form is attached in Contract Account <CAA1/CAA2>
Hope this helps
Rgds
Rajendra
06-20-2008 7:44 AM
Hello,
Table :ERDK
Field name: BETRW
just try out this....
Regards,
Narendar Konakanchi
06-20-2008 7:57 AM
Hello,
Table :ERDK
Field name: total_amnt
correction to previous post
Regards,
Narendar Konakanchi
06-20-2008 3:53 PM
Hello,
Please try FPL9 to see the account balance.
EA22 or EA60 for invoice amount.
ERDK Table for total amount - TOT_AMNT
or
DFKKOP - put main transaction and Subtransaction for invoice (e.g. 0100-0002) for invoice amount.
Regards
Mahavir
06-21-2008 6:23 AM
Hi,
There is a correction for ERDK table:
field is : TOTAL_AMNT for total amount.
Regards
Mahavir
06-22-2008 11:50 AM
Hi,
T-code CAA3 is for Displaying Contract Account. Here, you cant get any information about Invoice. EA40 is the t-code to see the invoice document. Please contact if this is not clearing your question.
Thanks
Vijay