Our construction company is new to Acumatica. When we look at our subcontract log, we would like to have a column for project so we can filter by projects. We are trying to add the Project ID number to this generic inquiry however when we do we get no results.
The Screen ID is SC3010PL.
Any ideas you have would be much appreciated!
Kay Howe
CFO
740-418-5250
Best answer by vkumar
Hi
I tried a workaround. I have added POLine and set the relation to pull only first line of the Sub contract to fetch the Project ID. If on sub contract first line does not have project reflected, it wont reflect the Project on GI result.
Here is the relation I have set and the GI result.
I have attached the XML of this modified GI as well. Hope this helps.
Regards,
Hi
The Project Code is not saved at Sub contract header level. The Subcontracts are stored in POOrder table, the column name for Project is ProjectID( POOrder.ProjectID).
But, since the Project information is not stored at header level, it reflects a value of zero or null.
Regards,
Hi
I tried a workaround. I have added POLine and set the relation to pull only first line of the Sub contract to fetch the Project ID. If on sub contract first line does not have project reflected, it wont reflect the Project on GI result.
Here is the relation I have set and the GI result.
I have attached the XML of this modified GI as well. Hope this helps.
Regards,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
