x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 0 replies
  • Subscribers 26 subscribers
  • Views 1263 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
631
topics
887
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
abinaya

I Need XML Template for purchase order and sales order import to sage 50

Posted By

Hi,

I am using sage 50 application version 2017 and Peachwserver DLL version is 24.0 and Run time version is v4.0.30319. I am also using visual studio version 2013.

My Sample Code:

public static void Import(BOAccountSettings settings, Logger logger)
{
if (logger != null)
logger.Log("BOAccount.Import(): START", Logger.LogType.Debug);

if (settings == null)
throw new Exception("BOAccount.Import(): The BOAccountSettings object that was passed is null.");

if (logger != null)
logger.Log("BOAccount.Import(): Importing accounts from " + settings.Filename + ".xml...", Logger.LogType.Debug);

if (logger != null)
logger.Log("Importing G/L accounts...", Logger.LogType.Information);
if (logger != null)
logger.Log("Importing G/L account data into Sage 50...", Logger.LogType.Detail);
if (logger != null)
logger.Log("-1", Logger.LogType.Percentage);

#region ImportAccounts
try
{


Interop.PeachwServer.LoginSelector ptSelector = new Interop.PeachwServer.LoginSelector();
Interop.PeachwServer.Login ptLogin = (Interop.PeachwServer.Login)ptSelector.GetCurrentLoginObject();
dynamic ptApp = ptLogin.GetApplication(settings.COMUserName, settings.COMPassword);
Interop.PeachwServer.Import importer;
importer = (Interop.PeachwServer.Import)ptApp.CreateImporter(Interop.PeachwServer.PeachwIEObj.peachwIEObjSalesOrders);
importer.ClearImportFieldList();

if (settings.IncludeGUIDs)
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_CustomerGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_CustomerId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_CustomerName);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToName);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToAddressLine1);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToAddressLine2);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToCity);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToState);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToZip);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipToCountry);
//importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Date);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipByDate);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesOrderNumber);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesOrderClosed);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesOrderDistNum);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesTaxAuthority);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesTaxCode);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_TaxType);
//importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_NumFields);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Quantity);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_QuoteNumber);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_DropShip);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_CustomerPurchaseOrder);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ShipVia);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Description);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ItemId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ItemGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_UnitPrice);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Amount);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_JobId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_JobGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_UPCSKU);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Weight);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_SalesRepId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ARAccountId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ARAccountGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_ARAmount);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_GLAccountGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_GLAccountId);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_Description);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_DiscountAmount);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_DisplayedTerms);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_DropShip);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_enProposal);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_enProposalAccepted);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_enStockingQuantity);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_enUMID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_enUMStockingUnitPrice);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_NumberOfDistributions);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_NotePrintsAfterLineItems);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_StatementNote);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_StatementPrintsBeforeInvoiceRef);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_TransactionGUID);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_TransactionPeriod);
importer.AddToImportFieldList((short)Interop.PeachwServer.PeachwIEObjSalesOrdersField.peachwIEObjSalesOrdersField_TransactioNumber);

importer.SetFileIncludesHeadersFlag(1);

importer.SetFilename("D:\\Sage\\Sample1.xml");
importer.SetFileType(Interop.PeachwServer.PeachwIEFileType.peachwIEFileTypeXML);
importer.Import();

}
catch (Exception ex)
{

throw;
}
#endregion

if (logger != null)
logger.Log("BOAccount.SaveAll(): Account objects successfully imported to database.", Logger.LogType.Debug);
if (logger != null)
logger.Log("G/L accounts successfully imported into Sage 50.", Logger.LogType.Detail);
if (logger != null)
logger.Log("-1", Logger.LogType.Percentage);

// Wait until the file is available for the next step
Sage50Application.CheckIfBeingUsedByAnotherProcess("D:\\Sage\\Sample1.xml");
if (logger != null)
logger.Log("", Logger.LogType.Information);
if (logger != null)
logger.Log("BOAccount.Import(): END", Logger.LogType.Debug);
}

 I have import two templates to sage 50 but is not import.

My Template is 

