cancel
Showing results for 
Search instead for 
Did you mean: 

Add Shipping Type in AR Invoice in Crystal Report

Former Member
0 Kudos

Dear Experts,

I'm designing the layout by Crystal Report. I want to add Shipping Type in AR Invoice. I used the ready format provided in version 8.8. However, there is no Shipping Type in the given format. So, I pulled in the OSHP table and link TrnspCode to OINV's TrnspCode.

This form works only if I select a shipping type from the drop-down menu in the AR Invoice. If I leave the shipping type empty, this form will generate a blank data.

Where did I go wrong?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

A question: why do you need leave the shipping type empty?

Thanks,

Gordon

Former Member
0 Kudos

It's not that I want to leave the shipping type empty. By default, the shipping type is empty and I didn't have this problem with the Delivery Order layout.

Former Member
0 Kudos

You must have joined the tables using INNER JOIN which must have a record in both tables. Try editing the link to a Left Join

Answers (0)