Purchase Order Number - 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 Purchase Order Number onto this report.

In what table will I find this?

Thank you!

John

[former_member419030 · Accepted solution]

Dear John,

Customer ref No already in table invoice.

the field name is numAtCard.

[Abdul]

Dear

to know about joins between tables in SAP B1 got o query generator and select both tables it will make auto joins form this you will know for simple and direct linked tables

[former_member594505]

That's, actually, not what I was asking.

I cannot join any tables - period. Crystal is not letting me. How do I do this?

John

[agustin_marcoscividanes]

Hi

the relationship between two documents is in the lines, you have to use RDR1 for sales order lines, DLN1 for delivery lines and INV1 for invoice lines.

In each line, you can find the document father and the type of the document. And be careful because you can find a sales order line in several delivery lines, and the same with sales invoice lines.

Kind regards

Agustín

[former_member594505]

Please disregard. The "Customer Ref. No." field will be used.

I apologize, for the bother.

John

[former_member594505]

Hi:

I'm sorry. But, I don't understand. Are you saying that a UDF has to be established, in order to have a field that will contain the PO Number?

John

[agustin_marcoscividanes]

Hi

If you convert one sales order in one sales invoice, you have 2 options: creating an UDF and copying the document number; or navigating through the invoice lines to the delivery lines, and then to the sales order lines and finally the sales order document.

If you convert several sales order in one sales invoice, you have to group the information by the sales order number.

Kind regards

Agustín