Packing Slip Posting considers Picked quantities regardless of shipment status

  • Packing Slip Posting considers Picked quantities regardless of shipment status

    Posted by DSC Communities on March 18, 2020 at 3:47 pm
    • David Barahona

      Member

      March 18, 2020 at 3:47 PM

      We are facing an issue where a sales order is processed across two shipments. One of the shipments gets updated to shipped, and the affiliated lines are picked up in our order packing slip batch job and then by order order invoice batch job.

      Ā 

      Once the second shipment is processed to Loaded status is where we are facing our issue. The inventory status of the sales order line gets updated to “picked” when a shipment is updated to loaded. When our query runs, the Loaded shipment is getting grabbed by the order packing slip batch job since the sales order already has a Shipped shipment and the inventory transaction is “picked”.

      Ā 

      This is an issue only if the warehouse makes any processing issue that needs to be corrected, but I’m curious if anyone knows of a better query setting than we are using or if there is a workaround to still only include Shipped shipments under all conditions.

      Order packing slip settings:

      • Quantity parameter: Picked
      • Sales order status: Open order
      • Load status: Shipped (this is accomplished off a table join to Load details and then Load)

      ——————————
      David Barahona
      Implus Corporation
      Durham NC
      ——————————

    • Guy Terry

      Member

      March 19, 2020 at 7:59 PM

      Hi David,

      I don’t have any good ideas, other than to vote on my idea for this problem!

      https://experience.dynamics.com/ideas/idea/?ideaid=163f40be-f56d-e711-80c0-00155d7cb38d

      Guy

      ——————————
      Guy Terry
      Application Consultant
      Annata
      ——————————
      ——————————————-

    • Adam Pascoe

      Member

      March 20, 2020 at 11:38 AM

      Good morning David;
      Not sure if this helps or not, but we do a lot of split shipments as well, these are the parameters we use on the packing-slip posting:

      Sales Orders.Status = Open order, Delivered
      Shipments.Shipment status = Shipped
      Shipments.Shipping confirmation date and time = !””

      Cuing off the shipment rather than the load may help.

      We have a couple of other filters, but they are there for other purposes, not likely pertinent to your scenario.

      Order lines.stopped = No
      Shipments.Planned Ship Date =Ā (DayRange(-30,0))
      Sales orders.Order type=Sales order

      (We are on 2012R3, and using Advanced Warehouse)

      ——————————
      Adam Pascoe
      Bio-techne
      Minneapolis MN
      ——————————
      ——————————————-

    • Andrew Lencsak

      Member

      March 20, 2020 at 2:23 PM

      One other thing to consider…. If you are using Warehouse management, the expectation is that you should be posting packing slips through the Load or shipment, not through Sales and Marketing. Specific features are only available by posting the packing slip from the Load or shipment that are not available when posting a packing slip from Sales and Marketing for a sales order that was processed through Warehouse management. Since you are posting through Sales, it effectively ignore what is on the Shipment and says, yes there is additional quantity available that can be picked to this sales order and we will also ship that. My guess is that join fails because Warehouse management is intended to be processed fully through Warehouse management rather than just an update on the Sales line status.

      ——————————
      Andrew Lencsak
      Solution Delivery Manager
      Arbela Technologies
      Irvine CA
      ——————————
      ——————————————-

    DSC Communities replied 6 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Packing Slip Posting considers Picked quantities regardless of shipment status’ 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!