cancel
Showing results for 
Search instead for 
Did you mean: 

Consulting business partners transactions

Former Member
0 Kudos

Hi everyone,

I'm trying to build a report for consulting all the transaction made by a business partner, so, I'd like to know if there is any table in SAP Business One that records all these information, just like OINM table stores all the information about inventory transactions.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thank you

former_member201110
Active Contributor
0 Kudos

Hi Moreno,

If you are only interested in transaction types that affect the BP balance then you can use the JDT1 table. This will have entries for purchasing, sales and GL related transactions. The TransType column will tell you what type of transaction it is, the BaseRef gives the document number and the ShortName column will have the BP Code. The data in this table for a particular BP should reconcile back to that BP's balance.

Kind Regards,

Owen