Can someone help me, that I may be doing wrong , Thank you

Hi Ben,

Are you importing this into Sage 50—U.S. Edition?

If so, in Sage 50 Tax Type can be between 0 - 27, see Article 25994: What are the Sales Journal fields for Import / Export?

Try changing tax_type to 0, and see if that imports.

I hope this helps.

JSelemani

Hi JSelemani, the version is  Sage 50—U.S. Edition  

If I see is the option 27, now if I use the freight that is what I want to import there is any relationship with jobid? or I misunderstood that part, you could enlighten me

Thanks

Hi Ben,

Try this...

Change the following line to reflect a total of  '3' distributions:

<Number_of_Distributions>2</Number_of_Distributions>

Then....

Set the following line to reflect distribution number of '0' in the actual freight charge node:

<SalesOrderDistributionNumber>3</SalesOrderDistributionNumber>

Hope this helps,

Scott

Hi Scott

I was reviewing and only change a information tax_type = 26

Attached final code in case someone else needs it

Thanks for help me

Ben

<?xml version="1.0"?>

<PAW_Invoices xmlns:xsd="www.w3.org/.../XMLSchema-datatypes" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:paw="urn:schemas-peachtree-com/paw8.02-datatypes">

<PAW_Invoice xsi:type="paw:receipt">

<Customer_ID xsi:type="paw:ID">REST01</Customer_ID>

<Customer_Name>Restaurante Grill and Bar La Cacerola</Customer_Name>

<Date xsi:type="paw:date">03/24/2015 12:00:00</Date>

<Sales_Tax_Code xsi:type="paw:ID">TA</Sales_Tax_Code>

<Ship_Date xsi:type="paw:date">3/25/2015 12:53:53 PM</Ship_Date>

<Date_Due xsi:type="paw:date">04/23/2015 12:00:00</Date_Due>

<Discount_Date xsi:type="paw:date">03/24/2015 12:00:00</Discount_Date>

<Discount_Amount/>

<Displayed_Terms>30 Days</Displayed_Terms>

<Invoice_Number>1008</Invoice_Number>

<ShipToAddress>

<Name/>

<Line1/>

<Line2/>

<City/>

<State/>

<Zip/>

</ShipToAddress>

<Accounts_Receivable_Account xsi:type="paw:ID">11000-00</Accounts_Receivable_Account>

<Accounts_Receivable_Amount>11.9800</Accounts_Receivable_Amount>

<Sales_Representative_ID xsi:type="paw:id">LSWEET</Sales_Representative_ID>

<GL_Sales_Acct>40000-AV</GL_Sales_Acct>

<Note/>

<CreditMemoType>FALSE</CreditMemoType>

<Number_of_Distributions>3</Number_of_Distributions>

<SalesLines>

<SalesLine>

<SalesOrderDistributionNumber>1</SalesOrderDistributionNumber>

<Quantity>0</Quantity>

<Description>Transporte</Description>

<GL_Account xsi:type="paw:id">40000-AV</GL_Account>

<Unit_Price>0</Unit_Price>

<Tax_Type>0</Tax_Type>

<Sales_Tax_Authority>TA001</Sales_Tax_Authority>

<Amount>-0.54</Amount>

</SalesLine>

<SalesLine>

<SalesOrderDistributionNumber>2</SalesOrderDistributionNumber>

<Quantity>2.0000</Quantity>

<Item_ID xsi:type="paw:id">FERT-16110</Item_ID>

<UM_ID xsi:type="paw:id">Bag</UM_ID>

<UM_Stocking_Units>1</UM_Stocking_Units>

<Stocking_Quantity>1</Stocking_Quantity>

<Description>Bell-Gro Azalea and Evergreen Food 4 lb. Bag</Description>

<GL_Account xsi:type="paw:id">40000-FF</GL_Account>

<Unit_Price>-5.99</Unit_Price>

<Tax_Type>1</Tax_Type>

<Amount>-11.98</Amount>

</SalesLine>

<SalesLine>

<SalesOrderDistributionNumber>0</SalesOrderDistributionNumber>

<Quantity>0</Quantity>

<Description>freight charge</Description>

<GL_Account xsi:type="paw:id">57500-00</GL_Account>

<Unit_Price>0</Unit_Price>

<Tax_Type>26</Tax_Type>

<Amount>-20.00</Amount>

</SalesLine>

</SalesLines>

</PAW_Invoice>

</PAW_Invoices>