Return Sales Order on a Drop Ship- prompting for bin

  • Return Sales Order on a Drop Ship- prompting for bin

    Posted by Devora on September 13, 2017 at 12:53 pm
    • Devora Locke

      Member

      September 13, 2017 at 12:53 PM

      Hi! Ā I’m hoping can help with some direction as I’m not finding web info on my specific scenario-Particulars are:

      NAV 2016 (no crm, no wh mgmt)

      Drop Ship Order which was invoiced with tax when the customer is tax-exempt.Ā 
      Issuing a Credit memo for the tax amount against G/L acct is not an option due to business practices.Ā 

      Attempted Solution- Process a sales order return, then re-issue the order without charging tax on invoicing.Ā 

      Problem! Ā When we try to create a return order we are getting prompted for location/bin, which of course does not exist. Because,..
      A. its a drop ship order and
      B. No product will actually be returned by customer. This is just an invoice adjustment to fix an error.Ā 
      C. We do not want another PO to go out to the vendor who will drop ship the product; we will not be returning any product to that vendor.Ā 

      All I can think to do is create a temporary bin for this ‘virtual product’, and then ‘virtually ship’ from that same bin on re-creating the SO. If I do that, the order is no longer a drop-ship, correct? So I need a better solution, if anyone can lend guidance.Ā 
      Ā 
      Is there a way to reverse only the invoice, and start again correctly from there so no actual return needs to be processed? Ā Again, our business does not allow for manual G/L adjustments such as mics. credits.

      Thanks for any advice about this procedure. Ā  Ā -d.

      ——————————
      Devora Locke
      Shin-Etsu MicroSi, Inc
      Phoenix AZ
      ——————————

    • John Bellinger

      Member

      September 14, 2017 at 8:21 AM

      For sales tax adjustments, we do a single document, if we need to collect sales tax dollars we use the Sales Invoice, if we need to refund we use the Sales Credit Memo.  In the line items, we do two lines items of type Resource, one for a positive quantity, and one for a negative quantity, quantity 1, same unit price, when looking at Statistics for the document, General and Invoicing Sales ($) net to zero.  Then in the lines we manually set Tax Group Code in each line to get to the desired Sales Tax Amount for the transaction (we have a group that results in no sales taxes for the line).  We then add enough comment text to the document to explain what’s going on to the customer.

       

      You could also transact on items versus resources, but if you manage bin’s and want to minimize protentional warehouse management issues, you could setup a “corrections” location that does not require bins / warehouse management features, and transact on that location.

          

      John Bellinger | ERP Manager | Activar, Inc.
      9700 Newton Ave. S. | Bloomington, MN 55431
      Office: 952-392-3912 | Cell: 612-719-0289 | Fax: 952-837-1221
      jbellinger@activar.com | http://www.activar.com

       

      ——Original Message——

      Hi! Ā I’m hoping can help with some direction as I’m not finding web info on my specific scenario-Particulars are:

      NAV 2016 (no crm, no wh mgmt)

      Drop Ship Order which was invoiced with tax when the customer is tax-exempt.Ā 
      Issuing a Credit memo for the tax amount against G/L acct is not an option due to business practices.Ā 

      Attempted Solution- Process a sales order return, then re-issue the order without charging tax on invoicing.Ā 

      Problem! Ā When we try to create a return order we are getting prompted for location/bin, which of course does not exist. Because,..
      A. its a drop ship order and
      B. No product will actually be returned by customer. This is just an invoice adjustment to fix an error.Ā 
      C. We do not want another PO to go out to the vendor who will drop ship the product; we will not be returning any product to that vendor.Ā 

      All I can think to do is create a temporary bin for this ‘virtual product’, and then ‘virtually ship’ from that same bin on re-creating the SO. If I do that, the order is no longer a drop-ship, correct? So I need a better solution, if anyone can lend guidance.Ā 
      Ā 
      Is there a way to reverse only the invoice, and start again correctly from there so no actual return needs to be processed? Ā Again, our business does not allow for manual G/L adjustments such as mics. credits.

      Thanks for any advice about this procedure. Ā  Ā -d.

      ——————————
      Devora Locke
      Shin-Etsu MicroSi, Inc
      Phoenix AZ
      ——————————

    Devora replied 8 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Return Sales Order on a Drop Ship- prompting for bin’ 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!