Sales Analysis Report per Sales Employee with BP Reference No

[Former Member]

Hi All,

I need your assistance in creating a query that balances back to Sales Analysis Report but I require the BP Reference No to show per row.  I have created 2 queries through Query Generator.  The 1st contains the OINV and OSLP tables with Fields:  DocNum, NumAtCard, SlpName, DocDate, CardCode, CardName, DocTotal

The 2nd contains the ORIN and OSLP tables withe the same Fields.

I need to combine these 2 queries and I need assistance with the DocTotal.  I need the amount before tax.

This report needs to balance back to the SAP B1 Sales Analysis Report.

Your assistance would be appreciated.

Regards,

Desiré Janse van Rensburg

[former_member206488]

you can use union all to combine two queries you created. or you can look at below link for queries and details:

http://scn.sap.com/message/10104817#10104817

Thanks