Data Export

Data Export enables you to export your Stock Costing data, outstanding Purchase Orders and Sales Orders data to to Microsoft Excel® tables for interchange with other software which permits this, such as accounts packages.   The files are called merstock.xls, merpurch.xls and mersales.xls, and are written to your Merlin  \export directory.
Please refer to the destination software for directions for importing data.

merpurch.xls contains the following fields: ordno [order no.], ordate, supcode [Supplier ID], partno, exp_5 [balance outstanding], and duedate.

purchase_orders.xls and purchase_orders.txt list all purchase orders on the system, and goods_in.xls and goods_in.txt, all goods-in received against them

merstock.xls contains the following fields: partno, desc [description], stock [on-shelf], picked [WiP], exp_5 [on-shelf stock + picked stock (WiP)], batch [Pack Quantity], batcost [cost of pack, calculated taking into account any price-breaks into which the stockholding would fall], exp_8 [cost of stock].

The pack cost and cost of stock [exp_8] are calculated according to the quantity in stock, the default supplier, and any price breaks which have been set up for that supplier.  In other words, if price breaks exist, the stock will be costed according to the price band into which the held quantity fits.
(Please see the Important Note:  Stock Costing/Valuation below, under Reports.)

The table also contains fields showing Allocated Stock and Stock Category.

merstock_and_supps.xls which contains all of the merstock.xls data (as above) plus supused, which is the currently selected supplier (1, 2 or 3), plus full costing details for all three suppliers (or as many as as associated with each item) in fields beginning s1... for supplier 1,  s2... and s3... for the second and third suppliers.

mersales.xls contains the following fields: saleno, date, client, custordno, jobno, product [top-level assembly], run [build quantity], runwas [quantity built or released to date], exp_9 [balance of sales order or job outstanding].

This report includes Sales Orders or jobs for top-level assemblies only, and therefore excludes internal subassembly jobs.

This data has been processed and must never be exported back to Merlin!