Sage 100

100 Premium... Client needs to print each model number on the SO invoice. the model numbers are sent by nightly by the vendor for the previous days shipments. I need to import the model numbers for each line on an invoice. My thought was to create a UDT, the key being the SO invoice number plus the line key. Once the table is populated how do I display the model numbers on the invoice? If an item has a qty shipped of 5, there would be 5 records in the table, so 5 model numbers would need to be displayed. i have created a UDF, validated the UDT, and added the UDF to the SO detail. This seems to be a dead end as I can only select one model number per line. Any good ideas?

Hi Doug I'm doing almost this same thing for a client. I created the UDT, pulled it into the SO Invoice as a sub report and on the subreport also formatted with columns (I'm bringing in 3 fields for each item). Invoice will have qty of 100 of an item and needs serial numbers from a home grown system (can't use serialized inventory, whole 'nother issue). My UDT key is the serial number+Invoice # and I linked the sub report on the item code. Note, I didn't have to use UDF's in my SO Invoice Table for this.

Thanks Nancy. How do you access the UDT using Crystal? Where is it located? Usually the UDF appends a specific table.

My UDT is a System table - so it was SY_UDT_SerialNumbers.

Found it. Mine is an SO table. I had opened the wrong data source and couldn't located it. Is the item number a field in the UDT so that you can use it to link the subreport to the invoice?

yes it is.

Thanks a million!

No problem, glad I could help!

BTW.. It would be nice if we could simply populate S/O Invoice Data Entry Tier Dist. Detail, but when the item valuation is average cost the business object throws an error when attempting a write.

Yeah, that's what my client wanted too - serialized with average costing.