Skip to Content
avatar image
Former Member

Sap Business One reports

Hi

I have started working with SAP B1 two weeks ago. I can not find anywhere how to create sales and purchase report for goods. I would like to know when I bought some item, how the AP invoices were look like and reversely: when I sold some item, who was a customer and how the AR invoice was look like.

Could you please help me?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 30, 2017 at 09:30 AM
    -1

    Hi,

    for purchase information navigate to

    Purchasing -- Purchasing report -- Purchase Analysis

    for sales information

    Sales -- Sales report -- sales Analysis

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2017 at 05:28 AM

    Hi Anna Lewandowska,

    you can download the E Learning Session but you need a SUSER Id. With the help of SUSER ID you can download any document from the www.sdn.sap.com

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 03:56 AM

    Hi,

    You can use standard reports sales and purchase from SAP B1. If you want create new report, you have to study query generator or query wizard.

    Also you need know tables ( for example, AP Invoice -->OPCH, AR Invoice- OINV) before creating any query.

    Here example to find when you bought item,

    SELECT T0.[DocNum], T0.[CardName], T0.[DocDate] FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[ItemCode] = [%0]

    Here example to find sold item,

    SELECT T0.[DocNum], T0.[CardName], T0.[DocDate] FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[ItemCode] = [%0]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded