Results 1 to 5 of 5

Thread: As Of Stock Status Report

  1. #1

    As Of Stock Status Report

    Is there any standard EnterpriseOne report to show itemwise stock status showing quantity, rate and value GL caterogy wise with totals matching with those shown by General Ledger inventory object accounts? I know that there is a table that is updated by As Of processing in Inventory Module, but is there any standard report that you can print therefrom?


  2. #2
    Member
    Join Date
    Mar 2002
    Location
    New Zealand
    Posts
    41

    Re: As Of Stock Status Report

    As you probably guessed from the lack of response, no there is no standard report available which is curious as I would suggest that this is would be std requirement for every site. It is a simple report for you to design, however, as the data fields are all within F41021, level break on GL Class code.

    cheers,
    JohnE
    HP9000 Xe SP22 Update 8

  3. #3
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    701
    I too came across to see if there is any as of inventory reports available.
    I guess, we cannot make one because the F41021 [Item Location File] is not designed to store dates.

    But can we generate the balance from Item Ledger F4111?
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  4. #4
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,247
    Theoretically you can take today's on-hand balances and work backward using F4111.
    In practice there will always be some level of inaccuracy due to the "wobble" factor:
    Failed / partial transaction, sql updates to on hand, ...
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  5. #5
    Member
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    324
    Have a look at Item Ledger by GL Class Code Report
    From manual....
    Select As Of Processing (G4122), Item Ledger by GL Class Report.

    Use the Item Ledger by GL Class Code report (R41541) to review the high-level totals of transactions for specific GL class and category codes. Each line of the report displays a GL classification code total for the fiscal year and period that you specify in the processing options.

    The R41541 program creates the quantity and amounts for the fiscal periods that this program uses.

    Note. It looks at As Of file as per your posting

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