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) | 日記 | 更新情報をチェックする
    この記事へのコメント
    コメントを書く
    コチラをクリックしてください
    ×

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