Sage 100

I'm using a custom S/O Entry label report.  Is there a way to specify a label qty for each individual item, and not just a single qty that applies to all lines?  I have the latter working but need the former.  The label qty can be different every single time and for each line item.

I'm using a similar process as above, i.e. "Create a table with one numeric field and have each row one incremental number (e.g.1,2,3,4) then add it to the report without a join (cross join) then it will make a row (label) per row (which equates to per number) value in the table.  Then use your param to limit the number of rows it returns: {?LabelQty} >= table.numberfield"

cross ref: https://community.90minds.com/discussion/inventory-receipt-label

I'm using a custom S/O Entry label report.  Is there a way to specify a label qty for each individual item, and not just a single qty that applies to all lines?  I have the latter working but need the former.  The label qty can be different every single time and for each line item.

I'm using a similar process as above, i.e. "Create a table with one numeric field and have each row one incremental number (e.g.1,2,3,4) then add it to the report without a join (cross join) then it will make a row (label) per row (which equates to per number) value in the table.  Then use your param to limit the number of rows it returns: {?LabelQty} >= table.numberfield"

cross ref: https://community.90minds.com/discussion/inventory-receipt-label

You probably have to use a sub-report for your labels, with the cross join being done in the sub-report.

I'm using a custom S/O Entry label report.  Is there a way to specify a label qty for each individual item, and not just a single qty that applies to all lines?  I have the latter working but need the former.  The label qty can be different every single time and for each line item.

I'm using a similar process as above, i.e. "Create a table with one numeric field and have each row one incremental number (e.g.1,2,3,4) then add it to the report without a join (cross join) then it will make a row (label) per row (which equates to per number) value in the table.  Then use your param to limit the number of rows it returns: {?LabelQty} >= table.numberfield"

cross ref: https://community.90minds.com/discussion/inventory-receipt-label

I use a UDF on the detail line allowing the user to specify QTY per line.

You probably have to use a sub-report for your labels, with the cross join being done in the sub-report.

I'm using a custom S/O Entry label report.  Is there a way to specify a label qty for each individual item, and not just a single qty that applies to all lines?  I have the latter working but need the former.  The label qty can be different every single time and for each line item.

I'm using a similar process as above, i.e. "Create a table with one numeric field and have each row one incremental number (e.g.1,2,3,4) then add it to the report without a join (cross join) then it will make a row (label) per row (which equates to per number) value in the table.  Then use your param to limit the number of rows it returns: {?LabelQty} >= table.numberfield"

cross ref: https://community.90minds.com/discussion/inventory-receipt-label