Sage 100

 View Only
Back to discussions
Expand all | Collapse all

PO Receipt of Goods Totals Issue

  • 1.  PO Receipt of Goods Totals Issue

    Posted 03-24-2024 10:52

    I am using VI to import PO Receipt of Goods.  The import is for multiple POs on a single receipt and all items are serial valuation.  The lines tab is working and the totals on the lines tab is correct however the amount on the Nontaxable Amount and Receipt Total on the Totals tab is incorrect. Sales tax is not enabled so all receipts are non-taxable.  Is there a way to re-calculate the Nontaxable Amount and Receipt Total on the Totals tab other than modifying the field in DFDM?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:42

    Do you maybe need something on the Records tab?



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:45

    @Brett Zimmerman  Maybe.  Any idea what should be there?  It's quite a mystery.  The lines might total $40,000 and the Nontaxable amount and the Total will be $10, 500 or something odd. 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 4.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:46

    Are you setting the Tax Class to NT?  It does not seem like that would be required, but maybe it will trigger the calculation of Non-taxable sales? 



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

    Original Message


  • 5.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:48
    Edited by Brett Zimmerman 03-25-2024 08:49



    edited below
    ------------------------------

    Original Message


  • 6.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:49

    Actually, my 2 jobs have nothing on the Records tab, but here's my Data tabs:



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 7.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 08:58

    Thanks @Brett Zimmerman  Here's mine. If anyone sees anything not correct please let me know.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 8.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 11:07

    As a general rule, header key fields first... so I'd move the H.PurchaseOrderNo column down below receipt type and receipt #.

    Also, get rid of ItemCode.  When doing a receipt from PO, you don't need it (...the OrderLineKey handles that part), and getting rid of it removes the possibility of adding new lines instead of receiving an existing PO line.

    LotSerialNo before the LL quantity.



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

    Original Message


  • 9.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 11:02

    After the import, go into the receipt and try changing the Tax Schedule to something else, click to Totals, then change the Tax Schedule back to what it was, and check the Totals again. 

    If that works, the line / receipt data is fine (...perhaps a bug with VI and multiple PO's per receipt, which is a relatively new feature). 

    If it doesn't, something else is happening.



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



  • 10.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 13:32

    Thanks for your suggestions @Kevin Moyes  I made the changes you mentioned and the totals are still the same.  I am convinced there is a bug in the VI when using multiple POs on a single receipt.  Sage has had the import job and source data for a week now and they haven't been able to figure it out.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 11.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 15:23
    Edited by David Speck II 03-25-2024 16:46

    Try placing the following in the Before Write perform logic on the Header.

     

    coBusiness'SalesTaxRecalculation() ! '

     

     

     

    Thanks,

    David Speck

    Senior Sage 100 Developer | O: 949.583.9500 x1156

    dspeck@blytheco.com | www.blytheco.com
    ACUMATICA PARTNER OF THE YEAR | SAGE INTACCT | SAGE 100 PLATINUM ELITE | CREATIO GOLD PARTNER
    This message contains information that may be confidential and privileged. Unless you are the addressee (or authorized to receive for the addressee) you may not use, copy, or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply email, and delete the message. Thank you.

     






  • 12.  RE: PO Receipt of Goods Totals Issue

    Posted 03-25-2024 16:18

    That solved it!  Thank you @David Speck II !! 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


Related Content