PO Numbers on Requisition Entry Landing Page

Kinetic ERP
1

I am looking to add a way to see the PO number on the Requisitions Entry Landing Page. How would you go about doing that if the PONum is located on the ReqDetail table and the landing page is pulling from the ReqHead table?

1 Like
2

Post BPM on the BO Method running to populate the Landing Page (Probably Something.GetRows, check F12 Dev Tools Network Tab when you refresh the grid)

Check what the dataset in the BO Method is, probably “ds” or “result” - find the appropriate DataTable within that method (ReqHead?) - loop through every row in the data table. Add a new column via something like:

foreach (var r in ds.ReqHead) {
   r["PONum"] = Db.ReqDetail.FirstOrDefault(x => x.Company == Session.CompanyID && <do stuff to look up the PONum from Db LINQ>).PONum;
}

Add some logic to provide a default value when there’s no matching record found.

Then, you need to make a custom layer on Requisitions Entry, modify gridModel.columns for the landing page to add your column. Save it, publish it, stick it on the menu in kinetic customizations.

2 Likes
3

Ok I follow what you’re saying there. Thank you so much!

1 Like