So, I’ve been working on a report to show what items got ordered that we don’t have the stock to cover it. And I FINALLY got it to work! However, I noticed one anomaly. And that is I have parts that have an order number, stock, and the order entry screen doesn’t pull any jobs for those. However, I go into Job Manager and I see a job number associated with that order number. So, I decided to do a little experiment and do another BAQ just a Part–>JobHead. Restricted part to the part I was looking into, and Nothing showed up. I went from an inner join to a left join and got all info except no job number. Any idea why a job number can be displayed in Job manager but not pull from the tables?
Start your BAQ with JobProd. It will link the job number with demand(order details by line , releases), join with part-bin to get quantity.
2 Likes