Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Makati City, Philippines
    Posts
    14

    Red face Unanswered: Need help with S.I. / O.R. Report

    hi there,

    i'm having a slight problem with one of my reports on Sales Invoice / Official Receipt report esp. on the Totals. Here's an example.

    Transactions SI Amount OR Amount
    1,600 1,600
    2,500 3,750
    1,250 (hide duplicates = true)
    480 480
    TOTALS 5,830 9,580 (diff. is the hidden value of 3,750)

    how do i resolve this, your help will be highly appreciated. thank you very much in advance.

    ReggieSter c",)

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Please clarify your request.

  3. #3
    Join Date
    Nov 2003
    Location
    Makati City, Philippines
    Posts
    14
    Sorry Teddy,

    what i would like to know is how do i tally both total amounts. the amounts don't tally because OR-002 has two OR amounts considered. this btw is a report. thank you very much in advance.

    OR No Transaction Details SI Amount OR Amount
    OR-001 1,600 1,600
    OR-002 2,500 3,750
    OR-002 1,250 (hide duplicates = true)
    OR-003 480 480
    TOTALS 5,830 9,580 (diff. is the hidden value of 3,750)


    Originally posted by Teddy
    Please clarify your request.

Posting Permissions

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