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