Käesolev artikkel kehtib Microsoft Dynamics nav-i kõik riigid ja kõik language locales.
Sümptomid
Kui sisestate - Aadressi tähis väärtuse müügitellimuse rakenduses Microsoft Dynamics nav-i 2013, Postiindeks, linna ja maakonna väärtused ei edastata Saaja aadress kaardi Saaja postiindeks välja, välja Saaja linn ja - Maakond välja müügitellimuse. See probleem ilmneb ainult siis, kui - Riigi/regiooni kood väärtus on juba määratud müügitellimuse ja selle väärtus erineb uue aadressi Riigi/regiooni kood väärtus.
Lahendus
Kiirparanduse teave
Lasknud välja toetatava käigultparanduse on nüüd Microsoftilt saadaval. Kuid see on ette nähtud ainult selles artiklis kirjeldatud probleemi kõrvaldamiseks. Rakendage seda ainult süsteemides, kus ilmneb see konkreetne probleem. Seda käigultparandust võidakse täiendavalt testida. Seega, kui probleem teie tööd tõsiselt ei kahjusta, soovitame oodata järgmist hoolduspaketti Microsoft Dynamics nav-i 2013 või järgmise Microsoft Dynamics nav-i versiooni, mis sisaldab seda kiirparandust.Märkus. Erijuhtudel kulud, mis tekivad teatud palub tühistada saab kui tehniline toetus Professional Microsoft Dynamics ja nendega seotud toodete leiab, et mõni konkreetne värskendus lahendab teie probleemi. Tavaline tugiteenuste kohaldatakse täiendavat tugiteenust vajavatele küsimustele ning probleemidele, mis pole lahendatavad konkreetse värskenduse installimisega.
Installiteave
Microsoft pakub programmeerimisnäiteid ainult artikli illustreerimiseks ilma igasuguse otsese või kaudse garantiita. See hõlmab, kuid ei piirdu kaudseid garantiisid turustatavuse või kindlaks otstarbeks sobivusega. See artikkel eeldab, et olete demonstreeritava programmeerimiskeelega programmeerimise keel ning luua protseduuride ja silumiseks kasutatavate tööriistadega tuttav. Microsofti tugitehnikud võivad aidata mõne konkreetse protseduuri talitlust selgitada. Siiski ei muuda nad neid näiteid lisafunktsioonide pakkumiseks ega Koosta vastavaid protseduure teie konkreetsetele nõuetele.Märkus. Enne selle kiirparanduse installimist veenduge, et kõik Microsoft Navision kliendi kasutajat sisse loginud süsteem välja. See hõlmab Microsoft Navision Application teenused (NAS) kliendi kasutajatele. Peaks olema ainult kliendi kasutaja on sisse logitud, kui otsustate seda käigultparandust.Selle kiirparanduse rakendamiseks peab teil olema arendaja litsentsi.Soovitame Windowsi sisselogimise aken või aken andmebaasi logimine kasutajakonto määrata "SUPER" rolli ID. Kui "SUPER" rolli ID-d ei saa määratud kasutajakonto, peate veenduma, et kasutaja konto on järgmised õigused:
-
Sa muutuvad objekti Muuda õigusi.
-
Käivita luba süsteemi objekti ID 5210 objekti ja süsteemi objekti ID 9015 objekti.
Märkus. Teil pole õigust andmeid talletab enne, kui olete andmete parandamiseks.
Koodi muudatusi
Märkus. Alati test koodi lahendab kontrollitavas keskkonnas enne rakendamist tootmine arvutite parandused.Selle probleemi lahendamiseks toimige järgmiselt.
-
Muuta koodi väljad tabeli asukoht (14) järgmiselt:Kood
... ValidateTableRelation=No; TestTableRelation=No } { 5715; ;County ;Text30 } { 5718; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 5719; ;Home Page ;Text90 ;ExtendedDatatype=URL }// Delete the following lines. { 5720; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND ("Country/Region Code" <> '') THEN Postcode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 5724; ;Use As In-Transit ;Boolean ;OnValidate=BEGIN IF "Use As In-Transit" THEN BEGIN TESTFIELD("Require Put-away",FALSE); TESTFIELD("Require Pick",FALSE); TESTFIELD("Use Cross-Docking",FALSE);...
Eemaldamise teave
... ValidateTableRelation=No; TestTableRelation=No } { 5715; ;County ;Text30 } { 5718; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 5719; ;Home Page ;Text90 ;ExtendedDatatype=URL }// Add the following line. { 5720; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 5724; ;Use As In-Transit ;Boolean ;OnValidate=BEGIN IF "Use As In-Transit" THEN BEGIN TESTFIELD("Require Put-away",FALSE); TESTFIELD("Require Pick",FALSE); TESTFIELD("Use Cross-Docking",FALSE);...
-
Muuta koodi väljad tabeli Klient (18) järgmiselt:Kood
... { 32 ; ;Place of Export ;Code20 } { 33 ; ;Invoice Disc. Code ;Code20 ;TableRelation=Customer; ValidateTableRelation=No; TestTableRelation=No } { 34 ; ;Customer Disc. Group;Code20 ;TableRelation="Customer Discount Group" }// Delete the following lines. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 36 ; ;Collection Method ;Code20 } { 37 ; ;Amount ;Decimal ;AutoFormatType=1; AutoFormatExpr="Currency Code" } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Customer),...Eemaldamise teave
... { 32 ; ;Place of Export ;Code20 } { 33 ; ;Invoice Disc. Code ;Code20 ;TableRelation=Customer; ValidateTableRelation=No; TestTableRelation=No } { 34 ; ;Customer Disc. Group;Code20 ;TableRelation="Customer Discount Group" }// Add the following line. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 36 ; ;Collection Method ;Code20 } { 37 ; ;Amount ;Decimal ;AutoFormatType=1; AutoFormatExpr="Currency Code" } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Customer),... -
Muuta koodi väljad tabeli hankija (23) järgmiselt:Kood
... { 30 ; ;Shipment Method Code;Code10 ;TableRelation="Shipment Method" } { 31 ; ;Shipping Agent Code ;Code10 ;TableRelation="Shipping Agent" } { 33 ; ;Invoice Disc. Code ;Code20 ;TableRelation=Vendor; ValidateTableRelation=No; TestTableRelation=No }// Delete the following lines. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Vendor), No.=FIELD(No.))); Editable=No } { 39 ; ;Blocked ;Option ;OptionString=[ ,Payment,All] }...Eemaldamise teave
... { 30 ; ;Shipment Method Code;Code10 ;TableRelation="Shipment Method" } { 31 ; ;Shipping Agent Code ;Code10 ;TableRelation="Shipping Agent" } { 33 ; ;Invoice Disc. Code ;Code20 ;TableRelation=Vendor; ValidateTableRelation=No; TestTableRelation=No }// Add the following line. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Vendor), No.=FIELD(No.))); Editable=No } { 39 ; ;Blocked ;Option ;OptionString=[ ,Payment,All] }... -
Muuta koodi väljad tabeli Müügi päis (36) järgmiselt:Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Delete the following lines. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Bill-to Country/Region Code" <> xRec."Bill-to Country/Region Code") AND (xRec."Bill-to Country/Region Code" <> '') THEN PostCode.ClearFields("Bill-to City","Bill-to Post Code","Bill-to County"); END; }// End of the lines. { 88 ; ;Sell-to Post Code ;Code20 ;TableRelation="Post Code"; OnValidate=BEGIN PostCode.ValidatePostCode( "Sell-to City","Sell-to Post Code","Sell-to County","Sell-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Add the following line. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 88 ; ;Sell-to Post Code ;Code20 ;TableRelation="Post Code"; OnValidate=BEGIN PostCode.ValidatePostCode( "Sell-to City","Sell-to Post Code","Sell-to County","Sell-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Sell-to County ;Text30 }// Delete the following lines. { 90 ; ;Sell-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Sell-to Country/Region Code" <> xRec."Sell-to Country/Region Code") AND (xRec."Sell-to Country/Region Code" <> '') THEN PostCode.ClearFields("Sell-to City","Sell-to Post Code","Sell-to County"); END; }// End of the lines. { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation="Post Code"; OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Asendamine kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Sell-to County ;Text30 }// Add the following line. { 90 ; ;Sell-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation="Post Code"; OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Delete the following lines. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County"); END; }// End of the lines. { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 97 ; ;Exit Point ;Code10 ;TableRelation="Entry/Exit Point"; OnValidate=BEGIN UpdateSalesLines(FIELDCAPTION("Exit Point"),FALSE); END;...
Asendamine kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Add the following line. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 97 ; ;Exit Point ;Code10 ;TableRelation="Entry/Exit Point"; OnValidate=BEGIN UpdateSalesLines(FIELDCAPTION("Exit Point"),FALSE); END;...
-
Muuta koodi väljad tabeli Ostu päis (38) järgmiselt:Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Pay-to County ;Text30 }// Delete the following lines. { 87 ; ;Pay-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Pay-to Country/Region Code" <> xRec."Pay-to Country/Region Code") AND (xRec."Pay-to Country/Region Code" <> '') THEN PostCode.ClearFields("Pay-to City","Pay-to Post Code","Pay-to County"); END; }// End of the lines. { 88 ; ;Buy-from Post Code ;Code20 ;TableRelation=IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Buy-from City","Buy-from Post Code","Buy-from County","Buy-from Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Pay-to County ;Text30 }// Add the following line. { 87 ; ;Pay-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 88 ; ;Buy-from Post Code ;Code20 ;TableRelation=IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Buy-from City","Buy-from Post Code","Buy-from County","Buy-from Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Buy-from County ;Text30 }// Delete the following lines. { 90 ; ;Buy-from Country/Region Code;Code10;TableRelation=Country/Region; OnValidate=BEGIN IF ("Buy-from Country/Region Code" <> xRec."Buy-from Country/Region Code") AND (xRec."Buy-from Country/Region Code" <> '') THEN PostCode.ClearFields("Buy-from City","Buy-from Post Code","Buy-from County"); END; }// End of the lines. { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Asendamine kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Buy-from County ;Text30 }// Add the following line. { 90 ; ;Buy-from Country/Region Code;Code10;TableRelation=Country/Region } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Delete the following lines. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County"); END; }// End of the lines. { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 95 ; ;Order Address Code ;Code10 ;TableRelation="Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)); OnValidate=BEGIN IF "Order Address Code" <> '' THEN BEGIN OrderAddr.GET("Buy-from Vendor No.","Order Address Code");...
Asendamine kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Add the following line. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 95 ; ;Order Address Code ;Code10 ;TableRelation="Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)); OnValidate=BEGIN IF "Order Address Code" <> '' THEN BEGIN OrderAddr.GET("Buy-from Vendor No.","Order Address Code");...
-
Muuta koodi väljad tabeli ettevõtte andmed (79) järgmiselt:Kood
... ValidateTableRelation=No; TestTableRelation=No } { 33 ; ;Ship-to County ;Text30 } { 34 ; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 35 ; ;Home Page ;Text80 ;ExtendedDatatype=URL }// Delete the following lines. { 36 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; } { 37 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County"); END; }// End of the lines. { 38 ; ;IBAN ;Code50 ;OnValidate=BEGIN CheckIBAN(IBAN); END; } { 39 ; ;SWIFT Code ;Code20 }...
Eemaldamise teave
... ValidateTableRelation=No; TestTableRelation=No } { 33 ; ;Ship-to County ;Text30 } { 34 ; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 35 ; ;Home Page ;Text80 ;ExtendedDatatype=URL }// Add the following lines. { 36 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 37 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region }// End of the lines. { 38 ; ;IBAN ;Code50 ;OnValidate=BEGIN CheckIBAN(IBAN); END; } { 39 ; ;SWIFT Code ;Code20 }...
-
Muuta koodi väljad tabeli Ressurss (156) järgmiselt:Kood
... { 55 ; ;Automatic Ext. Texts;Boolean } { 56 ; ;No. Series ;Code10 ;TableRelation="No. Series"; Editable=No } { 57 ; ;Tax Group Code ;Code10 ;TableRelation="Tax Group" } { 58 ; ;VAT Prod. Posting Group;Code10 ;TableRelation="VAT Product Posting Group" }// Delete the following lines. { 59 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 60 ; ;IC Partner Purch. G/L Acc. No.;Code20; TableRelation="IC G/L Account" } { 900 ; ;Qty. on Assembly Order;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Assembly Line"."Remaining Quantity (Base)" WHERE (Document Type=CONST(Order), Type=CONST(Resource),...Eemaldamise teave
... { 55 ; ;Automatic Ext. Texts;Boolean } { 56 ; ;No. Series ;Code10 ;TableRelation="No. Series"; Editable=No } { 57 ; ;Tax Group Code ;Code10 ;TableRelation="Tax Group" } { 58 ; ;VAT Prod. Posting Group;Code10 ;TableRelation="VAT Product Posting Group" }// Add the following line. { 59 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 60 ; ;IC Partner Purch. G/L Acc. No.;Code20; TableRelation="IC G/L Account" } { 900 ; ;Qty. on Assembly Order;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Assembly Line"."Remaining Quantity (Base)" WHERE (Document Type=CONST(Order), Type=CONST(Resource),... -
Töö tabelis (167) koodi muuta järgmiselt:Kood
... ValidateTableRelation=No; TestTableRelation=No } { 66 ; ;No. Series ;Code10 ;TableRelation="No. Series"; Editable=No } { 67 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region;// Delete the following lines. OnValidate=BEGIN IF ("Bill-to Country/Region Code" <> xRec."Bill-to Country/Region Code") AND (xRec."Bill-to Country/Region Code" <> '') THEN PostCode.ClearFields("Bill-to City","Bill-to Post Code","Bill-to County"); END;// End of the lines. Editable=Yes } { 68 ; ;Bill-to Name 2 ;Text50 } { 117 ; ;Reserve ;Option ;OptionString=Never,Optional,Always } { 1000; ;WIP Method ;Code20 ;TableRelation="Job WIP Method".Code WHERE (Valid=CONST(Yes)); OnValidate=VAR...
Eemaldamise teave
... ValidateTableRelation=No; TestTableRelation=No } { 66 ; ;No. Series ;Code10 ;TableRelation="No. Series"; Editable=No } { 67 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region; Editable=Yes } { 68 ; ;Bill-to Name 2 ;Text50 } { 117 ; ;Reserve ;Option ;OptionString=Never,Optional,Always } { 1000; ;WIP Method ;Code20 ;TableRelation="Job WIP Method".Code WHERE (Valid=CONST(Yes)); OnValidate=VAR...
-
Muuta koodi väljad tabeli saaja aadress (222) järgmiselt:Kood
... IF "Shipping Agent Code" <> xRec."Shipping Agent Code" THEN VALIDATE("Shipping Agent Service Code",''); END; } { 32 ; ;Place of Export ;Code20 }// Delete the following lines. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 54 ; ;Last Date Modified ;Date ;Editable=No } { 83 ; ;Location Code ;Code10 ;TableRelation=Location WHERE (Use As In-Transit=CONST(No)) } { 84 ; ;Fax No. ;Text30 } { 85 ; ;Telex Answer Back ;Text20 } { 91 ; ;Post Code ;Code20 ;TableRelation=IF (Country/Region Code=CONST()) "Post Code"...
Eemaldamise teave
... IF "Shipping Agent Code" <> xRec."Shipping Agent Code" THEN VALIDATE("Shipping Agent Service Code",''); END; } { 32 ; ;Place of Export ;Code20 }// Add the following line. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 54 ; ;Last Date Modified ;Date ;Editable=No } { 83 ; ;Location Code ;Code10 ;TableRelation=Location WHERE (Use As In-Transit=CONST(No)) } { 84 ; ;Fax No. ;Text30 } { 85 ; ;Telex Answer Back ;Text20 } { 91 ; ;Post Code ;Code20 ;TableRelation=IF (Country/Region Code=CONST()) "Post Code"...
-
Muuta koodi ClearFields funktsiooni tabelis postiindeks (225) järgmiselt:Kood
... CountryCode := PostCodeRec."Country/Region Code"; County := PostCodeRec.County; END; END;// Delete the following lines. PROCEDURE ClearFields@1(VAR City@1000 : Text[30];VAR PostCode@1001 : Code[20];VAR County@1002 : Text[30]); BEGIN City := ''; PostCode := ''; County := ''; END;// End of the lines. BEGIN END. } }...
Eemaldamise teave
... CountryCode := PostCodeRec."Country/Region Code"; County := PostCodeRec.County; END; END; BEGIN END. } }...
-
Muuta koodi väljad tabeli Pangakonto (270) järgmiselt:Kood
... END; } { 24 ; ;Language Code ;Code10 ;TableRelation=Language } { 26 ; ;Statistics Group ;Integer } { 29 ; ;Our Contact Code ;Code10 ;TableRelation=Salesperson/Purchaser }// Delete the following lines. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 37 ; ;Amount ;Decimal ;AutoFormatType=1; AutoFormatExpr="Currency Code" } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Bank Account), No.=FIELD(No.)));...
Eemaldamise teave
... END; } { 24 ; ;Language Code ;Code10 ;TableRelation=Language } { 26 ; ;Statistics Group ;Integer } { 29 ; ;Our Contact Code ;Code10 ;TableRelation=Salesperson/Purchaser }// Add the following line. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 37 ; ;Amount ;Decimal ;AutoFormatType=1; AutoFormatExpr="Currency Code" } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Comment Line" WHERE (Table Name=CONST(Bank Account), No.=FIELD(No.)));...
-
Muuta koodi väljad tabeli meeldetuletuse päis (295) järgmiselt:Kood
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Delete the following line. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 11 ; ;Language Code ;Code10 ;TableRelation=Language } { 12 ; ;Currency Code ;Code10 ;TableRelation=Currency; OnValidate=BEGIN IF CurrFieldNo = FIELDNO("Currency Code") THEN IF Undo THEN BEGIN...
Eemaldamise teave
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Add the following line. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 11 ; ;Language Code ;Code10 ;TableRelation=Language } { 12 ; ;Currency Code ;Code10 ;TableRelation=Currency; OnValidate=BEGIN IF CurrFieldNo = FIELDNO("Currency Code") THEN IF Undo THEN BEGIN...
-
Muuta koodi väljad viivisarve päise tabelis (302) järgmiselt:Kood
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Delete the folloiwng lines. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '')THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 11 ; ;Language Code ;Code10 ;TableRelation=Language } { 12 ; ;Currency Code ;Code10 ;TableRelation=Currency; OnValidate=BEGIN IF CurrFieldNo = FIELDNO("Currency Code") THEN IF Undo THEN BEGIN...
Eemaldamise teave
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Add the following line. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 11 ; ;Language Code ;Code10 ;TableRelation=Language } { 12 ; ;Currency Code ;Code10 ;TableRelation=Currency; OnValidate=BEGIN IF CurrFieldNo = FIELDNO("Currency Code") THEN IF Undo THEN BEGIN...
-
Muuta koodi väljad tabeli Kontakt (5050) järgmiselt:Kood
... { 10 ; ;Telex No. ;Text20 } { 15 ; ;Territory Code ;Code10 ;TableRelation=Territory } { 22 ; ;Currency Code ;Code10 ;TableRelation=Currency } { 24 ; ;Language Code ;Code10 ;TableRelation=Language } { 29 ; ;Salesperson Code ;Code10 ;TableRelation=Salesperson/Purchaser }// Delete the following lines. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Rlshp. Mgt. Comment Line" WHERE (Table Name=CONST(Contact), No.=FIELD(No.), Sub No.=CONST(0))); Editable=No }...Eemaldamise teave
... { 10 ; ;Telex No. ;Text20 } { 15 ; ;Territory Code ;Code10 ;TableRelation=Territory } { 22 ; ;Currency Code ;Code10 ;TableRelation=Currency } { 24 ; ;Language Code ;Code10 ;TableRelation=Language } { 29 ; ;Salesperson Code ;Code10 ;TableRelation=Salesperson/Purchaser }// Add the following line. { 35 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 38 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Rlshp. Mgt. Comment Line" WHERE (Table Name=CONST(Contact), No.=FIELD(No.), Sub No.=CONST(0))); Editable=No }... -
Kontakti lisa-aadressi tabeli (5051) koodi muuta järgmiselt:Kood
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Delete the following lines. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 12 ; ;Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 13 ; ;Telex No. ;Text20 } { 14 ; ;Extension No. ;Text30 } { 15 ; ;Mobile Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 16 ; ;Pager ;Text30 }...
Eemaldamise teave
... END; ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;County ;Text30 }// Add the following line. { 10 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 12 ; ;Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 13 ; ;Telex No. ;Text20 } { 14 ; ;Extension No. ;Text30 } { 15 ; ;Mobile Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 16 ; ;Pager ;Text30 }...
-
Muuta koodi väljad tabeli töötaja (5200) järgmiselt:Kood
... { 20 ; ;Birth Date ;Date } { 21 ; ;Social Security No. ;Text30 } { 22 ; ;Union Code ;Code10 ;TableRelation=Union } { 23 ; ;Union Membership No.;Text30 } { 24 ; ;Gender ;Option ;OptionString=[ ,Female,Male] }// Delete the following lines. { 25 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 26 ; ;Manager No. ;Code20 ;TableRelation=Employee } { 27 ; ;Emplymt. Contract Code;Code10 ;TableRelation="Employment Contract" } { 28 ; ;Statistics Group Code;Code10 ;TableRelation="Employee Statistics Group" } { 29 ; ;Employment Date ;Date } { 31 ; ;Status ;Option ;OnValidate=BEGIN...Eemaldamise teave
... { 20 ; ;Birth Date ;Date } { 21 ; ;Social Security No. ;Text30 } { 22 ; ;Union Code ;Code10 ;TableRelation=Union } { 23 ; ;Union Membership No.;Text30 } { 24 ; ;Gender ;Option ;OptionString=[ ,Female,Male] }// Add the following line. { 25 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 26 ; ;Manager No. ;Code20 ;TableRelation=Employee } { 27 ; ;Emplymt. Contract Code;Code10 ;TableRelation="Employment Contract" } { 28 ; ;Statistics Group Code;Code10 ;TableRelation="Employee Statistics Group" } { 29 ; ;Employment Date ;Date } { 31 ; ;Status ;Option ;OnValidate=BEGIN... -
Alternatiivse aadressi tabeli (5201) koodi muuta järgmiselt:Kood
... { 13 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Human Resource Comment Line" WHERE (Table Name=CONST(Alternative Address), No.=FIELD(Employee No.), Alternative Address Code=FIELD(Code))); Editable=No }// Delete the following lines. { 14 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. } KEYS { { ;Employee No.,Code ;Clustered=Yes } }...Eemaldamise teave
... { 13 ; ;Comment ;Boolean ;FieldClass=FlowField; CalcFormula=Exist("Human Resource Comment Line" WHERE (Table Name=CONST(Alternative Address), No.=FIELD(Employee No.), Alternative Address Code=FIELD(Code))); Editable=No }// Add the following line. { 14 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } } KEYS { { ;Employee No.,Code ;Clustered=Yes } }... -
Muuta koodi väljad tabeli Liidu (5209) järgmiselt:Kood
... { 9 ; ;Address 2 ;Text50 } { 10 ; ;County ;Text30 } { 11 ; ;Fax No. ;Text30 } { 12 ; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 13 ; ;Home Page ;Text80 ;ExtendedDatatype=URL }// Delete the following lines. { 14 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. } KEYS { { ;Code ;Clustered=Yes } }...Eemaldamise teave
... { 9 ; ;Address 2 ;Text50 } { 10 ; ;County ;Text30 } { 11 ; ;Fax No. ;Text30 } { 12 ; ;E-Mail ;Text80 ;ExtendedDatatype=E-Mail } { 13 ; ;Home Page ;Text80 ;ExtendedDatatype=URL }// Add the following line. { 14 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } } KEYS { { ;Code ;Clustered=Yes } }... -
Muuta koodi väljad tabeli vastutuse Center (5714) järgmiselt:Kood
... PostCode.ValidatePostCode(City,"Post Code",County,"Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END; ValidateTableRelation=No; TestTableRelation=No }// Delete the folloiwng lines. { 7 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County); END; }// End of the lines. { 8 ; ;Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 9 ; ;Fax No. ;Text30 } { 10 ; ;Name 2 ;Text50 } { 11 ; ;Contact ;Text50 } { 12 ; ;Global Dimension 1 Code;Code20 ;TableRelation="Dimension Value".Code WHERE (Global Dimension No.=CONST(1));...
Eemaldamise teave
... PostCode.ValidatePostCode(City,"Post Code",County,"Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END; ValidateTableRelation=No; TestTableRelation=No }// Add the following line. { 7 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region } { 8 ; ;Phone No. ;Text30 ;ExtendedDatatype=Phone No. } { 9 ; ;Fax No. ;Text30 } { 10 ; ;Name 2 ;Text50 } { 11 ; ;Contact ;Text50 } { 12 ; ;Global Dimension 1 Code;Code20 ;TableRelation="Dimension Value".Code WHERE (Global Dimension No.=CONST(1));...
-
Muuta koodi väljad tabeli Üleviimise päis (5740) järgmiselt:Kood 1
... ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;Transfer-from County;Text30 } { 10 ; ;Trsf.-from Country/Region Code;Code10;// Delete the following lines. TableRelation=Country/Region; OnValidate=BEGIN IF ("Trsf.-from Country/Region Code" <> xRec."Trsf.-from Country/Region Code") AND (xRec."Trsf.-from Country/Region Code" <> '') THEN PostCode.ClearFields("Transfer-from City","Transfer-from Post Code","Transfer-from County"); END; }// End of the lines. { 11 ; ;Transfer-to Code ;Code10 ;TableRelation=Location WHERE (Use As In-Transit=CONST(No)); OnValidate=VAR Location@1000 : Record 14; Confirmed@1001 : Boolean; BEGIN...
Kood 1
... ValidateTableRelation=No; TestTableRelation=No } { 9 ; ;Transfer-from County;Text30 } { 10 ; ;Trsf.-from Country/Region Code;Code10;// Add the folloiwng line. TableRelation=Country/Region } { 11 ; ;Transfer-to Code ;Code10 ;TableRelation=Location WHERE (Use As In-Transit=CONST(No)); OnValidate=VAR Location@1000 : Record 14; Confirmed@1001 : Boolean; BEGIN...
Kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 18 ; ;Transfer-to County ;Text30 }// Delete the following lines. { 19 ; ;Trsf.-to Country/Region Code;Code10;TableRelation=Country/Region; OnValidate=BEGIN IF ("Trsf.-to Country/Region Code" <> xRec."Trsf.-to Country/Region Code") AND (xRec."Trsf.-to Country/Region Code" <> '') THEN PostCode.ClearFields("Transfer-to City","Transfer-to Post Code","Transfer-to County"); END; }// End of the lines. { 20 ; ;Posting Date ;Date } { 21 ; ;Shipment Date ;Date ;OnValidate=BEGIN TestStatusOpen; TransferRoute.CalcReceiptDate( "Shipment Date",...
Asendamine kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 18 ; ;Transfer-to County ;Text30 }// Add the following line. { 19 ; ;Trsf.-to Country/Region Code;Code10;TableRelation=Country/Region } { 20 ; ;Posting Date ;Date } { 21 ; ;Shipment Date ;Date ;OnValidate=BEGIN TestStatusOpen; TransferRoute.CalcReceiptDate( "Shipment Date",...
-
Muuta koodi väljad tabeli teenuse päis (5900) järgmiselt:Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Delete the following lines. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Bill-to Country/Region Code" <> xRec."Bill-to Country/Region Code") AND (xRec."Bill-to Country/Region Code" <> '') THEN PostCode.ClearFields("Bill-to City","Bill-to Post Code","Bill-to County"); END; }// End of the lines. { 88 ; ;Post Code ;Code20 ;TableRelation=IF (Country/Region Code=CONST()) "Post Code" ELSE IF (Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode(City,"Post Code",County,"Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Add the following line. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 88 ; ;Post Code ;Code20 ;TableRelation=IF (Country/Region Code=CONST()) "Post Code" ELSE IF (Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode(City,"Post Code",County,"Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED); END;...
Kood 2
... TestTableRelation=No } { 89 ; ;County ;Text30 } { 90 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN VALIDATE("Ship-to Country/Region Code");// Delete the following lines. IF ("Country/Region Code" <> xRec."Country/Region Code") AND (xRec."Country/Region Code" <> '') THEN PostCode.ClearFields(City,"Post Code",County);// End of the lines. END; } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN...
Asendamine kood 2
... TestTableRelation=No } { 89 ; ;County ;Text30 } { 90 ; ;Country/Region Code ;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN VALIDATE("Ship-to Country/Region Code"); END; } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN...
Kood 3
... ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 } { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN// Delete the following lines. IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County");// End of the lines. IF "Ship-to Country/Region Code" <> '' THEN "VAT Country/Region Code" := "Ship-to Country/Region Code" ELSE "VAT Country/Region Code" := "Country/Region Code" END;...
Asendamine kood 3
... ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 } { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF "Ship-to Country/Region Code" <> '' THEN "VAT Country/Region Code" := "Ship-to Country/Region Code" ELSE "VAT Country/Region Code" := "Country/Region Code" END;...
-
Muuta koodi väljad tabeli tagasi sisuga (6650) järgmiselt:Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Pay-to County ;Text30 }// Delete the following lines. { 87 ; ;Pay-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Pay-to Country/Region Code" <> xRec."Pay-to Country/Region Code") AND (xRec."Pay-to Country/Region Code" <> '') THEN PostCode.ClearFields("Pay-to City","Pay-to Post Code","Pay-to County"); END; }// End of the lines. { 88 ; ;Buy-from Post Code ;Code20 ;TableRelation=IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Buy-from City","Buy-from Post Code","Buy-from County","Buy-from Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Pay-to County ;Text30 }// Add the following line. { 87 ; ;Pay-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 88 ; ;Buy-from Post Code ;Code20 ;TableRelation=IF (Buy-from Country/Region Code=CONST()) "Post Code" ELSE IF (Buy-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Buy-from Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Buy-from City","Buy-from Post Code","Buy-from County","Buy-from Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Buy-from County ;Text30 }// Delete the following lines. { 90 ; ;Buy-from Country/Region Code;Code10;TableRelation=Country/Region; OnValidate=BEGIN IF ("Buy-from Country/Region Code" <> xRec."Buy-from Country/Region Code") AND (xRec."Buy-from Country/Region Code" <> '') THEN PostCode.ClearFields("Buy-from City","Buy-from Post Code","Buy-from County"); END; }// End of the lines. { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Asendamine kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Buy-from County ;Text30 }// Add the following line. { 90 ; ;Buy-from Country/Region Code;Code10;TableRelation=Country/Region } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Delete the following lines. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County"); END; }// End of the lines. { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 95 ; ;Order Address Code ;Code10 ;TableRelation="Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)) } { 97 ; ;Entry Point ;Code10 ;TableRelation="Entry/Exit Point" } { 98 ; ;Correction ;Boolean } { 99 ; ;Document Date ;Date }...
Asendamine kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Add the following line. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 95 ; ;Order Address Code ;Code10 ;TableRelation="Order Address".Code WHERE (Vendor No.=FIELD(Buy-from Vendor No.)) } { 97 ; ;Entry Point ;Code10 ;TableRelation="Entry/Exit Point" } { 98 ; ;Correction ;Boolean } { 99 ; ;Document Date ;Date }...
-
Tagasi päise tabelis (6660) koodi muutmiseks järgmiselt:Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Delete the following lines. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Bill-to Country/Region Code" <> xRec."Bill-to Country/Region Code") AND (xRec."Bill-to Country/Region Code" <> '') THEN PostCode.ClearFields("Bill-to City","Bill-to Post Code","Bill-to County"); END; }// End of the lines. { 88 ; ;Sell-to Post Code ;Code20 ;TableRelation=IF (Sell-to Country/Region Code=CONST()) "Post Code" ELSE IF (Sell-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Sell-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Sell-to City","Sell-to Post Code","Sell-to County","Sell-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 1
... END; ValidateTableRelation=No; TestTableRelation=No } { 86 ; ;Bill-to County ;Text30 }// Add the following line. { 87 ; ;Bill-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 88 ; ;Sell-to Post Code ;Code20 ;TableRelation=IF (Sell-to Country/Region Code=CONST()) "Post Code" ELSE IF (Sell-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Sell-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Sell-to City","Sell-to Post Code","Sell-to County","Sell-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Sell-to County ;Text30 }// Delete the following lines. { 90 ; ;Sell-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Sell-to Country/Region Code" <> xRec."Sell-to Country/Region Code") AND (xRec."Sell-to Country/Region Code" <> '') THEN PostCode.ClearFields("Sell-to City","Sell-to Post Code","Sell-to County"); END; }// End of the lines. { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Asendamine kood 2
... END; ValidateTableRelation=No; TestTableRelation=No } { 89 ; ;Sell-to County ;Text30 }// Add the following line. { 90 ; ;Sell-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 91 ; ;Ship-to Post Code ;Code20 ;TableRelation=IF (Ship-to Country/Region Code=CONST()) "Post Code" ELSE IF (Ship-to Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Ship-to Country/Region Code)); OnValidate=BEGIN PostCode.ValidatePostCode( "Ship-to City","Ship-to Post Code","Ship-to County","Ship-to Country/Region Code",(CurrFieldNo <> 0) AND GUIALLOWED);...
Kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Delete the following lines. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region; OnValidate=BEGIN IF ("Ship-to Country/Region Code" <> xRec."Ship-to Country/Region Code") AND (xRec."Ship-to Country/Region Code" <> '') THEN PostCode.ClearFields("Ship-to City","Ship-to Post Code","Ship-to County"); END; }// End of the lines. { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 97 ; ;Exit Point ;Code10 ;TableRelation="Entry/Exit Point" } { 98 ; ;Correction ;Boolean } { 99 ; ;Document Date ;Date } { 100 ; ;External Document No.;Code35 }...
Asendamine kood 3
... END; ValidateTableRelation=No; TestTableRelation=No } { 92 ; ;Ship-to County ;Text30 }// Add the following line. { 93 ; ;Ship-to Country/Region Code;Code10 ;TableRelation=Country/Region } { 94 ; ;Bal. Account Type ;Option ;OptionString=G/L Account,Bank Account } { 97 ; ;Exit Point ;Code10 ;TableRelation="Entry/Exit Point" } { 98 ; ;Correction ;Boolean } { 99 ; ;Document Date ;Date } { 100 ; ;External Document No.;Code35 }...
Eeltingimused
Microsoft Dynamics NAV 2013 selle kiirparanduse rakendamiseks peab teil olema.
Eemaldamise teave
See käigultparandus ei saa eemaldada.
Olek
Microsoft on kinnitanud, et see probleem esineb jaotises "Kehtib järgmiste toodete kohta" loetletud Microsofti toodetel.
Märkus. See on "Kiire avaldamise" artikli loonud otse Microsofti tugiteenuse pakkujalt. Siintoodud teave on esitatud lähtudes-olemasoleval kujul vastusena ilmnenud probleemidele. Kiire avaldamise materjalides esineda trükivigu ja võidakse muuta ette teatamata. Vaadake Kasutustingimused muid kaalutlusi.
