Sage 100

 View Only

  • 1.  AR_CustomerSalesHistory wrong

    Posted 05-07-2019 10:15
    Hello,
     I have a client with a customer that has a wrong Sales total amount for one just period - April 2019. Jan, Feb, Mar & so far May are correct. The COGS is correct for each month, including April, but not the Sales total. The SO_SalesHistory table is correct & matches the AR_InvoiceHistory tables, but the bucket from AR_CustomerSalesHistory for 04/2019 is not. It is causing a negative profit for this one month.  I can't find another customer that is wrong, but I can't rule out that there are not more. I know I can just fix that amount displayed in Customer Maintenance or DFDM, but why or how would this happen? I can't narrow it down to a certain day or group of invoices or anything. I also don't see any kind of Customer History Recalc utility like IM has to grab any others that I haven't found. Any insight?  Thx!

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------


  • 2.  RE: AR_CustomerSalesHistory wrong

    Posted 05-07-2019 16:33
    If you determine it's off by the sales tax amount, that was a thing. What year and what version, and are there 3rd party add-ons like Avalara?

    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------



  • 3.  RE: AR_CustomerSalesHistory wrong

    Posted 05-07-2019 16:44
    No sales tax for any customers. They are on v2016 PU5, no large enhancements. They have 1 DSD add-on for multiple item aliases, but nothing like Avalara. They use StarShip for shipping.

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------

    Original Message


  • 4.  RE: AR_CustomerSalesHistory wrong

    Posted 05-07-2019 17:01
    Edited by Kevin Moyes 05-07-2019 17:06
    SO_SalesHistory is by PL, meaning no misc items / charges... but AR_CustomerSalesHistory does include misc items / misc charges.  Perhaps someone posted a /M credit to that month?

    Edit: corrected in next reply.

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

    Original Message


  • 5.  RE: AR_CustomerSalesHistory wrong

    Posted 05-07-2019 17:06

    There is an Customer history recalculation utility out in the community that will recalculate the Customer Sales History  ARAPFX.V1.1.

     

    If you want to see if it was a bad post you can copy the  company and recalculate to see if it fixes it.

     

     

    Jim Woodhead

     

     

     



    ------Original Message------

    SO_SalesHistory is by PL, meaning no misc items / charges... but AR_CustomerSalesHistory does include misc items / misc charges.  Perhaps someone posted a /M credit to that month?

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


  • 6.  RE: AR_CustomerSalesHistory wrong

    Posted 05-07-2019 17:06
    Change that... it seems SO_SalesHistory can include misc charges, but not invoices posted through AR Invoice Entry.  (I should have looked closer at my quick test before posting).

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

    Original Message


  • 7.  RE: AR_CustomerSalesHistory wrong

    Posted 05-09-2019 08:26
    @Kevin Moyes thanks for double checking that, but I looked for those items too & noticed other customer's misc charges were in the total. I also looked for drop ship vs non-drop ship, posting dates, any misc anything.... nada.

    @Jim Woodhead thanks! I will check that out! ​​

    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    Lansing MI
    ------------------------------

    Original Message


Related Content