7 Replies Latest reply: May 15, 2014 10:02 AM by Grant Perkins RSS

    Null Value

    francisco _

      Good morning. This is my first time in this forum and new in Monarch.

      I started to use it the day before yesterday after a was told this program can help me solve lots of problems with reports, excell, and other kisnd of documents.

       

      Well I started to use it and I got this far, but cann't seems to figure out why I am getting this null value.

       

      Doc_ID     Ref Date     PO Date     PO Number     Req PO date     Item Number     UPC Number

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805894K     Jul.  4, 2008     72565250331     

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805894K     Jul.  4, 2008     72565250539     788904114770

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805894K     Jul.  4, 2008     72565270091     788904114749

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805894K     Jul.  4, 2008     72565270299     788904114732

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805894K     Jul.  4, 2008     72565270497     788904114794

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565260067     788904114763

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565260265     788904114725

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565260463     788904114787

      08188100727     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565270091     788904114756

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565270299     788904114732

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     1805902K     Jul.  4, 2008     72565270497     788904114794

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     5290408R     Jul.  4, 2008     72565250133     788904114763

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5290416R     Jul.  4, 2008     72565250133     788904114718

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5290416R     Jul.  4, 2008     72565260067     788904114718

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5290416R     Jul.  4, 2008     72565270091     788904114725

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5290440R     Jul.  4, 2008     72566310265     788904114732

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300140C     Jul.  4, 2008     72565250331     788904110185

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300140C     Jul.  4, 2008     72565250539     788904114770

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300140C     Jul.  4, 2008     72565270299     788904114749

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300140C     Jul.  4, 2008     72565270497     788904114794

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565250133     788904114763

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565260067     788904114718

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565260265     788904114725

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565260463     788904114787

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565270091     788904114756

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565270299     788904114732

      08188100727     Jul.  6, 2008     Jun. 21, 2008     5300157C     Jul.  4, 2008     72565270497     788904114794

      08188100727     Jul.  6, 2008     Jun. 21, 2008     6387302H     Jul.  4, 2008     72565250133     788904114763

      08188100727     Jul.  6, 2008     Jun. 21, 2008     6387302H     Jul.  4, 2008     72565270091     788904114718

      08188100727     Jul.  6, 2008     Jun. 21, 2008     6387310H     Jul.  4, 2008     72565260067     788904114732

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     6387310H     Jul.  4, 2008     72565260265     788904114725

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     6387310H     Jul.  4, 2008     72565260463     788904114787

      08188100727 LEVEL     Jul.  6, 2008     Jun. 21, 2008     6387310H     Jul.  4, 2008     72565270091     788904114756

       

       

      The first line on the last colums keep getting "Null Value"

      There are other issues that I want to find out how to fix them like avoiding the repetitious values like Doc_ID, PO_Date, and PO_#

       

      The final output file should look like this:

      PO#     Order Date     Requested Ship Date     Dep #     Vendor #     Item #     UPC#

      1805894K     6/21/2008     7/4/2008     725     6288     72565250331     788904114770

                               72565250539     788904114749

                               72565270091     788904114732

                               72565270299     788904114794

                               72565270497     788904114763

      1805902K     6/21/2008     7/4/2008     725     6288     72565260067     788904114725

                               72565260265     788904114787

                               72565260463     788904114756

                               72565270091     788904114732

                               72565270299     788904114794

                               72565270497     788904114763

      5290408R     6/21/2008     7/4/2008     725     6288     72565250133     788904114718

      5290416R     6/21/2008     7/4/2008     725     6288     72565250133     788904114718

                               72565260067     788904114725

                               72565270091     788904114732

      5290440R     6/21/2008     7/4/2008     725     6288     72566310265     788904110185

      5300140C     6/21/2008     7/4/2008     725     6288     72565250331     788904114770

                               72565250539     788904114749

                               72565270299     788904114794

                               72565270497     788904114763

      5300157C     6/21/2008     7/4/2008     725     6288     72565250133     788904114718

                               72565260067     788904114725

                               72565260265     788904114787

                               72565260463     788904114756

                               72565270091     788904114732

                               72565270299     788904114794

                               72565270497     788904114763

      6387302H     6/21/2008     7/4/2008     725     6288     72565250133     788904114718

                               72565270091     788904114732

      6387310H     6/21/2008     7/4/2008     725     6288     72565260067     788904114725

                               72565260265     788904114787

                               72565260463     788904114756

                               72565270091     788904114732

       

       

      Any ideas or sggestions, I will really, really appreciate!

      I wanted to include the report file and the templetes I did but seems I can't upload them here.

       

      Have a great day!!!!!

       

      Francisco

        • Null Value
          Data Kruncher

          Hi Francisco, and welcome to the forum and the wonderful world of Monarch.

           

          While you cannot attach files to the forum, you can [URL="http://www.monarchforums.com/showthread.php?t=2290"]post samples of your report[/URL]. This really helps to figure out the best ways to handle problems.

           

          Seeing that you're extracting most of your UPC numbers (which are likely numeric fields) seemingly properly, I'd speculate that the first UPC number contains a letter. It might be something tricky to spot, like a letter O instead of a zero. Monarch wouldn't be able to derive a numeric value in that case, and would give you a null value.

           

          As to the others that are duplicating values from prior records, you can change the Empty Cells option for the field from "Copy value from previous record" to "Leave blank".

           

          If you can post a sample of your report using the CODE tags, we'll be better able to assist.

           

          HTH,

          Kruncher

          • Null Value
            Grant Perkins

            Good morning. This is my first time in this forum and new in Monarch.

            I started to use it the day before yesterday after a was told this program can help me solve lots of problems with reports, excell, and other kisnd of documents.

             

            Well I started to use it and I got this far, but cann't seems to figure out why I am getting this null value.

            Doc_ID    Ref Date    PO Date    PO Number    Req PO date    Item Number    UPC Number

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805894K    Jul. 4, 2008    72565250331   

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805894K    Jul. 4, 2008    72565250539    788904114770

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805894K    Jul. 4, 2008    72565270091    788904114749

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805894K    Jul. 4, 2008    72565270299    788904114732

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805894K    Jul. 4, 2008    72565270497    788904114794

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565260067    788904114763

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565260265    788904114725

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565260463    788904114787

            08188100727    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565270091    788904114756

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565270299    788904114732

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    1805902K    Jul. 4, 2008    72565270497    788904114794

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    5290408R    Jul. 4, 2008    72565250133    788904114763

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5290416R    Jul. 4, 2008    72565250133    788904114718

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5290416R    Jul. 4, 2008    72565260067    788904114718

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5290416R    Jul. 4, 2008    72565270091    788904114725

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5290440R    Jul. 4, 2008    72566310265    788904114732

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300140C    Jul. 4, 2008    72565250331    788904110185

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300140C    Jul. 4, 2008    72565250539    788904114770

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300140C    Jul. 4, 2008    72565270299    788904114749

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300140C    Jul. 4, 2008    72565270497    788904114794

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565250133    788904114763

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565260067    788904114718

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565260265    788904114725

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565260463    788904114787

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565270091    788904114756

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565270299    788904114732

            08188100727    Jul. 6, 2008    Jun. 21, 2008    5300157C    Jul. 4, 2008    72565270497    788904114794

            08188100727    Jul. 6, 2008    Jun. 21, 2008    6387302H    Jul. 4, 2008    72565250133    788904114763

            08188100727    Jul. 6, 2008    Jun. 21, 2008    6387302H    Jul. 4, 2008    72565270091    788904114718

            08188100727    Jul. 6, 2008    Jun. 21, 2008    6387310H    Jul. 4, 2008    72565260067    788904114732

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    6387310H    Jul. 4, 2008    72565260265    788904114725

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    6387310H    Jul. 4, 2008    72565260463    788904114787

            08188100727 LEVEL    Jul. 6, 2008    Jun. 21, 2008    6387310H    Jul. 4, 2008    72565270091    788904114756[/code]

             

             

            The first line on the last colums keep getting "Null Value"

            There are other issues that I want to find out how to fix them like avoiding the repetitious values like Doc_ID, PO_Date, and PO_#

             

            The final output file should look like this:

             

            PO# Order Date Requested Ship Date Dep # Vendor # Item # UPC#

            1805894K 6/21/2008 7/4/2008 725 6288 72565250331 788904114770

            72565250539 788904114749

            72565270091 788904114732

            72565270299 788904114794

            72565270497 788904114763

            1805902K 6/21/2008 7/4/2008 725 6288 72565260067 788904114725

            72565260265 788904114787

            72565260463 788904114756

            72565270091 788904114732

            72565270299 788904114794

            72565270497 788904114763

            5290408R 6/21/2008 7/4/2008 725 6288 72565250133 788904114718

            5290416R 6/21/2008 7/4/2008 725 6288 72565250133 788904114718

            72565260067 788904114725

            72565270091 788904114732

            5290440R 6/21/2008 7/4/2008 725 6288 72566310265 788904110185

            5300140C 6/21/2008 7/4/2008 725 6288 72565250331 788904114770

            72565250539 788904114749

            72565270299 788904114794

            72565270497 788904114763

            5300157C 6/21/2008 7/4/2008 725 6288 72565250133 788904114718

            72565260067 788904114725

            72565260265 788904114787

            72565260463 788904114756

            72565270091 788904114732

            72565270299 788904114794

            72565270497 788904114763

            6387302H 6/21/2008 7/4/2008 725 6288 72565250133 788904114718

            72565270091 788904114732

            6387310H 6/21/2008 7/4/2008 725 6288 72565260067 788904114725

            72565260265 788904114787

            72565260463 788904114756

            72565270091 788904114732[/code]

             

             

             

            Any ideas or sggestions, I will really, really appreciate!

            I wanted to include the report file and the templetes I did but seems I can't upload them here.

             

            Have a great day!!!!!

             

            Francisco[/quote]

             

            Original post with CODE tags as requested by Kruncher!

             

            Some records have the word LEVEL in the row. What does that signify? Does it throw out the column definitions?

             

            How are you going about setting the trap and template definition for the records?

             

             

            Grant

              • Null Value
                francisco _

                Thank you Grant!

                Here is the fixed report. You were right about the "LEVEL" thing. I actually noticed right after I posted the note but I was able to fix that right away.

                 

                Doc_ID     Ref Date     PO Date     PO Number     Req PO date     Item Number     UPC Number

                08188100727     2008-07-06     2008-06-21     1805894K     2008-07-04     72565250331     

                08188100727     2008-07-06     2008-06-21     1805894K     2008-07-04     72565250539     788904114770

                08188100727     2008-07-06     2008-06-21     1805894K     2008-07-04     72565270091     788904114749

                08188100727     2008-07-06     2008-06-21     1805894K     2008-07-04     72565270299     788904114732

                08188100727     2008-07-06     2008-06-21     1805894K     2008-07-04     72565270497     788904114794

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565260067     788904114763

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565260265     788904114725

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565260463     788904114787

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565270091     788904114756

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565270299     788904114732

                08188100727     2008-07-06     2008-06-21     1805902K     2008-07-04     72565270497     788904114794

                08188100727     2008-07-06     2008-06-21     5290408R     2008-07-04     72565250133     788904114763

                08188100727     2008-07-06     2008-06-21     5290416R     2008-07-04     72565250133     788904114718

                08188100727     2008-07-06     2008-06-21     5290416R     2008-07-04     72565260067     788904114718

                08188100727     2008-07-06     2008-06-21     5290416R     2008-07-04     72565270091     788904114725

                08188100727     2008-07-06     2008-06-21     5290440R     2008-07-04     72566310265     788904114732

                08188100727     2008-07-06     2008-06-21     5300140C     2008-07-04     72565250331     788904110185

                08188100727     2008-07-06     2008-06-21     5300140C     2008-07-04     72565250539     788904114770

                08188100727     2008-07-06     2008-06-21     5300140C     2008-07-04     72565270299     788904114749

                08188100727     2008-07-06     2008-06-21     5300140C     2008-07-04     72565270497     788904114794

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565250133     788904114763

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565260067     788904114718

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565260265     788904114725

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565260463     788904114787

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565270091     788904114756

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565270299     788904114732

                08188100727     2008-07-06     2008-06-21     5300157C     2008-07-04     72565270497     788904114794

                08188100727     2008-07-06     2008-06-21     6387302H     2008-07-04     72565250133     788904114763

                08188100727     2008-07-06     2008-06-21     6387302H     2008-07-04     72565270091     788904114718

                08188100727     2008-07-06     2008-06-21     6387310H     2008-07-04     72565260067     788904114732

                08188100727     2008-07-06     2008-06-21     6387310H     2008-07-04     72565260265     788904114725

                08188100727     2008-07-06     2008-06-21     6387310H     2008-07-04     72565260463     788904114787

                08188100727     2008-07-06     2008-06-21     6387310H     2008-07-04     72565270091     788904114756[/QUOTE]

                 

                The problem I'm still having is the "null value" I'm not sure why it keeps giving the null value just in that first field.

                 

                After two days playing with the software without having any experience in this, I think I have accomplih what I wanted.

                Yesterday I spoke with someone who had little bet of exposure to this software and told me I could actually make Monarch to create an excell file that will contain my data and some hardcoded data as well.

                So how would I be able to do this?

                I would like to add two fileds, Dep_No and Vendor_No. both will have a hard code value of 725 and 002688?

                Something like this...

                 

                Doc_ID     Dep_No     Vendor_No     Ref Date     PO Date     PO Number     Req PO date     Item Number     UPC Number

                08188100727     725     2268     7/6/2008     6/21/2008     1805894K     7/4/2008     72565250331     

                08188100727     725     2268     7/6/2008     6/21/2008     1805894K     7/4/2008     72565250539     788904114770

                08188100727     725     2268     7/6/2008     6/21/2008     1805894K     7/4/2008     72565270091     788904114749

                08188100727     725     2268     7/6/2008     6/21/2008     1805894K     7/4/2008     72565270299     788904114732

                08188100727     725     2268     7/6/2008     6/21/2008     1805894K     7/4/2008     72565270497     788904114794

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565260067     788904114763

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565260265     788904114725

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565260463     788904114787

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565270091     788904114756

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565270299     788904114732

                08188100727     725     2268     7/6/2008     6/21/2008     1805902K     7/4/2008     72565270497     788904114794

                08188100727     725     2268     7/6/2008     6/21/2008     5290408R     7/4/2008     72565250133     788904114763

                08188100727     725     2268     7/6/2008     6/21/2008     5290416R     7/4/2008     72565250133     788904114718

                08188100727     725     2268     7/6/2008     6/21/2008     5290416R     7/4/2008     72565260067     788904114718

                08188100727     725     2268     7/6/2008     6/21/2008     5290416R     7/4/2008     72565270091     788904114725

                08188100727     725     2268     7/6/2008     6/21/2008     5290440R     7/4/2008     72566310265     788904114732

                08188100727     725     2268     7/6/2008     6/21/2008     5300140C     7/4/2008     72565250331     788904110185

                08188100727     725     2268     7/6/2008     6/21/2008     5300140C     7/4/2008     72565250539     788904114770

                08188100727     725     2268     7/6/2008     6/21/2008     5300140C     7/4/2008     72565270299     788904114749

                08188100727     725     2268     7/6/2008     6/21/2008     5300140C     7/4/2008     72565270497     788904114794

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565250133     788904114763

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565260067     788904114718

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565260265     788904114725

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565260463     788904114787

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565270091     788904114756

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565270299     788904114732

                08188100727     725     2268     7/6/2008     6/21/2008     5300157C     7/4/2008     72565270497     788904114794

                08188100727     725     2268     7/6/2008     6/21/2008     6387302H     7/4/2008     72565250133     788904114763

                08188100727     725     2268     7/6/2008     6/21/2008     6387302H     7/4/2008     72565270091     788904114718

                08188100727     725     2268     7/6/2008     6/21/2008     6387310H     7/4/2008     72565260067     788904114732

                08188100727     725     2268     7/6/2008     6/21/2008     6387310H     7/4/2008     72565260265     788904114725

                08188100727     725     2268     7/6/2008     6/21/2008     6387310H     7/4/2008     72565260463     788904114787

                08188100727     725     2268     7/6/2008     6/21/2008     6387310H     7/4/2008     72565270091     788904114756[/QUOTE]

                 

                Hope you have a great weekend!!!!!!

                Thanks in advance!

                Francisco

                  • Null Value
                    francisco _

                    I forgot to include the original report!

                     

                     

                    From:  JCPENNEY869                                                             

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                    DOCUMENT HEADER                      ST                                        

                      Transaction Set Identifier Code    869                                                                               

                    BEGIN SEGMNT FOR ORDER STATUS INQUR  BSI                                       

                      Inquiry Reference Number           08188100727                               

                      Inquiry Reference Date             Jul.  6, 2008                             

                      Order/Item Code                    Selected Orders - Selected Items                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              1805894K                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250331                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114770                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250539                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114749                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270299                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114794                                                                               

                    HIERARCHICAL LEVEL                   HL                                                                               

                    From:PrJCPENNEY869 7, 2008                                              Page: 1

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270497                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114763                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              1805902K                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260067                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114725                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260265                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114787                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260463                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114756                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    From:PrJCPENNEY869 7, 2008                                              Page: 2

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270299                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114794                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270497                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114763                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              5290408R                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250133                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114718                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              5290416R                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                    From:PrJCPENNEY869 7, 2008                                              Page: 3

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250133                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114718                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260067                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114725                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              5290440R                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72566310265                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904110185                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              5300140C                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                             

                    From:PrJCPENNEY869 7, 2008                                              Page: 4

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250331                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114770                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250539                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114749                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270299                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114794                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270497                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114763                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              5300157C                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                                                               

                    From:PrJCPENNEY869 7, 2008                                              Page: 5

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250133                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114718                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260067                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114725                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260265                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114787                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260463                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114756                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270299                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114794                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270497                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                    From:PrJCPENNEY869 7, 2008                                              Page: 6

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                      Product/Service ID                 788904114763                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              6387302H                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565250133                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114718                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Level Code            Order                                                                               

                    PURCHASE ORDER REFERENCE             PRF                                       

                      Purchase Order Number              6387310H                                  

                      Purchase Order Date                Jun. 21, 2008                                                                               

                    DATE/TIME REFERENCE                  DTM                                       

                      Date/Time Qualifier                Requested Ship                            

                      Date                               Jul.  4, 2008                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Department Number                         

                      Reference Identification           725                                                                               

                    REFERENCE IDENTIFICATION             REF                                       

                      Reference Identification Qualifier Internal Vendor Number                    

                      Reference Identification           006288                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260067                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114725                              

                    From:PrJCPENNEY869 7, 2008                                              Page: 7

                    Document Type: 869 Order Status Inquiry    Version: 004030                     

                    Document ID: 08188100727                   TEST DOCUMENT                       

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260265                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114787                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565260463                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114756                                                                               

                    HIERARCHICAL LEVEL                   HL                                        

                      Hierarchical Identification No.                                              

                      Hierarchical Parent ID Number                                                

                      Hierarchical Level Code            Item                                                                               

                    ITEM IDENTIFICATION DETAIL           LIN                                       

                      Product/Service ID Qualifier       Buyer's Item Number                       

                      Product/Service ID                 72565270091                               

                      Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                      Product/Service ID                 788904114732                                                                               

                    TRANSACTION TOTALS                   CTT                                       

                      Number of Line Items               42                                                                               

                    DOCUMENT TRAILER                     SE                                         /CODE

                     

                     

                    I'm not usre if the report format is my problem!

                     

                    Have a great weekend!!!!!!

                    Francisco

                    • Null Value
                      Grant Perkins

                      Francisco,

                       

                      Looks like the last column in your fist line has no value.

                       

                      Assuming Monarch's field for that column is defined as a NUMERIC field a blank value is invalid and will return a NULL. In the OPTIONS you can can specify how you want nulls to display BUT, without further work to adapt the field, you cannot use the displayed value for calcualtions.

                       

                      However, in this case it looks like you are just dealing with a reference code that happens to be numeric. If you never use the value in the field for calculations you can make it a CHARACTER field instead and then a blank field would be OK. By default Monarch would decide that the column seems to be a numeric column but you can override easily when required.

                       

                      That said I THINK you have a problem with the extraction. It's not easy to be sure (I will check some more) as it looks like the last posted sample data start point may not be the same as the 'extracted' sample example BUT I think your ITEM NUMBER and UPC NUMBER values are coming from different records. If so that might explain why you have a blank UPC field for the first record ...that record's UPC number seems to appear in the second record. I'm guessing you have a problem with an Append trap somewhere and maybe don't need the append anyway.

                       

                       

                      As for the fixed value fields. Extract what you can from the report into the table. The in the table window set up some calculated fields, one for each of the fields you want and simply enter the values you want to display as the formula. For example "725".

                       

                      If this might vary from one running of the model the next you could make it a User Entered field to be prompted for whenever the report/model is loaded.

                       

                      Having said that the two value you mention seem to be in the report at the top in among the headers - so you can simply pull them from there using an append or maybe two appends if that would be easier. (One or two is a decision to be made dependent on the format and structure of the full report.

                       

                      REFERENCE IDENTIFICATION             REF                                       

                        Reference Identification Qualifier Department Number                         

                        Reference Identification           725                                       

                       

                      REFERENCE IDENTIFICATION             REF                                       

                        Reference Identification Qualifier Internal Vendor Number                    

                        Reference Identification           006288                                 

                      /code

                       

                      Looks like a PAGE HEADER template of 3 rows on any row that prints a page number over on the right would also be a useful idea. since some sections of the report seem to split either side of the page breaks and this can be troublesome sometimes. PAGE HEADER templates are 'invisible' areas to the processes working with other templates so the three line would be igniored by the other process but not by any part of the PAGE HEADER template processing.

                       

                      Does this help at all?

                       

                       

                      Grant

                        • Null Value
                          francisco _

                          Hi Grant!

                          Hope you had a great weekend!

                          After I read your reply, for some reason that I don't know, I change the type of templetes I had in my model.

                          See, all the templetes were append and only one was detail. The detail one was for the item #. What I did was:

                          first I change the item # templete from detail and I made it append.

                          then I changed the UPC templedte from append to detail

                          and there it was. the null value went away and now I can see my upc#.

                          I would like to know why or how this works so I can determine the type of templete I need to use.

                          I read the chapter 1 and 2 and I theorically understand the concept or I think I understand.

                          A header templete for something that repeats in every page

                          A append templete for things associated to details.

                          A detail templete for all the details in you report

                          A footer for totals.

                           

                          Can you add more than one detail templete in one single model?

                           

                          Thanks

                          Francisco

                            • Null Value
                              Grant Perkins

                              Hi Francisco,

                               

                              It sounds like you have a resolution.

                               

                              You can only have one detail template and you must have a detail template - it represents the lowest level of detail you need from the report. Usually that would the lowest level of the report heirarchy, as in this case.

                               

                              The report layout is unusually confusing to the point of being almost unreadable 'at a glance'.

                               

                              But to me your detail will be the 'Items'. Basically this block:

                               

                              HIERARCHICAL LEVEL                   HL                                        

                                Hierarchical Identification No.                                              

                                Hierarchical Parent ID Number                                                

                                Hierarchical Level Code            Item                                      

                               

                              ITEM IDENTIFICATION DETAIL           LIN                                       

                                Product/Service ID Qualifier       Buyer's Item Number                       

                                Product/Service ID                 72565250331                               

                                Product/Service ID Qualifier       U.P.C. Consumer Package Co                

                                Product/Service ID                 788904114770                             

                               

                              /code

                               

                               

                               

                              Appends should always be related to data ABOVE the detail record. (There are some exceptions to this in terms of where the data to be captured might be BUT the TRAP for an APPEND template must always be above or equal to the trap for the detail template. Your sample report does not seem to need any 'special' processing for unusual append requirements so we can leave that for now.)

                               

                              Your APPENDS will be from:

                               

                              HIERARCHICAL LEVEL                   HL                                        

                                Hierarchical Identification No.                                              

                                Hierarchical Level Code            Order                                     

                               

                              PURCHASE ORDER REFERENCE             PRF                                       

                                Purchase Order Number              1805894K                                  

                                Purchase Order Date                Jun. 21, 2008                             

                               

                              DATE/TIME REFERENCE                  DTM                                       

                                Date/Time Qualifier                Requested Ship                            

                                Date                               Jul.  4, 2008                             

                               

                              REFERENCE IDENTIFICATION             REF                                       

                                Reference Identification Qualifier Department Number                         

                                Reference Identification           725                                       

                               

                              REFERENCE IDENTIFICATION             REF                                       

                                Reference Identification Qualifier Internal Vendor Number                    

                                Reference Identification           006288                                  

                              /code

                               

                              I am assuming here that an order reference will always relate to a single Internal Vendor Number and Qualifier department number and that this set of references is really one consistent set. If so they can be treated as a single append. If there can be variation then they may need to be separated into individual appends.

                               

                              Footers will always need to grab any data they contain using a trap that starts AFTER a detail record or set of detail records. So yes, if you want subtotals they will come lower in the report (usually - people have seen exceptions to that concept!)

                               

                              Page Header templates are pretty much as you describe them but also have some special properties which are useful if the report splits records across page breaks - as your does. So even if you don't need any data from the page header area you can still create a Page Header template without aby fields so that those lines are not seen by the other templates.

                               

                              I always think the first task, before starting a model for a new report, is to get to fully understand the heirarchical structure of the data in the report AS YOU NEED TO READ IT - which may not be quite the same as the way the report is formatted, although usually it will be close or you will need to consider how to re-structure it before you can analyse it.

                               

                              So in this case the order items are the lowest level of detail. Next UP would be the order header detail. And then maybe something form the first few lines of the report header page in this case although there is nothing there I would definitiely see as being a requirement.

                               

                              If you have started with the Learning guide I would recommend working through to chapter 10 or thereabouts as the journey will help with familiarisation as well as features and usage methods. Then use the other chapters as they become relevant to your needs.

                               

                              Or if you have an opportunity to take a training course, use it. Well worth the time and investment.

                               

                              HTH.

                               

                               

                               

                              Grant