on 04-17-2008 12:00 PM
To have all comtrols in place and for flow of information , we require to have below given data :
1. Customer wise invoicing data between any given dates.
2. invoice wise collection advise raised in system with full details
3. after adjustment of collection advises , net balance of amount invoice wise.
4. In some cases there will not be collection advise but we adjust customer account directly through FI entry. These transactions also to be taken care while extracting data.
5.Key account manager (KAM) wise listing of invoicing
Total columns in report are to be :
1. KAM name
2.branch name
3.customer name
4.Invoice amt
5.Inv.date
6.qty
7.amount
8.duty & tax
9.tax form key (C form , H form , VAT etc)
10.collection (date wise )
11.other adjustments ( like qlty discount etc)
12.net invoice amount outstanding.
13.age analysis
14.analysis of KAM monthly plan Vs.actual collections.
15.analysis of debtors exceeded credit limit.
Can you please give me that any single Tcode in SAP can give all the above data .
if not possible , various Tcodes through which data can be extracted and sorted invoice wise.
Hello,
I think you may get some of the data from the tables VBAP, VBRK and VBRP.
Prase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.