x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

General Discussion Import Error just in GESOPP function

State Not Answered
+1 person also asked this people also asked this
Replies 8 replies
Subscribers 139 subscribers
Views 3210 views
Users 0 members are here

Browse Forums

237

topics

29

replies

General Discussion

5k

topics

13k

replies

Sage Data & Analytics

56

topics

95

replies

Sage Enterprise Intelligence

210

topics

416

replies

Sage Intelligence Reporting

121

topics

322

replies

Import Error just in GESOPP function

Posted By zpmarcos over 5 years ago

Hi,

Im trying to import some Sales Quotes (SQH) files through IMPORTSIL code.

If I use the IMPORTSIL code in GESOPP function I get this error:

If I use the exactly same code, with the exactly same file anywhere outside the GESOPP it works fine without errors....

I have no more ideas what should I do, but I need it to work in GESOPP (Projects) function!

All the field showing errors should be auto-filled, as they are outside that GESOPP function

Any suggestions?

Parents

0 Saleck over 5 years ago

Hi,

Try closing the table SQUOTE [F:SQH] before the call of IMPOTSIL then open it after the import

Check also for SQUOTED and the quote screens if they are also already open in your context...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Hi,

Thanks for the quick reply...

" If clalev ([F:SQH]) : LogicClose File [F:SQH] : Endif
If clalev ([F:SQD]) : LogicClose File [F:SQD] : Endif
If clalev ([F:CAL]) : LogicClose File [F:CAL] : Endif"

Used this instructions before the IMPORTSIL call...

Still same errors!

Any more suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 zpmarcos over 5 years ago in reply to Saleck

Hi,

Thanks for the quick reply...

" If clalev ([F:SQH]) : LogicClose File [F:SQH] : Endif
If clalev ([F:SQD]) : LogicClose File [F:SQD] : Endif
If clalev ([F:CAL]) : LogicClose File [F:CAL] : Endif"

Used this instructions before the IMPORTSIL call...

Still same errors!

Any more suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Saleck over 5 years ago in reply to zpmarcos

zpmarcos said:
LogicClose

Not sure if this instruction exists en 4GL!

Try: If clalev ([F:SQH]) : Close local File [SQH] : Endif
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Thanks for the reply...

Still the same error...

It seems that X3 can't "autofill" the fields when Im on GESOPP!

Any more idea?

Best Regards
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Saleck over 5 years ago in reply to zpmarcos

Try changing the values of the global variables GFONCTION1 and GFONCTION from GESOPP to another values before the call of IMPORTSIL and restore them after the call.

If this doesn't fix the issue, send me your script
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zpmarcos over 5 years ago in reply to Saleck

Thanks for the reply.

Still not working... Sent you a friend invite.

Best Regards
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel