Sage 300 OE IMPORT SCRIPT

Posted By J-Y over 9 years ago

II need to import OE from an external application. Spent many hours trying to create a valid script without success. I am not using serialized or lotted items but the import function keeps looking for them even though System Information does not list these modules?? It is a shame the documentation is practically inexistent for such important function.

Q1: Instead of reinventing the wheel I was wondering if someone would be willing to share or sell a working OE import script that I can use as a starting point?

Q2: Which file format is easier to use? Single CSV or Individual CSV/XLS files?

Q3: Has anyone successfully created a macro to run OE imports?

My environment is Sage 300 v2104 SP1 (SQL Server 2008 R2)

0 Jay Converse Acumen over 9 years ago

Use real code, not scripts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 9 years ago

I've done many OE integrations - the key is to NOT use import files, they really suck.

Record a macro while you enter an OE order/shipment/invoice - that gives you a starting point. Then write the code to read your source data and then create the OE transactions in Sage 300.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 J-Y over 9 years ago in reply to Ettienne Schwagele

Jay and Ettienne, thanks both for the advice.

Ettienne, since you've done so many OE integrations, is there a way to contact you directly to subcontract this task?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 D Kellock over 8 years ago

Hi J-Y, not sure if you've resolved this as yet or not, but, our OE Host Interface does exactly this. While our import formats are hierarchical they are declarative and if matched with our external EnableSCRIPT utility, files can be picked up remotely, logged and transformed. The script will also prepare each file for presentation to the Host Interface.

The OE Host Interface itself has a large number of options for each import template and is highly declarative.

The import can be run automatically or manually and during import, audit logs are created.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MClark over 8 years ago in reply to D Kellock

This may be of interest to one of my customers - could you contact me directly ([email protected]) to discuss?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Sage 300 OE IMPORT SCRIPT

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING