Skip to Content

Difficulty adding new field to crystal report. SAP B1 / Crystal Reports For SAP / Accellos WMS

Dec 11, 2017 at 02:53 PM


avatar image

I am having difficulty making an amendment to a pre-existing crystal report file.

Our in house crystal expert has unexpected left the company and I have yet to have training.

We run SAP Business One 9.1 and Accellos WMS.

This crystal report is used by Accellos, to generate a delivery note based on information provided by SAP Business One.

Looking at the Database Expert in Crystal Reports, the report is using a view table called NER_DelNote which contains only the fields necessary for this report.

I wish to add the field U_PO_number from RDR1 table in SAP sales order onto this crystal report, on a product line level.

My initial though was to create a new connection in Database Expert and add the ORDR and RDR1 tables in but I cannot link these to any of the fields in the NER_DelNote view/table because the 'data types are not compatible'

Is there an alternative way to achieve what I am trying create?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers