この記事は、ベルギー語 (be) 言語ロケールの Microsoft Dynamics NAV に適用されます。
現象
ベルギーバージョンの Microsoft Dynamics NAV で 100% のライン割引がある販売請求書、販売注文、購買請求書、発注書、またはサービス注文を転記すると、総勘定元帳 (GL) エントリが正しくありません。
この問題は、明細行金額、明細行割引金額、付加価値税 (VAT) 基準額、および "VAT を含む金額" の金額が 0 に設定されている場合に発生します。
この問題は、次の製品で発生します。
- ベルギー版 Microsoft Dynamics NAV 2009 Service Pack 1 (SP1)
- ベルギー版 Microsoft Dynamics NAV 2009 R2
解決策
修正プログラムの情報
サポートされている修正プログラムが Microsoft から入手できるようになりました。 ただし、この記事で説明されている問題を修正することのみを目的としています。 この特定の問題が発生しているシステムにのみ適用します。 この修正プログラムは、追加のテストを受け取る場合があります。 したがって、この問題の影響を大きく受けない場合は、次の Microsoft Dynamics NAV 2009 Service Pack またはこの修正プログラムを含む次の Microsoft Dynamics NAV バージョンを待つことをおすすめします。
注 特別なケースでは、Microsoft Dynamics および関連製品のテクニカル サポート プロフェッショナルが特定の更新プログラムによって問題が解決されると判断した場合、通常はサポート呼び出しに対して発生する料金が取り消されることがあります。 ただし、特定の更新プログラムの対象とならない追加の質問および問題については、通常のサポート料金が適用されます。
インストール情報
Microsoft は、明示または黙示の保証なしで、説明のみを目的としてプログラミング例を提供しています。 これには、商品性または特定の目的への適合性に関する暗黙の保証が含まれますが、これらに限定されません。 この記事では、デモンストレーションされているプログラミング言語と、プロシージャの作成とデバッグに使用されるツールについてよく理解していることを前提としています。 マイクロソフト サポート窓口では、特定のプロシージャの機能説明に関するご質問に対して支援いたしますが、本例を特定の目的を満たすために機能を追加したり、プロシージャを構築することは行いません。
注 この修正プログラムをインストールする前に、すべての Microsoft Navision クライアント ユーザーがシステムからログオフされていることを確認します。 これには、Microsoft Navision Application Services (NAS) クライアント ユーザーが含まれます。 この修正プログラムを実装するときにログオンする唯一のクライアント ユーザーである必要があります。
この修正プログラムを実装するには、開発者ライセンスが必要です。
[Windows ログイン] ウィンドウまたは [データベース ログイン] ウィンドウのユーザー アカウントに "SUPER" ロール ID を割り当てることをお勧めします。 ユーザー アカウントに "SUPER" ロール ID を割り当てることができない場合は、ユーザー アカウントに次のアクセス許可があることを確認する必要があります。
- 変更するオブジェクトの [変更] アクセス許可。
- システム オブジェクト ID 5210 オブジェクトとシステム オブジェクト ID 9015 オブジェクトの Execute アクセス許可。
メモ データ修復を実行する必要がない限り、データ ストアに対する権限は必要ありません。
コードの変更
メモ 運用環境のコンピューターに修正プログラムを適用する前に、制御された環境でコード修正を常にテストします。
この問題を解決するには、次の手順を実行します。
Sales Line テーブル (37) の ZeroAmountLine 関数のコードを次のように変更します。
既存のコード
... IF Type = Type::" " THEN EXIT(TRUE); IF Quantity = 0 THEN EXIT(TRUE); // Delete the following line. IF ("Unit Price" = 0) OR ("Line Discount %" = 100) THEN EXIT(TRUE); IF QtyType = QtyType::Invoicing THEN IF "Qty. to Invoice" = 0 THEN EXIT(TRUE); EXIT(FALSE); ...置換コード
... IF Type = Type::" " THEN EXIT(TRUE); IF Quantity = 0 THEN EXIT(TRUE); // Add the following line. IF ("Unit Price" = 0) THEN EXIT(TRUE); IF QtyType = QtyType::Invoicing THEN IF "Qty. to Invoice" = 0 THEN EXIT(TRUE); EXIT(FALSE); ...購入明細行テーブル (39) の UpdateVATOnLines 関数のコードを次のように変更します。
既存のコード 1
... IF FINDSET THEN REPEAT // Delete the following lines. VATAmountLine.GET("VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0); IF VATAmountLine.Modified THEN BEGIN xRecRef.GETTABLE(PurchLine); IF NOT TempVATAmountLineRemainder.GET( "VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0) THEN BEGIN TempVATAmountLineRemainder := VATAmountLine; TempVATAmountLineRemainder.INIT; TempVATAmountLineRemainder.INSERT; END; IF QtyType = QtyType::General THEN LineAmountToInvoice := "Line Amount" ELSE LineAmountToInvoice := ROUND("Line Amount" * "Qty. to Invoice" / Quantity,Currency."Amount Rounding Precision"); IF "Allow Invoice Disc." THEN BEGIN IF VATAmountLine."Inv. Disc. Base Amount" = 0 THEN InvDiscAmount := 0 ELSE BEGIN IF QtyType = QtyType::General THEN LineAmountToInvoice := "Line Amount" ELSE LineAmountToInvoice := ROUND("Line Amount" * "Qty. to Invoice" / Quantity,Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."Invoice Discount Amount" := TempVATAmountLineRemainder."Invoice Discount Amount" + VATAmountLine."Invoice Discount Amount" * LineAmountToInvoice / VATAmountLine."Inv. Disc. Base Amount"; InvDiscAmount := ROUND( TempVATAmountLineRemainder."Invoice Discount Amount",Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."Invoice Discount Amount" := TempVATAmountLineRemainder."Invoice Discount Amount" - InvDiscAmount; END; IF QtyType = QtyType::General THEN BEGIN "Inv. Discount Amount" := InvDiscAmount; CalcInvDiscToInvoice; END ELSE "Inv. Disc. Amount to Invoice" := InvDiscAmount; END ELSE InvDiscAmount := 0; IF QtyType = QtyType::General THEN IF PurchHeader."Prices Including VAT" THEN BEGIN IF (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount" = 0) OR ("Line Amount" = 0) THEN BEGIN VATAmount := 0; NewAmountIncludingVAT := 0; END ELSE BEGIN VATAmount := TempVATAmountLineRemainder."VAT Amount" + VATAmountLine."VAT Amount" * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); NewAmountIncludingVAT := TempVATAmountLineRemainder."Amount Including VAT" + VATAmountLine."Amount Including VAT" * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); END; NewAmount := ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision") - ROUND(VATAmount,Currency."Amount Rounding Precision"); IF ("VAT %" <> 0) AND (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"<> 0) THEN NewVATBaseAmount := TempVATAmountLineRemainder."VAT Base (Lowered)" + VATAmountLine."Line Amount" * (1 - PurchHeader."VAT Base Discount %" / 100) * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") ELSE NewVATBaseAmount := NewAmount; END ELSE BEGIN IF "VAT Calculation Type" = "VAT Calculation Type"::"Full VAT" THEN BEGIN VATAmount := "Line Amount" - "Inv. Discount Amount"; NewAmount := 0; NewVATBaseAmount := 0; END ELSE BEGIN NewAmount := "Line Amount" - "Inv. Discount Amount"; // End of the deleted lines. IF ("VAT %" <> 0) AND (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount" <> 0) THEN NewVATBaseAmount := TempVATAmountLineRemainder."VAT Base (Lowered)" + ...置換コード 1
... IF FINDSET THEN REPEAT // Add the following lines. IF NOT ZeroAmountLine(QtyType) THEN BEGIN VATAmountLine.GET("VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0); IF VATAmountLine.Modified THEN BEGIN xRecRef.GETTABLE(PurchLine); IF NOT TempVATAmountLineRemainder.GET( "VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0) THEN BEGIN TempVATAmountLineRemainder := VATAmountLine; TempVATAmountLineRemainder.INIT; TempVATAmountLineRemainder.INSERT; END; IF QtyType = QtyType::General THEN LineAmountToInvoice := "Line Amount" ELSE LineAmountToInvoice := ROUND("Line Amount" * "Qty. to Invoice" / Quantity,Currency."Amount Rounding Precision"); IF "Allow Invoice Disc." THEN BEGIN IF VATAmountLine."Inv. Disc. Base Amount" = 0 THEN InvDiscAmount := 0 ELSE BEGIN IF QtyType = QtyType::General THEN LineAmountToInvoice := "Line Amount" ELSE LineAmountToInvoice := ROUND("Line Amount" * "Qty. to Invoice" / Quantity,Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."Invoice Discount Amount" := TempVATAmountLineRemainder."Invoice Discount Amount" + VATAmountLine."Invoice Discount Amount" * LineAmountToInvoice / VATAmountLine."Inv. Disc. Base Amount"; InvDiscAmount := ROUND( TempVATAmountLineRemainder."Invoice Discount Amount",Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."Invoice Discount Amount" := TempVATAmountLineRemainder."Invoice Discount Amount" - InvDiscAmount; END; IF QtyType = QtyType::General THEN BEGIN "Inv. Discount Amount" := InvDiscAmount; CalcInvDiscToInvoice; END ELSE "Inv. Disc. Amount to Invoice" := InvDiscAmount; END ELSE InvDiscAmount := 0; IF QtyType = QtyType::General THEN IF PurchHeader."Prices Including VAT" THEN BEGIN IF (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount" = 0) OR ("Line Amount" = 0) THEN BEGIN VATAmount := 0; NewAmountIncludingVAT := 0; END ELSE BEGIN VATAmount := TempVATAmountLineRemainder."VAT Amount" + VATAmountLine."VAT Amount" * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); NewAmountIncludingVAT := TempVATAmountLineRemainder."Amount Including VAT" + VATAmountLine."Amount Including VAT" * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); END; NewAmount := ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision") - ROUND(VATAmount,Currency."Amount Rounding Precision"); // End of the added lines. IF ("VAT %"<> 0) AND (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount" <> 0) THEN NewVATBaseAmount := TempVATAmountLineRemainder."VAT Base (Lowered)" + ...既存のコード 2
... TempVATAmountLineRemainder."VAT Base (Lowered)" + VATAmountLine."Line Amount" * (1 - PurchHeader."VAT Base Discount %" / 100) * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") ELSE NewVATBaseAmount := NewAmount; // Delete the following lines. IF VATAmountLine."VAT Base" = 0 THEN VATAmount := 0 ELSE VATAmount := TempVATAmountLineRemainder."VAT Amount" + VATAmountLine."VAT Amount" * NewAmount / VATAmountLine."VAT Base"; END; NewAmountIncludingVAT := NewAmount + ROUND(VATAmount,Currency."Amount Rounding Precision"); END ELSE BEGIN IF (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") = 0 THEN VATDifference := 0 ELSE VATDifference := TempVATAmountLineRemainder."VAT Difference" + VATAmountLine."VAT Difference" * (LineAmountToInvoice - InvDiscAmount) / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); IF LineAmountToInvoice = 0 THEN "VAT Difference" := 0 ELSE "VAT Difference" := ROUND(VATDifference,Currency."Amount Rounding Precision"); END; IF (QtyType = QtyType::General) AND (PurchHeader.Status = PurchHeader.Status::Released) THEN BEGIN Amount := NewAmount; "Amount Including VAT" := ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision"); IF "VAT %" <> 0 THEN "VAT Base Amount" := ROUND(NewVATBaseAmount,Currency."Amount Rounding Precision") ELSE "VAT Base Amount" := Amount; END; InitOutstanding; IF NOT ((Type = Type::"Charge (Item)") AND ("Quantity Invoiced" <> "Qty. Assigned")) THEN BEGIN SetUpdateFromVAT(TRUE); UpdateUnitCost; END; IF Type = Type::"Charge (Item)" THEN UpdateItemChargeAssgnt; MODIFY; RecRef.GETTABLE(PurchLine); ChangeLogMgt.LogModification(RecRef,xRecRef); TempVATAmountLineRemainder."Amount Including VAT" := NewAmountIncludingVAT - ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."VAT Amount" := VATAmount - NewAmountIncludingVAT + NewAmount; TempVATAmountLineRemainder."VAT Difference" := VATDifference - "VAT Difference"; TempVATAmountLineRemainder."VAT Base (Lowered)" := NewVATBaseAmount - "VAT Base Amount"; TempVATAmountLineRemainder.MODIFY; // End of the deleted lines. END; UNTIL NEXT = 0; SETRANGE(Type); SETRANGE(Quantity); SETRANGE("Qty. to Invoice"); ...置換コード 2
... TempVATAmountLineRemainder."VAT Base (Lowered)" + VATAmountLine."Line Amount" * (1 - PurchHeader."VAT Base Discount %" / 100) * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") ELSE NewVATBaseAmount := NewAmount; // Add the following lines. END ELSE BEGIN IF "VAT Calculation Type" = "VAT Calculation Type"::"Full VAT" THEN BEGIN VATAmount := "Line Amount" - "Inv. Discount Amount"; NewAmount := 0; NewVATBaseAmount := 0; END ELSE BEGIN NewAmount := "Line Amount" - "Inv. Discount Amount"; IF ("VAT %" <>0) AND (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"<>0) THEN NewVATBaseAmount := TempVATAmountLineRemainder."VAT Base (Lowered)" + VATAmountLine."Line Amount" * (1 - PurchHeader."VAT Base Discount %" / 100) * ("Line Amount" - "Inv. Discount Amount") / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") ELSE NewVATBaseAmount := NewAmount; IF VATAmountLine."VAT Base" = 0 THEN VATAmount := 0 ELSE VATAmount := TempVATAmountLineRemainder."VAT Amount" + VATAmountLine."VAT Amount" * NewAmount / VATAmountLine."VAT Base"; END; NewAmountIncludingVAT := NewAmount + ROUND(VATAmount,Currency."Amount Rounding Precision"); END ELSE BEGIN IF (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount") = 0 THEN VATDifference := 0 ELSE VATDifference := TempVATAmountLineRemainder."VAT Difference" + VATAmountLine."VAT Difference" * (LineAmountToInvoice - InvDiscAmount) / (VATAmountLine."Line Amount" - VATAmountLine."Invoice Discount Amount"); IF LineAmountToInvoice = 0 THEN "VAT Difference" := 0 ELSE "VAT Difference" := ROUND(VATDifference,Currency."Amount Rounding Precision"); END; IF (QtyType = QtyType::General) AND (PurchHeader.Status = PurchHeader.Status::Released) THEN BEGIN Amount := NewAmount; "Amount Including VAT" := ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision"); IF "VAT %" <> 0 THEN "VAT Base Amount" := ROUND(NewVATBaseAmount,Currency."Amount Rounding Precision") ELSE "VAT Base Amount" := Amount; END; InitOutstanding; IF NOT ((Type = Type::"Charge (Item)") AND ("Quantity Invoiced" <>"Qty. Assigned")) THEN BEGIN SetUpdateFromVAT(TRUE); UpdateUnitCost; END; IF Type = Type::"Charge (Item)" THEN UpdateItemChargeAssgnt; MODIFY; RecRef.GETTABLE(PurchLine); ChangeLogMgt.LogModification(RecRef,xRecRef); TempVATAmountLineRemainder."Amount Including VAT" := NewAmountIncludingVAT - ROUND(NewAmountIncludingVAT,Currency."Amount Rounding Precision"); TempVATAmountLineRemainder."VAT Amount" := VATAmount - NewAmountIncludingVAT + NewAmount; TempVATAmountLineRemainder."VAT Difference" := VATDifference - "VAT Difference"; TempVATAmountLineRemainder."VAT Base (Lowered)" := NewVATBaseAmount - "VAT Base Amount"; TempVATAmountLineRemainder.MODIFY; END; // End of the added lines. END; UNTIL NEXT = 0; SETRANGE(Type); SETRANGE(Quantity); SETRANGE("Qty. to Invoice"); ...購入明細行テーブル (39) の CalcVATAmountLines 関数のコードを次のように変更します。
既存のコード
... Vendor.GET(PurchHeader."Pay-to Vendor No."); VendorPostingGroup.GET(Vendor."Vendor Posting Group"); END; IF FINDSET THEN REPEAT // Delete the following lines. IF (Type = Type::"G/L Account") AND NOT "Prepayment Line" THEN RoundingLineInserted := ("No." = VendorPostingGroup."Invoice Rounding Account") OR RoundingLineInserted; IF "VAT Calculation Type" IN ["VAT Calculation Type"::"Reverse Charge VAT","VAT Calculation Type"::"Sales Tax"] THEN "VAT %" := 0; IF NOT VATAmountLine.GET( "VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0) THEN BEGIN VATAmountLine.INIT; VATAmountLine."VAT Identifier" := "VAT Identifier"; VATAmountLine."VAT Calculation Type" := "VAT Calculation Type"; VATAmountLine."Tax Group Code" := "Tax Group Code"; VATAmountLine."Use Tax" := "Use Tax"; VATAmountLine."VAT %" := "VAT %"; VATAmountLine.Modified := TRUE; VATAmountLine.Positive := "Line Amount" >= 0; VATAmountLine.INSERT; END; CASE QtyType OF QtyType::General: BEGIN VATAmountLine.Quantity := VATAmountLine.Quantity + "Quantity (Base)"; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + "Line Amount"; IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + "Line Amount"; VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + "Inv. Discount Amount"; VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine."VAT Base (Lowered)" := VATAmountLine."VAT Base (Lowered)" + "VAT Base Amount"; VATAmountLine.MODIFY; END; QtyType::Invoicing: BEGIN CASE TRUE OF ("Document Type" IN ["Document Type"::Order,"Document Type"::Invoice]) AND (NOT PurchHeader.Receive) AND PurchHeader.Invoice AND (NOT "Prepayment Line"): BEGIN IF "Receipt No." = '' THEN BEGIN QtyToHandle := GetAbsMin("Qty. to Invoice","Qty. Rcd. Not Invoiced"); VATAmountLine.Quantity := VATAmountLine.Quantity + GetAbsMin("Qty. to Invoice (Base)","Qty. Rcd. Not Invoiced (Base)"); END ELSE BEGIN QtyToHandle := "Qty. to Invoice"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Invoice (Base)"; END; END; ("Document Type" IN ["Document Type"::"Return Order","Document Type"::"Credit Memo"]) AND (NOT PurchHeader.Ship) AND PurchHeader.Invoice: BEGIN QtyToHandle := GetAbsMin("Qty. to Invoice","Return Qty. Shipped Not Invd."); VATAmountLine.Quantity := VATAmountLine.Quantity + GetAbsMin("Qty. to Invoice (Base)","Ret. Qty. Shpd Not Invd.(Base)"); END; ELSE BEGIN QtyToHandle := "Qty. to Invoice"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Invoice (Base)"; END; END; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF (PurchHeader."Invoice Discount Calculation" <> PurchHeader."Invoice Discount Calculation"::Amount) THEN VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + ROUND("Inv. Discount Amount" * QtyToHandle / Quantity,Currency."Amount Rounding Precision") ELSE VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + "Inv. Disc. Amount to Invoice"; VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine."VAT Base (Lowered)" := VATAmountLine."VAT Base (Lowered)" + "VAT Base Amount"; VATAmountLine.MODIFY; END; QtyType::Shipping: BEGIN IF "Document Type" IN ["Document Type"::"Return Order","Document Type"::"Credit Memo"] THEN BEGIN QtyToHandle := "Return Qty. to Ship"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Return Qty. to Ship (Base)"; END ELSE BEGIN QtyToHandle := "Qty. to Receive"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Receive (Base)"; END; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + ROUND("Inv. Discount Amount" * QtyToHandle / Quantity,Currency."Amount Rounding Precision"); VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine.MODIFY; END; END; TotalVATAmount := TotalVATAmount + "Amount Including VAT" - Amount; // End of the deleted lines. UNTIL NEXT = 0; SETRANGE(Type); SETRANGE(Quantity); ...置換コード
... Vendor.GET(PurchHeader."Pay-to Vendor No."); VendorPostingGroup.GET(Vendor."Vendor Posting Group"); END; IF FINDSET THEN REPEAT // Add the following lines. IF NOT ZeroAmountLine(QtyType) THEN BEGIN IF (Type = Type::"G/L Account") AND NOT "Prepayment Line" THEN RoundingLineInserted := ("No." = VendorPostingGroup."Invoice Rounding Account") OR RoundingLineInserted; IF "VAT Calculation Type" IN ["VAT Calculation Type"::"Reverse Charge VAT","VAT Calculation Type"::"Sales Tax"] THEN "VAT %" := 0; IF NOT VATAmountLine.GET( "VAT Identifier","VAT Calculation Type","Tax Group Code","Use Tax","Line Amount" >= 0) THEN BEGIN VATAmountLine.INIT; VATAmountLine."VAT Identifier" := "VAT Identifier"; VATAmountLine."VAT Calculation Type" := "VAT Calculation Type"; VATAmountLine."Tax Group Code" := "Tax Group Code"; VATAmountLine."Use Tax" := "Use Tax"; VATAmountLine."VAT %" := "VAT %"; VATAmountLine.Modified := TRUE; VATAmountLine.Positive := "Line Amount" >= 0; VATAmountLine.INSERT; END; CASE QtyType OF QtyType::General: BEGIN VATAmountLine.Quantity := VATAmountLine.Quantity + "Quantity (Base)"; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + "Line Amount"; IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + "Line Amount"; VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + "Inv. Discount Amount"; VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine."VAT Base (Lowered)" := VATAmountLine."VAT Base (Lowered)" + "VAT Base Amount"; VATAmountLine.MODIFY; END; QtyType::Invoicing: BEGIN CASE TRUE OF ("Document Type" IN ["Document Type"::Order,"Document Type"::Invoice]) AND (NOT PurchHeader.Receive) AND PurchHeader.Invoice AND (NOT "Prepayment Line"): BEGIN IF "Receipt No." = '' THEN BEGIN QtyToHandle := GetAbsMin("Qty. to Invoice","Qty. Rcd. Not Invoiced"); VATAmountLine.Quantity := VATAmountLine.Quantity + GetAbsMin("Qty. to Invoice (Base)","Qty. Rcd. Not Invoiced (Base)"); END ELSE BEGIN QtyToHandle := "Qty. to Invoice"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Invoice (Base)"; END; END; ("Document Type" IN ["Document Type"::"Return Order","Document Type"::"Credit Memo"]) AND (NOT PurchHeader.Ship) AND PurchHeader.Invoice: BEGIN QtyToHandle := GetAbsMin("Qty. to Invoice","Return Qty. Shipped Not Invd."); VATAmountLine.Quantity := VATAmountLine.Quantity + GetAbsMin("Qty. to Invoice (Base)","Ret. Qty. Shpd Not Invd.(Base)"); END; ELSE BEGIN QtyToHandle := "Qty. to Invoice"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Invoice (Base)"; END; END; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF (PurchHeader."Invoice Discount Calculation" <> PurchHeader."Invoice Discount Calculation"::Amount) THEN VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + ROUND("Inv. Discount Amount" * QtyToHandle / Quantity,Currency."Amount Rounding Precision") ELSE VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + "Inv. Disc. Amount to Invoice"; VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine."VAT Base (Lowered)" := VATAmountLine."VAT Base (Lowered)" + "VAT Base Amount"; VATAmountLine.MODIFY; END; QtyType::Shipping: BEGIN IF "Document Type" IN ["Document Type"::"Return Order","Document Type"::"Credit Memo"] THEN BEGIN QtyToHandle := "Return Qty. to Ship"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Return Qty. to Ship (Base)"; END ELSE BEGIN QtyToHandle := "Qty. to Receive"; VATAmountLine.Quantity := VATAmountLine.Quantity + "Qty. to Receive (Base)"; END; VATAmountLine."Line Amount" := VATAmountLine."Line Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); IF "Allow Invoice Disc." THEN VATAmountLine."Inv. Disc. Base Amount" := VATAmountLine."Inv. Disc. Base Amount" + (ROUND(QtyToHandle * "Direct Unit Cost" - ("Line Discount Amount" * QtyToHandle / Quantity), Currency."Amount Rounding Precision")); VATAmountLine."Invoice Discount Amount" := VATAmountLine."Invoice Discount Amount" + ROUND("Inv. Discount Amount" * QtyToHandle / Quantity,Currency."Amount Rounding Precision"); VATAmountLine."VAT Difference" := VATAmountLine."VAT Difference" + "VAT Difference"; IF "Prepayment Line" THEN VATAmountLine."Includes Prepayment" := TRUE; VATAmountLine.MODIFY; END; END; TotalVATAmount := TotalVATAmount + "Amount Including VAT" - Amount; END; // End of the added lines. UNTIL NEXT = 0; SETRANGE(Type); SETRANGE(Quantity); ...次のように、購入明細行テーブル (39) に ZeroAmountLine 関数を作成します。
... PROCEDURE ZeroAmountLine@66(QtyType@1000 : 'General,Invoicing,Shipping') : Boolean; BEGIN IF Type = Type::" " THEN EXIT(TRUE); IF Quantity = 0 THEN EXIT(TRUE); IF ("Direct Unit Cost" = 0) THEN // W10001 EXIT(TRUE); IF QtyType = QtyType::Invoicing THEN IF "Qty. to Invoice" = 0 THEN EXIT(TRUE); EXIT(FALSE); END; ...Sales-Post codeunit (80) の UpdInvPostingBuffer 関数のコードを次のように変更します。
既存のコード
... InvPostingBuffer[1]."Dimension Entry No." := EntryNo; IF InvPostingBuffer[1].Type = InvPostingBuffer[1].Type::"Fixed Asset" THEN BEGIN FALineNo := FALineNo + 1; InvPostingBuffer[1]."Fixed Asset Line No." := FALineNo; END; InvPostingBuffer[2] := InvPostingBuffer[1]; IF InvPostingBuffer[2].FIND THEN BEGIN InvPostingBuffer[2].Amount := InvPostingBuffer[2].Amount + InvPostingBuffer[1].Amount; InvPostingBuffer[2]."VAT Amount" := InvPostingBuffer[2]."VAT Amount" + InvPostingBuffer[1]."VAT Amount"; ...置換コード
... InvPostingBuffer[1]."Dimension Entry No." := EntryNo; IF InvPostingBuffer[1].Type = InvPostingBuffer[1].Type::"Fixed Asset" THEN BEGIN FALineNo := FALineNo + 1; InvPostingBuffer[1]."Fixed Asset Line No." := FALineNo; END; // Add the following lines. IF (SalesLine."Line Discount %" = 100) THEN BEGIN InvPostingBuffer[1]."VAT Base Amount" := 0; InvPostingBuffer[1]."VAT Base Amount (ACY)" := 0; InvPostingBuffer[1]."VAT Amount" := 0; InvPostingBuffer[1]."VAT Amount (ACY)" := 0; END; // End of the added lines. InvPostingBuffer[2] := InvPostingBuffer[1]; IF InvPostingBuffer[2].FIND THEN BEGIN InvPostingBuffer[2].Amount := InvPostingBuffer[2].Amount + InvPostingBuffer[1].Amount; InvPostingBuffer[2]."VAT Amount" := InvPostingBuffer[2]."VAT Amount" + InvPostingBuffer[1]."VAT Amount"; ...Sales-Post codeunit (80) の DivideAmount 関数のコードを次のように変更します。
既存のコード
... IF RoundingLineInserted AND (RoundingLineNo = SalesLine."Line No.") THEN EXIT; WITH SalesLine DO // Delete the following line IF (SalesLineQty = 0) OR ("Unit Price" = 0) OR ("Line Discount %" = 100) THEN BEGIN "Line Amount" := 0; "Line Discount Amount" := 0; "Inv. Discount Amount" := 0; "VAT Base Amount" := 0; Amount := 0; ...置換コード
... IF RoundingLineInserted AND (RoundingLineNo = SalesLine."Line No.") THEN EXIT; WITH SalesLine DO // Add the following line IF (SalesLineQty = 0) OR ("Unit Price" = 0) THEN BEGIN // W10001 "Line Amount" := 0; "Line Discount Amount" := 0; "Inv. Discount Amount" := 0; "VAT Base Amount" := 0; Amount := 0; ...Purch.-Post codeunit (90) の UpdInvPostingBuffer 関数のコードを次のように変更します。
既存のコード
... IF InvPostingBuffer[1].Type = InvPostingBuffer[1].Type::"Fixed Asset" THEN BEGIN FALineNo := FALineNo + 1; InvPostingBuffer[1]."Fixed Asset Line No." := FALineNo; END; InvPostingBuffer[2] := InvPostingBuffer[1]; IF InvPostingBuffer[2].FIND THEN BEGIN InvPostingBuffer[2].Amount := InvPostingBuffer[2].Amount + InvPostingBuffer[1].Amount; InvPostingBuffer[2]."VAT Amount" := ...置換コード
... IF InvPostingBuffer[1].Type = InvPostingBuffer[1].Type::"Fixed Asset" THEN BEGIN FALineNo := FALineNo + 1; InvPostingBuffer[1]."Fixed Asset Line No." := FALineNo; END; // Add the following lines. IF (PurchLine."Line Discount %" = 100) THEN BEGIN InvPostingBuffer[1]."VAT Base Amount" := 0; InvPostingBuffer[1]."VAT Base Amount (ACY)" := 0; InvPostingBuffer[1]."VAT Amount" := 0; InvPostingBuffer[1]."VAT Amount (ACY)" := 0; END; // End of the added lines. InvPostingBuffer[2] := InvPostingBuffer[1]; IF InvPostingBuffer[2].FIND THEN BEGIN InvPostingBuffer[2].Amount := InvPostingBuffer[2].Amount + InvPostingBuffer[1].Amount; InvPostingBuffer[2]."VAT Amount" := ...Purch.-Post codeunit (90) の DivideAmount 関数のコードを次のように変更します。
既存のコード
... IF RoundingLineInserted AND (RoundingLineNo = PurchLine."Line No.") THEN EXIT; WITH PurchLine DO // Delete the following line IF (PurchLineQty = 0) OR ("Direct Unit Cost" = 0) OR ("Line Discount %" = 100) THEN BEGIN "Line Amount" := 0; "Line Discount Amount" := 0; "Inv. Discount Amount" := 0; "VAT Base Amount" := 0; Amount := 0; ...置換コード
... IF RoundingLineInserted AND (RoundingLineNo = PurchLine."Line No.") THEN EXIT; WITH PurchLine DO // Add the following line IF (PurchLineQty = 0) OR ("Direct Unit Cost" = 0) THEN BEGIN // W10001 "Line Amount" := 0; "Line Discount Amount" := 0; "Inv. Discount Amount" := 0; "VAT Base Amount" := 0; Amount := 0; ...Serv-Amounts Mgt. codeunit (5986) の FillInvPostingBuffer 関数のコードを次のように変更します。
既存のコード 1
... TotalVATACY, TotalAmount, TotalAmountACY, TotalVATBase, TotalVATBaseACY); UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); END; IF SalesSetup."Discount Posting" IN [SalesSetup."Discount Posting"::"Line Discounts",SalesSetup."Discount Posting"::"All Discounts"] THEN ...置換コード 1
... TotalVATACY, TotalAmount, TotalAmountACY, TotalVATBase, TotalVATBaseACY); // Add the following lines. IF ServiceLine."Line Discount %" = 100 THEN ClearSerLineDiscBuffer(InvPostingBuffer[1]); // End of the added lines. UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); END; IF SalesSetup."Discount Posting" IN [SalesSetup."Discount Posting"::"Line Discounts",SalesSetup."Discount Posting"::"All Discounts"] THEN ...既存のコード 2
... TotalVATACY, TotalAmount, TotalAmountACY, TotalVATBase, TotalVATBaseACY); UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); END; InvPostingBuffer[1].SetAmounts( TotalVAT, ...置換コード 2
... TotalVATACY, TotalAmount, TotalAmountACY, TotalVATBase, TotalVATBaseACY); // Add the following lines. IF ServiceLine."Line Discount %" = 100 THEN ClearSerLineDiscBuffer(InvPostingBuffer[1]); // End of the added lines. UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); END; InvPostingBuffer[1].SetAmounts( TotalVAT, ...既存のコード 3
... TotalVATBase, TotalVATBaseACY); END; END; END; UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); ...置換コード 3
... TotalVATBase, TotalVATBaseACY); END; END; END; // Add the following lines. IF ServiceLine."Line Discount %" = 100 THEN ClearSerLineDiscBuffer(InvPostingBuffer[1]); // End of the added lines. UpdInvPostingBuffer(InvPostingBuffer,TempDocDim); ...Serv-Amounts Mgt. codeunit (5986) の ClearSerLineDiscBuffer 関数のコードを次のように変更します。
... LOCAL PROCEDURE ClearSerLineDiscBuffer@50(VAR InvPostingBuffer@1050 : Record 49); BEGIN InvPostingBuffer."VAT Base Amount" := 0; InvPostingBuffer."VAT Base Amount (ACY)" := 0; InvPostingBuffer."VAT Amount" := 0; InvPostingBuffer."VAT Amount (ACY)" := 0; END; ...
前提条件
この修正プログラムを適用するには、次のいずれかの製品がインストールされている必要があります。
- ベルギー版 Microsoft Dynamics NAV 2009 Service Pack 1 (SP1)
- ベルギー版 Microsoft Dynamics NAV 2009 R2
アンインストール情報
この修正プログラムを削除することはできません。
状態
Microsoft は、これが "適用対象" セクションに記載されている Microsoft 製品の問題であることを確認しました。
参考資料
VSTF DynamicsNAV SE: 284212
注: この資料は、"迅速な公開" を目的としてマイクロソフト サポート組織により直接作成されたものです。 ここに含まれる情報は、新しい問題に対応するため、そのままの状態で提供されます。 情報を迅速に公開するため、この資料には誤植などが含まれる可能性があり、また、予告なく改訂される場合があります。 その他の注意事項については、使用条件を参照してください。