Removed Landed Costs from Received Not Invoiced Report

  • Removed Landed Costs from Received Not Invoiced Report

    Posted by Kyle Malone on July 10, 2018 at 3:53 pm
    • Kyle Malone, CPA

      Member

      July 10, 2018 at 3:53 PM

      Hello,
      We accrued landed costs for a shipment.Ā  We’ve fully matched the shipment itself to the invoice but found that we entered an incorrect vendor for the landed costs (thus cannot match the invoice to the accrued landed cost).

      For the “Received/Not Invoiced” report which should match our accrual, how do we remove the landed cost that will never be matched?

      For regular shipments that’ll never be invoiced, we’d update the POP10500 table to set QtyMatched = QtyShipped.Ā  Not sure what to do for landed costs in a similar situation.

      Thank you,
      Kyle

      ——————————
      Kyle Malone, CPA
      Dynamics GP Administrator
      CGB Enterprises, Inc.
      Covington, LA
      Kyle.Malone@cgb.com
      985-867-3591
      ——————————

    • Ken Roy

      Member

      July 10, 2018 at 4:40 PM

      If you manually close the PO, it will drop off theĀ Received/Not Invoiced report.

      ——————————
      Ken Roy
      Premier Manufacturing
      Tualatin OR
      ——————————
      ——————————————-

    • Amber Bell

      Member

      July 11, 2018 at 9:25 AM

      You should match to the wrong vendor vs. forcing closed. Then create a Credit Memo to zero out the wrong vendor.Ā 

      Do this when you have the invoice from the real Vendor so you can use the real cost.Ā 

      For the Credit Memo for the wrong Vendor and the Invoice for the correct Vendor, use the AP transaction window and the same Offset to net to zero for the Offset.

      ——————————
      Amber Bell
      Training Dynamo LLC
      Email: amber@trainingdynamo.com
      Website: http://www.trainingdynamo.com
      Twitter: @trainingdynamo
      ——————————
      ——————————————-

    Members

    Kyle Malone replied 8 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Removed Landed Costs from Received Not Invoiced Report’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!