Results 1 to 7 of 7

Thread: AR Aging an it's categories

  1. #1

    AR Aging an it's categories

    Hello,

    We do invoicing twice a month hence on 15th and last day of the month.

    Currently my aging category are set like this (-15,30,60,90,120,180,365,730)

    I am having issues with my April aging. Invoicing done on 31/03/2017 is being included in 0-30 days buckets whereas it should be in 31-60 days.

    Appreciate your immediate guidance.

  2. #2
    Which aging program are you using? (e.g. R03B4201B)
    What processing options are you using?

  3. #3
    yes I am using R03B4201B

    My processing options are like below

    2. Aging Date=30/04/2017

    3. Date Type=1 (Invoice Date)

    4. Aging method= 1(Aging days)

    5-10. Aging Categories ( -15,30,60,90,120,365)

  4. #4
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    143
    Since you are using aging days it SHOULD be in the 0-30 days since April 30th is 30 days after March 31st. You can maybe change you aging periods from 30 to 29 but then the problem is that you will need to adjust based upon which month you are in. You may need to tweak with your processing options or switch to using fiscal periods.
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.1.4.4, Application RL 9.0
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 58.0.3029.96

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  5. #5
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    143
    Also what are your process options for Aging Tab "#1 Aging Specifications"?
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.1.4.4, Application RL 9.0
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 58.0.3029.96

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  6. #6
    Mike,

    My aging specification is blank means I am using processing options.

    I tested fiscal periods, it works fine but I cannot use it due complex calculation of provisions for certain aging periods when I use R03B155 and I have more aging categories.

    And if I change my days to 29 for the month of April it works fine but disturbs over 120 aging.

    I need to come up with Aging categories solution where exactly two invoices are shown in each month, regardless of 30 or 31 days month.

  7. #7
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    143
    I think fiscal periods would work for you as it was intended to 'group' by your period as defined in the calendar setup.
    But if this is causing issues with provisions then I'm not sure what to tell you.

    What about changing the process option for 'Date Type' and set it to something other than invoice date? Maybe you can use something else like statement date or due date? You can enter the due date at time of entry and use the month ending date or something like that. Just a suggestion...
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.1.4.4, Application RL 9.0
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 58.0.3029.96

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.