Sage 100

 View Only
  • 1.  Purchases Clearing from History Report

    Posted 11-17-2022 10:26

    We upgraded a client for Sage 100 version 2022 recently. They are running the Purchases Clearing from History Report and telling us that it does not match the General Ledger Balances.

    Does anyone have clients using this new report? Does it actually work? I see that there are two new tables (listed below). I think are related to this report but I don't know where to even start with troubleshooting the balances on this report. If anyone has any pointers that would be appreciated.  

    ·         PO_ReceiptHistoryAppliedLC

    ·         PO_ReceiptHistoryAppliedPO

    Thanks in Advance.

     

    David Overholt,

    Project  Manager

     

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     

     

     

     

    Outlook Signature Logo

     

    The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by person(s) or entities other than the intended recipient is prohibited.  If you received this in error, please contact the sender and destroy any copies of this information.

     



  • 2.  RE: Purchases Clearing from History Report

    Posted 11-17-2022 11:02
    So far, I've been looking at this report like the Inventory Valuation Report by Period - suspiciously.  Which sucks, because this PC report is REALLY REALLY needed.

    But on the other hand - do we know that the client ran the regular PC report on the last day of those months and it balanced in the first place?

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Purchases Clearing from History Report

    Posted 11-17-2022 11:07

    Well. Great question Beth!  I was assuming that but I should know better. I will find out.

     

     

     

    Do not miss out on our 2022 Sage 100 Year-End Tips Webinar: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 4.  RE: Purchases Clearing from History Report

    Posted 11-17-2022 11:32

    Yes she does balance every month before doing PE closing and locates and corrects any discrepancies each month.

     

     

     

     

    Do not miss out on our 2022 Sage 100 Year-End Tips Webinar: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 5.  RE: Purchases Clearing from History Report

    Posted 11-17-2022 11:17
    I'm guessing that the new report relies on RoI details existing in receipt history, which wasn't added until v2021.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 6.  RE: Purchases Clearing from History Report

    Posted 12-17-2024 13:30

    I searched on the Purchases Clearing From History and this posting is the only hit that I found, so I thought I might refresh it and ask if anyone has clients that are using this report and if it works as expected?  I have not heard any feedback from my clients since this post 2 years ago, so I thought I would ask the group. 

    I also searched Sage KB and did not find any hits there either. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 7.  RE: Purchases Clearing from History Report

    Posted 12-17-2024 14:35

    I personally don't trust it any more than the Inventory Valuation by Period... If clients make no mistakes re dates, then the reports may work, but who among us has perfect clients?



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 8.  RE: Purchases Clearing from History Report

    Posted 12-17-2024 14:55

    I agree, I have not trusted it so far, and to your point even reports like the A/P trial balance are only as good as the users entering data.

     

    However, it would be a huge deal if this report actually did work. I will see if I can round up some Guinea-pig clients during year end this year and have them test it out.  

     

     

    Year-end is around the corner. Be sure to attend our 2024 Sage 100 Year-End Live Webcast: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text  Description automatically generated

     






  • 9.  RE: Purchases Clearing from History Report

    Posted 12-18-2024 08:26

    I have not found the costs in this report to be reliable.



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------