Recapitulation - Sales Order and Delivery Note Report

[supjkt]

Hi there,

need help please.

we try to looking built-in report on SAP Business One 9.2, but can't find for our needs.

we like to lookup all Sales Order which have been created for certain period (date range), and see its status (delivery or still outstanding, how many, when..etc).

basically, what it's told in Relationship map in sales order, we like to view as report.

is that possible? trying to figure out name table, but still struggling.

we consider to build report using crystal report.

kindly please help.

thank you.

[nalamo]

The Order header table is ORDR, lines table RDR1. The Delivery Header is ODLN and lines is DLN1. In the delivery line table, there is BaseEntry and BaseLine which correspond to the DocEntry and LineNum of the Sales Order from which the Delivery was created.

Link these tables together and you have the foundation for your report.