Sage 100

 View Only
  • 1.  Here's a tricky one... Customer needs to print lab

    Posted 05-12-2015 14:54
    Here's a tricky one... Customer needs to print labels for shipments to one customer. They sell liquid products and they may be in 55 gallon drums but the quantity per drum may vary. They sell by gallons so the customer may order 200 gallons of a particular product that in a perfect world would ship in four 50-gallon drums. Here is the tricky part. For that 200-gallon order, it may ship in three drums with 50 gallons each and a final one with 52 gallons so total shipped is 202. They need to have four labels with the quantities included so three labels stating 50 gallons and one label stating 52 gallons. They use lot valuation so I created a label by lot number so if the four containers were from different lots, it works perfectly but if two come from the same lot, I can't think of a way to specify they need two labels that say 50 vs. one label that says 100. Thought about using different packages in Shipping Data Entry (which they are using) but that was kind of messy splitting one lot between two packages (got the error that the packaging doesn't agree with the quantity shipped that I discovered for another customer last month). I didn't totally explore that option yet; it just seemed ""messy"". TL/DR. What they really need is a table specifying how many labels by size, i.e. three labels that say 50 and one label that says 52 for the one 202 gallon shipment. Am I missing the easy solution??


  • 2.  RE: Here's a tricky one... Customer needs to print lab

    Posted 05-12-2015 15:35
      |   view attached
    The attached may help. Its not exactly what you want but should be adaptable for your needs.

    Attachment(s)



  • 3.  RE: Here's a tricky one... Customer needs to print lab

    Posted 05-12-2015 15:39
    Hmm, thanks @MoiraGoggin - something to think about....


  • 4.  RE: Here's a tricky one... Customer needs to print lab

    Posted 05-15-2015 04:36
    @ThereseLogeais - How did you resolve this?


  • 5.  RE: Here's a tricky one... Customer needs to print lab

    Posted 05-15-2015 04:41
    Haven't yet but we're thinking of an Excel query with a macro of some sort to let them select if a line was split or not and if so, what size(s) and quantities. Too many variations.


  • 6.  RE: Here's a tricky one... Customer needs to print lab

    Posted 05-15-2015 06:17
    @ThereseLogeais what would be the max different qty per lot. Reason I am asking is if it is 2 or 3 then what about 3 UDF's per lot (XXXXX) and they can manually put it in once they pick the drums. You could make the first 2 fields the qty of labels and the next 3 would be the size of the drum??? (01052,02050) and then maybe you could use Moira example for multiple labels. Just a thought.