Inkonsekvente data mellom serviceposter og finans når du endrer en kontrakt-fakturaen før bokføring i Microsoft Dynamics NAV 2009

Informasjon om hurtigreparasjon

En støttet hurtigreparasjon er nå tilgjengelig fra Microsoft. Det er imidlertid bare ment å løse problemet som er beskrevet i denne artikkelen. Bruk den bare på systemer som har dette bestemte problemet. Denne hurtigreparasjonen kan gjennomgå ytterligere testing. Hvis du ikke er alvorlig påvirket av dette problemet, anbefaler vi derfor at du venter på neste oppdateringspakke for Microsoft Dynamics NAV 2009 eller den neste versjonen av Microsoft Dynamics NAV som inneholder denne hurtigreparasjonen.

Obs! I spesielle tilfeller avgifter som vanligvis påløper for støtte samtaler kan avbrytes hvis en kundestøttemedarbeider for Microsoft Dynamics og beslektede produkter avgjør at en bestemt oppdatering løser problemet. Vanlige kundestøttekostnader gjelder for ytterligere kundestøttespørsmål og problemer som ikke dekkes av den gjeldende oppdateringen.

Kodeendringer

Obs! Alltid løser teste koden i et kontrollert miljø før du installerer hurtigreparasjoner til produksjonsdatamaskiner for.
Hvis du vil løse dette problemet, gjør du følgende:

1. Endre koden i tabellen Dokumentdimensjon (357) som følger:
   Eksisterende kode 1

   ...      Text005@1009 : TextConst 'ENU=Canceled.';
         Text006@1010 : TextConst 'ENU=You may have changed a dimension. Some lines are already shipped. When you post the line with the changed dimension to the general ledger, amounts on the Inventory Interim account will be out of balance when reported per dimension.\\Do you want to update the lines?';
   
       PROCEDURE UpdateGlobalDimCode@25(GlobalDimCodeNo@1000 : Integer;"Table ID"@1001 : Integer;"Document Type"@1002 : Option;"Document No."@1003 : Code[20];"Line No."@1004 : Integer;NewDimValue@1005 : Code[20]);
   ...
   
   

   Ny kode 1

   ...      Text005@1009 : TextConst 'ENU=Canceled.';
         Text006@1010 : TextConst 'ENU=You may have changed a dimension. Some lines are already shipped. When you post the line with the changed dimension to the general ledger, amounts on the Inventory Interim account will be out of balance when reported per dimension.\\Do you want to update the lines?';
         Text007@1011 : TextConst 'ENU=You cannot change the dimension because the document is based on a service contract.';
   
       PROCEDURE UpdateGlobalDimCode@25(GlobalDimCodeNo@1000 : Integer;"Table ID"@1001 : Integer;"Document Type"@1002 : Option;"Document No."@1003 : Code[20];"Line No."@1004 : Integer;NewDimValue@1005 : Code[20]);
   ...
   
   

   Eksisterende kode 2

   ...    PROCEDURE VerifyLineDim@5(VAR DocDim@1000 : Record 357);
       VAR
         SalesLine@1001 : Record 37;
         PurchaseLine@1002 : Record 39;
       BEGIN
         CASE "Table ID" OF
           DATABASE::"Sales Line":
             BEGIN
               IF SalesLine.GET(DocDim."Document Type",DocDim."Document No.",DocDim."Line No.") THEN
                 IF (SalesLine."Qty. Shipped Not Invoiced" <> 0) OR (SalesLine."Return Rcd. Not Invd." <> 0) THEN
                   IF NOT CONFIRM(Text004,TRUE,SalesLine.TABLECAPTION) THEN
                     ERROR(Text005)
             END;
           DATABASE::"Purchase Line":
             BEGIN
               IF PurchaseLine.GET(DocDim."Document Type",DocDim."Document No.",DocDim."Line No.") THEN
                 IF (PurchaseLine."Qty. Rcd. Not Invoiced" <> 0) OR (PurchaseLine."Return Qty. Shipped Not Invd." <> 0) THEN
   
                   IF NOT CONFIRM(Text004,TRUE,PurchaseLine.TABLECAPTION) THEN
                     ERROR(Text005)
             END;
         END;
       END;
   ...
   
   

   Ny kode 2

   ...    PROCEDURE VerifyLineDim@5(VAR DocDim@1000 : Record 357);
       VAR
         SalesLine@1001 : Record 37;
         PurchaseLine@1002 : Record 39;
         ServiceHeader@1003 : Record 5900;
         ServiceLine@1004 : Record 5902;
       BEGIN
         CASE "Table ID" OF
           DATABASE::"Sales Line":
             BEGIN
               IF SalesLine.GET(DocDim."Document Type",DocDim."Document No.",DocDim."Line No.") THEN
                 IF (SalesLine."Qty. Shipped Not Invoiced" <> 0) OR (SalesLine."Return Rcd. Not Invd." <> 0) THEN
                   IF NOT CONFIRM(Text004,TRUE,SalesLine.TABLECAPTION) THEN
                     ERROR(Text005)
             END;
           DATABASE::"Purchase Line":
             BEGIN
               IF PurchaseLine.GET(DocDim."Document Type",DocDim."Document No.",DocDim."Line No.") THEN
                 IF (PurchaseLine."Qty. Rcd. Not Invoiced" <> 0) OR (PurchaseLine."Return Qty. Shipped Not Invd." <> 0) THEN
   
                   IF NOT CONFIRM(Text004,TRUE,PurchaseLine.TABLECAPTION) THEN
                     ERROR(Text005)
             END;
           DATABASE::"Service Header":
             IF ServiceHeader.GET(DocDim."Document Type",DocDim."Document No.") AND (ServiceHeader."Contract No." <> '') THEN
               ERROR(Text007);
           DATABASE::"Service Line":
             IF ServiceLine.GET(DocDim."Document Type",DocDim."Document No.",DocDim."Line No.") THEN
               IF (ServiceLine."Contract No." <> '') THEN
                 ERROR(Text007);
         END;
       END;
   ...
   
   

