Sage 100

 View Only

  • 1.  PV'S and PO Clearing best practice

    Posted 02-21-2024 21:25

    Is it true that when you have a purchase variance (PV source journal) it causes your PO clearing GL account to not balance to the PO Clearing report? I've had other posts on this, calls with Sage and now I'm being told that PV's should never be the reason your GL PO Clearing acct does not to tie to the PO Clearing report.  If variances are actually hitting PO Clearing GL acct then there is a setup GL assigned incorrectly, but I don't see that as the case. Looking for some clarification. This all started with trying to figure out the PO Clearing from History report and noticed the variances on there but not on the regular PO clearing report and then saw the variances sitting in the GL PO clearing acct.



    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------


  • 2.  RE: PV'S and PO Clearing best practice

    Posted 02-21-2024 22:25
      |   view attached

    Welcome to the hornet's nest.  Major PITA.  Has the PO Clearing from History ever been vetted?  It is a fairly new report.  I tried using it a couple of times only to bail.  There was a session at the 2014 Summit in Vegas in which resellers and end users vented to Sage.  Crickets.  Attached is a rough draft that I wrote to @Wayne Schulz 22 years ago that outlined my frustration at the time (not much has changed).  PPVs are trapped in the PC GL account until the entire line has been received.  Nothing is written to the GL for special and misc purchase receipts during ROG update, Only when the invoice is processed is the expense posted.  Cleaning up line items is still a PITA.  Bottom line, you have to stay on top of the report for ANY usefulness.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------

    Attachment(s)

    pdf
    POClearingIssues.pdf   66 KB 1 version


  • 3.  RE: PV'S and PO Clearing best practice

    Posted 02-22-2024 08:43

    Unfortunately, the PC from History ranks right up there with the Valuation Report by Period, for me.  If your clients have never made a mistake with incorrect dates, etc, then it might work.  Otherwise - nope.



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

    Original Message


  • 4.  RE: PV'S and PO Clearing best practice

    Posted 02-22-2024 11:27

    The biggest issue I have noticed with the report is that if you have history from before this report was added,  the database is incomplete so you end up getting a lot of old orphaned info.



    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    ------------------------------



  • 5.  RE: PV'S and PO Clearing best practice

    Posted 02-22-2024 12:18

    Look at the data conversion logs from the upgrade where this feature was added.  You'll notice a long list of activity where Sage backwards filled the PO RoI data into the receipt history tables, if the associated AP invoice history existed.  Obviously, that conversion is not seamless, and quite possibly the cause of some complications.

    I haven't worked with the new "from history" report much... when I did once, it was off, but the regular "now" report was fine. 

    *shrugs*



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

    Original Message


Related Content