1. <?xml version="1.0" encoding="utf-8"?>
<Company xmlns:xsi="www.w3.org/.../XMLSchema-instance"
xmlns:xsd="www.w3.org/.../XMLSchema">
<SalesOrders>
<SalesOrder>
<Id>12345</Id>
<AccountReference>INTE001</AccountReference>
<SalesOrderDate>2011-01-01T11:11:11</SalesOrderDate>
<SalesOrderAddress>
<Title>Mr</Title>
<Forename>Test</Forename>
<Surname>Person</Surname>
<Company>Internetware</Company>
<Address1>i6 Building</Address1>
<Address2>6-8 Charlotte Square</Address2>
<Address3 />
<Town>Newcastle Upon Tyne</Town>
<Postcode>NE1 4XF</Postcode>
<County>County</County>
<Country>GB</Country>
<Telephone>0845 123 2920</Telephone>
<Fax>0845 123 2921</Fax>
<Email>[email protected]</Email>
</SalesOrderAddress>
<SalesOrderDeliveryAddress>
<Title>Mr</Title>
<Forename>Test</Forename>
<Surname>Person</Surname>
<Company>Internetware</Company>
<Address1>i6 Building</Address1>
<Address2>6-8 Charlotte Square</Address2>
<Address3 />
<Town>Newcastle Upon Tyne</Town>
<Postcode>NE1 4XF</Postcode>
<County>County</County>
<Country>GB</Country>
<Telephone>0845 123 2920</Telephone>
<Fax>0845 123 2921</Fax>
<Email>[email protected]</Email>
</SalesOrderDeliveryAddress>
<SalesOrderItems>
<Item>
<Sku>TEST01</Sku>
<QtyOrdered>1</QtyOrdered>
<UnitPrice>200</UnitPrice>
</Item>
</SalesOrderItems>
<TakenBy>Connect Web Order</TakenBy>
</SalesOrder>
</SalesOrders>
</Company>

