Codeunit 30246 Shpfy Create Sales Doc. Refund

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Order Return Refund Processing/Codeunits/ShpfyCreateSalesDocRefund.Codeunit.al588 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Shopify;using Microsoft.Finance.Currency;using Microsoft.Sales.Document;codeunit 30246 "Shpfy Create Sales Doc. Refund"{    var        OrderSalesHeader: Record "Sales Header";        Shop: Record "Shpfy Shop";        RefundProcessEvents: Codeunit "Shpfy Refund Process Events";        RefundId: BigInteger;        SalesDocumentType: Enum "Sales Document Type";    trigger OnRun()    begin        CreateSalesDocument();    end;    internal procedure SetSource(SourceDocumentId: BigInteger)    begin        RefundId := SourceDocumentId;    end;    internal procedure SetTargetDocumentType(SalesDocType: Enum "Sales Document Type")    begin        SalesDocumentType := SalesDocType;    end;    internal procedure GetSalesHeader(): Record "Sales Header";    begin        exit(OrderSalesHeader);    end;    local procedure CreateSalesDocument()    var        RefundHeader: Record "Shpfy Refund Header";        ReleaseSalesDocument: Codeunit "Release Sales Document";    begin        if RefundHeader.Get(RefundId) then begin            Shop.Get(RefundHeader."Shop Code");            if DoCreateSalesHeader(RefundHeader, SalesDocumentType, OrderSalesHeader) then begin                CreateSalesLines(RefundHeader, OrderSalesHeader);                RefundHeader.Get(RefundHeader."Refund Id");                ReleaseSalesDocument.Run(OrderSalesHeader);                RefundProcessEvents.OnAfterProcessSalesDocument(RefundHeader, OrderSalesHeader);            end;        end;    end;    local procedure DoCreateSalesHeader(var RefundHeader: Record "Shpfy Refund Header"; SalesDocType: Enum "Sales Document Type"; var SalesHeader: Record "Sales Header"): Boolean    var        OrderHeader: Record "Shpfy Order Header";        DocLinkToBCDoc: Record "Shpfy Doc. Link To Doc.";        ShopifyTaxArea: Record "Shpfy Tax Area";        BCDocumentTypeConvert: Codeunit "Shpfy BC Document Type Convert";        ProcessOrder: Codeunit "Shpfy Process Order";        OrderMgt: Codeunit "Shpfy Order Mgt.";        IsHandled: Boolean;    begin        Clear(SalesHeader);        DocLinkToBCDoc.SetRange("Shopify Document Type", "Shpfy Shop Document Type"::"Shopify Shop Refund");        DocLinkToBCDoc.SetRange("Shopify Document Id", RefundHeader."Refund Id");        DocLinkToBCDoc.SetCurrentKey("Shopify Document Type", "Shopify Document Id");        if not DocLinkToBCDoc.IsEmpty then            exit;        if OrderHeader.Get(RefundHeader."Order Id") then begin            RefundProcessEvents.OnBeforeCreateSalesHeader(RefundHeader, SalesHeader, IsHandled);            if not IsHandled then begin                SalesHeader.Init();                SalesHeader.SetHideValidationDialog(true);                SalesHeader.Validate("Document Type", SalesDocType);                SalesHeader.Insert(true);                SalesHeader.Validate("Sell-to Customer No.", OrderHeader."Sell-to Customer No.");                SalesHeader."Sell-to Customer Name" := CopyStr(OrderHeader."Sell-to Customer Name", 1, MaxStrLen(SalesHeader."Sell-to Customer Name"));                SalesHeader."Sell-to Customer Name 2" := CopyStr(OrderHeader."Sell-to Customer Name 2", 1, MaxStrLen(SalesHeader."Sell-to Customer Name 2"));                SalesHeader."Sell-to Address" := CopyStr(OrderHeader."Sell-to Address", 1, MaxStrLen(SalesHeader."Sell-to Address"));                SalesHeader."Sell-to Address 2" := CopyStr(OrderHeader."Sell-to Address 2", 1, MaxStrLen(SalesHeader."Sell-to Address 2"));                SalesHeader."Sell-to City" := CopyStr(OrderHeader."Sell-to City", 1, MaxStrLen(SalesHeader."Sell-to City"));                SalesHeader."Sell-to Country/Region Code" := ProcessOrder.GetCountryCode(CopyStr(OrderHeader."Sell-to Country/Region Code", 1, 10));                SalesHeader."Sell-to Post Code" := CopyStr(OrderHeader."Sell-to Post Code", 1, MaxStrLen(SalesHeader."Sell-to Post Code"));                SalesHeader."Sell-to County" := OrderHeader."Sell-to County";                SalesHeader."Sell-to Phone No." := CopyStr(DelChr(OrderHeader."Phone No.", '=', DelChr(OrderHeader."Phone No.", '=', '0123456789 +()/.')), 1, MaxStrLen(SalesHeader."Sell-to Phone No."));                SalesHeader."Sell-to E-Mail" := CopyStr(OrderHeader.Email, 1, MaxStrLen(SalesHeader."Sell-to E-Mail"));                SalesHeader.Validate("Sell-to Contact No.", OrderHeader."Sell-to Contact No.");                SalesHeader.Validate("Bill-to Customer No.", OrderHeader."Bill-to Customer No.");                SalesHeader."Bill-to Name" := CopyStr(OrderHeader."Bill-to Name", 1, MaxStrLen(SalesHeader."Bill-to Name"));                SalesHeader."Bill-to Name 2" := CopyStr(OrderHeader."Bill-to Name 2", 1, MaxStrLen(SalesHeader."Bill-to Name 2"));                SalesHeader."Bill-to Address" := CopyStr(OrderHeader."Bill-to Address", 1, MaxStrLen(SalesHeader."Bill-to Address"));                SalesHeader."Bill-to Address 2" := CopyStr(OrderHeader."Bill-to Address 2", 1, MaxStrLen(SalesHeader."Bill-to Address 2"));                SalesHeader."Bill-to City" := CopyStr(OrderHeader."Bill-to City", 1, MaxStrLen(SalesHeader."Bill-to City"));                SalesHeader."Bill-to Country/Region Code" := ProcessOrder.GetCountryCode(CopyStr(OrderHeader."Bill-to Country/Region Code", 1, 10));                SalesHeader."Bill-to Post Code" := CopyStr(OrderHeader."Bill-to Post Code", 1, MaxStrLen(SalesHeader."Bill-to Post Code"));                SalesHeader."Bill-to County" := CopyStr(OrderHeader."Bill-to County", 1, MaxStrLen(SalesHeader."Bill-to County"));                SalesHeader.Validate("Bill-to Contact No.", OrderHeader."Bill-to Contact No.");                SalesHeader.Validate("Ship-to Code", '');                SalesHeader."Ship-to Name" := CopyStr(OrderHeader."Ship-to Name", 1, MaxStrLen(SalesHeader."Ship-to Name"));                SalesHeader."Ship-to Name 2" := CopyStr(OrderHeader."Ship-to Name 2", 1, MaxStrLen(SalesHeader."Ship-to Name 2"));                SalesHeader."Ship-to Address" := CopyStr(OrderHeader."Ship-to Address", 1, MaxStrLen(SalesHeader."Ship-to Address"));                SalesHeader."Ship-to Address 2" := CopyStr(OrderHeader."Ship-to Address 2", 1, MaxStrLen(SalesHeader."Ship-to Address 2"));                SalesHeader."Ship-to City" := CopyStr(OrderHeader."Ship-to City", 1, MaxStrLen(SalesHeader."Ship-to City"));                SalesHeader."Ship-to Country/Region Code" := ProcessOrder.GetCountryCode(CopyStr(OrderHeader."Ship-to Country/Region Code", 1, 10));                SalesHeader."Ship-to Post Code" := CopyStr(OrderHeader."Ship-to Post Code", 1, MaxStrLen(SalesHeader."Ship-to Post Code"));                SalesHeader."Ship-to County" := CopyStr(OrderHeader."Ship-to County", 1, MaxStrLen(SalesHeader."Ship-to County"));                SalesHeader."Ship-to Contact" := OrderHeader."Ship-to Contact Name";                SalesHeader."Prices Including VAT" := OrderHeader."VAT Included";                case OrderHeader."Processed Currency Handling" of                    "Shpfy Currency Handling"::"Shop Currency":                        SalesHeader.Validate("Currency Code", Shop."Currency Code");                    "Shpfy Currency Handling"::"Presentment Currency":                        SalesHeader.Validate("Currency Code", RefundHeader."Presentment Currency Code");                end;                SalesHeader.Validate("Document Date", DT2Date(RefundHeader."Created At"));                if OrderHeader."Tax Area Code" <> '' then begin                    SalesHeader.Validate("Tax Area Code", OrderHeader."Tax Area Code");                    SalesHeader.Validate("Tax Liable", OrderHeader."Tax Liable");                end else                    if OrderMgt.FindTaxArea(OrderHeader, ShopifyTaxArea) and (ShopifyTaxArea."Tax Area Code" <> '') then begin                        SalesHeader.Validate("Tax Area Code", ShopifyTaxArea."Tax Area Code");                        if not OrderHeader."Tax Exempt" then                            SalesHeader.Validate("Tax Liable", ShopifyTaxArea."Tax Liable");                    end;                MapPaymentMethodCode(SalesHeader);            end;            SalesHeader."Shpfy Refund Id" := RefundHeader."Refund Id";            if RefundHasExchangeItemLines(RefundHeader."Refund Id") then begin                SalesHeader."Shpfy Order Id" := OrderHeader."Shopify Order Id";                SalesHeader."Shpfy Order No." := OrderHeader."Shopify Order No.";            end;            SalesHeader.Modify(true);            Clear(DocLinkToBCDoc);            DocLinkToBCDoc."Document Type" := BCDocumentTypeConvert.Convert(SalesHeader."Document Type");            DocLinkToBCDoc."Document No." := SalesHeader."No.";            DocLinkToBCDoc."Shopify Document Type" := "Shpfy Shop Document Type"::"Shopify Shop Refund";            DocLinkToBCDoc."Shopify Document Id" := RefundHeader."Refund Id";            DocLinkToBCDoc.Insert();            RefundProcessEvents.OnAfterCreateSalesHeader(RefundHeader, SalesHeader);            exit(true);        end;    end;    local procedure GetLastLineNo(DocumentType: Enum "Sales Document Type"; DocumentNo: Code[20]): Integer    var        SalesLine: Record "Sales Line";    begin        SalesLine.SetLoadFields("Document Type", "Document No.", "Line No.");        SalesLine.SetRange("Document Type", DocumentType);        SalesLine.SetRange("Document No.", DocumentNo);        if SalesLine.IsEmpty() then            exit(10000)        else            if SalesLine.FindLast() then                exit(SalesLine."Line No." + 10000);    end;    local procedure CreateSalesLines(RefundHeader: Record "Shpfy Refund Header"; var SalesHeader: Record "Sales Header")    var        SalesLine: Record "Sales Line";        RefundLine: Record "Shpfy Refund Line";        ReturnLine: Record "Shpfy Return Line";        OrderHeader: Record "Shpfy Order Header";        LineNo: Integer;        ShopifyOrderNoLbl: Label 'Shopify Order No.: %1', Comment = '%1 = Order No.';    begin        LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");        if Shop."Shopify Order No. on Doc. Line" then begin            SalesLine.Init();            SalesLine.SetHideValidationDialog(true);            SalesLine.Validate("Document Type", SalesHeader."Document Type");            SalesLine.Validate("Document No.", SalesHeader."No.");            SalesLine.Validate("Line No.", LineNo);            SalesLine.Validate(Type, SalesLine.Type::" ");            OrderHeader.Get(RefundHeader."Order Id");            SalesLine.Validate(Description, StrSubstNo(ShopifyOrderNoLbl, OrderHeader."Shopify Order No."));            SalesLine.Insert(true);        end;        RefundLine.SetRange("Refund Id", RefundHeader."Refund Id");        RefundLine.SetAutoCalcFields("Item No.", "Variant Code", Description, "Gift Card", "Unit of Measure Code");        if RefundLine.FindSet(false) then            CreateSalesLinesFromRefundLines(RefundLine, RefundHeader, SalesHeader, LineNo)        else            if RefundHeader."Return Id" > 0 then begin                ReturnLine.SetRange("Return Id", RefundHeader."Return Id");                ReturnLine.SetRange(Type, ReturnLine.Type::Default);                ReturnLine.SetAutoCalcFields("Item No.", "Variant Code", Description, "Unit of Measure Code");                if ReturnLine.FindSet(false) then                    CreateSalesLinesFromReturnLines(ReturnLine, RefundHeader, SalesHeader, LineNo);            end;        CreateSalesLinesFromRefundShippingLines(RefundHeader, SalesHeader, LineNo);        CreateSalesLinesFromRemainingAmount(RefundHeader, SalesHeader, LineNo);    end;    local procedure CreateSalesLinesFromRefundLines(var RefundLine: Record "Shpfy Refund Line"; RefundHeader: Record "Shpfy Refund Header"; var SalesHeader: Record "Sales Header"; var LineNo: Integer)    var        SalesLine: Record "Sales Line";        GiftCard: Record "Shpfy Gift Card";        ShopLocation: Record "Shpfy Shop Location";        ExchangeOrderLine: Record "Shpfy Order Line";        OrderHeader: Record "Shpfy Order Header";        OpenAmount: Decimal;        LocationId: BigInteger;        ShopifyOrderNo: Code[50];        IsHandled: Boolean;    begin        if OrderHeader.Get(RefundHeader."Order Id") then            ShopifyOrderNo := OrderHeader."Shopify Order No.";        repeat            case RefundLine."Restock Type" of                "Shpfy Restock Type"::"Legacy Restock",                "Shpfy Restock Type"::Return,                "Shpfy Restock Type"::"No Restock":                    begin                        LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");                        RefundProcessEvents.OnBeforeCreateItemSalesLine(RefundHeader, RefundLine, SalesHeader, SalesLine, LineNo, IsHandled);                        if not IsHandled then begin                            SalesLine.Init();                            SalesLine.SetHideValidationDialog(true);                            SalesLine.Validate("Document Type", SalesHeader."Document Type");                            SalesLine.Validate("Document No.", SalesHeader."No.");                            SalesLine.Validate("Line No.", LineNo);                            SalesLine.Insert(true);                            if RefundLine."Gift Card" then begin                                SalesLine.Validate(Type, "Sales Line Type"::"G/L Account");                                Shop.TestField("Sold Gift Card Account");                                SalesLine.Validate("No.", Shop."Sold Gift Card Account");                            end else                                if RefundLine."Restock Type" = "Shpfy restock Type"::"No Restock" then begin                                    SalesLine.Validate(Type, "Sales Line Type"::"G/L Account");                                    Shop.TestField("Refund Acc. non-restock Items");                                    SalesLine.Validate("No.", Shop."Refund Acc. non-restock Items");                                    SalesLine.Description := RefundLine.Description;                                end else begin                                    SalesLine.Validate(Type, "Sales Line Type"::Item);                                    SalesLine.Validate("No.", RefundLine."Item No.");                                    if RefundLine."Unit of Measure Code" <> '' then                                        SalesLine.Validate("Unit of Measure Code", RefundLine."Unit of Measure Code");                                    if RefundLine."Variant Code" <> '' then                                        SalesLine.Validate("Variant Code", RefundLine."Variant Code");                                    // Exchange-item refund lines are created before the order lines exist, so their Location Id                                    // is 0. Resolve it now from the exchange order line, which carries the fulfillment location.                                    LocationId := RefundLine."Location Id";                                    if RefundLine."Is Exchange Item" and (LocationId = 0) then begin                                        ExchangeOrderLine.SetLoadFields("Location Id");                                        if ExchangeOrderLine.Get(RefundHeader."Order Id", RefundLine."Order Line Id") then                                            LocationId := ExchangeOrderLine."Location Id";                                    end;                                    if ShopLocation.Get(Shop.Code, LocationId) then                                        SalesLine.Validate("Location Code", ShopLocation."Default Location Code");                                    if (Shop."Return Location Priority" = "Shpfy Return Location Priority"::"Default Return Location") or (SalesLine."Location Code" = '') then                                        SalesLine.Validate("Location Code", Shop."Return Location");                                end;                            SalesLine.Validate(Quantity, RefundLine.Quantity);                            SalesLine.Validate("Unit Price", RefundLine.Amount);                            case Shop."Currency Handling" of                                "Shpfy Currency Handling"::"Shop Currency":                                    begin                                        SalesLine.Validate("Unit Price", RefundLine.Amount);                                        SalesLine.Validate("Line Discount Amount", (SalesLine."Unit Price" * SalesLine.Quantity) - RefundLine."Subtotal Amount");                                    end;                                "Shpfy Currency Handling"::"Presentment Currency":                                    begin                                        SalesLine.Validate("Unit Price", RefundLine."Presentment Amount");                                        SalesLine.Validate("Line Discount Amount", (SalesLine."Unit Price" * SalesLine.Quantity) - RefundLine."Presentment Subtotal Amount");                                    end;                            end;                        end;                        SalesLine."Shpfy Refund Id" := RefundHeader."Refund Id";                        SalesLine."Shpfy Refund Line Id" := RefundLine."Refund Line Id";                        if RefundLine."Is Exchange Item" then begin                            SalesLine."Shpfy Order Line Id" := RefundLine."Order Line Id";                            SalesLine."Shpfy Order No." := ShopifyOrderNo;                        end;                        SalesLine.Modify();                        if RefundLine."Gift Card" then begin                            GiftCard.SetRange("Order Line Id", RefundLine."Order Line Id");                            GiftCard.SetAutoCalcFields("Known Used Amount");                            OpenAmount := SalesLine.GetLineAmountInclVAT();                            if GiftCard.FindSet(true) then                                repeat                                    if GiftCard.Amount - GiftCard."Known Used Amount" > 0 then                                        if OpenAmount <= GiftCard.Amount - GiftCard."Known Used Amount" then begin                                            GiftCard.Amount -= OpenAmount;                                            OpenAmount := 0;                                        end else begin                                            OpenAmount := GiftCard.Amount - GiftCard."Known Used Amount";                                            GiftCard.Amount := GiftCard."Known Used Amount";                                        end;                                    GiftCard.Modify();                                until (OpenAmount = 0) or (GiftCard.Next() = 0);                        end;                        RefundProcessEvents.OnAfterCreateItemSalesLine(RefundHeader, RefundLine, SalesHeader, SalesLine);                    end;                "Shpfy Restock Type"::Cancel:                    begin                        LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");                        SalesLine.Init();                        SalesLine.SetHideValidationDialog(true);                        SalesLine.Validate("Document Type", SalesHeader."Document Type");                        SalesLine.Validate("Document No.", SalesHeader."No.");                        SalesLine.Validate("Line No.", LineNo);                        SalesLine.Insert(true);                        SalesLine.Validate(Type, "Sales Line Type"::"G/L Account");                        Shop.TestField("Refund Account");                        SalesLine.Validate("No.", Shop."Refund Account");                        SalesLine.Validate(Quantity, 1);                        case Shop."Currency Handling" of                            "Shpfy Currency Handling"::"Shop Currency":                                SalesLine.Validate("Unit Price", RefundLine."Subtotal Amount");                            "Shpfy Currency Handling"::"Presentment Currency":                                SalesLine.Validate("Unit Price", RefundLine."Presentment Subtotal Amount");                        end;                        SalesLine."Shpfy Refund Id" := RefundHeader."Refund Id";                        SalesLine."Shpfy Refund Line Id" := RefundLine."Refund Line Id";                        SalesLine.Modify();                    end;            end;        until RefundLine.Next() = 0    end;    local procedure CreateSalesLinesFromReturnLines(var ReturnLine: Record "Shpfy Return Line"; RefundHeader: Record "Shpfy Refund Header"; var SalesHeader: Record "Sales Header"; var LineNo: Integer)    var        SalesLine: Record "Sales Line";        ShopLocation: Record "Shpfy Shop Location";        IsHandled: Boolean;    begin        repeat            LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");            RefundProcessEvents.OnBeforeCreateItemSalesLineFromReturnLine(RefundHeader, ReturnLine, SalesHeader, SalesLine, LineNo, IsHandled);            if not IsHandled then begin                SalesLine.Init();                SalesLine.SetHideValidationDialog(true);                SalesLine.Validate("Document Type", SalesHeader."Document Type");                SalesLine.Validate("Document No.", SalesHeader."No.");                SalesLine.Validate("Line No.", LineNo);                SalesLine.Insert(true);                SalesLine.Validate(Type, "Sales Line Type"::Item);                SalesLine.Validate("No.", ReturnLine."Item No.");                if ReturnLine."Unit of Measure Code" <> '' then                    SalesLine.Validate("Unit of Measure Code", ReturnLine."Unit of Measure Code");                if ReturnLine."Variant Code" <> '' then                    SalesLine.Validate("Variant Code", ReturnLine."Variant Code");                if ShopLocation.Get(Shop.Code, ReturnLine."Location Id") then                    SalesLine.Validate("Location Code", ShopLocation."Default Location Code");                if (Shop."Return Location Priority" = "Shpfy Return Location Priority"::"Default Return Location") or (SalesLine."Location Code" = '') then                    SalesLine.Validate("Location Code", Shop."Return Location");                SalesLine.Validate(Quantity, ReturnLine.Quantity);                case Shop."Currency Handling" of                    "Shpfy Currency Handling"::"Shop Currency":                        SalesLine.Validate("Unit Price", ReturnLine."Discounted Total Amount" / ReturnLine.Quantity);                    "Shpfy Currency Handling"::"Presentment Currency":                        SalesLine.Validate("Unit Price", ReturnLine."Presentment Disc. Total Amt." / ReturnLine.Quantity);                end;            end;            SalesLine."Shpfy Refund Id" := RefundHeader."Refund Id";            SalesLine.Modify(false);            RefundProcessEvents.OnAfterCreateItemSalesLineFromReturnLine(RefundHeader, ReturnLine, SalesHeader, SalesLine);        until ReturnLine.Next() = 0;    end;    local procedure CreateSalesLinesFromRefundShippingLines(RefundHeader: Record "Shpfy Refund Header"; var SalesHeader: Record "Sales Header"; var LineNo: Integer)    var        RefundShippingLine: Record "Shpfy Refund Shipping Line";        OrderHeader: Record "Shpfy Order Header";        SalesLine: Record "Sales Line";    begin        RefundShippingLine.SetRange("Refund Id", RefundHeader."Refund Id");        if RefundShippingLine.FindSet() then            repeat                LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");                SalesLine.Init();                SalesLine.SetHideValidationDialog(true);                SalesLine.Validate("Document Type", SalesHeader."Document Type");                SalesLine.Validate("Document No.", SalesHeader."No.");                SalesLine.Validate("Line No.", LineNo);                SalesLine.Insert(true);                SalesLine.Validate(Type, "Sales Line Type"::"G/L Account");                Shop.TestField("Shipping Charges Account");                SalesLine.Validate("No.", Shop."Shipping Charges Account");                SalesLine.Validate(Description, RefundShippingLine.Title);                SalesLine.Validate(Quantity, 1);                OrderHeader.Get(RefundHeader."Order Id");                case OrderHeader."Processed Currency Handling" of                    "Shpfy Currency Handling"::"Shop Currency":                        if SalesHeader."Prices Including VAT" then                            SalesLine.Validate("Unit Price", RefundShippingLine."Presentment Subtotal Amount" + RefundShippingLine."Tax Amount")                        else                            SalesLine.Validate("Unit Price", RefundShippingLine."Presentment Subtotal Amount");                    "Shpfy Currency Handling"::"Presentment Currency":                        if SalesHeader."Prices Including VAT" then                            SalesLine.Validate("Unit Price", RefundShippingLine."Presentment Subtotal Amount" + RefundShippingLine."Presentment Tax Amount")                        else                            SalesLine.Validate("Unit Price", RefundShippingLine."Presentment Subtotal Amount");                end;                SalesLine."Shpfy Refund Id" := RefundHeader."Refund Id";                SalesLine."Shpfy Refund Shipping Line Id" := RefundShippingLine."Refund Shipping Line Id";                SalesLine.Modify(false);            until RefundShippingLine.Next() = 0;    end;    local procedure FillRemainingAmountLineFields(RefundHeader: Record "Shpfy Refund Header"; SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line"; var LineNo: Integer)    begin        Shop.TestField("Refund Account");        LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");        SalesLine.Init();        SalesLine.SetHideValidationDialog(true);        SalesLine.Validate("Document Type", SalesHeader."Document Type");        SalesLine.Validate("Document No.", SalesHeader."No.");        SalesLine.Validate("Line No.", LineNo);        SalesLine.Insert(true);        SalesLine.Validate(Type, "Sales Line Type"::"G/L Account");        SalesLine.Validate("No.", Shop."Refund Account");        SalesLine.Validate(Quantity, 1);        SalesLine."Shpfy Refund Id" := RefundHeader."Refund Id";    end;    local procedure CreateSalesLinesFromRemainingAmount(RefundHeader: Record "Shpfy Refund Header"; var SalesHeader: Record "Sales Header"; var LineNo: Integer)    var        SalesLine: Record "Sales Line";        Currency: Record Currency;        OrderHeader: Record "Shpfy Order Header";        SkipBalancing: Boolean;        RoundingAmount: Decimal;    begin        SalesHeader.CalcFields(Amount, "Amount Including VAT");        Currency.Initialize(SalesHeader."Currency Code");        RoundingAmount := CreateRoundingLine(RefundHeader, SalesHeader, LineNo);        RefundProcessEvents.OnBeforeCreateSalesLinesFromRemainingAmount(RefundHeader, SalesHeader, SkipBalancing);        if SkipBalancing then            exit;        // When the return includes an exchange item, the credit memo already carries the returned item (+qty) and the        // exchange item (-qty). Their net is the true customer impact and can differ from Shopify's Total Refunded Amount,        // which is floored at 0 when the kept exchange item is more expensive than the returned item (the customer pays the        // difference instead of receiving a refund). Reconciling to Total Refunded Amount here would add a spurious balancing        // Refund Account line, so the exchange item lines are left to stand on their own.        if RefundHasExchangeItemLines(RefundHeader."Refund Id") then            exit;        OrderHeader.Get(RefundHeader."Order Id");        case OrderHeader."Processed Currency Handling" of            "Shpfy Currency Handling"::"Shop Currency":                if SalesHeader."Amount Including VAT" <> RefundHeader."Total Refunded Amount" + RoundingAmount then begin                    FillRemainingAmountLineFields(RefundHeader, SalesHeader, SalesLine, LineNo);                    if SalesHeader."Prices Including VAT" then                        SalesLine.Validate("Unit Price", RefundHeader."Total Refunded Amount" - SalesHeader."Amount Including VAT")                    else                        SalesLine.Validate(                            "Unit Price",                            Round(                                (RefundHeader."Total Refunded Amount" - SalesHeader."Amount Including VAT") / (1 + SalesLine."VAT %" / 100),                                Currency."Amount Rounding Precision",                                Currency.VATRoundingDirection())                        );                    SalesLine.Modify(false);                end;            "Shpfy Currency Handling"::"Presentment Currency":                if SalesHeader."Amount Including VAT" <> RefundHeader."Pres. Tot. Refunded Amount" then begin                    FillRemainingAmountLineFields(RefundHeader, SalesHeader, SalesLine, LineNo);                    if SalesHeader."Prices Including VAT" then                        SalesLine.Validate("Unit Price", RefundHeader."Pres. Tot. Refunded Amount" - SalesHeader."Amount Including VAT")                    else                        SalesLine.Validate(                            "Unit Price",                            Round(                                (RefundHeader."Pres. Tot. Refunded Amount" - SalesHeader."Amount Including VAT") / (1 + SalesLine."VAT %" / 100),                                Currency."Amount Rounding Precision",                                Currency.VATRoundingDirection())                        );                    SalesLine.Modify(false);                end;        end;    end;    local procedure RefundHasExchangeItemLines(ShopifyRefundId: BigInteger): Boolean    var        RefundLine: Record "Shpfy Refund Line";    begin        RefundLine.SetRange("Refund Id", ShopifyRefundId);        RefundLine.SetRange("Is Exchange Item", true);        exit(not RefundLine.IsEmpty());    end;    local procedure CreateRoundingLine(RefundHeader: Record "Shpfy Refund Header"; SalesHeader: Record "Sales Header"; var LineNo: Integer): Decimal    var        OrderHeader: Record "Shpfy Order Header";    begin        OrderHeader.Get(RefundHeader."Order Id");        case OrderHeader."Processed Currency Handling" of            "Shpfy Currency Handling"::"Shop Currency":                exit(CreateRoundingLine(SalesHeader, LineNo, OrderHeader."Refund Rounding Amount"));            "Shpfy Currency Handling"::"Presentment Currency":                exit(CreateRoundingLine(SalesHeader, LineNo, OrderHeader."Pres. Refund Rounding Amount"));        end;    end;    local procedure CreateRoundingLine(SalesHeader: Record "Sales Header"; var LineNo: Integer; RefundRoundingAmount: Decimal): Decimal    var        SalesLine: Record "Sales Line";        CashRoundingLbl: Label 'Cash rounding';    begin        if RefundRoundingAmount <> 0 then begin            LineNo := GetLastLineNo(SalesHeader."Document Type", SalesHeader."No.");            SalesLine.Init();            SalesLine.SetHideValidationDialog(true);            SalesLine.Validate("Document Type", SalesHeader."Document Type");            SalesLine.Validate("Document No.", SalesHeader."No.");            SalesLine.Validate("Line No.", LineNo);            SalesLine.Insert(true);            SalesLine.Validate(Type, SalesLine.Type::"G/L Account");            Shop.TestField("Cash Roundings Account");            SalesLine.Validate("No.", Shop."Cash Roundings Account");            SalesLine.Validate(Quantity, 1);            SalesLine.Validate("Unit Price", GetRoundingAmountFromTransactions());            SalesLine.Validate(Description, CashRoundingLbl);            SalesLine.Modify();            exit(SalesLine."Unit Price");        end;    end;    local procedure MapPaymentMethodCode(var SalesHeader: Record "Sales Header")    var        OrderTransaction: Record "Shpfy Order Transaction";        PaymentMethods: List of [Code[10]];    begin        OrderTransaction.SetAutoCalcFields("Payment Method");        OrderTransaction.SetRange("Refund Id", RefundId);        OrderTransaction.SetRange(Status, "Shpfy Transaction Status"::Success);        OrderTransaction.SetRange(Type, "Shpfy Transaction Type"::Refund);        if OrderTransaction.FindSet() then begin            repeat                if not PaymentMethods.Contains(OrderTransaction."Payment Method") then                    PaymentMethods.Add(OrderTransaction."Payment Method");                if PaymentMethods.Count > 1 then                    exit;            until OrderTransaction.Next() = 0;            SalesHeader.Validate("Payment Method Code", PaymentMethods.Get(1));        end;    end;    local procedure GetRoundingAmountFromTransactions(): Decimal    var        OrderTransaction: Record "Shpfy Order Transaction";        TotalAmount: Decimal;    begin        OrderTransaction.SetRange("Refund Id", RefundId);        OrderTransaction.SetRange(Status, "Shpfy Transaction Status"::Success);        OrderTransaction.SetRange(Type, "Shpfy Transaction Type"::Refund);        if not OrderTransaction.FindSet() then            exit;        repeat            TotalAmount += OrderTransaction."Rounding Amount";        until OrderTransaction.Next() = 0;        exit(TotalAmount);    end;}