cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports: Orange Link Arrow to OPCH (Purchase Invoice)

leon_laikan
Participant
0 Kudos

Hi!

 

This is my first attempt at using link arrows in Crystal Reports, so please bear with me.

 

I created a test Crystal Report using the following fields from SAP Table OPCH (Purchase Invoice):

 

                                 DocEntry,  DocNum,   CardCode,   U_Scan.

 

U_Scan is a User Defined Field which was created in Marketing Documents and defined as  ‘Link field’

 

The purpose of this field is to attach scanned PDF files of Suppliers’ Invoices.

When I click on this UDF, the scanned PDF pops us.

In this way, it’s easy to view the Purchase Invoice without the pain of searching for the hard copy.

 

Now for link arrow:

 

In the Hyperlink X-2 box, I type  this formula:

 

                'http://$b1$/link?table=OPCH&key='+TOTEXT({OPCH.DocEntry})

When I run the Crystal Report from SAP (Preview External Crystal Reports File), I see a golden link arrow on each row.

When I click on one of these arrows, the relevant A/P Invoice Screen pops up.

If I then click on the UDF (which is on the same screen), the scanned invoice pops up.

 

Now, this is not exactly what I want.

I don’t want users to have access to the A/P Invoice screen (accidental modification!).

I want them to go directly to the PDF.

 

I want  the scanned invoice to pop up when the user clicks on the golden arrow in Crytal Reports.

 

Is this possible? How can I modify my formula to make it possible?

 

Thanks

Leon Lai

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Leon,

No idea what you are referencing. Possibly this is Business One version of Crystal Reports in which case please log your question to the B1 forums. It's an OEM product so that forum supports it.

Don

leon_laikan
Participant
0 Kudos

Hi Don,

Thanks for your reply.

Yes, it is SAP B1 version of Crystal Report.

I have more chance of getting a reply when I post my question here,

But if it is unanswered, I'll try to migrate it to SAP Reporting forum as you suggest.

Best Regards

Leon Lai

0 Kudos

Moved to the B1 forum...

I doubt you'll get an answer here, as I said B1 is an OEM Product so the CR forum does not know what those reports are or how the interface works.

You should have a support contract so I suggest you log a CSS ticket.

Thanks

Don

Former Member
0 Kudos

Hello,

why do you just show the U_scan field in the report, and create it as a hyperlink to the PDF.

I think this can be done, since you can choose the "File" option under the Hyperlink tab in Crystal reports.

It just an idea, please try it if you wish.

Kind regards,

Ottó

leon_laikan
Participant
0 Kudos

Hi Otto,

This is what I have actually done to solve my problem.

My thread has been closed quite some time ago.

Anyway, thanks a lot for your reply.

Best Regards

Leon

Answers (0)