Sending data from product costing reports to external files
To export a product costing report, at the main screen:-
● Select: Print - Product costing
The Product costing dialog is displayed
● Select Product requirements file to export
● Select Export option
● Select OK to continue
The data is exported to directory set by System parameter: Path for Export data
File name is: <product requirements name>.EX1. For example:-
Prods20.EX1
All the data is exported (header, sub headings, data, totals etc). Markers indicated the different data types.
For example:-
%1,DEMO USER 1,Modular,Tuesday 14 November 2015
%1,Product costing,Week 22
%1,Ref,Prods20,Description,Week 22,Optimising,DEFAULT,Saw,DEFAULT,Over,0
%1,No,Code,Qty,Information,Cost per product,Total cost
%3,1.,BASE-CABINET,2,Base unit - cabinet,82.633,165.265
%3,2.,BASE-DOUBLE,3,Double base unit,47.977,143.932
%3,3.,BASE-DRAWER,1,Drawers-MFC18-OAK,67.323,67.323
%3,4.,BASE-SINGLE,5,Single base unit,41.217,206.085
%3,5.,BASE-SINK,1,Sink base unit,45.073,45.073
%3,6.,BASE-CORNER,2,Corner cabinet,38.926,77.851
%4,,,,,,705.529
Data types are:-
1 - header line
2 - sub-heading
3 - item line
4 - totals
Notes
- The data types exported cannot be selected (this is not like other Summary reports)