2. Endre koden i tabellen Servicefakturalinje (5902) som følger:
   Eksisterende kode 1

   ...               IF (Quantity <> 0) AND ItemExists(xRec."No.") AND
                     (("Spare Part Action" = "Spare Part Action"::"Component Replaced") OR
                      ("Spare Part Action" = "Spare Part Action"::"Component Installed") OR
                      ("Spare Part Action" = "Spare Part Action"::" "))
                  THEN
                    ReserveServLine.VerifyChange(Rec,xRec);
                END;
   
       OnDelete=VAR
   ...
   
   

   Ny kode 1

   ...               IF (Quantity <> 0) AND ItemExists(xRec."No.") AND
                     (("Spare Part Action" = "Spare Part Action"::"Component Replaced") OR
                      ("Spare Part Action" = "Spare Part Action"::"Component Installed") OR
                      ("Spare Part Action" = "Spare Part Action"::" "))
                  THEN
                    ReserveServLine.VerifyChange(Rec,xRec);
                  IF "Document Type" = ServiceLine."Document Type"::Invoice THEN
                    IF ("Appl.-to Service Entry" <> 0) AND ("Contract No." <> '') THEN
                      ERROR(Text046);
                END;
   
       OnDelete=VAR
   ...
   
   

   Eksisterende kode 2

   ...    { 5   ;   ;Type                ;Option        ;OnValidate=BEGIN
   
   
   
                                                                   GetServHeader;
   
                                                                   TESTFIELD("Qty. Shipped Not Invoiced",0);
   ...
   
   

   Ny kode 2

   ...    { 5   ;   ;Type                ;Option        ;OnValidate=BEGIN
                                                                   IF ("Appl.-to Service Entry" <> 0) AND ("Contract No." <> '') THEN
                                                                     ERROR(Text046);
   
                                                                   GetServHeader;
   ...
   
   

   Eksisterende kode 3

   ...    { 6   ;   ;No.                 ;Code20        ;TableRelation=IF (Type=CONST(" ")) "Standard Text"
                                                                    ELSE IF (Type=CONST(G/L Account)) "G/L Account"
                                                                    ELSE IF (Type=CONST(Item)) Item
                                                                    ELSE IF (Type=CONST(Resource)) Resource
                                                                    ELSE IF (Type=CONST(Cost)) "Service Cost";
                                                      OnValidate=VAR
                                                                   ShowLocMessage@1000 : Boolean;
                                                                 BEGIN
                                                                   TESTFIELD("Qty. Shipped Not Invoiced",0);
   ...
   
   

   Ny kode 3

   ...    { 6   ;   ;No.                 ;Code20        ;TableRelation=IF (Type=CONST(" ")) "Standard Text"
                                                                    ELSE IF (Type=CONST(G/L Account)) "G/L Account"
                                                                    ELSE IF (Type=CONST(Item)) Item
                                                                    ELSE IF (Type=CONST(Resource)) Resource
                                                                    ELSE IF (Type=CONST(Cost)) "Service Cost";
                                                      OnValidate=VAR
                                                                   ShowLocMessage@1000 : Boolean;
                                                                 BEGIN
                                                                   IF ("Appl.-to Service Entry" <> 0) AND ("Contract No." <> '') THEN
                                                                     ERROR(Text046);
   
                                                                   TESTFIELD("Qty. Shipped Not Invoiced",0);
   ...
   
   

   Eksisterende kode 4

   ...    { 22  ;   ;Unit Price          ;Decimal       ;OnValidate=BEGIN
                                                                   GetServHeader;
   
   
                                                                   IF ("Unit Price" > ServHeader."Max. Labor Unit Price") AND
   ...
   
   

   Ny kode 4

   ...    { 22  ;   ;Unit Price          ;Decimal       ;OnValidate=BEGIN
                                                                   GetServHeader;
                                                                   IF ("Appl.-to Service Entry" > 0) AND (CurrFieldNo <> 0) THEN
                                                                     ERROR(Text046,FIELDCAPTION("Unit Price"));
                                                                   IF ("Unit Price" > ServHeader."Max. Labor Unit Price") AND
   ...
   
   

   Eksisterende kode 5

   ...      Text043@1097 : TextConst 'ENU=You cannot change the value of the %1 field manually if %2 for this line is %3';
         Text044@1012 : TextConst 'ENU=Do you want to split the resource line and use it to create resource lines\for the other service items with divided amounts?';
         Text045@1099 : TextConst 'ENU=You cannot delete this service line because one or more service entries exist for this line.';
   ...
   
   

   Ny kode 5

   ...      Text043@1097 : TextConst 'ENU=You cannot change the value of the %1 field manually if %2 for this line is %3';
         Text044@1012 : TextConst 'ENU=Do you want to split the resource line and use it to create resource lines\for the other service items with divided amounts?';
         Text045@1099 : TextConst 'ENU=You cannot delete this service line because one or more service entries exist for this line.';
        Text046@1100 : TextConst 'ENU=You cannot modify the document because it is based on a service contract.';
   ...