How to handle miscellaneous items in shipping data entry (and/or inventory)

I recently contacted Sage support over the phone about this but was directed here. Here is a breakdown of my issue/question.


Our business used to bypass the shipping section of the sales order module by sending a packing list to the floor, having a picker/packer use that to write on what was packed into each box, and then that was brought back to our sales department for manual data entry back directly into invoice data entry. When doing this we were not retaining packaging information or tracking info in Sage. We'd like to fix that, so we are going to start using shipping data entry. This is also being driven by the fact that we are implementing scanners into our warehouse and they integrate with shipping data entry, so this is required.


In using shipping data entry we have run into an issue with miscellaneous items on the sales orders. When selling these items (not physical items), shipping data entry is REQUIRING that we put them into a package... Obviously this isn't ideal. We'd like them to not need to be packaged, but to still be able to remain on the invoice. Please note, adding them onto the invoice manually after the shipping process is complete isn't a good option for us... This would be extremely error prone and definitely not any better than our current process which we are trying to improve.


An example of this is where we sell access to a specific website with sensitive information on it that shouldn't otherwise be available to the public. This brings up a side note here... Are we handling this wrong in the first place? We are currently treating this website account as an item in inventory because we need to track quantity and time of people purchasing access. Its a standard inventoried item as of now with no stock quantity, and we just allow it to go negative on hand as they sell. This may not be ideal, but it hasn't been causing us any issues. I believe it was even recommended to us to handle it this way in the past, but I'm not sure where that recommendation came from exactly. We contemplated using a /misc item code for this instead to alleviate the negative inventory thing, but it doesn't seem to matter for us with this shipping data entry issue. Even if its a /misc line item on the sales order it seems that the module still requires it to be packaged if its shipped... And if it isn't shipped, its not populated on the invoice...


So we are at a bit of a stand still here... Any advice? We don't want these miscellaneous things to have to be packaged, but they have to be on the sales order under our current process. If there is a better idea of how to handle this situation up front I'm all ears!

  • 0
    Shipping Data Entry is just another front end for Invoice Data Entry. Both Shipping Data Entry and Invoice Data Entry write to the same tables. Now if you have miscellaneous items on the sales orders what would you do in Invoice Data Entry? Now are you saying that you do not want to see them on the packing list? If that is the case then a simple edit of the packing list form should do the trick.
  • 0 in reply to BigLouie
    The "Drop Ship" flag might be an option to consider.
  • 0 in reply to BigLouie
    Yes, they absolutely are. Currently we would simply "ship" the item on the invoice. And yes I could certainly edit the packing list form to not show this. Its more of a question for our internal team I suppose. When the sales order "leaves" sales order entry and gets input into invoice data entry there is no requirement for packaging items. This is the info we are wanting to retain. When doing it through shipping data entry it requires you to package every line item on the order, or back order it. Obviously we can't back order it because then it wouldn't get invoiced, so we must ship it. How can you input the data into the shipping data entry window without having to package these items? Obviously they aren't going to be put into a package. It seems like an oversight in the software design to me. Is there no way to distinguish to shipping data entry which items should be packaged and which shouldn't?
  • 0 in reply to Kevin M
    Kevin M, maybe you could elaborate more here? I'm not familiar with the "Drop Ship" flag.
  • 0 in reply to llevron20
    Drop Ship is an order / invoice line checkbox, indicating nothing is physically shipping from your warehouse, but is included on the invoice. It's intended to be used for items shipped directly from the supplier to the customer, but it can be handy for other purposes.
    Of course you'll want to do proper testing before using Live.
  • 0 in reply to llevron20
    And I am also guessing the you use the Pack feature to Shipping Data Entry to "pack" the items and print out separate packing list. Is this correct. So just skip the misc. items as the system will automatically put them in box #1. Then edit the form.
  • 0 in reply to Kevin M
    Well that sounds exactly like what I was looking for! I'll look into that and see if it resolves our issue here. Thank you guys for the quick responses!
  • 0 in reply to BigLouie
    BigLouie, I'm not aware of a specific "Pack" feature that we are using. We are simply inputting the sales order number into shipping data entry, it populates the table below, and you must manual go through each line item and type the quantity being packaged, and then select new package for the next box and do the same. You can always go back through the package list and edit things but that is extremely cumbersome.

    When I skip the misc items it doesn't automatically put them in anything, it pops up an error that says I've shipped 1 and packaged 0, and wont allow me to continue until I've manually packaged the misc item. Is there another option your talking about turning on here that automatically does this? Keep in mind we'd still want the shipping data entry window to display the error it does in case there is a clerical mistake when typing in amounts and such.
  • 0 in reply to Kevin M
    Kevin, I'm currently trying to test the drop shipping thing, but I don't see anything like this in sales order entry or shipping data entry. Could you give me an approximate location of this checkbox you're talking about? Specifically, can this be done by line item on the order, and if so, where?