Sales/Purchases in FD10N

[former_member1095384]

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

[Former Member · Accepted solution]

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

[former_member1095384 · Accepted solution]

Hello Paul,

That's what we already do (using SD and COPA for reporting).

So for having information on sales (reporting figures) and open items, you will always have to use at least two SAP transactions/queries?

Johan

[JozsefSzikszai]

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

[Former Member]

To run ex VAT reports, they should come from SD.