Increasing Line Item Comments on Historical SOP Invoices

(0) Share

Report

Posted on by Community Member

Hi everyone,

I need to increase my line item comments on my SOP Blank History Invoice Form.

In the past, i've made a calculated field and used this script for the SOP Blank Invoice Form:
FUNCTION SCRIPT (RW_SOPLINECommentText SOP_LINE_WORK.SOP Type SOP_LINE_WORK.SOP Number SOP_LINE_WORK.Line Item Sequence SOP_LINE_WORK.Component Sequence 80 1 )

Will this script work for a historical form?

Thanks!

Also a side question : are calculated fields made in report writer interchangeable between reports? They don't seem to be.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member on at

Like (1)

Report

RE: Increasing Line Item Comments on Historical SOP Invoices

Thanks Lyn! I'll try this out soon!
Verified answer

Lyn Barr on at

Like (0)

Report

RE: Increasing Line Item Comments on Historical SOP Invoices

Yes, that script will work on the historical form, except that the table will longer be the WORK table. Instead it will be SOP_LINE_HIST.

I'm not quite sure what you mean when you ask about interchangeable calculated fields. In general, you can use the FUNCTION SCRIPTS anywhere you need to use them. However, calculated fields are not global - they need to be created within each individual report.

One workaround is that you can use the "Notepad trick" to quickly create historical versions of open forms, and vice versa. To do that, you would export the first form to a package file, edit it with Notepad, replacing all the WORK references with HIST references. Be sure to rename the form near the top of the Notepad file. Then, import the modified package.

One important caveat to this is that there are sometimes different section settings between OPEN and HIST forms, which can adversely affect whether forms can be emailed.

Here is David Musgrave's post about the trick and also the potential pitfall: blogs.msdn.com/.../copying-report-formats-between-reports-and-a-warning-about-word-templates.aspx