I created a report to list job material for our spare parts business
(orderdet.prodcode 06). All was well until a request was made to add
the issued qty to the job. I am having trouble linking the job
material table (issued qty) to the order. I need the order info for
the $. These are the joins I have:
orderhed to customer
orderhed to orderdtl
orderdtl to orderrel
orderrel to jobprod
jobprod to jobhead
jobhead to jobasmbl
jobasmbl to jobmtl
All data appears correct except for the issued qty. The mtlseq is
incorrect in relationship to the orderrel line info. Any help would
be appreciated.
John
(orderdet.prodcode 06). All was well until a request was made to add
the issued qty to the job. I am having trouble linking the job
material table (issued qty) to the order. I need the order info for
the $. These are the joins I have:
orderhed to customer
orderhed to orderdtl
orderdtl to orderrel
orderrel to jobprod
jobprod to jobhead
jobhead to jobasmbl
jobasmbl to jobmtl
All data appears correct except for the issued qty. The mtlseq is
incorrect in relationship to the orderrel line info. Any help would
be appreciated.
John