Warehouse receipt line modification

JosetxoJosetxo Member Posts: 92
Hello,

I am trying to modify the Warehouse Receipts process. It seems to be very simple: when I am on a Warehouse Receipt, I select a Purchase Order and then I click on Functions -> Get Source Documents.
The Purchase Lines on the source documents are then shown. Then I select one or more, click on OK and they are brought to the Warehouse Receipt Line table.
Everything is correct.

But, when those purchase lines are moved to the Warehouse Receipts Line table, I'd like to additionally get a field (QC) on the related Item table, and copy its value to a new field (Quality Control) on my Warehouse Receipt Line table. The field is not in the Purchase Line table, it is only in the Item table.

I have tried writing the code on the OnInsert trigger, but it seems it does not fire when records are inserted this way.

Where should I write that code?

Many thanks in advance,
Josetxo

Answers

  • JosetxoJosetxo Member Posts: 92
    I think I have solved it (by myself ;)

    I have just added the code on the OnAfterGetRecord trigger of the 5769 subform. It looks on the Item table and retrieves the NC value from the item record.

    I still have to test it thoroughly, but I think I've got it.

    Regards,
    Josetxo
Sign In or Register to comment.