Launching forms using Variables with form event in Syteline v10

Specifically dealing with an event to launch the Job Materials Transactions form from the Job Orders form. It has two steps:

Set Values: SETVARVALUES(vJobNum=P(Job),vJobSuffix=P(Suffix))
Run Form: JobMaterialTransactions( FILTER(JobNum='P(Job)' AND V(JobOrdersformFilter) AND JobItemVar=P(Item)) )

This will launch the form, and fill in the Item field but it will not put any data into the Job or job suffix fields. Launching other forms this way like the SRO Transactions form works but for some reason I cannot get the Job Materials Transactions to work. Help is greatly appreciated!

Find more posts tagged with

General Discussions

Accepted answers

christian-rogers

Apparently what I was missing was the "JobNumVar". Running the form as a linked child with "JobMaterialTransactions( SETVARVALUES(JobNumVar=P(Job), JobNum=P(Job)) )" fixed the issue!

All comments

Rene Bottern

Have you verified that the Variable on the Target Form are named "JobNum"?
Also, I do not see that you are sending the "JobSuffix" when calling the "JobMaterialTransactions"?

christian-rogers

Yes the variable for the job number field on the material transactions form is "JobNum". It didn't seem to matter if I included the job suffix -SuffixVar- on the materials transactions form; it still didn't work.

kazuyuki-mochizuki

At first look im confused in the code with 'P(Job)'

JobMaterialTransactions( FILTER(JobNum='P(Job)' AND V(JobOrdersformFilter) AND JobItemVar=P(Item)) )

should it be FP(JOB) if it needs quotes?

christian-rogers

Slight correction on what I am using to run the form:

The second step is:

Run Form: JobMaterialTransactions( SETVARVALUES(JobNum=V(vJobNum),SuffixVar=V(vJobSuffix),JobItemVar=P(Item)) )

This fills in the "item" field but nothing else.

christian-rogers

Apparently what I was missing was the "JobNumVar". Running the form as a linked child with "JobMaterialTransactions( SETVARVALUES(JobNumVar=P(Job), JobNum=P(Job)) )" fixed the issue!

Copyright © 2025 Infor. All rights reserved.