2016年05月18日

"Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision caused by what


Summary: When you apply a payment to more than one invoice in Microsoft Business Solutions - Navision 4.0, the report "Aged Accounts Receivable" (120) returns the wrong information.



Resolution: If you fix "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision error in time, your PC will run like brand new. In order to fix your errors and speed up PC, it is recommended that your download the '"Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision Repair Tool'. It's an amazing software which is designed for users to troubleshoot "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision errors efficiently..



Try "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision Removal Program Now



In order to repair "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision issue, install SmartPCFixer immediately. This system optimizer software is already proven to locate, identify, and troubleshoot "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision errors. Speed up your PC with SmartPCFixer at once




Manual Solutions


Hotfix information

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Business Solutions - Navision 4.00 service pack that contains this hotfix.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Installation information

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. Note Before you install this hotfix, verify that all Microsoft Navision client users are logged off from the system. This includes Microsoft Navision Application Services (NAS) client users. You should be the only client user who is logged on when you implement this hotfix.

To install this hotfix, you must have a valid license for the Solution Developer granule. We recommend that you assign the "SUPER" role ID to the user account in the Windows Logins dialog box or in the Database Logins dialog box. If you cannot assign this role ID, verify that the user account has the following permissions:
  • Modify permissions for the Report Object ID 120 object.
  • You do not have to have permissions to the data stores unless you must repair data repair.

    To install this hotfix, change the code in the "Aged Accounts Receivable" (120) report according to the following example.
    Existing code
    Report 120
    DataItem
    Name
    Integer
    TempCustLedgEntryLoop
    Trigger TempCustLedgEntryLoop - OnAfterGetRecord()
    ...
    {TempCustLedgEntry.SETRANGE("Date Filter",0D,EndingDate);
    TempCustLedgEntry.CALCFIELDS(Amount,"Amount (LCY)");
    IF TempCustLedgEntry.Amount = 0 THEN
    CurrReport.SKIP;

    CustLedgEntryEndingDate := TempCustLedgEntry;
    {CustLedgEntryEndingDate."Remaining Amount" := TempCustLedgEntry.Amount;
    CustLedgEntryEndingDate."Remaining Amt. (LCY)" := TempCustLedgEntry."Amount (LCY)";

    CustLedgEntry.SETCURRENTKEY("Closed by Entry No.");
    CustLedgEntry.SETRANGE("Closed by Entry No.",TempCustLedgEntry."Entry No.");
    CustLedgEntry.SETRANGE("Posting Date",0D,EndingDate);
    IF CustLedgEntry.FIND('-') THEN
    REPEAT
    CustLedgEntry.CALCFIELDS(Amount);
    IF CustLedgEntry.Amount <> 0 THEN BEGIN
    CustLedgEntryEndingDate."Remaining Amount" += CustLedgEntry."Closed by Currency Amount";
    CustLedgEntryEndingDate."Remaining Amt. (LCY)" += CustLedgEntry."Closed by Amount (LCY)";
    END;
    UNTIL CustLedgEntry.NEXT = 0;
    CustLedgEntry.RESET;
    CustLedgEntry.SETRANGE("Entry No.",TempCustLedgEntry."Closed by Entry No.");
    CustLedgEntry.SETRANGE("Posting Date",0D,EndingDate);
    IF CustLedgEntry.FIND('-') THEN
    REPEAT
    CustLedgEntry.CALCFIELDS(Amount);
    IF CustLedgEntry.Amount <> 0 THEN BEGIN
    CustLedgEntryEndingDate."Remaining Amount" -= CustLedgEntryEndingDate."Closed by Amount";
    CustLedgEntryEndingDate."Remaining Amt. (LCY)" -= CustLedgEntryEndingDate."Closed by Amount (LCY)";
    END;
    UNTIL CustLedgEntry.NEXT = 0;
    Replacement code
    Report 120
    DataItem
    Name
    Integer
    TempCustLedgEntryLoop
    Trigger TempCustLedgEntryLoop - OnAfterGetRecord()
    ...........
    CustLedgEntryEndingDate := TempCustLedgEntry;
    CustLedgEntryEndingDate.SETRANGE("Date Filter",0D,EndingDate);
    CustLedgEntryEndingDate.CALCFIELDS(Amount,"Amount (LCY)","Remaining Amount","Remaining Amt. (LCY)");
    IF CustLedgEntryEndingDate."Remaining Amount" = 0 THEN
    CurrReport.SKIP;
    Existing code
    DataItemTable=Table21;
    DataItemTableView=SORTING(Customer No.,Open,Positive,Due Date,Currency Code)
    WHERE(Open=CONST(Yes));
    DataItemVarName=OpenCustLedgEntry;
    OnPreDataItem=BEGIN
    SETRANGE("Posting Date",0D,EndingDate);
    END;

    OnAfterGetRecord=BEGIN

    InsertTemp(OpenCustLedgEntry);
    END;

    Replacement code
    DataItemTable=Table21;
    DataItemTableView=SORTING(Customer No.,Open,Positive,Due Date,Currency Code);

    DataItemVarName=OpenCustLedgEntry;
    OnPreDataItem=BEGIN
    SETRANGE("Posting Date",0D,EndingDate);
    SETRANGE("Date Filter",0D,EndingDate);
    END;

    OnAfterGetRecord=BEGIN
    CALCFIELDS("Remaining Amt. (LCY)");
    IF "Remaining Amt. (LCY)" = 0 THEN
    CurrReport.SKIP;

    InsertTemp(OpenCustLedgEntry);
    END;


    Note Always test code fixes in a controlled environment before you apply the fixes to your production computers.

    Prerequisites

    Restart requirement

    After you have installed the hotfix, and after you have performed any required data repair, you must quit the Microsoft Navision client program. Users must then restart their Microsoft Navision client programs. You do not have to restart Microsoft Windows.

    What Else Does SmartPCFixer Offer You?


    Apart from fixing "Aged Accounts Receivable" (120) report returns wrong information when you apply a payment to more than one invoice in Microsoft Navision problems, SmartPCFixer is designed to provide the user's computer system with better optimization, which helps you manage startup items, desktop, browser objects, Internet, system service, Windows optimization, file extensions and so on. With these sophisticated utilities your system is tuned up to run at the optimal state.


    SmartPCFixer provides you with Registry Backup, System Backup, Favorites Backup and Folder Backup. In addition, the new built-in function of Restore Point enables you to create a system store point so you can recover your system to a previous state if you do not like the changes you have made. This ensures the safety of your system when you run the registry repair process.





    Related: Antivirus Windows Vista,Macromedia Flash Player 11,Download Windows 7 Microsoft,Windows 7 Update,Windows Installer Windows 7
    Read More: ,scanner error 5,best free antivirus windows,tc exe,audio,microsoft upgrades
    posted by Diana at 16:14| Comment(0) | 日記 | 更新情報をチェックする

    How Can I Fix BUG: Long Comments Can Break Object Code Error


    Summary: SQL Enterprise Manager (SEM) and ISQL/w can create objects such as views,
    rules, defaults, stored procedures, or triggers whose object code is
    nonsensical in syscomments if long comments (defined by /* */ or --) exist
    with the object creation script. Recreating the object with this code would
    cause a syntax error. This behavior can be viewed by using the
    corresponding edit object feature in SEM or running sp_helptext on the
    object from any client application. This behavior was seen with a comment
    of 966 to 1010 bytes in size and depends on the length of the object name.



    Solution: Fixing BUG: Long Comments Can Break Object Code errors is a really difficult task for most computer users. In order to fix your errors and speed up PC, it is recommended that your download the 'BUG: Long Comments Can Break Object Code Repair Tool'. This is an advanced optimizing tool the can repair all those problems that are slowing your computer down.



    Install BUG: Long Comments Can Break Object Code Error Fixer Now



    In order to repair BUG: Long Comments Can Break Object Code problem, install SmartPCFixer immediately. This optimization tool is already proven to locate, identify, and fix BUG: Long Comments Can Break Object Code errors. Speed up your PC with SmartPCFixer at once




    Manual Resolutions



    What Else Does SmartPCFixer Offer You?


    Apart from fixing BUG: Long Comments Can Break Object Code problems, SmartPCFixer is designed to provide the user's computer system with better optimization, which helps you manage startup items, desktop, browser objects, Internet, system service, Windows optimization, file extensions and so on. With these sophisticated utilities your system is tuned up to run at the optimal state.


    SmartPCFixer is designed to scan, diagnose and repair your operating system. Using it results in better optimization, manages startup and desktop, assists you with maintaining browser objects, internet options, system service, and repairs file extensions. With this arsenal of powerful, sophisticated utilities your system is tuned to run at its optimal state. Included are Easy Repair Wizard, Error Utilities, File Association fixer, Register ActiveX, Shortcuts Fixer, Winsock2 Repair toolkit, Dll Fixer and more.





    Related: Download Toolbar,Adobe Flash Player Windows,Update Adobe Flash,Get Flash Player,Microsoft Update It Tool
    Read More: ,Windows 98 Usb Memory Stick Drivers,adobe flash professional,msi installer error 1603,error code 35,tc exe
    posted by Diana at 16:13| Comment(0) | 日記 | 更新情報をチェックする

    広告


    この広告は60日以上更新がないブログに表示がされております。

    以下のいずれかの方法で非表示にすることが可能です。

    ・記事の投稿、編集をおこなう
    ・マイブログの【設定】 > 【広告設定】 より、「60日間更新が無い場合」 の 「広告を表示しない」にチェックを入れて保存する。


    ×

    この広告は180日以上新しい記事の投稿がないブログに表示されております。