How to create a new Custom screen to allow for Import Scenario creation

@NetAdmin42  Can you please share the screenshots of your custom screen and along with your import scenario for us to do initial check?

Hi Naveen,

First attached is some sample data of the Excel file I am trying to create a Custom screen for so that I can then create an Import Scenario.  Also is the DB script and the DAC I have published in the Customization.

Right now I deleted the screen I was trying to create in this customization.  I really do NOT even want an Input screen.  But apparently I have to have a screen to create an Import Scenario. 

Really, all I want to do is create the legacy historical data table/DAC and then import the legacy data into it so that I can use a GI to display it. 
 

I find it very frustrating that there is not an easy way to do this for Acumatica.  These data will NOT be associated to or used for anything else except historical reference.

Thank you for your help,
 

@Naveen Boga Please let me know if those files I uploaded were what you needed.  Thank you,

@NetAdmin42  I will check and let you know.

@Naveen Boga Have you had an opportunity to see what I need to do to be able to do this?  Again, thank you for your time

@NetAdmin42 Sorry for the late reply. Bit occupied with my work.

I have deployed the customization package, it seems you have not attached the import scenario and screen.

Can you please attach your custom screen and import scenario and re-share the package?

Naveen Boga wrote:

@NetAdmin42 Sorry for the late reply. Bit occupied with my work.

I have deployed the customization package, it seems you have not attached the import scenario and screen.

Can you please attach your custom screen and import scenario and re-share the package?

 

 

@Naveen Boga Hi Naveen.  That is actually what I do not know how to do.  I tried to create an import scenario through the Import Scenario’s screen in Acumatica, but it requires a screen to do so.  I then tried to create a simple screen in this customization with Grid(View) and that too would not let me create an Import Scenario in Acumatica.  So, that was my original question.  How do I create a screen in a customization that will allow me to then create an Import Scenario?

Again, thank you,

Jeff

@NetAdmin42  As you already created the custom screen, then add that screen and Import Scenario to the customization project and share it here.

@Naveen Boga Please forgive me for taking so long to respond back.  I was pulled into a high-priority project and am only now able to circle back on this.

Please find attached that customization with the screen defined.

@Naveen Bogawhere you ever able to determine why I cannot create an import scenario for this customization package?

Hi @NetAdmin42 were you able to find a solution? Thank you!

@NetAdmin42 Your conclusion is correct. I was easily able to create a SQL table and include it into Acumatica for use with Generic Inquiries. 

The challenge comes with creating a screen or import scenario so you can enter data into your screen. This task involves creating business logic with rules for how the data is entered. The Acumatica T200 class in Open University (https://openuni.acumatica.com/courses/development/) will help you learn the process. So unfortunately there is no shortcut I can share.