Dynamics Community Forum Thread Details

Flow Custom Fields from Warehouse Receipt Line(7317) to Purch. Rcpt. Line (121)

Hello Experts,

I want to transfer my custom fields from Warehouse Receipt Line (Table 7317) to Purch. Rcpt. Line (Table 121) in Business Central SaaS.

I have implemented the following approach and would like to verify whether it is the recommended approach or if there is a better alternative available.

Current approach:

Warehouse Receipt Line (7317)
        ↓
Purchase Line (39)
        ↓
Purch. Rcpt. Line (121)

To achieve this, I first copy the custom field from Warehouse Receipt Line to Purchase Line, and then allow it to flow from Purchase Line to Purch. Rcpt. Line during the posting process.

I have used the following event for this implementation:

 [EventSubscriber(ObjectType::Codeunit, codeunit::"Whse.-Post Receipt", 'OnBeforePurchLineModify', '', true, true)]
    local procedure UpdatePurchaseLines(var ModifyLine: Boolean; var PurchaseLine: Record "Purchase Line"; WhseRcptLine: Record "Warehouse Receipt Line")
    begin
        PurchaseLine."Bag Size" := WhseRcptLine."Bag Size";
    end;