PO Export issue using xml port

kamranshehzad · 2009-02-10

Hi
I am facing a strange thing.
I have created a XML port to export the data into a file.

I am filtering out PurchaseHeader.Document Type = order using set range
and same with Purchase Lines but when it exports the data, it includes all lines of Purchase Lines table (39) and Range works fine for PurchaseHeader (38) table.

Any idea. Code follows.

IF EXISTS('C:\XML_PO_OUT.XML') THEN
    ERASE('C:\XML_PO_OUT.XML');

    PurchaseHeader.SETRANGE(PurchaseHeader."Document Type",PurchaseHeader."Document Type"::Order);
    PurchaseLine.SETRANGE(PurchaseLine."Document Type",PurchaseLine."Document Type"::Order);
    PurchaseHeader.SETFILTER(PurchaseHeader."No.",'104001');
    PurchaseLine.SetFilter(PurchaseLine."Document No.", '104001');

    TESTFILE.CREATE('C:\XML_PO_OUT.XML');
    TESTFILE.CREATEOUTSTREAM(TestStream);

    XP_PO.SETTABLEVIEW(PurchaseHeader);
    XP_PO.SETDESTINATION(TestStream);
     XP_PO.Export;

   // XMLPORT.EXPORT(123456753,TestStream);
    TESTFILE.CLOSE;
MESSAGE('PO Exported Successfully.');

Please suggest anything.

regards,

DenSter · 2009-02-10

You need to set the link between the header and line tables in your XMLPort. Somewhere in there you have a table element for the header table, and somewhere else a table element for the line table. On the line table element go to the properties of the dataitem, and set the LinkFields property correctly.

kamranshehzad · 2009-02-10

Great. I had a thought about it but then thought setting filter / range should sort it out.

Thanks its working.

DenSter · 2009-02-10

You're welcome, always glad to help

Howdy, Stranger!

Quick Links

Categories

PO Export issue using xml port

Answers