Unable to add database fields in SAP B1 Crystal Report

[Erasmos_Asare]

Hi Experts,

We use the outgoing payment to create payment between Expense G/L and Cash Account(see Frame 1).

Upon generating the PV report, we wish to see the respective Doc. Remarks and Expense G/Ls  however this is not the case (see Frame. 2). 

We decided to Design it in the Crystal Report to make that information available in the report. Upon getting to Crystal Report, we noticed the Doc. Remarks is in the RCT4  table hence we used the database expert to add the table.

PROBLEM:

After adding the RCT4 table, the information initially on the report is deleted on the Preview Mode even though the Design Mode has all the fields (see Frame 3).

How do I go about this?

Frame 3

Thank you.