"Customer Ref. No.", "Payment Terms", "Shipping Date", and "Ship Via" Fields - A/R Invoice (Crystal)

[former_member594505]

Hello:

In SAP Business One 9.3 PL06, I'm trying to modify the A/R Invoice in Crystal. I'd like to place the "Customer Ref. No.", "Payment Terms", "Shipping Date", "Ship Via", and "Freight" fields onto this report.

In what tables, within Crystal Reports, will I find these?

Thank you!

John

[former_member594505]

Hi:

It doesn't much matter what table I join. The invoice doesn't print.

Why not?

John

[Abdul]

For payment terms just add OCTG by making a join with OINV

[former_member419030]

Dear John,

to get the payment term, you can

1) link OINV with OCRD (Business partner).

the field name is GroupNUM .

2) then Link the OCRD with OCTG (Payment term) to get the description.

[former_member594505]

Thanks, Agustin!

The only thing that I have been unable to do is the following:

To show the payment terms, you have to add the OPYM table and link with the field peyMethod in the document.

I don't see any tables beginning with "O" when I drill into the ODBC Connection that is used with the Database menu.

John

[agustin_marcoscividanes]

Hi

the Customer Ref No is the field NumatCard.

To show the payment terms, you have to add the OPYM table and link with the field peyMethod in the document.

To show Shipping date, this field is in the rows document.

To show the freight, you have to use the INV2 table

Kind regards

Agustín