on 07-31-2008 9:18 PM
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.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.