on 10-08-2007 1:23 PM
Hi,
When we check customer balances via FD10N there's a column called Sales/Purchases which displays the period's sales.
The amount shown includes VAT. Is there any possibility to display sales/purchases without VAT in the customer balances? (We also have the sales amount incl VAT in FD11 (Customer Analysis).
Thank you
Regards,
Johan
Hi Johan,
This is all based on open items including VAT. When you want this you have to create a report based on the tables BSID, BSAD and BSET (Tax).
For sales reporting you have to look in SD or CO-PA
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Johan,
I am afraid it only works with some calculation. You have to delelop a report, which creates net values from the stored gross values (on vendor and customer accounts). For example:
BSID-DMBTR - amount in company code currency
BSID-MWSTS - tax amount in company code currency
the difference between the two will give you the net amount.
more:
BSID-WRBTR - amount in document currency
BSID-WMWST - tax amount indocument currency
same calculation...
same for BSAD, BSIK; BSAK.
regards
ec
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To run ex VAT reports, they should come from SD.
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 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.