Personalization, Customization and Productivity Tools

[jazzolina]

Is it possible to run VI from the command line in a test only mode?  Once this is run, is there a place within MAS that I can locate the test results?  Is there some kind of Import Log I could query?

[BigLouie]

Welcome to the Sage Community. In v4.30 there really is no more "Test" with VI for modules that are on the business framework. It creates records. You would need to run in a test company. Note that if you run it attended the log will come up at the end.

[connex]

If you run it unattended then you can see the last Job Log using the button with the same name on the Import Job Maintenance panel.

[BigLouie]

---

jazzolina wrote:
Is it possible to run VI from the command line in a test only mode?  Once this is run, is there a place within MAS that I can locate the test results?  Is there some kind of Import Log I could query?

---

If you are going to run the import and then go into MAS and open the Import Log why not just run it from within MAS anyway?

[jazzolina]

Thanks for the great replies!!  I think, based on the information that you've all provided, that our approach to our issue is not correct.  so here is a followup question.  If we use the Business Object programming interface to add data to sales orders, is there a way to post that data into the system programmatically?  We need to integrate our ERP system and MAS, but due to timing issues, the VI tool does not seem to provide enough flexibility.  Any thoughts on importing and posting the data programmatically?

[BigLouie]

With VB and the BOI you can create new sales orders and you can over-write header information, you can also ADD NEW lines to a sales order but if you want to edit existing lines you will need to know the line key.  My question is, are you creating new records? Editing header information? Adding new lines to the detail? Wanting to edit existing lines.

Also I have to ask, have you taken the course on BOI?

[jazzolina]

I will need to do two things (I think)

1. Create NEW Headers with NEW line items (no editing)

2. Post these new orders into the system

From what I've gathered, the first seems doable, it's the second I'm a bit worried about.

And no, I have not taken the class, nor will I be able to.

Thanks so much for all the help!

[BigLouie]

With Sales Orders there is no posting. When you write to the Sales Order files that's it.

Why can't you take the course?  I would not attempt VB and BOI without taking the class.

[BigLouie]

---

jazzolina wrote:
Is it possible to run VI from the command line in a test only mode?  Once this is run, is there a place within MAS that I can locate the test results?  Is there some kind of Import Log I could query?

---

Starting with v4.10 if you do a test import into Sales Order Data Entry it will create cancelled records. If you simply want to see if your import works then do it in a test company first. You can run from a command line into the test company and then pull up the job and look at the log.

[jazzolina]

so, the customer has v4.3 of MAS.  Today, when they import items for billing (the data eventually ends up in AR_InvoiceHeaderHistory and AR_InvoiceDetailHistory) they use VI to import it.  The process is that they open the VI job and have two options, test and import.  They test first.  Then, if no errors, they import.  At this point, if they run invoices, there is no data, they have to run another job to "bring the data in from the staging area".  Forgive me if I'm not being clear.  We want to automate this process so that the user can just kick off the entire test/import/post process.  Perhaps, VI brings the data into a staging area first and if we use BOI, this step is eliminated?