Šis straipsnis taikomas Microsoft Dynamics NAV visose šalyse ir visų kalbų aplinkos.
Požymiai
Kai įvedate reikšmę - Gavėjo adreso kodą pardavimo užsakymo, Microsoft Dynamics NAV 2013, Pašto kodas, miestas ir apskritis reikšmių nėra perduodami iš kortelės pristatymo adresas - Gavėjo pašto kodas laukų, lauko - Gavėjo miestas ir Apskritis-gavėjo pardavimo užsakymo. Ši problema iškyla tik jei jau nurodyta pardavimo užsakymo Pristatymo šalies/regiono kodas reikšmė ir reikšmė skiriasi nuo tos Šalies/regiono kodas naują pristatymo adresą.
Sprendimas
Karštųjų pataisų informacija
Palaikomą naujausią pataisą dabar yra Microsoft. Tačiau jos skirtos tik šiame straipsnyje aprašytai problemai spręsti. Taikyti ją tik sistemoms, kuriose kyla ši konkreti problema. Šios karštosios pataisos gali būti papildomai išbandoma. Todėl, jei jums nelabai trukdo Ši problema, rekomenduojame palaukti kito pakeitimų paketo Microsoft Dynamics NAV 2013 arba kitą versiją Microsoft Dynamics NAV, kuriame bus šios karštosios pataisos.Pastaba. Konkrečiais atvejais už palaikymo skambučius gali būti atšaukti, jei techninės pagalbos specialistas Microsoft Dynamics ir susijusių produktų taikomi įprasti mokesčiai nustato, kad jūsų problemą galima išspręsti naudojant konkretų naujinimą. Į įprastos kainos už palaikymą taikomos papildomos palaikymo klausimams ir problemoms, kurių negalima išspręsti naudojant minėtą naujinimą.
Diegimo informacija
"Microsoft" pateikia programavimo pavyzdžius tik, tačiau nesuteikia jokių aiškių arba numanomų garantijų. Tai apima, bet neapsiribojant, numanomas garantijas dėl perkamumo ir tinkamumo konkrečiam tikslui. Šis straipsnis parašytas galvojant, kad esate susipažinę su pateikta programavimo kalba ir įrankiais, kurie yra naudojami procedūroms kurti ir derinti. "Microsoft" palaikymo inžinieriai gali padėti paaiškindami konkrečios procedūros funkcines galimybes. Tačiau jie nekeis šių pavyzdžių, kad numatytų papildomą funkcinę galimybę arba sukurtų konkrečius jūsų reikalavimus atitinkančias procedūras.Pastaba. Prieš diegdami šias karštąsias pataisas, patikrinkite, kad visi Microsoft Navision klientas vartotojai išsiregistravę sistema. Tai reiškia, kad Microsoft Navision programos paslaugos (NAS) kliento naudotojai. Jums turėtų būti tik kliento vartotojo, kuris yra prisijungęs, kai atliekate šias karštąsias pataisas.Norint pritaikyti šią karštąją pataisą, turite programų kūrėjo licencijos.Rekomenduojame, kad vartotojo abonemento Windows registravimosi lange arba duomenų bazės prisijungimų langas būti priskirta "SUPER" vaidmenį ID. Jei vartotojo abonementas negali būti priskirta "SUPER" ID., turi patikrinti, kad vartotojo abonementas turi šias teises:
-
Keisti teisės objektas, kuris bus pakeisti.
-
Teisės vykdyti sistemos objekto ID 5210 objekto ir sistemos objekto ID 9015 objekto.
Pastaba. Turite turėti teisių į duomenų saugyklų, nebent jūs turite atlikti duomenų atkūrimo.
Pastaba.
Pastaba. Visada bandymas kodas nustato kontroliuojamoje aplinkoje prieš taikydami nustato savo gamybos kompiuteriams.Norėdami išspręsti šią problemą, atlikite šiuos veiksmus:
-
Pakeisti kodą laukuose vietos lentelės (14) taip:Esamas kodas
... 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);...
Pastaba.
... 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);...
-
Keisti kodo laukuose lentelėje (18) taip:Esamas kodas
... { 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),...Pastaba.
... { 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),... -
Keisti kodo laukuose tiekėjo lentelėje (23) taip:Esamas kodas
... { 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] }...Pastaba.
... { 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] }... -
Pakeisti laukų kodą pardavimo antraštės lentelėje (36) taip:Esamas kodas 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;...
Atsarginis kodas 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;...
Esamas kodas 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;...
Atsarginis kodas 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;...
Esamas kodas 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;...
Pakeitimo kodas 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;...
-
Keisti kodo laukuose pirkimo antraštės lentelėje (38) taip:Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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");...
Pakeitimo kodas 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");...
-
Keisti kodo įmonės informacijos lentelės (79) laukuose taip:Esamas kodas
... 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 }...
Pastaba.
... 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 }...
-
Keisti kodo laukuose išteklių lentelėje (156) taip:Esamas kodas
... { 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),...Pastaba.
... { 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),... -
Keisti kodo laukuose darbo lentelės (167) taip:Esamas kodas
... 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...
Pastaba.
... 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...
-
Keisti kodo laukuose-gavėjo adresas lentelėje (222) taip:Esamas kodas
... 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"...
Pastaba.
... 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"...
-
Pakeisti ClearFields funkcija lentelėje pašto indeksą (225):Esamas kodas
... 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. } }...
Pastaba.
... CountryCode := PostCodeRec."Country/Region Code"; County := PostCodeRec.County; END; END; BEGIN END. } }...
-
Keisti kodo laukuose (270) banko sąskaitos lentelėje taip:Esamas kodas
... 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.)));...
Pastaba.
... 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.)));...
-
Keisti kodo laukuose priminimą antraštės lentelėje (295) taip:Esamas kodas
... 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...
Pastaba.
... 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...
-
Keisti kodo laukuose delspinigių pažymos antraštės lentelėje (302) taip:Esamas kodas
... 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...
Pastaba.
... 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...
-
Keisti kodo laukuose Kontakto lentelėje (5050) taip:Esamas kodas
... { 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 }...Pastaba.
... { 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 }... -
Keisti kodo laukuose kontaktą arba adresų lentelėje (5051) taip:Esamas kodas
... 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 }...
Pastaba.
... 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 }...
-
Keisti kodo laukuose darbuotojų lentelėje (5200) taip:Esamas kodas
... { 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...Pastaba.
... { 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... -
Keisti kodo laukuose alternatyva adresų lentelėje (5201) taip:Esamas kodas
... { 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 } }...Pastaba.
... { 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 } }... -
Keisti kodo laukuose (5209) Sąjungos lentelėje taip:Esamas kodas
... { 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 } }...Pastaba.
... { 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 } }... -
Pakeisti kodą laukuose lentelę (5714) taip:Esamas kodas
... 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));...
Pastaba.
... 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));...
-
Keisti kodo laukuose perdavimo antraštės lentelėje (5740) taip:Esamas kodas 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...
Atsarginis kodas 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...
Esamas kodas 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",...
Atsarginis kodas 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",...
-
Pakeisti kodą laukuose aptarnavimo antraščių lentelės (5900) taip:Esamas kodas 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;...
Atsarginis kodas 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;...
Esamas kodas 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...
Atsarginis kodas 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...
Esamas kodas 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;...
Pakeitimo kodas 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;...
-
Keisti kodo laukuose grįžti siuntos antraštės lentelėje (6650) taip:Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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 }...
Pakeitimo kodas 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 }...
-
Keisti kodo laukuose grąžinimo pažymos antraštės lentelėje (6660) taip:Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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);...
Atsarginis kodas 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);...
Esamas kodas 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 }...
Pakeitimo kodas 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 }...
Būtinosios sąlygos
Turite Microsoft Dynamics NAV 2013 norint taikyti šias karštąsias pataisas.
Pašalinimo informacija
Jūs negalite pašalinti šias karštąsias pataisas.
Būsena
„Microsoft“ patvirtino, kad tai yra „Microsoft“ produktų, išvardytų skyriuje „Taikoma“, problema.
Pastaba. Tai yra "GREITAI PUBLIKUOJAMAS" straipsnis, sukurtas tiesiogiai Microsoft palaikymo tarnybos. Čia pateikta informacija yra atsakas į kylančius klausimus. Dėl greito publikavimo medžiagoje gali būti spausdinimo klaidų ir ji gali būti peržiūrima bet kuriuo metu be įspėjimo. Naudojimo ieškokite kitų priežasčių.
