<InvoiceLine> <LineItemNumber>000010</LineItemNumber> <GTIN>000000000000245929</GTIN> <TradeItemId> <TradeItemNumber /> <TradeItemNumberTypeCode /> </TradeItemId> <ItemDescription>ME HOLZLASUR ML NUSSBAUM 1250</ItemDescription> <DeliveredQuantity> <Quantity>12.000</Quantity> <MeasureUnitQualifier>PCE</MeasureUnitQualifier> </DeliveredQuantity> <InvoicedQuantity> <Quantity>12.000</Quantity> <MeasureUnitQualifier>PCE</MeasureUnitQualifier> </InvoicedQuantity> <LineItemAmount>201.00</LineItemAmount> <AdditionalIdentification> <BatchNumber /> <HarmonisedSytemNumber /> <PromotionalDealNumber /> </AdditionalIdentification> <NetUnitPrice> <Price>6.70</Price> <UnitPriceBasis>1</UnitPriceBasis> <MeasureUnitQualifier>LTR</MeasureUnitQualifier> </NetUnitPrice> <GrossUnitPrice> <Price /> <UnitPriceBasis /> <MeasureUnitQualifier /> </GrossUnitPrice>
//Start handling line LoadNodeList(XMLDocument,XMLNodeList,'InvoiceLine'); // Load nodes <Items><Item></Item><Items> from XML File. LoadNode(XMLNodeList,XMLNode,0); // Load Node Number 1 (0 = 1) from Node List. REPEAT // Loop through all Nodes. XMLimpIndkøbsFaktura."Faktura nr." := CurrentInvoiceNo; EVALUATE(XMLimpIndkøbsFaktura."Linie nr.",XMLNode.selectNodes('LineItemNumber').item(0).text); EVALUATE(XMLimpIndkøbsFaktura."Leverandørens varenr.",XMLNode.selectNodes('GTIN').item(0).text); EVALUATE(XMLimpIndkøbsFaktura."Leverandørens varetekst",XMLNode.selectNodes('ItemDescription').item(0).text); XMLNode := XMLNodeList.nextNode; // Next Node Element
Comments
RIS Plus, LLC
MVP - Business Apps
Thank you very much for the help. I looked into C.6226 and completly rewrote my code and now it works perfectly.
Best regards
Andhilda
Oh one more thing you will run into. Make sure you program type conversion. The XML document holds text values only, so you will have to convert those values into option values, integers, decimals, booleans, etc.
RIS Plus, LLC
MVP - Business Apps