SaveXML Creates Duplicate line numbers.

[Former Member]

When saving a Document I am getting multiple Document Line numbers.

This seems to have started after SP1 patch release 8 or 9

Example:

- <BOM>

- <BO>

- <AdmInfo>

<Object>13</Object>

<Version>2</Version>

</AdmInfo>

- <Documents>

- <row>

<DocNum>92</DocNum>

<DocType>dDocument_Items</DocType>

<HandWritten>tNO</HandWritten>

……

</row>

</Documents>

- <Document_Lines>

- <row>

<LineNum>0</LineNum>

<ItemCode>100-41-29V-E-F-BL</ItemCode>

<ItemDescription>HEX SCREW WHITE</ItemDescription>

<Quantity>16000.000000</Quantity>

…

</row>

</Document_Lines>

- <Document_Lines>

- <row>

<LineNum>0</LineNum>

<ItemCode>100-41-29V-E-F-BL</ItemCode>

<ItemDescription>HEX SCREW WHITE</ItemDescription>

<Quantity>16000.000000</Quantity>

…

</row>

</Document_Lines>

</BO>

</BOM>

[Former Member · Accepted solution]

I am replying for Joe Guagenti, as I work with him and he probably has not had time to respond. We are having the same problem with patch 11. We were not planning on upgrading to patch 12 before we put our addon into production. Can someone from SAP B1 or someone using SaveXML at patch level 12 tell us if the bug has been fixed at that level?

Nancy Walk

nwalk@socket.net

[Trinidad · Accepted solution]

Hi Nancy,

I have tested with PL12 and the number of the lines are correct.

The only strange thing I have noticed is that the Document_Lines section is repeated twice... I think you should open a message for support to see why it happens.

<?xml version="1.0" encoding="UTF-16" ?>

- <BOM>

- <BO>

- <AdmInfo>

<Object>13</Object>

<Version>2</Version>

</AdmInfo>

- <Documents>

+ <row>

</Documents>

- <Document_Lines>

- <row>

<LineNum>0</LineNum>

<ItemCode>A00001</ItemCode>

...

</row>

- <row>

<LineNum>1</LineNum>

<ItemCode>A00002</ItemCode>

...

</row>

- <row>

<LineNum>2</LineNum>

<ItemCode>A00003</ItemCode>

...

</row>

</Document_Lines>

- <DocumentsAdditionalExpenses>

+ <row>

</DocumentsAdditionalExpenses>

- <Document_Lines>

- <row>

<LineNum>0</LineNum>

<ItemCode>A00001</ItemCode>

...

</row>

- <row>

<LineNum>1</LineNum>

<ItemCode>A00002</ItemCode>

...

</row>

- <row>

<LineNum>2</LineNum>

<ItemCode>A00003</ItemCode>

...

</row>

</Document_Lines>

</BO>

</BOM>

Regards

Trinidad.

[Former Member · Accepted solution]

Trinidad,

Your reply:

" The only strange thing I have noticed is that the Document_Lines section is repeated twice."

is the bug we are dealing with. Since it is not fixed in patch 12 either, how do I request a fix from SAP?

Thanks,

Nancy Walk

nwalk@socket.net

[Trinidad · Accepted solution]

Patch 14 is already available, please test it and if the problem is not solved please create a message for SAP support (in SAP webpages with your S-User). SDN is only to share tips and tricks.

Regards

Trinidad.

[Former Member · Accepted solution]

Dear Nacy,

I tried the PL:12, the Document_Lines repeat twice. Also, i encounter the NullObjectReference in PL:14 when executing the Document object method. So, you have to filter the extra node manually

Regards,

Kit

[Former Member · Accepted solution]

Thank you, everyon who has tested the other patches regarding this problem. I am going to try to write a temporary program to filter out the extra xml node. If anyone has already done this and would care to share their code with me, I would be very grateful.

Nancy

[Former Member · Accepted solution]

Dear Nancy,

You can reslove the problem by patch 14.

Regards,

Kit

[Trinidad]

Are you having the same problem with PL12?