Skip to Content
0
Former Member
Feb 09, 2015 at 05:29 PM

Creating a delivery query with delivery information, line and batch data

170 Views

I am trying to create a simple query but having difficulty linking the delivery (ODLN, DLN1) and batch tables (OIBT, IBT1). The output is simple:

BP Card

BP Name

Item Code

Item Description

Batch#

Expiration Date

Warehouse

Quantity

Date Shipped

Delivery #