How to see Subcontract demand that still needs a PO placed?

Kinetic ERP
1

Hi All,

We have recently starting using Subcontract PO’s more frequently and I’m trying to update my reporting to reflect material line status and Subcontract line status.

So far I’ve looked at Subcontract Status Report, but that doesn’t give me any PO info (or lack there of). Am I overlooking an application?

My goal is to be able to search by part number and display if the subcontract line has a po place and if so, when the due date is, if it’s confirmed, etc.

Thank you in advance!

2

I think most of this can be covered by querying the PartDtl table.

PartDtl “contains all of the open demand and supply records”.

There is a field called Type on this table. Set a Table Criteria for Type = “Sub” and you’ll see all subcontract demand.

There are also PONum, POLine & PORelNum columns on this table for easy reference. Linking that to POHead, PODetail, PORel tables should get you any reference due dates and confirmation information you’re trying to find.

2 Likes