Tables on purchase invoice

[Pasquale_P]

Hi All,

When I record an invoice, I notice that data is written to all tables except OPCH, PCH1, PCH6, and PCH12. Are there any other tables I should be checking?

thanks all for your support, 

[SBO]

Hi,

It really all depends on your specific Purchase Invoice creation scenario, but should you have included row or header Freight charges as well, you may wish to check tables PCH2 (A/P Invoice - Freight - Rows) and PCH3 (A/P Invoice - Freight) as well.

Best of luck.

[jitin_chawla]

Hi,

OPCH and PCH1 are the tables which are main tables and each record of the AP Invoice should go into the OPCH table and line details in the PCH1.

Check what query are you using to check records in the MSSQL/HANA? May be you can share the same here.

Also, is this happening with specific document or all documents have the same issue?

If you use the document number, in the SAP Business One application, are you able to find the Invoice?

Kr,

Jitin