13 Replies Latest reply: May 15, 2014 10:14 AM by Olly Bond RSS

    Struggling with Traps

    JLain _

      I know I need a detail line and either append or footer line but have been terribly unsuccessful creating a table for this report.

       

      Deposit Date     Company Name    Check   Invoice   Payment

      12/3/12            Rufus BBQ            1234   120555    42,000

                                                               129999    12,000

                                                               131000     1,900

       

      So, when I trap as a detail the deposit date, check, invoice and payment amount...any other template for invoice 129999 & 131000 wont bring the data into a report.

      Report table output should look like:

      Deposit Date     Company Name    Check   Invoice   Payment

      12/3/12            Rufus BBQ            1234   120555    42,000

      12/3/12            Rufus BBQ            1234   129999    12,000

      12/3/12            Rufus BBQ            1234   131000     1,900

       

      What am i missing?  The only way thus far to bring in company name and invoice's is when i trap 129999 and get everything below it...but then cant add the company name to these records...it's a vicious circle.

        • Struggling with Traps
          Olly Bond

          Hello,

           

          Is the report really laid out like this?

           

          Deposit Date Company Name Check Invoice Payment

          12/3/12 Rufus BBQ 1234 120555 42,000

          129999 12,000

          131000 1,900[/CODE]

           

          If it's more like

           

          MEDIA QTY  DESCRIPTION                              LABEL/NO.   UNT_PRC   AMOUNT                                                                               

          ORDER NUMBER:  536017    SHIP DATE: 04/08/08                                                                               

          CD      4  Bartok, Sonata for Solo Violin           MK-42625       8.99    35.96   

                  7  Mozart, Mass in C, K.427                 420831-2       9.00    63.00   

                  2  Luening, Electronic Music                CD 611        10.19    20.38 /CODE

           

          then you can use the technique for the Media field in Lesson10.xmod on Classic.prn.

           

          If not, there are tricks, but it would help if you could post your report as it is really formatted.

           

          Best wishes,

           

          Olly

            • Struggling with Traps
              JLain _

              I wished I could copy a screenshot of the report...but it is like I advised not like your second example. The only line with cust name and date and transaction id is the first line and then any subsequent payment on that check or EFT follows.

                • Struggling with Traps
                  JLain _

                  the payment amount and invoice no are in the same column on the report

                    • Struggling with Traps
                      Olly Bond

                      Hello JLain,

                       

                      If you just copy the report from the Report window in Monarch, and paste it into your browser between CODE and /CODE tags with square brackets around them, then we'll see it exactly as Monarch sees it and give you helpful advice. There's a sticky thread on these forums "Tips on posting sample reports properly" that might have more detailed help.

                       

                      Best wishes,

                       

                      Olly

                        • Struggling with Traps
                          JLain _

                          Olly, great tip...unfortunately I must be copy and paste challenged. when I attempt to paste the report nothing happens...just the cursor moves over 1 spot inside the bracket?

                            • Struggling with Traps
                              JLain _

                              Tks Olly...so the idea is to trap all of the records either by trace/chk no or cust name

                               

                                        Deposit                                   Check #        Comp                                                                

                              Lockbox#   Date    Batch #  Company Name            Trace #        Code  SAP Doc #    Invoice #     Payment Amount       Adjustment    

                              -


                                   

                              EFT      12/03/12  000      Cust Name                     1500076417                    9092522337         43,200.00-            0.00                                                                               

                              USEP  0100016139   9092555435          2,400.00             0.00                                                                               

                              STCW  0102876275   9092582041          3,294.96             0.00                                                                               

                              USEP  0100020475   9092588216         13,750.86             0.00                                                                               

                              STCD  0104533557   9092595483         80,943.22             0.00                                                                               

                              STCQ  0100425826   9092581001          5,400.00             0.00                                                                               

                              -


                                                                                                               

                              • CHECK/TRACE TOTAL        62,589.04             0.00                                                                               

                              -


                                   

                                                                                                      

                                  • BATCH TOTAL                   62,589.04             0.00                                                                               

                              -


                                   

                                                                                                 

                                    • PRODUCT TOTAL                     62,589.04             0.00                                                                               

                              ================================   

                              EFT      12/03/12  000      Next Cust Name         22000399122012 STCQ               WSAK111412        224,075.48             0.00                                                                               

                              -


                                                                                                               

                              • CHECK/TRACE TOTAL       224,075.48             0.00                                                                               

                              -


                                   

                                                                                                      

                                  • BATCH TOTAL                  224,075.48             0.00                                                                               

                              -


                                   

                                                                                                 

                                    • PRODUCT TOTAL                    224,075.48             0.00    

                              /QUOTE

                                • Struggling with Traps
                                  Olly Bond

                                  Hello JLain,

                                   

                                  Is this what you're after?

                                   

                                  2012-03-12     000     Cust Name     1500076417     9092522337     EFT     -43200

                                  2012-03-12     000     Cust Name     0100016139     9092555435     USEP     2400

                                  2012-03-12     000     Cust Name     0102876275     9092582041     STCW     3294.96

                                  2012-03-12     000     Cust Name     0100020475     9092588216     USEP     13750.86

                                  2012-03-12     000     Cust Name     0104533557     9092595483     STCD     80943.22

                                  2012-03-12     000     Cust Name     0100425826     9092581001     STCQ     5400[/CODE]

                                   

                                  Best wishes,

                                   

                                  Olly

                                    • Struggling with Traps
                                      JLain _

                                      The report didnt come over like it should..the table format once the traps are working would look like:

                                       

                                      Date - Cust Name - Trace # - Inv # - Amt

                                      12/3/12 - Cust Name 1 - 1500076417 - 9092522337 - (43,200.00)

                                      12/3/12 - Cust Name 1 - 1500076417 (repeated from line above) - 9092555435 - 2,400.00

                                      12/3/12 - Cust Name 1 - 1500076417 - 9092582041 - 3294.96

                                      12/3/12 - Cust Name 1 - 1500076417 - 9092588216 - 13,750.86

                                      12/3/12 - Cust Name 1 - 1500076417 - 9092595483 - 80,943.22

                                      12/3/12 - Cust Name 1 - 1500076417 - 9092581001 - 5,400.00

                                      12/3/12 - Cust Name 2 - 22000399122012 - WSAK111412 - 224,075.48

                                       

                                      You can see the report breaks between record. On the report, the date, cust name, and trace no are all unique to the first line of each new record...the last line above is the beginning of the next new record.  Hope this helps

                                        • Struggling with Traps
                                          Olly Bond

                                          Hello Jlain,

                                           

                                          Aha - that makes it slightly trickier. We need to grab more lines than we want and filter them out using IsAlpha() on the first character. But it's OK, I think.

                                           

                                          2012-03-12     Cust Name     1500076417     9092522337     -43200

                                          2012-03-12     Cust Name     1500076417     9092555435     2400

                                          2012-03-12     Cust Name     1500076417     9092582041     3294.96

                                          2012-03-12     Cust Name     1500076417     9092588216     13750.86

                                          2012-03-12     Cust Name     1500076417     9092595483     80943.22

                                          2012-03-12     Cust Name     1500076417     9092581001     5400

                                          2012-03-12     Next Cust Name     22000399122012     WSAK111412     224075.48[/CODE]

                                           

                                          Is that right?

                                           

                                          Best wishes,

                                           

                                          Olly

                                            • Struggling with Traps
                                              JLain _

                                              Yes.  I feel better on my lack of progress if you think this is a bit tricky to get this data mined.  the trick is collecting between the record breaks as you probably are now aware...thanks again for the help

                                                • Struggling with Traps
                                                  Olly Bond

                                                  Hello JLain,

                                                   

                                                  Clearly, whoever designed that report in your SAP system didn't think anyone might have to one day use the data...

                                                   

                                                  The tricky bit is just around the floating trap - once you get used to how that helps you'll be fine.

                                                   

                                                  Best wishes,

                                                   

                                                  Olly

                                                    • Struggling with Traps
                                                      JLain _

                                                      So I'm not that confident using floating traps...I tried that approach as well on this report and again....failed.

                                                       

                                                      I put the whole sequence of payments in that first entry and highlighted to pull into the trap. I used the date as my floater.

                                                       

                                                      The report is still winning this battle