Add Freight to Invoice in import

SUGGESTED

I'm trying to import a Freigh to an invoice and always gives an error of Type_Tax because I always left in value 26, 

Setting Sales tax:

Sales Tax ID TA
Sales Tax Name Tax Example

Detail:

Agency Name Transporte
ID TA001
Rate 4.5%

Also check that GL Account has Freight in Sage 50: 57500-00

add the xml file import that I am doing:

<?xml version="1.0"?>

-<PAW_Invoices xmlns:xsd="http://www.w3.org/2000/10/XMLSchema-datatypes" xmlns:xsi="http://www.w3.org/2000/10/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>-10</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>2</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>3</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>

Parents Reply Children