Untitled

 avatar
unknown
plain_text
5 months ago
9.0 kB
9
Indexable
page 50072 "Change VAT Entry Table"
{
    // version BSDP02/015

    // #BSDP02/015# - Change Posted Incoming Document No. and Date

    CaptionML = ENU='Change Date/Enternal Doc.No.',
                PLK='Zmień datę/Numer dokumentu zewnętrznego';
    PageType = Card;
    Permissions = TableData 17=rm,
                  TableData 25=rm,
                  TableData 122=rm,
                  TableData 254=rm,
                  TableData 380=rm,
                  TableData 5601=rm,
                  TableData 5802=rm,
                  TableData 52063068=rm;
    SourceTable = Table254;

    layout
    {
        area(content)
        {
            group("Ogólne")
            {
                CaptionML = ENU='Change date/External Document No.',
                            PLK='Zmień datę i numer faktury zakupu';
                field("External Document No.";"External Document No.")
                {
                    CaptionML = ENU='External Document No.',
                                PLK='Numer dokumentu zewnętrznego';
                    Editable = true;

                    trigger OnValidate();
                    begin
                        //START/BSDP02/015
                        IF "Source Code" = 'ZAKUPY' THEN BEGIN
                          //change in table 254
                          "Old External Document No." := xRec."External Document No.";
                          MODIFY;

                          //change in table 122
                          PurchInvHeader.SETRANGE(PurchInvHeader."No.","Document No.");
                          IF PurchInvHeader.FINDFIRST THEN BEGIN
                            PurchInvHeader."Old External Document No." := PurchInvHeader."Vendor Invoice No.";
                            PurchInvHeader."Vendor Invoice No." := "External Document No.";
                            PurchInvHeader.MODIFY;
                          END;

                          //change in table 17
                          GLEntry.SETRANGE(GLEntry."Document No.","Document No.");
                          IF GLEntry.FINDSET THEN
                            REPEAT
                              GLEntry."External Document No." := "External Document No.";
                              GLEntry.MODIFY;
                            UNTIL GLEntry.NEXT = 0;

                          //change in table 25
                          VendorLedgerEntry.SETRANGE(VendorLedgerEntry."Document No.","Document No.");
                          IF VendorLedgerEntry.FINDFIRST THEN BEGIN
                            VendorLedgerEntry."External Document No." := "External Document No.";
                            VendorLedgerEntry.MODIFY;
                          END;

                          //change in table 5601
                          FALedgerEntry.SETRANGE(FALedgerEntry."Document No.","Document No.");
                          IF FALedgerEntry.FINDFIRST THEN BEGIN
                            FALedgerEntry."External Document No." := "External Document No.";
                            FALedgerEntry.MODIFY;
                          END;

                          //change in table 5802
                          ValueEntry.SETRANGE(ValueEntry."Document No.","Document No.");
                          IF ValueEntry.FINDFIRST THEN
                            REPEAT
                              ValueEntry."External Document No." := "External Document No.";
                              ValueEntry.MODIFY;
                            UNTIL ValueEntry.NEXT = 0;
                        END
                        //STOP/BSDP02/015
                    end;
                }
                field("Document Date";"Document Date")
                {
                    Editable = true;

                    trigger OnValidate();
                    begin
                        //START/BSDP02/015
                        IF "Source Code" = 'ZAKUPY' THEN BEGIN
                          //change in table 254
                          "Old Document Date" := xRec."Document Date";
                          MODIFY;

                          //change in table 122
                          PurchInvHeader.SETRANGE(PurchInvHeader."No.","Document No.");
                          IF PurchInvHeader.FINDFIRST THEN BEGIN
                            PurchInvHeader."Old Document Date" := PurchInvHeader."Document Date";
                            PurchInvHeader."Document Date" := "Document Date";
                            PurchInvHeader.MODIFY;
                          END;

                          //change in table 17
                          GLEntry.SETRANGE(GLEntry."Document No.","Document No.");
                          IF GLEntry.FINDSET THEN
                            REPEAT
                              GLEntry."Document Date" := "Document Date";
                              GLEntry.MODIFY;
                            UNTIL GLEntry.NEXT = 0;

                          //change in table 25
                          VendorLedgerEntry.SETRANGE(VendorLedgerEntry."Document No.","Document No.");
                          IF VendorLedgerEntry.FINDFIRST THEN BEGIN
                            VendorLedgerEntry."Document Date" := "Document Date";
                            VendorLedgerEntry.MODIFY;
                          END;

                          //change in table 5601
                          FALedgerEntry.SETRANGE(FALedgerEntry."Document No.","Document No.");
                          IF FALedgerEntry.FINDFIRST THEN BEGIN
                            FALedgerEntry."Document Date" := "Document Date";
                            FALedgerEntry.MODIFY;
                          END;

                          //change in table 5802
                          ValueEntry.SETRANGE(ValueEntry."Document No.","Document No.");
                          IF ValueEntry.FINDFIRST THEN
                            REPEAT
                              ValueEntry."Document Date" := "Document Date";
                              ValueEntry.MODIFY;
                            UNTIL ValueEntry.NEXT = 0;

                        END
                        //STOP/BSDP02/015
                    end;
                }
                field("Document Receipt/Sales Date";"Document Receipt/Sales Date")
                {
                    CaptionML = ENU='Extrenal Document Date',
                                PLK='Data dokumentu zewnętrznego';
                    Editable = true;

                    trigger OnValidate();
                    begin
                        //START/BSDP02/015
                        IF "Source Code" = 'ZAKUPY' THEN BEGIN
                          //change in table 254
                          "Old Document Receipt Date" := xRec."Document Receipt/Sales Date";
                          MODIFY;

                          //change in table 122
                          PurchInvHeader.SETRANGE(PurchInvHeader."No.","Document No.");
                          IF PurchInvHeader.FINDFIRST THEN BEGIN
                            PurchInvHeader."Old Document Receipt Date" := PurchInvHeader."Document Receipt Date";
                            PurchInvHeader."Document Receipt Date" := "Document Receipt/Sales Date";
                            PurchInvHeader.MODIFY;
                          END;

                          //change in table 52063068
                          DetailedVATEntry.SETRANGE(DetailedVATEntry."Document No.","Document No.");
                          IF DetailedVATEntry.FINDFIRST THEN BEGIN
                            DetailedVATEntry."Document Receipt/Sales Date" := "Document Receipt/Sales Date";
                            DetailedVATEntry.MODIFY;
                          END;

                        END
                        //STOP/BSDP02/015
                    end;
                }
                field("Old External Document No.";"Old External Document No.")
                {
                    CaptionML = ENU='Old External Document Nio.',
                                PLK='Poprzedni  numer dokumentu zewnętrznego';
                    Editable = false;
                }
                field("Old Document Date";"Old Document Date")
                {
                }
                field("Old Document Receipt Date";"Old Document Receipt Date")
                {
                    CaptionML = ENU='Old External Document Date',
                                PLK='Poprzednia data dokumentu zewnętrznego';
                    Editable = false;
                }
            }
        }
    }

    actions
    {
    }

    var
        VATEntry : Record "254";
        PurchInvHeader : Record "122";
        GLEntry : Record "17";
        VendorLedgerEntry : Record "25";
        FALedgerEntry : Record "5601";
        DetailedVATEntry : Record "52063068";
        ValueEntry : Record "5802";

    procedure SetValuesDateNo(NewVATEntry : Record "254";OldVATEntry : Record "254");
    begin
    end;
}

Editor is loading...
Leave a Comment