I recently developed a table extension for Purchase Line, which adds a longer text field for the item description, the purchase order lines are associated with a job number and a task number.
When a Posted Purchase Invoice is generated, automatically the description of the item and other data are linked in Job Planning Lines and I can see the description of the item, I need to know what I should do so that Job Planning Lines not only see the description of the item but also the text field that you add in the Purchase Line table.
You would need to add another field to the Purchase Line table to reference the specific Job Planning Line or Job Contract Entry (unique identifier to all Job Planning Lines). Then add a flow field on the Job Planning Line to see (but not edit) the long description field.
Hi Ben
Thank you very much for the answer, thanks for the suggestion, I understand the flow field, I have seen that it allows to do a kind of lookup or query as you indicate, the problem I have is that in Purchase Order Line I cannot add the lookup field to Job Planning Lines since in that instance the record does not yet exist in Planning Job Lines.
The current process is
1.- When creating a Purchaser Order Line, it has a relationship with Job No. and Job Task No. since the job does exist, at this moment job planning lines do not exist.
2.- When generating a Posted purchase Invoice this is like a copy of the purchase order or confirmation that the purchase was made.
3.- when the purchase order is confirmed at that time the lines of the posted purchase invoice appear in Job Planning lines already associated, without the user doing anything, it is as if when generating the posted purchase invoice the lines were copied and some Values from posted purchase invoice to job planning lines.
All I am doing is because when I generate the Job report I need show the long description of the item when the purchase order was created to be in the report, I do not know if at the report level I can also directly consult a different entity considering that I do not have the relationship towards purchase order but only posted purchase order, I really appreciate any suggestion, or at least to know if it is something that could be done.
once again thank you very much for your opinion.
Hi Ben
Thank you very much for the answer, thanks for the suggestion, I understand the flow field, I have seen that it allows to do a kind of lookup or query as you indicate, the problem I have is that in Purchase Order Line I cannot add the lookup field to Job Planning Lines since in that instance the record does not yet exist in Planning Job Lines.
The current process is
1.- When creating a Purchaser Order Line, it has a relationship with Job No. and Job Task No. since the job does exist, at this moment job planning lines do not exist.
2.- When generating a Posted purchase Invoice this is like a copy of the purchase order or confirmation that the purchase was made.
3.- when the purchase order is confirmed at that time the lines of the posted purchase invoice appear in Job Planning lines already associated, without the user doing anything, it is as if when generating the posted purchase invoice the lines were copied and some Values from posted purchase invoice to job planning lines.
All I am doing is because when I generate the Job report I need show the long description of the item when the purchase order was created to be in the report, I do not know if at the report level I can also directly consult a different entity considering that I do not have the relationship towards purchase order but only posted purchase order, I really appreciate any suggestion, or at least to know if it is something that could be done.
once again thank you very much for your opinion.
