Sage 100

Has anyone ever customized SO Shipping Labels to print one label per quantity of each item on the sales order?

I have the attached using sales order work but guess the same could apply to the shipping label. I have also created one using an unlinked excel file where the user is prompted to enter the number of labels required. I found the instructions for later in the old Sage forum.

Thanks Lisa. What factor determined how you linked the 2 tables together?

The sort field from the SO Work to the GL account key basically is just needs a file with many records that it can use to count. I have not tested the attached and went with the unlinked excel file because I needed the label to print box x of x. I was told the box x of x would only be possible if I did one of the following on the attached report: I see in the old report you were prompting them. I can think of a couple of ways to do it but none of them as easy. 1. Prompt them as you were doing in the old report 2. Add a udf to the invoice header that they have to enter in a value 3. Add a udf to the invoice total and put a script behind it to compute the value upon accessing the panel 4. Add a subreport to the crystal report above the details section that will do a prepass of the data and total up the quantity ordered (this will probably slow the report down but shouldn't be by much) Those are the 4 ways I can see to do it. You can't do it in the main report because you can't get a total quantity until all lines are processed which can't happen as each one is printing.

Lisa I am not quite following how to do this. Here's my example: I have 2 different items on my sales order: Item A is for a quantity of 4 and Item B is for a quantity of 2; I would need 4 labels to print for Item A and 2 labels for Item B. It sounds like option 4 is the closest to what I want, but I don't know what commands to enter to make it print the label the same number of times as the quantity.

I believe the attached will work for yoru purpose just replacing the SO work with the shipping label work file. In my case each item on the sales order shipped in it's own box and I needed the label to total the number of boxes in the shipment plus print one label for each and count the number of boxes in the shipment.

I think I got it to work now. I had to tweak it more ... I couldn't get it to count the records correctly when using the count on the work file lines - I had to link in the SO lines table. Now I'm going to apply the logic to the Shipping Label. You are a life saver .. thanks so much!

I usually create a UDT for this purpose. The records will have values of 001, 002, 003, etc. If I have 100 records in my UDT, then when I link in this table (with a not equal join), I will have 100 records per line detail. I suppress the detail section when: ToNumber(<<UDT_Counter>>) > <<SO Line Quantity>> I also will create a formula that I use for sorting and most times I have to add that as a group. The sort is by whatever the normal sort is plus the counter field from the UDT.

I did it similar to how William did but with a twist. They wanted to enter how many labels to print themselves (they determine themselves based on the order how many boxes they need). Created a UDF in Shipping panel of Shipping Data Entry for that. Then on the form, joined that to a UDT with values of 1 - 10. I joined on the non-key field of the UDT so it was numeric to numeric AND the join type was a >= join (that's what produced the multiple label records)