Sage 100

I'm trying to create a receipt label that has fields from the Receipt of Good entry Screen. Only now I find out the table IM_inventoryLabelsWrk is all the fields from CI_Item and does not have any of the fields from Receipt of Goods except the Quantity Received. What I need does not necessarily need to be a label, Has anyone created a document that can be printed after ROG entry with fields from that table? I don't even see any way to add UDF's to that table and source them from the ROG tables. I can create a crystal and put it on the menu I suppose. I was planning to just use the prompt ""do you want to print Receipt Labels. There are several users and it will not be as easy if they have to jump to a menu item and print labels before updating ROG register and put in parameters to pick their batch or batches. Not to mention if they would forget the step. Before I go that route I thought I would check with 90Minds.

What I've done in the past is pass the udf values to PO receipt history, then create a crystal label from from the PO receipt history detail/header. Is that what you are looking for?

Ah, remember that you need to run the udfs through the IM transactionposting table and selecting the PO receipt register source.

Don't forget you can put a button on the ROG screen to link to a Crystal Report, so they don't have to jump to a menu. And you could make it a really BIG button.

Clark, Do the users have to put in the receipt numbers they want to print? I do have all of the UDF's posting to history tables already, so If they would forget the information is there to re-print. Thought this was going to be a piece of cake to design using the receipt label work table, and as happens occasionally this is going to be a bigger task than I expected.

Yes, a button is a good idea, hadn't thought of that!

I second @BethBowers - I just read this (via email) and was going to suggest the same - gosh this group is fast!

I use a button that queues labels by type (from RoG, Shipping data entry, etc) and then a user with the Bar Tender installed can use a companion print labels button to invoke Bar Tender. Bar Tender has an API which can be used from scripting to do just about anything.

Thanks everyone! I tried the button on the ROG screen - one drawback is that since I want to pull data from the ROG lines tab they have to accept first and then go back to hit the button. Not bad, but not ideal. I do appreciate the feedback it helps. I really want to whine about not having ROG entry fields in the receipt label printing function but I know that will get me nowhere.