Importing into PO Module.

[zedsded]

Can anyone give me some tips on importing PO data into the PO Module. Data is coming from a customized manufacturing solution for the industry we are in. I'm planning on importing the PO data thru MS Access into the SQL tables in Macola. Current environment and modules avail:
- Windows Network
- Macola 7.5.4 MSSQL engine
- Flexibility Suite
Should I be looking into Flexibility? Thank for any info.

 

[AndrewForrest]

Hi Zedsded,
We also need to import production info from an external source which we do with a Visual Basic program we also need to produce multiple items from a single item which Shop floor orders do not do very well, which we do through PO using Flex code.
The PO using flex code works through Shop Floor Orders, we have flex code in the SFO Entry screen that creates multiple POPs, when we finish the SFOrder another bit of flex code creates a Barcode import file that when imported (you need the Barcode Module), completes the POPs and lets Macola do the record updates & inserts, which is a better option than manually doing the inserts because you don’t have to worry about missed files or any future changes to Macola etc.

To manually import production information into Macola from an external system. (We use Serial Lot Numbers. If you don’t or if you use Bin No. then the list may differ). You need to update the following files for a basic import. This also does not include any Audit, History, Costing or GL files, depending on how your system is set up.
File list:- IMCTLFIL_SQL for next doc number
IMLSMST_SQL Inventory Manager Master file
IMINVLOC_SQL Inventory Location File
IMLSTRX_SQL Transaction File
IMINVTRX_SQL Transaction File

Have fun...

"Don't worry about the world coming to an end today.
It’s already tomorrow in Australia." - Charles Schulz

 

[NEmacGuy]

I first opinion would be to searh out any third party apps ( or exact add-ons). Not aware of many for PO. Then I would tend to think Flex is the next best answer. You will have to write a good bite of code, but the data will pass thru business logic as flex is running in the macola screens. Then Access into the tables directly. This could cause problems as you are bypassing the business logic, but you could put the PO's in as unreleased, and pickup some business logic thru the release process.
I am sure someone else will probably chime in on wisys objects which would be an other option.

 

[zedsded]

Thanks guys, I am actually looking into third party solutions since I could just imagine the amount of time i would spend figuring this out might end up costing us more. but i can't seem to find that "add-on". most of the ones on the net are either importing OE Orders or GL Jrnls. Another solution i found is Quick Receipt using Barcode scanning, but i believe it would require the Barcode module. I'll keep looking, while at the same time learn Flex since i have no clue how it works (any quick tip to start on flex?). Again, Thanks guys!

 

[dgillz]

Check out the Wisys objects, Wisys wrote .com objects to simplify all this, they work great.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html