x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 28 subscribers
  • Views 573 views
  • Users 0 members are here
Browse Forums
Announcements
321
topics
19
replies
General Discussion
81
topics
179
replies
G. Monica Southgate

GAS Import template

Posted By

Hi, 

I have a tech/dev question please. Sage X3 V11 patch 11.

Can we add any conditions to the GAS import template for accounting date to check if period is restricted or closed? 

We're using a csv file to import journals to X3 based on GAS template. 

We routinely update the CLO parameters for period restrictions and hard close the periods when we're done. 

When we import the csv file, sometimes user's forget to update the accounting date and the file imports in closed periods or where we have CLO dates restrictions in place.

Thank you so much. 

  • 0

    Hello,

    From a technical point of view,I do not believe there is a way to do this directly, however you should be able to add some custom 4GL code to the import template for this functionality.   You might want to discuss your requirements with your local X3 support provider if you need to pursue this further.

    Having said that, from a functional perspective the import should behave the same as if a user was entering via a screen, so not sure if you are allowed to add journals to a closed period as a user in the front end?  (Sorry I do not know much functional stuff)  If you cannot enter a journal to a closed period in the front end, then check you have picked the correct function for the import template (should be GESGAS) 

    regards

    Mike

  • 0

    Hello 

    As per Mike's comment - import should behave in the same way as manual entry therefore control would be expected.

    Said that, we found some differences between templates using "Standard Script" IMPGAS vs the ones using "Standard Script" GASIMPORT. 

    Therefore if you look at the Import Template that you are using - what is the "Standard Script" Value being used?

    However as you are on V11 P11 It could be something corrected in later patches or V12

    Thank you

  • 0 in reply to Ramon Pairau

    Hi. Yes indeed this has been resoled with the upgrade to V12. Thank you. 

*Community Hub is the new name for Sage City