Alpha Video Training
Results 1 to 6 of 6

Thread: Expression question

  1. #1
    Member
    Real Name
    Kathleen Matthews
    Join Date
    Aug 2008
    Posts
    12

    Default Expression question

    Hi there,

    I have a problem with a report. Here's the scenario: We built a report that shows Total Production; it's based on the Sales Order Line table. It has a date parameter and shows all items on open sales orders for a specific (transaction) date. We also built Production Line reports. The Production Line is a Custom Field in Inventory attached to each item. The Total Production Report works famously and MOST of the Production Reports work great also. We are having a problem where SOME of the items are not appearing in their appropriate report, even though they have the correct Line # in the Custom Field.

    I checked to be sure we are consistent with the way we are populating the Custom Field.

    The weird thing is the report is not excluding items completely. It appears to miss items on large Sales Orders, but that same item appears on the report - but the total quantity is short.

    Any ideas?

    Kathleen

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Expression question

    Kathleen,
    The Production report I helped you with is NOT based on the transaction date but the due date....unless you changed this filter criteria it very well could be the cause of your problem.

    Just a thought and a possibility to consider....if this is not the cause, then it could very well take someone considerable time to figure out the root cause by going through all the records to see how and when they vary.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  3. #3
    Member
    Real Name
    Kathleen Matthews
    Join Date
    Aug 2008
    Posts
    12

    Default Re: Expression question

    Mike,

    The report was changed from the Due Date to the Transaction Date. They are not consistent with the Due Date and it is being used for something else. They neglected to tell me that until after all 12 reports were built.

    Kathleen

  4. #4
    Member
    Real Name
    Kathleen Matthews
    Join Date
    Aug 2008
    Posts
    12

    Default Re: Expression question

    Mike,

    We have narrowed the problem down to one Item from one Production Line. At this point I am reasonably sure it is data related. The item in question appeared on 7 sales orders but the report excluded the items from 2 of the Sales Orders. The orders excluded were both very large.

    I am going to run this report again at mid point through the day today to see if I can dig a little deeper.

    Kathleen

  5. #5
    Member
    Real Name
    Kathleen Matthews
    Join Date
    Aug 2008
    Posts
    12

    Default Re: Expression question

    Good Afternoon Mike & Keith,

    Although both of you were kind enough to offer assistance; I solved the problem. After spending about an hour trying (in vain) to figure out some methodology as to why the Qty on Sales Order 14686 was included, but the Qty on SO 14698 was not, I decided to build a brand new report.

    Well, the new report works famously - just like all the other reports. Gosh - I just love my job.

    Anyway - the week ended with a happy client, so life is good!!

    Thanks to both of you for your offers of assistance. I will take rain checks :)

    Regards,
    Kathleen

  6. #6
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Expression question

    Good deal Kathleen. There are times like this when it isn't worth figuring out the exact reason, but just being able to figure out how to remedy the problem is enough. You may even find out the reason at a later time.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. Filter Expression Question
    By Tbrondolo in forum Alpha Five Version 8
    Replies: 3
    Last Post: 03-09-2008, 10:16 PM
  2. Ask a Question Expression
    By jpayne in forum Alpha Five Version 8
    Replies: 1
    Last Post: 11-02-2007, 08:22 AM
  3. Expression question ...
    By Rich Hartnett in forum Application Server Version 8
    Replies: 0
    Last Post: 02-27-2007, 01:38 PM
  4. expression question
    By martinwcole in forum Alpha Five Version 5
    Replies: 0
    Last Post: 01-15-2003, 09:24 AM
  5. IF Expression Question
    By Bob Kieffer in forum Alpha Five Version 4
    Replies: 1
    Last Post: 09-09-2000, 05:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •