Skip to Content

Sales/Purchases in FD10N

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 08, 2007 at 12:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 08, 2007 at 12:32 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2007 at 12:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded