Open Forum

Expand all | Collapse all

Reports are not pulling the correct information

  • 1.  Reports are not pulling the correct information

    Posted 20 days ago
    I am now running report for the new year (2020), but for some reason when I run January the report is only pulling data from 1/31/2020 and not the whole month.  The report for February isn't correct either.  My fiscal periods are correct.  Any advice?

    ------------------------------
    Janet Flood
    Richard A. Weidel Corporation
    Pennington NJ
    ------------------------------


  • 2.  RE: Reports are not pulling the correct information

    TOP CONTRIBUTOR
    Posted 20 days ago
    Edited by Gerald Buenafe 20 days ago
    Hi Janet,

    What report are we dealing with? Also, how are the reports being generated (GP, Management Reporter, Excel, etc)?

    In case it's a GP - GL trial balance report - summary, see if the same amounts are generated when using the detail version of the report. You can also try comparing the totals of the Summary vs Detail Inquiry windows.

    If the total amounts are different, there might be a need to run the Financial Reconcile* (Year) to have GP recompute the totals.
    * MDGP >> Tools >> Utilities >> Financial >> Reconcile [Year]

    Add: if there were changes made in the Fiscal Period, please run Reconcile so that GP gets to "re-categorize" the transactions based on the period / dates. You will need to run reconcile for Payables and Receivables too.

    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 3.  RE: Reports are not pulling the correct information

    Posted 20 days ago

    Hi Gerald,

     

    I am using Report Designer.

     

    The Summary and Detail inquiries are the same (for the two accounts I checked).

     

    When I run the Income Statement and Trial Balance from Report Designed it is only pulling transactions with a date of 1/31/2020.

     

    Thanks.

     

    Janet Flood

    Controller

     

    Office:  609-737-1522 ext 229

    Fax: 609-737-2052

    jflood@weidel.com

    439 Grand Avenue

    Ewing, NJ  08628

    www.weidel.com

     

    The Way Home | Since 1915

     

    Email Confidentiality Notice: This email transmission and any documents, files or previous email messages attached to it may contain confidential information that is legally privileged.  If you are not the intended recipient or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender.  Please destroy the original transmission and its attachments without reading or saving it in any manner.

     






  • 4.  RE: Reports are not pulling the correct information

    GPUG ALL STAR
    Posted 20 days ago
    @Janet Flood

    Can you send a screenshot of the report options you are using?  In the report, click the report you are using and hit "Modify" so we can see if there are any restrictions.​

    ------------------------------

    ------------------------------



  • 5.  RE: Reports are not pulling the correct information

    TOP CONTRIBUTOR
    Posted 20 days ago
    Edited by Gerald Buenafe 20 days ago

    Hi Janet,

    Since this the report is generated via Management Reporter / Report Designer, could you please provide screenshots of your report building blocks?
    - row definition
    - column definition
    - report definition

    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 6.  RE: Reports are not pulling the correct information

    Posted 20 days ago

     

    Here are screen shots. 

     

    Thanks!

     

     

     

     

    Janet Flood

    Controller

     

    Office:  609-737-1522 ext 229

    Fax: 609-737-2052

    jflood@weidel.com

    439 Grand Avenue

    Ewing, NJ  08628

    www.weidel.com

     

    The Way Home | Since 1915

     

    Email Confidentiality Notice: This email transmission and any documents, files or previous email messages attached to it may contain confidential information that is legally privileged.  If you are not the intended recipient or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender.  Please destroy the original transmission and its attachments without reading or saving it in any manner.

     






  • 7.  RE: Reports are not pulling the correct information

    TOP CONTRIBUTOR
    Posted 20 days ago
    Hi Janet,

    Thanks for the screenshots. Out of curiosity, which column/s are showing the correct/incorrect values anyway?

    By the way, if you use the GP GL - Trial Balance and set it to use a Date range from 01/01/2020 to 01/31/2020 for Open year 2020... do you get the 'target' result - or is the result similar to what is generated in MR?


    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------



  • 8.  RE: Reports are not pulling the correct information

    Posted 20 days ago

    Hi Ryan,

     

    2020 is not correct, but 2019 appears to be correct.  It also doesn't work for my other income statements reports.

     

    When I run a summary TB Summary the numbers are correct.  Looking further, if I click in to the detail and open up the financial transaction this is what I get as an example:

     

    8160-0200 FEDERAL EXP

    642119000 01/07/19 1/7/2019

    0

    642828345 01/14/19 1/14/2019

    0

    643606201 01/21/19 1/21/2019

    0

    644305387 01/28/19 1/28/2019

    0

    644891125 02/04/19 1/31/2019

    0

    689505337 01/13/20 1/13/2020

    106.86

    690245925 01/20/20 1/20/2020

    183.61

    690847511 01/27/20 1/27/2020

    144.82

    691523862 02/03/20 1/31/2020

    110.07

     

    Why is something from 2019 there and not everything from 2020?  There should be another transfer from 1/6/2020 that is not showing.

     

    Anything that only has transactions dated 1/31/2020 is fine.

     

    I ran 2019 reports and they tie to what I have saved.

     

    Is there something in GP itself that is causing the problem?  I did close out all the modules for 2019 but all my balances rolled forward correctly and I previously opened the new fiscal periods.

     

    Janet Flood

    Controller

     

    Office:  609-737-1522 ext 229

    Fax: 609-737-2052

    jflood@weidel.com

    439 Grand Avenue

    Ewing, NJ  08628

    www.weidel.com

     

    The Way Home | Since 1915

     

    Email Confidentiality Notice: This email transmission and any documents, files or previous email messages attached to it may contain confidential information that is legally privileged.  If you are not the intended recipient or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender.  Please destroy the original transmission and its attachments without reading or saving it in any manner.

     






  • 9.  RE: Reports are not pulling the correct information

    Posted 20 days ago

    I know why 2019 is there.  My report pulls current year and prior year.  It's there for the prior year information.

     

    Janet Flood

    Controller

     

    Office:  609-737-1522 ext 229

    Fax: 609-737-2052

    jflood@weidel.com

    439 Grand Avenue

    Ewing, NJ  08628

    www.weidel.com

     

    The Way Home | Since 1915

     

    Email Confidentiality Notice: This email transmission and any documents, files or previous email messages attached to it may contain confidential information that is legally privileged.  If you are not the intended recipient or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED.  If you have received this transmission in error, please immediately notify the sender.  Please destroy the original transmission and its attachments without reading or saving it in any manner.

     






If you've found this thread useful, dive deeper into User Group community content by role