Skip to Content
0

Sap Business One reports

Jan 29, 2017 at 07:35 PM

83

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vinoth Florian Z 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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 30, 2017 at 05:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Jan 31, 2017 at 03:56 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded