I would like to use one of the database fields to store picking location for products (i.e. shelf, bin, etc.). I would like to know how to integrate that with the packing list.
I am new to dealing with dynamically generated pages, so please forgive my ignorance. Ideally, I would like to place this information on a line just below the [itemname] on the list. I note that the only identifiable database field used on the section of the page is "[id]" and that the other fields seem to use a derived name like [itemname], [unitprice], and [subtotal].
I have experimented, but it appears that there are only a limited number of derived names/variables are allowed in that section of the page. I had used the [extended_description] field for my information as I don't have any other use for it. So, what I would like to have would look something like (my part is the "Bin/Shelf Location in red):
<!--START: items-->
<tr class="report-font1">
<td width="15%" height="24" align="left" valign="top">[id]</td>
<td valign="top" align="left" width="53%">[itemname]
<br>Bin/Shelf Location [extended_description]</td>
<td width="1%"> </td>
<!-- <td valign="top" align="right" width="9%">[unitprice]</td>-->
<td width="1%"> </td>
<td valign="top" align="center" width="9%">[numitems]</td>
<td width="2%"> </td>
<!-- <td valign="top" align="right" width="10%">[subtotal]</td>-->
</tr>
<!--END: items-->
What can I use to do what need to here.
Thanks in advance
I am new to dealing with dynamically generated pages, so please forgive my ignorance. Ideally, I would like to place this information on a line just below the [itemname] on the list. I note that the only identifiable database field used on the section of the page is "[id]" and that the other fields seem to use a derived name like [itemname], [unitprice], and [subtotal].
I have experimented, but it appears that there are only a limited number of derived names/variables are allowed in that section of the page. I had used the [extended_description] field for my information as I don't have any other use for it. So, what I would like to have would look something like (my part is the "Bin/Shelf Location in red):
<!--START: items-->
<tr class="report-font1">
<td width="15%" height="24" align="left" valign="top">[id]</td>
<td valign="top" align="left" width="53%">[itemname]
<br>Bin/Shelf Location [extended_description]</td>
<td width="1%"> </td>
<!-- <td valign="top" align="right" width="9%">[unitprice]</td>-->
<td width="1%"> </td>
<td valign="top" align="center" width="9%">[numitems]</td>
<td width="2%"> </td>
<!-- <td valign="top" align="right" width="10%">[subtotal]</td>-->
</tr>
<!--END: items-->
What can I use to do what need to here.
Thanks in advance
Comment