Wednesday, 24 September 2014

How to Import XML file Through X++ coding , SalesOrder XML file How to Import using X++ code

static void SalesOrderCreatandInvoice(Args _args)
{
    RetailTransactionService    RetailTransactionService;
    str   dc;

    XmlDocument doc;
    XmlNodeList data;
    XmlElement nodeTable;
    XmlElement nodeAccount;
    XmlElement nodeName;
    #define.filename(@'C:\Temp\CreateCustomerOrder.xml')
    doc = XmlDocument::newFile(#filename);
    doc.load(@'C:\Temp\CreateCustomerOrder.xml');
   // dc = any2str(doc.lo);

    RetailTransactionService::createCustomerOrder(doc.toString());
}



XML file:

Customer Order / SalesOrder file .

<CustomerOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <AutoPickOrder>false</AutoPickOrder>
  <TransactionId>0000000296</TransactionId>
  <OrderType>SalesOrder</OrderType>
  <Status>0</Status>
  <DocumentStatus>0</DocumentStatus>
  <CustomerAccount>2002</CustomerAccount>
  <AddressRecord>22565427550</AddressRecord>
  <InventLocationId>BOSTON</InventLocationId>
  <StoreId>BOSTON</StoreId>
  <TerminalId>BOSTON-1</TerminalId>
  <TotalManualDiscountAmount>0</TotalManualDiscountAmount>
  <TotalManualDiscountPercentage>0</TotalManualDiscountPercentage>
  <ExpiryDate>2014-09-10</ExpiryDate>
  <HourOfDay>16</HourOfDay>
  <DeliveryMode>60</DeliveryMode>
  <RequestedDeliveryDate>2014-08-11</RequestedDeliveryDate>
  <Comment />
  <PrepaymentAmountOverridden>false</PrepaymentAmountOverridden>
  <PrepaymentAmountApplied>95.61</PrepaymentAmountApplied>
  <PreviouslyInvoicedAmount>0</PreviouslyInvoicedAmount>
  <SalespersonStaffId>000137</SalespersonStaffId>
  <CurrencyCode>USD</CurrencyCode>
  <LoyaltyCardId />
  <HasLoyaltyPayment>false</HasLoyaltyPayment>
  <ChannelReferenceId>STONON-1300001</ChannelReferenceId>
  <Email>marykay@contoso.com</Email>
  <Items>
    <Item ItemId="0061" RecId="0" Quantity="1" QuantityPicked="0" Unit="ea" Price="24.9900000000000000" Discount="0" DiscountPercent="0" NetAmount="24.99" Comment="" TaxGroup="MA" TaxItemGroup="RP" SalesMarkup="0" Status="0" InventLocationId="BOSTON" DeliveryMode="60" RequestedDeliveryDate="2014-08-11" AddressRecord="22565427550" BatchId="" SerialId="" VariantId="" LineDscAmount="0" PeriodicDiscount="0" PeriodicPercentageDiscount="0" LineManualDiscountAmount="0" LineManualDiscountPercentage="0" TotalDiscount="0" TotalPctDiscount="0" IgnDeliveryTime="00:00:00">
      <Charges />
      <Discounts />
      <Salespersons>
        <Salesperson SalespersonId="000100" SalespersonName="Josh Edwards" />
        <Salesperson SalespersonId="000155" SalespersonName="Renata Krausova" />
      </Salespersons>
    </Item>
    <Item ItemId="0066" RecId="0" Quantity="1" QuantityPicked="0" Unit="ea" Price="74.9900000000000000" Discount="0" DiscountPercent="0" NetAmount="74.99" Comment="" TaxGroup="MA" TaxItemGroup="RP" SalesMarkup="0" Status="0" InventLocationId="BOSTON" DeliveryMode="60" RequestedDeliveryDate="2014-08-11" AddressRecord="22565427550" BatchId="" SerialId="" VariantId="" LineDscAmount="0" PeriodicDiscount="0" PeriodicPercentageDiscount="0" LineManualDiscountAmount="0" LineManualDiscountPercentage="0" TotalDiscount="0" TotalPctDiscount="0" IgnDeliveryTime="00:00:00">
      <Charges />
      <Discounts />
      <Salespersons>
        <Salesperson SalespersonId="000110" SalespersonName="Dan Park" />
        <Salesperson SalespersonId="000111" SalespersonName="Patrick Elliot" />
        <Salesperson SalespersonId="000120" SalespersonName="Andrew Lan" />
        <Salesperson SalespersonId="000137" SalespersonName="Emma Harris" />
      </Salespersons>
    </Item>
  </Items>
  <Charges />
  <Payments>
    <Payment PaymentType="1" Amount="10.62" Currency="" Prepayment="false" />
  </Payments>
  <Affiliations />
</CustomerOrder>

1 comment: