Creating a production order gi with production nbr, operation , labor details to be displayed using sales order , sales order requested date and order date

Look at the Production Order Labor Efficiency report for the tables you need.  This article explains the manufacturing tables.particularly the transaction codes for the different labor types in AMMTran.   https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=1ce567e9-7d64-4f0d-aa14-d894a35a8fc3

@vishalsharma49 dgodsill97's pointer is the right model. The Production Order Labor Efficiency report (AM653000) joins AMProdItem to AMProdOper on OrderType and ProdOrdID, AMProdOper to AMMTran on OrderType, ProdOrdID and OperationID, then AMMTran to EPEmployee on EmployeeID. It only shows the employee labor detail when AMMTran.DocType is L. AMMTran holds every manufacturing transaction (material, move, labor, cost and others), so add a condition AMMTran.DocType Equals L.

The sales order join is the part that's off. AMProdItem.OrderType is the production order type, so OrderType = OrderType won't find the sales order the production order came from. That link lives in three other AMProdItem fields: OrdTypeRef, OrdNbr and OrdLineRef (Sales Order Type, Sales Order Nbr., SO Line Nbr.). They're filled when the production order is created from or linked to a sales order line, and blank otherwise.

Left join SOLine on OrdTypeRef = OrderType, OrdNbr = OrderNbr and OrdLineRef = LineNbr. Left join SOOrder on the first two to get Date and Requested On. Right now SOOrder isn't joined at all, because both of its relations are unchecked. The left join keeps production orders that have no sales order. Their sales order columns just come back empty.