Sage 100

Have a client that was on MAS90 (I'm a rebel, I know) 4.3 and running a VI Export from IM.DETAIL (IM2) creating a CSV file with item number and a calculated field (QtyOnHand - QtyOnBackOrder - QtyOnSalesOrders, if I remember correctly, don't have it right in front of me) and the VI job was running through the windows scheduler every four hours. After updating to 4.4 I cannot recreate this export job because the VI dictionary does not contain the Qty fields necessary for the export!! Huh!! I know I can do it with Crystal, but how do I get the job to run from the scheduler and create a CSV file unattended? Can anyone think of a way to do this? Thanks in advance.

@JimWoodhead swears by this - http://www.milletsoftware.com/Visual_CUT.htm - he can give more details on whether it works for CSV but my impression is that it would

I sent Ido Millet an email, thanks for the tip, I'll report back.

Have you clicked on the Options button in VI Export Job Maintenance and clicked Display Read Only Fields for Export? (And I've used Visual Cut with success, too.)

OH FOR PEET'S SAKE! Thanks Beth. What the %^& is the purpose of a checkbox for Read Only fields for an EXPORT!

It does work with a csv file. This is a great way to automate Crystal reports at a low cost.

I've done this with VI, but some jobs can take forever... so switched to Saberlogic Logicity. No VI required and it's free.

Re check box - what can only wonder.

I normally use Access for something like this.

@GregStiles - Probably a case of TLTF syndrome......... It catches me more frequently than I want to admit.

Thanks everyone, client is very happy to have that working again, one of those DOH moments, who-da thunk! Visual Cut sounds like a very useful program and Ido Millet confirmed that his software would do the job and could even FTP the file to the website as well (which we have as a separate scheduler task). @MarkKotyla I have looked into Logicity as well, the thing was this was working just fine on 4.3 I just didn't know about that read only option in VI. @LouisAraiza Yes you are right, I don't know as much as I need to re Access.