2.<?xml version="1.0" encoding="utf-8"?>
<orders xmlns="www.demandware.com/.../2006-10-31">
<order order-no="000000522">
<order-date>2016-10-06T14:31:08.477Z</order-date>
<created-by>storefront</created-by>
<original-order-no>000000522</original-order-no>
<currency>USD</currency>
<customer-locale>en_US</customer-locale>
<taxation>net</taxation>
<invoice-no/>
<custom-attributes>
<custom-attribute attribute-id="sendOrderConfEmail">N</custom-attribute>
<custom-attribute attribute-id="storeId">431</custom-attribute>
<custom-attribute attribute-id="avalaraDocId"/>
</custom-attributes>
<customer>
<customer-no>127</customer-no>
<customer-name>Mohan</customer-name>
<customer-email>[email protected]</customer-email>
<billing-address>
<first-name>Mohan</first-name>
<last-name>1</last-name>
<address1>56 110 St Apt "B"</address1>
<address2/>
<city>Astoria</city>
<postal-code>11333</postal-code>
<state-code>NY</state-code>
<country-code>US</country-code>
<phone>718-555-9048</phone>
</billing-address>
</customer>
<status>
<order-status>NEW</order-status>
<shipping-status>NOT_SHIPPED</shipping-status>
<confirmation-status>CONFIRMED</confirmation-status>
<payment-status>NOT_PAID</payment-status>
</status>
<current-order-no>000000522</current-order-no>
<product-lineitems>
<product-lineitem>
<net-price>110</net-price>
<tax>9.76</tax>
<gross-price>119.76</gross-price>
<base-price>110</base-price>
<lineitem-text>Stellar solar Jacket</lineitem-text>
<tax-basis>9.76</tax-basis>
<position>1</position>
<product-id>Stellar solar Jacket</product-id>
<product-name>Stellar solar Jacket</product-name>
<quantity unit="Each">1</quantity>
<tax-rate>8.875</tax-rate>
<shipment-id/>
<gift>false</gift>
<price-adjustments>
<price-adjustment>
<net-price>0</net-price>
<tax>9.76</tax>
<gross-price>0</gross-price>
<base-price>0</base-price>
<lineitem-text></lineitem-text>
<tax-basis>9.76</tax-basis>
<promotion-id/>
<campaign-id/>
<coupon-id/>
</price-adjustment>
</price-adjustments>
</product-lineitem>
</product-lineitems>
<shipping-lineitems>
<shipping-lineitem>
<net-price>5.95</net-price>
<tax>0.53</tax>
<gross-price>6.48</gross-price>
<base-price>5.95</base-price>
<lineitem-text>Shipping</lineitem-text>
<tax-basis>5.95</tax-basis>
<item-id>Standard</item-id>
<shipment-id/>
<tax-rate>8.875</tax-rate>
</shipping-lineitem>
</shipping-lineitems>
<shipments>
<shipment shipment-id="">
<status>
<shipping-status>NOT_SHIPPED</shipping-status>
</status>
<shipping-method>592</shipping-method>
<shipping-address>
<first-name>Mohan</first-name>
<last-name>1</last-name>
<address1>56 110 St Apt "B"</address1>
<address2/>
<city>Astoria</city>
<postal-code>11333</postal-code>
<state-code>NY</state-code>
<country-code>US</country-code>
<phone></phone>
<custom-attributes>
<custom-attribute attribute-id="validationStatus">Valid</custom-attribute>
</custom-attributes>
</shipping-address>
<gift>false</gift>
<totals>
<merchandize-total>
<net-price>110</net-price>
<tax>9.76</tax>
<gross-price>119.76</gross-price>
</merchandize-total>
<adjusted-merchandize-total>
<net-price>2</net-price>
<tax>0</tax>
<gross-price>2</gross-price>
</adjusted-merchandize-total>
<shipping-total>
<net-price>5.95</net-price>
<tax>0.53</tax>
<gross-price>6.48</gross-price>
</shipping-total>
<adjusted-shipping-total>
<net-price>5.95</net-price>
<tax>0.53</tax>
<gross-price>6.48</gross-price>
</adjusted-shipping-total>
<order-total>
<net-price>116.48</net-price>
<tax>9.76</tax>
<gross-price>128.24</gross-price>
</order-total>
</totals>
</shipment>
</shipments>
<totals>
<merchandize-total>
<net-price>110</net-price>
<tax>9.76</tax>
<gross-price>119.76</gross-price>
</merchandize-total>
<adjusted-merchandize-total>
<net-price>2</net-price>
<tax>0</tax>
<gross-price>2</gross-price>
</adjusted-merchandize-total>
<shipping-total>
<net-price>5.95</net-price>
<tax>0.53</tax>
<gross-price>6.48</gross-price>
</shipping-total>
<adjusted-shipping-total>
<net-price>5.95</net-price>
<tax>0.53</tax>
<gross-price>6.48</gross-price>
</adjusted-shipping-total>
<order-total>
<net-price>116.48</net-price>
<tax>9.76</tax>
<gross-price>128.24</gross-price>
</order-total>
</totals>
<payments>
<payment>
<credit-card>
<card-type>Visa</card-type>
<card-number>1111</card-number>
<expiration-month>4</expiration-month>
<expiration-year>2020</expiration-year>
</credit-card>
<custom-method>
<method-name>Credit Card</method-name>
</custom-method>
<amount>128.24</amount>
<processor-id></processor-id>
<transaction-id>4757643608516231401014</transaction-id>
<custom-attributes>
<custom-attribute attribute-id="approvalStatus">100</custom-attribute>
<custom-attribute attribute-id="authAmount">128.24</custom-attribute>
<custom-attribute attribute-id="authCode">3242</custom-attribute>
<custom-attribute attribute-id="requestId">23423</custom-attribute>
<custom-attribute attribute-id="requestToken">Ahj/7wSTAemRht6Nl442ESDdm2bMGrFzHqVZLajVoJcMf/0RQClwx//RFaQOyGGIiGTSTLdIDyftYE5MB6ZGG3o2XjjYLARN</custom-attribute>
<custom-attribute attribute-id="creditCardToken"/>
</custom-attributes>
</payment>
</payments>
<remoteHost></remoteHost>
</order>
</orders>

*Community Hub is the new name for Sage City