cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the document no. & doc date from return form?

meimei
Explorer
0 Kudos

Dear Experts,


Im making a layout for delivery form thru crystal report. but i want the document no. from return form will appear on my layout. the link i made was ORDN.CardCode --> ODLN.CardCode. the Doc. No. from return was appeared but when i check the relationship of that document on SAP B1 it looks like that return no. is not related on my delivery. What should i do?

Regards,

Meimei

Accepted Solutions (1)

Accepted Solutions (1)

Johan_H
Active Contributor
0 Kudos

Hi Meimei,

Finding the relevant document is tricky, because the delivery may have been copied to an invoice or to a returns.

Also it is possible to copy some rows to an invoice and some rows to a returns.

And it is even possible to copy part of the quantity of a row to an invoice and another part to a returns.

Because of this you need to start from the Returns document rows. You may link the RDN1.BaseEntry field to the DLN1.DocEntry field and RDN1.BaseLine to DLN1.LineNum.

Regards,

Johan

Answers (0)