Sage 100

Is there a way to add fields in the AR Invoice Header or AR Invoice History Header to the AR Invoice Work file used by Crystal? My client want ""Applied To Invoice #"" to print on credit memos. You'd think that would have been included in the work file, wouldn't you?

Create a UDF in the work table with the source being the applied to invoice #.

Odd that they left that out of the UDF source-fields for AR Invoice. If you setup a UDF in AR Invoice Header and in the worktable, a script in Invoice Entry could populate it with the value.

But what if they need to print a credit memo from history? This just irritates me no end. I mean I can link in those files but jeez.

Then I have to worry about left outer joins because it can't be both in Invoice Header and Invoice History Header. Double jeez.

IF the field exists in history, then you can also populate the UDF from the history field as well.

And as far as thinking Sage would ""think"", I gave that up soooo long ago. Left hand doesn't communicate with the right hand at all. One would ""think"" fixing the date field formatting in BR reconciliation register would be a slam dunk after all these years......

Absolutely you can add UDF fields to the work tables. Tables are a source for the work files.

When adding the UDF to AR Invoice, move it forward to Invoice Print work file, Invoice Header History, Invoice History Work files.

Thanks to all. I'll get to work on it!