5 Replies Latest reply: May 15, 2014 9:57 AM by Grant Perkins RSS

    Text files from Great Plains Accounting Software

    mvdiablo _

      When I print a Great Plains report to a .txt file, the format does not look anything like the actual report when I try to open it in Monarch or Notepad. It looks more like a tab delimited file. Since Great Plains is a widely used accounting software, I'm hoping someone can offer some advice on how to use the GP reports in Monarch.

        • Text files from Great Plains Accounting Software
          Bruce _

          If it is in fact a tab delimited file (I have never used GP), you would be better importing as a database. Select file open, database to get started.

           

          You have quite a few options to work through, but start with the delimiters that seem to work best on your file. (tab demilited with or with out comma etc.)

           

          Let us know how you make out.

           

          Cheers

          • Text files from Great Plains Accounting Software
            Data Kruncher

            Opening that file type as a database would be the easiest approach, but that's not an option for you mvdiablo if you don't have Monarch Pro, as your profile would seem to indicate.

             

            Do you have v9 Pro or Standard?

            • Text files from Great Plains Accounting Software
              Grant Perkins

              If you are printing to what should be a text file and it looks OK in notepad.wordpad.word, what sort of fonts are we dealing with here?

               

              If that is not the situation what are the exact settings for the print from GP?

               

               

              Grant

              • Text files from Great Plains Accounting Software
                mvdiablo _

                Not sure if I'm doing this right, but I'm trying to insert a sample of the text file. In response to previous comments, I have v9.0 Pro. Again, the text file bears little resemblance to the report printed to screen in GP.

                 

                [font="courier"]Ranges: From: To: Date: 7/1/2007 7/31/2007 Subtotal By: No Subtotals Include: Posting                                    

                Account: First Last Sorted By: Account Print Currency In:  Functional (Z-US$)                                            

                Account: 1010-0000-00-00  Description: Cash - B of A 9274 (CA Depository) Beginning Balance: ($149,262.46)               

                Trx Date Jrnl No. Orig. Audit Trail Distribution Reference Orig. Master Number Orig. Master Name  Debit Credit                                                                               

                Net Change Ending Balance No transactions for this account                                                             

                Totals: Account: 1010-0000-00-00 $0.00 ($149,262.46) $0.00 $0.00                                                         

                Account: 1020-0000-00-00  Description: Cash - B of A 2636 (CA Payroll) Beginning Balance: $332,481.23                    

                Trx Date Jrnl No. Orig. Audit Trail Distribution Reference Orig. Master Number Orig. Master Name  Debit Credit                                                                               

                Net Change Ending Balance No transactions for this account                                                             

                Totals: Account: 1020-0000-00-00 $0.00 $332,481.23 $0.00 $0.00                                                           

                Account: 1030-0000-00-00  Description: Cash - B of A 9359 (CA A/P) Beginning Balance: $42,522.88                         

                Trx Date Jrnl No. Orig. Audit Trail Distribution Reference Orig. Master Number Orig. Master Name  Debit Credit           

                7/2/2007 81,124 PMCHK00000484 Cash 13612 L.A. County Fire Department   $2,207.00                                         

                7/2/2007 81,126 PMCHK00000485 Cash 13613 Dempsey Business Systems   $5,000.00                                            

                7/2/2007 81,209 PMPAY00000152 Cash 000000004279 AMRESCO Commercial Finance, LLC   $3,999.52                              

                7/3/2007 81,332 PMCHK00000486 Cash 13614 ADT Security Services   $1,887.00                                               

                7/3/2007 81,333 PMCHK00000486 Cash 13615 Blue Shield of California   $11,923.67                                          

                7/3/2007 81,335 PMCHK00000486 Cash 13616 CALIFORNIA ENVIRONMENTAL PROTECTION AGENCY   $7.50                              

                7/3/2007 81,336 PMCHK00000486 Cash 13617 L.A County Tax Collector   $275.00                                              

                7/3/2007 81,337 PMCHK00000486 Cash 13618 Ceridian   $18.76                                                               

                7/3/2007 81,338 PMCHK00000486 Cash 13619 Coast To Coast Produtc   $404.07                                                

                7/3/2007 81,339 PMCHK00000486 Cash 13620 Direct TV   $38.83                                                              

                7/3/2007 81,340 PMCHK00000486 Cash 13621 Equipment Direct   $321.18                                                      

                7/3/2007 81,341 PMCHK00000486 Cash 13622 FedEx   $785.39                                                                 

                7/3/2007 81,342 PMCHK00000486 Cash 13623 G & K Services Corp.   $524.28                                                  

                7/3/2007 81,343 PMCHK00000486 Cash 13624 Irvine Ranch Water District   $97.67                                            

                7/3/2007 81,345 PMCHK00000486 Cash 13625 Kaiser Foundation Health Plan Inc.   $3,649.46                                  

                7/3/2007 81,346 PMCHK00000486 Cash 13626 National Oil & Lube News   $38.00                                               

                7/3/2007 81,347 PMCHK00000486 Cash 13627 Premium Financing Specialists of CA, INC.   $1,936.09                           

                7/3/2007 81,348 PMCHK00000486 Cash 13628 Santa Margarita Water District   $138.33                                        

                7/3/2007 81,349 PMCHK00000486 Cash 13629 Staples Business Advantage   $226.57                                            

                7/3/2007 81,350 PMCHK00000486 Cash 13630 Verizon California   $48.81                                                     

                7/3/2007 81,351 PMCHK00000486 Cash 13631 ZNM Holdings Corp.   $8,417.00                                                  

                  /font[/quote]

                • Text files from Great Plains Accounting Software
                  Grant Perkins

                  Is what we see here what you get as a text file?

                   

                  If so at first sight it looks quite usable as far as Monarch is concerned.

                   

                  Fully formatted reports for graphically aware programs - like screens, Word and so on - will tend to look different since the graphics capability will be absenet. So even simple things like BOLD and italics will be absent. Likewise any fancy line positioning information will be discarded (or at least handled differently) when converted to an approximation of the original in a txt file. Similarly many fonts will not be appropriate or change the appearance and spacing of characters on screen or in a word processor in way that are not available in the simpler text file. (Compare Word with Notepad for example.)

                   

                  I have no idea how GP deals with on screen report 'prints' nor how it then attempts to transcribe them to a text file. However if the original format is important to you you may need to check the GP information about that process. It could be that the TXT export value for a file defaults to the equivalent of a space separated delimited file and there may be other selections possible.

                   

                  Bear in mind that for Monarch purposes it is often much easier to work with files using a simple fixed size character font but that many graphically aware packages will use proportionally spaced fonts to influence the appearance of the output and will 'print' using such fonts. This too will likely affect the look of the report on screen.

                   

                  My personal opinion is that as long as the incoming file is consistent (assuming it will be a repeating task) and usable I don't really care what it looks like in Monarch because I will be transforming the data to something else anyway. In this case the fields do not neatly align to columns  - perhaps because of inconsistent data? - but the spacing looks like it provide for enough to develop a consistent analysis model albeit using a number of calculated fields and slice and dice techniques.

                   

                  There are some exceptions to that approach when manipulating reports which still need to be re-presented in their original format with changes, but in the main as long as the content is accessible the look does not matter much.

                   

                  My thoughts, for what they are worth.

                   

                  HTH.

                   

                   

                  Grant