Skip to Content
author's profile photo Former Member
Former Member

Customer ageing displayed problem

Hi all,

I'm facing again same problem regarding to customer ageing displayed which it displayed wrong data (previuous issue - customer ageing - by posting date). I've upgrade 2005 A PL 11 to PL 45, but now it happen again. what should i do? plz help me.

Edited by: Muhd Mahyuddin Zakaria on Jun 4, 2008 2:46 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2008 at 06:53 AM

    Hi,

    Could you please explain the issue clearly or append the link of the previous thread and that would be easy to answer.

    Regards,

    Venkatesan G.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Thanks for reply. My previuous issue:

      I'm facing the customer ageing which I want to display by posting date (parameter in selection criteria) but the total not accruate. The total ageing already reconciled with payment (amount minus payment = remaining balance).

      Scenario:

      1. Display ageing for as at 31.3.2008

      Ageing date :31.03.2008

      Posting date :1.1.2008 to 31.3.2008

      Total ageing :RM 100,000.00

      2. Payment on 5.4.2008 is RM 50,000.00

      3. 1. Display ageing for as at 14.3.2008

      Ageing date :14.03.2008

      Posting date :1.1.2008 to 31.3.2008

      Total ageing :RM 50,000.00 *

      In accounting normal practise it should be display

      RM 100,000.00 not RM 50,000.

      Problem:

      Now: I tried to displayed by sales document tab and by posting date. but, the end result it will displayed balance after deduction (at 14.3.2008 is OK but when I try to displayed at 31.3.2008 again is not correct which it must show actual amount RM 100,000 not RM 50,000)

      What should I do, thanks for attention.

      Edited by: Muhd Mahyuddin Zakaria on Jun 4, 2008 4:14 PM

  • author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2008 at 08:13 AM

    Dear Mr.Muhd Mahyuddin Zakaria,

    Do you mean the data in Aging report-by posting data is not matched with BP account balance?Would you let me know more detailed information ?

    Best regards,

    Lucy Shen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Uddin,

      Here is the note:

      How to display the Aging reports?

      Symptom

      How to display the Aging reports?

      Other terms

      Aging Report, Customer Receivables Aging, Vendor Liabilities Aging, SBO

      Reason and Prerequisites

      FAQ

      Solution

      Path: Reports => Accounting => Aging => Customer Receivables Aging/

      Vendor Liabilities Aging.

      Code - you can choose a range of customers that will be displayed in the

      report.

      Customer Group - from the drop down menu you can choose the customers

      by the groups they have been assigned to in the BP master data

      Properties - click on Properties in order to filter the customer

      selection by their properties

      Choose All - click this pushbutton in order to display all the customers

      in the report.

      Aging Date - the age of the debts will be calculated according to this

      date. The default date is the computer's date.

      E.g. if you are interested in displaying the debts as they were last

      week, enter the date of last week and the debts will be calculated

      according to the date you have entered.

      Interval/Days - enter a range of days by which you would like to

      divide the display of the debts.

      Posting Date - you can enter a range of posting dates if you wish to

      filter the contents of the report by posting dates

      Due Date - you can enter a range of due dates if you wish to filter the

      contents of the report by due dates

      Due Date by Journal Post. tab page.

      Choose this tab page in order to display the debts of your customers

      including sales documents and journal entries.

      Display BP with Amount Zero - check this box in order to display

      customers whose account balance is currently zero.

      Display Reconciled Transactions - check this box in order to display

      reconciled transactions. If you leave this box cleared, only

      transactions which are not reconciled will be displayed in the report.

      Consider Reconciliation Date - check this box if you wish to consider

      the reconciliation date in the report.

      E.g. if an A/R Invoice is reconciled with an Incoming Payment, but if in

      the range of dates selected for the report, the A/R Invoice was not yet

      reconciled, the report will display this Invoice as open.

      If you leave this box cleared, SAP Business One will check if the

      Invoice was reconciled and will not display the Invoice even if the

      it was not reconciled in the range of dates selected for the report.

      Due Date by Sales Doc. tab page.

      Choose this tab page in order to display the debts of your customers by

      sales documents.

      Display BP with Amount Zero - check this box in order to display

      customers whose account balance is currently zero.

      Display List of Journal Entries - check this box for a detailed display

      of all the journal entries which are not linked to any document.

      If you leave this box cleared, the journal entries will be displayed in

      a single row.

      Note! In case an Invoice has been partially cleared by an Incoming

      Payment, the transactions created by these documents will be displayed

      as fully open when you run the report using Due Date by Journal Post.

      However, if you run the report using Due Date by Sales Doc., the Invoice

      will be displayed with its open amount only.

      Edu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.