AnsweredAssumed Answered

Peachtree Sales_Price field returns zero when updating to MySQL database

Question asked by khobar.it430393 on Aug 28, 2016
Latest reply on Sep 14, 2016 by Srinivas Chandrakanth Vangari

Peachtree Sales_Price (Price Level  1) field returns zero when updating to MySQL database but when inserting it shows in ten lines as shown here in Peachtree and MySQL database:

MySQL database

MySQL database

Probably because there are ten prices levels in Peachtree. How do I just insert or update on the first row only. I’ve noticed that there a @Key field and a Sales_Price field. I tried using string concat and input value as 1 in the @Key as shown in the below pic but still I can’t the first row. What should I do?

 

Map Function String Concat

 

Here is the Connection Data Test Results

<?xml version="1.0" encoding="UTF-8"?>

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

<PAW_Item>

                <ID>WS-C3750X-12S-S</ID>

                <Description>Catalyst 3750X 12 Port GE SFP</Description>

                <Class>1</Class>

                <isInactive>FALSE</isInactive>

                <Subject_to_Commission>FALSE</Subject_to_Commission>

                <Sales_Prices>

                <Sales_Price_Info Key="1">

                <Sales_Price>14980.00000</Sales_Price>

                <Sales_Price_Calc>LC*1.0700000</Sales_Price_Calc>

                <Sales_Price_Rounding>2</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="2">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="3">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="4">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="5">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="6">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="7">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="8">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="9">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

                <Sales_Price_Info Key="10">

                <Sales_Price>0.00000</Sales_Price>

                <Sales_Price_Calc>NC</Sales_Price_Calc>

                <Sales_Price_Rounding>0</Sales_Price_Rounding>

                <Sales_Price_Rounding_Cent>0.00000</Sales_Price_Rounding_Cent>

                </Sales_Price_Info>

</Sales_Prices>                <Tax_Type>0</Tax_Type>

                <Last_Unit_Cost>14000.00000</Last_Unit_Cost>

                <Costing_Method>1</Costing_Method>

                <GL_Sales_Account>40000</GL_Sales_Account>

                <GL_Sales_Account_GUID>{0B563AB7-2CC1-47A1-8C7C-3B1D416373B4}</GL_Sales_Account_GUID>

                <GL_Inventory_Account>12000</GL_Inventory_Account>

                <GL_Inventory_Account_GUID>{4F6173DB-E2ED-40F6-9ABE-3ECDFEF546DD}</GL_Inventory_Account_GUID>

                <GL_COGSSalary_Acct>50000</GL_COGSSalary_Acct>

                <GL_COGSSalary_Acct_GUID>{925E7E10-EB89-4200-9C57-489061971752}</GL_COGSSalary_Acct_GUID>

                <Weight>0.00000</Weight>

                <Minimum_Stock>0.00000</Minimum_Stock>

                <Reorder_Quantity>0.00000</Reorder_Quantity>

                <GUID>{ED88FA0C-3D9F-4125-9503-9F764981A84C}</GUID>

                <CustomFields>

                <CustomField>

                <Description>Alternate Vendor</Description>

                <Value Index="1" />

                </CustomField>

                <CustomField>

                <Description>Substitution    </Description>

                <Value Index="2" />

                </CustomField>

                <CustomField>

                <Description>Special Note    </Description>

                <Value Index="3" />

                </CustomField>

                <CustomField>

                <Description>&lt;Custom Field 4&gt;</Description>

                <Value Index="4" />

                </CustomField>

                <CustomField>

                <Description>&lt;Custom Field 5&gt;</Description>

                <Value Index="5" />

                </CustomField>

</CustomFields>             <Substock_Primary_Attributes>

</Substock_Primary_Attributes>             <Substock_Secondary_Attributes>

</Substock_Secondary_Attributes>       <QuantityOnSO>0.00000</QuantityOnSO>

                <QuantityOnPO>0.00000</QuantityOnPO>

                <QuantityOnHand>11.00000</QuantityOnHand>

                <IsTaxable>TRUE</IsTaxable>

                <Tax_Type_Name>Regular</Tax_Type_Name>

                <Class_Description>Stock item</Class_Description>

                <Use_MultiPacks>FALSE</Use_MultiPacks>

                <Purchasing_UM_Num_Stocking_Units>0.00000</Purchasing_UM_Num_Stocking_Units>

                <Purchasing_Weight>0.00000</Purchasing_Weight>

                <Purchasing_UM_As_Default>FALSE</Purchasing_UM_As_Default>

                <Sales_UM_Num_Stocking_Units>0.00000</Sales_UM_Num_Stocking_Units>

                <Sales_Weight>0.00000</Sales_Weight>

                <Sales_UM_As_Default>FALSE</Sales_UM_As_Default>

                <Print_Components>FALSE</Print_Components>

                <Number_of_Components>0</Number_of_Components>

                <Components>

                <Component>

                <Effective_Date />

                <Component_Number>0</Component_Number>

                <Qty_Needed>0.00000</Qty_Needed>

                </Component>

</Components></PAW_Item>

</PAW_Items>

Outcomes