Dataport for item

hhhhhhhqat

dear all

i want to make dataport to export item price list with the following fields:

item No,Barcode,description, Uint,cost price , sales price

note :
i already done one dataport and give me last price ( updated one ) for multi barcodes

if one item No have many barcodes , the prices will come for two lines .

the problem now for customer price group , if i have many customer price group , how can i filter by sales code to give me one customer price group and last prices also.

any one can help me


thanks

kriki

I think it is best to use a report (so you can filter on the items) and use the FILE-type to export the data.
In the OnAfterGetRecord of the item, you can put all the logic you want to get all the information to be exported.

hhhhhhhqat

thanks for your reply

can you give me example for FILE type

thanks

kriki

For example:

In the OnPreReport:

filFile.WRITEMODE(TRUE);
filFile.TEXTMODE(TRUE);
filFile.QUERYREPLACE(TRUE);
filFile.CREATE('c:\...\TheName.txt');

In the OnAFterGetRecord:

filFile.WRITE(txtSomeVariable);

In the OnPostReport;

filFile.CLOSE;