在客戶總帳資料編輯] 表格內的金額 (LCY) 不包含詳細的客戶總帳 Microsoft 動態航行點 2009年中。因此,的加總的數量 (LCY) 不符合客戶總帳帳戶。下列產品中,就會發生這個問題︰
-
Microsoft 動態航行點 2009 R2
-
Microsoft 動態航行點 2009 Service Pack 1 (SP1)
解決方案
Hotfix 資訊
已經可以從 Microsoft 取得支援的 hotfix。不過,它只被用來修正本文所述的問題。它只適用於發生此特定問題的系統上。此 hotfix 可能會接受其他測試。因此,如果此問題不會嚴重影響,我們建議您等候下一步的 Microsoft 動態航行點 2009 service pack 或包含此 hotfix 的下一個 Microsoft 動態航行點版本。
注意 在特殊的情況下,通常會支援呼叫可能已被取消如果技術支援專業人員的 Microsoft 動態及相關的產品所產生的費用會決定某特定更新程式可以解決您的問題。收取支援費用會套用,如果有其他支援問題是,不能限定的特定更新程式。安裝資訊
Microsoft 會提供程式設計範例僅供說明,而不做任何明示或默示的保證。這包括,但不限於適售性或適合某特定用途之默示擔保責任。本文假設您已相當熟悉使用的我們所示範的程式設計語言以及建立和偵錯程序所使用的工具。Microsoft 技術支援工程師可以協助解釋特定程序的功能。不過,它們不會修改這些範例以提供附加功能或建構程序來滿足您特定需求。
注意套用此 hotfix 之前,請確認所有的 Microsoft 動態航行點用戶端使用者會登出系統。這包括 Microsoft 動態航行點應用程式伺服器 (NAS) 服務。您應該是唯一的用戶端使用者已登入,當您實作此 hotfix。 若要實作此 hotfix,您必須有開發人員授權。 我們建議您在 Windows 登入] 視窗中的色彩,或資料庫登入] 視窗中的使用者帳戶被指派 「 進階 」 的角色識別碼。如果使用者帳戶不能指派為 「 超級 」 的角色識別碼,您必須確認使用者帳戶具有下列權限︰-
您將會變更物件的 [修改] 權限。
-
執行權限的系統物件 ID 5210物件和系統物件 ID 9015
物件。
注意您沒有擁有資料存放區的權限,除非您需要執行資料修復。
程式碼變更
注意一定要測試程式碼修正在受控制的環境中生產電腦套用修正程式之前。前套用變更,請匯入所有的 SEPA 更新。
若要解決這個問題,請依照下列步驟執行:-
變更欄位中的 Cust 程式碼。總帳項目資料表 (21) 的如下所示︰
現有的程式碼 1...{ 11 ; ;Currency Code ;Code10 ;TableRelation=Currency }
{ 13 ; ;Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1; ...取代程式碼
...{ 11 ; ;Currency Code ;Code10 ;TableRelation=Currency }
{ 13 ; ;Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1; ...現有的程式碼 2
...AutoFormatType=1 }
{ 17 ; ;Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1 } ...取代程式碼 2
...AutoFormatType=1 }
{ 17 ; ;Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1 } ...現有的程式碼 3
...{ 54 ; ;Closed by Amount (LCY);Decimal ;AutoFormatType=1 }
{ 58 ; ;Debit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Debit Amount" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 3
...{ 54 ; ;Closed by Amount (LCY);Decimal ;AutoFormatType=1 }
{ 58 ; ;Debit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Debit Amount" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 4
...AutoFormatExpr="Currency Code" }
{ 59 ; ;Credit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Credit Amount" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 4
...AutoFormatExpr="Currency Code" }
{ 59 ; ;Credit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Credit Amount" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 5
...AutoFormatExpr="Currency Code" }
{ 60 ; ;Debit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Debit Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 5
...AutoFormatExpr="Currency Code" }
{ 60 ; ;Debit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Debit Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 6
...AutoFormatType=1 }
{ 61 ; ;Credit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Credit Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 6
...AutoFormatType=1 }
{ 61 ; ;Credit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry"."Credit Amount (LCY)" WHERE (Cust. Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ... -
變更欄位中 (25) 中的 [供應商總帳資料編輯] 表格中的程式碼如下所示︰
現有的程式碼 1...{ 11 ; ;Currency Code ;Code10 ;TableRelation=Currency }
{ 13 ; ;Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry".Amount WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1; ...取代程式碼 1
...{ 11 ; ;Currency Code ;Code10 ;TableRelation=Currency }
{ 13 ; ;Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry".Amount WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1; ...現有的程式碼 2
...AutoFormatType=1 }
{ 17 ; ;Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1 } ...取代程式碼 2
...AutoFormatType=1 }
{ 17 ; ;Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); Editable=No; AutoFormatType=1 } ...現有的程式碼 3
...{ 54 ; ;Closed by Amount (LCY);Decimal ;AutoFormatType=1 }
{ 58 ; ;Debit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Debit Amount" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 3
...{ 54 ; ;Closed by Amount (LCY);Decimal ;AutoFormatType=1 }
{ 58 ; ;Debit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Debit Amount" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 4
...AutoFormatExpr="Currency Code" }
{ 59 ; ;Credit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Credit Amount" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 4
...AutoFormatExpr="Currency Code" }
{ 59 ; ;Credit Amount ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Credit Amount" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 5
...AutoFormatExpr="Currency Code" }
{ 60 ; ;Debit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Debit Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 5
...AutoFormatExpr="Currency Code" }
{ 60 ; ;Debit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Debit Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...現有的程式碼 6
...AutoFormatType=1 }
{ 61 ; ;Credit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Credit Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Delete the following line. Entry Type=FILTER(<>Application), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...取代程式碼 6
...AutoFormatType=1 }
{ 61 ; ;Credit Amount (LCY) ;Decimal ;FieldClass=FlowField; CalcFormula=Sum("Detailed Vendor Ledg. Entry"."Credit Amount (LCY)" WHERE (Vendor Ledger Entry No.=FIELD(Entry No.), // Add the following line. Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Correction of Remaining Amount|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'), Posting Date=FIELD(Date Filter))); BlankZero=Yes; Editable=No; ...
先決條件
您必須具備套用此 hotfix 之後安裝下列產品的其中一個︰
-
Microsoft 動態航行點 2009 R2
-
Microsoft 動態航行點 2009 SP1
移除資訊
您無法移除此 hotfix。
狀態
Microsoft 已確認這是<套用>一節所列出的 Microsoft 產品的問題。
注意這是直接從 Microsoft 支援組織內建立的「快速發行」文件。本文件所包含的現狀資訊是針對新興問題的回應。為縮短使其可用的時程,資料可能會包含印刷錯誤,且可能會隨時進行修改而不另行通知。如其他考量,請參閱 「使用規定」。