Jump to content

Willkommen im Coresystems Community Forum

Dieses Forum wird nicht mehr weiter betrieben.
Sollten Sie eine Lösung für eine spezifische Aufgabenstellung suchen wenden Sie sich bitte an unseren Support: helpdesk.coresystems.ch.
Für allgemeine Produktinformationen kontaktieren Sie unser Sales-Team: sales@coresystems.ch

Welcome at the coresystems community forum

This forum is no longer being maintained.
If you need a specific solution please contact our support: helpdesk.coresystems.ch.
For general product information do not hesitate to contact our sales team: sales@coresystems.ch


Sales Pivot SAR06001 CORESUITE accounting

Sales Pivot SAR06001

  • Please log in to reply
1 reply to this topic

#1 Massimo Ennio

Massimo Ennio

    New Member

  • Members
  • 3 posts

Posted 15 May 2014 - 16:56

in the "sales pivot"  are considered the invoice lines that are indicated as tax only ( so the field TaxOnly of the table INV1 is checked).

...then the invoice total is wrong because the taxonly rows are include in the total amount of the sales document.


the SAP standard  invoice list is correct,  without the taxonly row


how can I fix it in the coresuite report?


#2 fiona.shao


    New Member

  • Members
  • 3 posts

Posted 19 May 2014 - 09:53

Hello Massimo,

This issue was lead by the datasource of this report. As this datasource is provided by our add-on, if you want to fix by yourself, the only possible way is duplicate the layout definition of this layout, remove our datasource on the top of right and attach your own datasource saved in query manager. please check follow steps to get the datasource:

1. open designer configuration -> check log query

2. restart our add-on

3. running the report SAR06001

4. open the path -> Temp -> swald -> your company DB -> queries -> queries.txt

5. the txt file record the datasource query

6. please revise this query and save in query manager

then the saved query could be used in your duplicated layout definiation.


best regards,


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users