Skip to Content
Sep 04, 2020 at 07:00 PM

Query for Suppliers Invoice and Journal Entry


Hi everybody, at work, I use SAP B1 v9.0 and I would need a Query that reports the invoices of suppliers and the journal entry. Besides, I would need the following details - Business Partner name and code - Invoice number - Distribution rule - Registration date - Description - Competence From/To - Amount in DS without VAT - Amount in DS with VAT I tried to create a query using PCH1 and JDT1 but I can't tie them together. Please help me! Thanks