Results 1 to 3 of 3

Thread: Any A/R Statements Experts Out There?

  1. #1
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

    Any A/R Statements Experts Out There?

    Issue:
    User (Finance / CFO) wants to be able to rerun statements at any time given a "As Of Date". Fine so far. This issue is that the Statements subsystem doesn't appear to really support reproducing / reprinting a old statement exactly. Specifically the summary and detail shows up under the Previous Balance column rather than what should be current or new invoices column.

    I've determined that the Statement "Reset" feature allows resetting or wiping out statement data in the detail for the last run statement which allows re-running / reprinting the last statement (and only the last run statement) to include any adjustments, etc. But going back and reprinting older statements with numbers in the correct columns doesn't seem to be an option.

    Question:
    Is there a way to reprint a older statement for a customer as of a specific date with the numbers in the columns they should be for that date?

    Thanks for your review of my issue.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246
    Ping

    Anyone?
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    180
    Can't you just use the Review Statements option (P03B202)?

    We generally blow away the statements (R03B5010) prior to monthly running of AR statements (300+) and also use BI Publisher to print the statements.
    We then run new statements and print/email them to our customers.

    Maybe create a custom version of R03B525 to run on-demand for a specific customer where the user plugs in aging and data selection for customer??
    You may need to urge out old entries for this customer prior to re-running this.
    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 62.0.3202.94

    - 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)

Tags for this Thread

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 and, or Oracle.