Patricia

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 33 total)
  • Author
    Posts
  • in reply to: Custom fields not passing to Quickbooks. #65109

    Patricia
    Participant

    Thanks, Rohan.

    My issue is with the ItemInventory table. In QB in the Item List, I have the Custom Fields created, along with the values they can contain. (For example, ‘Active’, ‘Discontinued’, et al) These custom fields pertain to all items, so no matter what item I open, I can see the custom fields.

    I have been maintaining two custom fields per item for about 5 years. Now when I put a value in the CustomField1 column in the iteminventory table, it never updates QB, AND it is erased after a Refresh/Update.

    This is a big problem for me…. Not quite like your problem.

    I updated to OpenSync late last year, and to QB 2019 early this year – both with full database Populates. My customer only recently noticed that these fields were not being updated…..

    Thanks for your input.

    in reply to: Custom Field value disappears after sync #65107

    Patricia
    Participant

    Custom fields not updating is a big problem for me; I am using the ItemInventory table only – not estimates (never have used Estimates). This worked for 5 years with OpenSync 2.0 – are CustomFields broken in Version 3.0??

    in reply to: Custom fields #65105

    Patricia
    Participant

    I have been updating Custom Fields in QB via OpenSync 2.0 for 5 years. And the data stays in the CustomField columns in the database.
    Has this broken with OpenSync 3.0?

    My customer RELIES on this functionality. Please help.

    in reply to: Custom fields not passing to Quickbooks. #65103

    Patricia
    Participant

    Rohan,
    Did you ever get an answer to this issue?
    I have been updating Custom Fields with OpenSync for 5 years with version 2 with no problem. Now with version 3 these fields are no longer updated in QB and they are not retained in the db table. I am updating ItemInventory.

    Do you have a solution?
    Thanks in advance
    Patricia Lawson
    pat@bluediamondapps.com

    I appreciate any input!!


    Patricia
    Participant

    I have the same issue. Please, OpenSync support, try to look into this.

    When we first started using OpenSync several years ago this did not happen. Please, check it out!

    in reply to: Need better / more info in OpenSync Log #64461

    Patricia
    Participant

    Does the os_log table exist for OpenSync v 2.0.71?

    Does it need to be enabled? I use history and error table all the time but do not have os_log.

    Thanks

    in reply to: Vendor.name truncated to 11 characters on populate #63821

    Patricia
    Participant

    Andrew – is it the datatype of the the vendor name that you changed or the size of the field?

    in reply to: OpenSync 2 – QB 2018 #63820

    Patricia
    Participant

    Hello Yair;

    The notes on your recent update were very useful to me.
    I have a few more questions:
    1. Did you have to do full rebuild after your update?
    2. Did you update your ODBC driver? (I am on 5.1)

    Thanks in advance!
    Pat


    Patricia
    Participant

    I repeat my question: what is the length of the column Other1 in Quickbooks?


    Patricia
    Participant

    Yes, I can make the field 29 characters but I actually chose it because a need a longer string. Is 29 the limit in QB for this field?

    in reply to: ItemInventory will not update #15584

    Patricia
    Participant

    Just to confirm understanding, you are saying that the bug related to UnitOfMeasure can stop iteminventory from updating…

    And the fact that I used the IIF technique to add the inventory into QB had no bearing on the matter? That would be GOOD.

    in reply to: ItemInventory will not update #15581

    Patricia
    Participant

    I can now update iteminventory.

    I enabled UnitofMeasure and on one item I created the measure ea each (selected the top radio button when assigning UM for the first item.)
    I repopulated iteminventory. (Not sure I needed to..)
    Set listid for all items to the same as for the single item. Ran refreshupdate
    465 item failed on ReorderPoint must be less than Max (whatever the msg is )
    Set all ReorderPoint to NULL where Max = 0, to keep the ReorderPoint < Max
    Now update works.

    I am not certain I needed to turn on UM, and could find no QB advice on it, although I can see no reason NOT to do this, since we are using Inventory. I think a big key was making ReorderPoint NULL when Max = 0.

    Can this really be the source of our problems, Tom?

    in reply to: ItemInventory will not update #15576

    Patricia
    Participant

    NO


    Patricia
    Participant

    Could not upload files; here they are”

    UpdateCustomer.xml
    <CoreObjXLog CompanyPath=”C:\AnaheimGear\AnaheimGear2017\AnaheimGear.QBW” qbXMLVersion=”13.0″ ProductName=”Intuit QuickBooks Desktop Enterprise Solutions: Manufacturing and Wholesale 17.0″ MajorVersion=”27″ MinorVersion = “0” CoreObjXVersion=”7.0.178″>
    <OUTGOING>
    <QBXML><QBXMLMsgsRq onError = “continueOnError”><CustomerModRq requestID = “1”><CustomerMod><ListID>80000002-1483912556</ListID><EditSequence>1484324409</EditSequence><Name>#1 TRANSMISSION</Name><IsActive>1</IsActive><CompanyName>#1 TRANSMISSION</CompanyName><Salutation></Salutation><FirstName>EDGAR, BERTHA</FirstName><MiddleName></MiddleName><LastName></LastName><BillAddress><Addr1>#1 TRANSMISSION</Addr1><Addr2>3855 S VALLEY VIEW UNIT 37</Addr2><Addr3></Addr3><Addr4></Addr4><Addr5></Addr5><City>LAS VEGAS</City><State>NV</State><PostalCode>89103</PostalCode><Country></Country><Note></Note></BillAddress><ShipAddress><Addr1>#1 TRANSMISSION</Addr1><Addr2>3855 S VALLEY VIEW UNIT 37</Addr2><Addr3></Addr3><Addr4></Addr4><Addr5></Addr5><City>LAS VEGAS</City><State>NV</State><PostalCode>89103</PostalCode><Country></Country><Note>702-558-2324</Note></ShipAddress><Phone>702-558-2324</Phone><AltPhone></AltPhone><Fax></Fax><Email>test@test.com</Email><Contact>EDGAR</Contact><AltContact></AltContact><CustomerTypeRef><FullName></FullName></CustomerTypeRef><TermsRef><FullName>CREDIT CARD</FullName></TermsRef><SalesRepRef><FullName></FullName></SalesRepRef><SalesTaxCodeRef><FullName>Non</FullName></SalesTaxCodeRef><ItemSalesTaxRef><FullName>Out of State</FullName></ItemSalesTaxRef><ResaleNumber></ResaleNumber><AccountNumber></AccountNumber><CreditLimit></CreditLimit><PreferredPaymentMethodRef><FullName></FullName></PreferredPaymentMethodRef><JobStatus>None</JobStatus><JobDesc></JobDesc><JobTypeRef><FullName></FullName></JobTypeRef><PriceLevelRef><FullName>SHOP</FullName></PriceLevelRef></CustomerMod></CustomerModRq></QBXMLMsgsRq></QBXML>
    </OUTGOING>
    <RETURNS>

    <QBXML>
    <QBXMLMsgsRs>
    <CustomerModRs requestID=”1″ statusCode=”0″ statusSeverity=”Info” statusMessage=”Status OK”>
    <CustomerRet>
    <ListID>80000002-1483912556</ListID>
    <TimeCreated>2017-01-08T13:55:56-08:00</TimeCreated>
    <TimeModified>2017-04-03T09:10:52-08:00</TimeModified>
    <EditSequence>1491235852</EditSequence>
    <Name>#1 TRANSMISSION</Name>
    <FullName>#1 TRANSMISSION</FullName>
    <IsActive>true</IsActive>
    <Sublevel>0</Sublevel>
    <CompanyName>#1 TRANSMISSION</CompanyName>
    <FirstName>EDGAR, BERTHA</FirstName>
    <BillAddress>
    <Addr1>#1 TRANSMISSION</Addr1>
    <Addr2>3855 S VALLEY VIEW UNIT 37</Addr2>
    <City>LAS VEGAS</City>
    <State>NV</State>
    <PostalCode>89103</PostalCode>
    </BillAddress>
    <BillAddressBlock>
    <Addr1>#1 TRANSMISSION</Addr1>
    <Addr2>3855 S VALLEY VIEW UNIT 37</Addr2>
    <Addr3>LAS VEGAS, NV 89103</Addr3>
    </BillAddressBlock>
    <ShipAddress>
    <Addr1>#1 TRANSMISSION</Addr1>
    <Addr2>3855 S VALLEY VIEW UNIT 37</Addr2>
    <City>LAS VEGAS</City>
    <State>NV</State>
    <PostalCode>89103</PostalCode>
    <Note>702-558-2324</Note>
    </ShipAddress>
    <ShipAddressBlock>
    <Addr1>#1 TRANSMISSION</Addr1>
    <Addr2>3855 S VALLEY VIEW UNIT 37</Addr2>
    <Addr3>LAS VEGAS, NV 89103</Addr3>
    <Addr4>702-558-2324</Addr4>
    </ShipAddressBlock>
    <ShipToAddress>
    <Name>Ship To 1</Name>
    <Addr1>#1 TRANSMISSION</Addr1>
    <Addr2>3855 S VALLEY VIEW UNIT 37</Addr2>
    <City>LAS VEGAS</City>
    <State>NV</State>
    <PostalCode>89103</PostalCode>
    <Note>702-558-2324</Note>
    <DefaultShipTo>true</DefaultShipTo>
    </ShipToAddress>
    <Phone>702-558-2324</Phone>
    <Email>test@test.com</Email>
    <Contact>EDGAR</Contact>
    <AdditionalContactRef>
    <ContactName>Main Phone</ContactName>
    <ContactValue>702-558-2324</ContactValue>
    </AdditionalContactRef>
    <AdditionalContactRef>
    <ContactName>Main Email</ContactName>
    <ContactValue>test@test.com</ContactValue>
    </AdditionalContactRef>
    <ContactsRet>
    <ListID>00000000000001Hn</ListID>
    <TimeCreated>2017-01-08T20:55:56-08:00</TimeCreated>
    <TimeModified>2017-04-03T16:10:52-08:00</TimeModified>
    <EditSequence>1491261052</EditSequence>
    <FirstName>EDGAR</FirstName>
    </ContactsRet>
    <TermsRef>
    <ListID>80000008-1483912556</ListID>
    <FullName>CREDIT CARD</FullName>
    </TermsRef>
    <Balance>0.00</Balance>
    <TotalBalance>0.00</TotalBalance>
    <SalesTaxCodeRef>
    <ListID>80000002-1483912460</ListID>
    <FullName>Non</FullName>
    </SalesTaxCodeRef>
    <ItemSalesTaxRef>
    <ListID>80000002-1483912556</ListID>
    <FullName>Out of State</FullName>
    </ItemSalesTaxRef>
    <JobStatus>None</JobStatus>
    <PreferredDeliveryMethod>None</PreferredDeliveryMethod>
    <PriceLevelRef>
    <ListID>80000001-1483912556</ListID>
    <FullName>SHOP</FullName>
    </PriceLevelRef>
    </CustomerRet>
    </CustomerModRs>
    </QBXMLMsgsRs>
    </QBXML>

    </RETURNS>
    </CoreObjXLog>

    UpdateItemInventory.xml
    <CoreObjXLog CompanyPath=”C:\AnaheimGear\AnaheimGear2017\AnaheimGear.QBW” qbXMLVersion=”13.0″ ProductName=”Intuit QuickBooks Desktop Enterprise Solutions: Manufacturing and Wholesale 17.0″ MajorVersion=”27″ MinorVersion = “0” CoreObjXVersion=”7.0.178″>
    <OUTGOING>
    <QBXML><QBXMLMsgsRq onError = “continueOnError”><ItemInventoryModRq requestID = “1”><ItemInventoryMod><ListID>80000008-1483913079</ListID><EditSequence>1490325848</EditSequence><Name>013 311 295A</Name><IsActive>true</IsActive><ManufacturerPartNumber></ManufacturerPartNumber><UnitOfMeasureSetRef><FullName></FullName></UnitOfMeasureSetRef><SalesTaxCodeRef><FullName>Tax</FullName></SalesTaxCodeRef><SalesDesc>SYNCRO RING</SalesDesc><SalesPrice>0000000.00000</SalesPrice><IncomeAccountRef><FullName>RESALE:Parts</FullName></IncomeAccountRef><PurchaseDesc>SYNCRO RING</PurchaseDesc><PurchaseCost>0000000.00000</PurchaseCost><COGSAccountRef><FullName>Cost of Goods Sold:Parts</FullName></COGSAccountRef><PrefVendorRef><FullName></FullName></PrefVendorRef><AssetAccountRef><FullName>Inventory Asset</FullName></AssetAccountRef><ReorderPoint>0000000.00000</ReorderPoint><Max>0000000.00000</Max></ItemInventoryMod></ItemInventoryModRq></QBXMLMsgsRq></QBXML>
    </OUTGOING>
    <RETURNS>

    <QBXML>
    <QBXMLMsgsRs>
    <ItemInventoryModRs requestID=”1″ statusCode=”3060″ statusSeverity=”Error” statusMessage=”There was an error when converting the quantity "0000000.00000" in the field "reorder point". QuickBooks error message: The min quantity must be less than the max quantity.” />
    </QBXMLMsgsRs>
    </QBXML>

    </RETURNS>
    </CoreObjXLog>

    UpdateIteminventory.xml after changing Max to 3
    <CoreObjXLog CompanyPath=”C:\AnaheimGear\AnaheimGear2017\AnaheimGear.QBW” qbXMLVersion=”13.0″ ProductName=”Intuit QuickBooks Desktop Enterprise Solutions: Manufacturing and Wholesale 17.0″ MajorVersion=”27″ MinorVersion = “0” CoreObjXVersion=”7.0.178″>
    <OUTGOING>
    <QBXML><QBXMLMsgsRq onError = “continueOnError”><ItemInventoryModRq requestID = “1”><ItemInventoryMod><ListID>80000008-1483913079</ListID><EditSequence>1490325848</EditSequence><Name>013 311 295A</Name><IsActive>true</IsActive><ManufacturerPartNumber></ManufacturerPartNumber><UnitOfMeasureSetRef><FullName></FullName></UnitOfMeasureSetRef><SalesTaxCodeRef><FullName>Tax</FullName></SalesTaxCodeRef><SalesDesc>SYNCRO RING</SalesDesc><SalesPrice>0000000.00000</SalesPrice><IncomeAccountRef><FullName>RESALE:Parts</FullName></IncomeAccountRef><PurchaseDesc>SYNCRO RING</PurchaseDesc><PurchaseCost>0000000.00000</PurchaseCost><COGSAccountRef><FullName>Cost of Goods Sold:Parts</FullName></COGSAccountRef><PrefVendorRef><FullName></FullName></PrefVendorRef><AssetAccountRef><FullName>Inventory Asset</FullName></AssetAccountRef><ReorderPoint>0000000.00000</ReorderPoint><Max>0000003.00000</Max></ItemInventoryMod></ItemInventoryModRq></QBXMLMsgsRq></QBXML>
    </OUTGOING>
    <RETURNS>

    <QBXML>
    <QBXMLMsgsRs>
    <ItemInventoryModRs requestID=”1″ statusCode=”3060″ statusSeverity=”Error” statusMessage=”There was an error when converting the quantity "0000000.00000" in the field "reorder point". QuickBooks error message: The min quantity must be less than the max quantity.” />
    </QBXMLMsgsRs>
    </QBXML>

    </RETURNS>
    </CoreObjXLog>


    Patricia
    Participant

    Hello Tom,
    Attached are the files you requested.

    Note two things:
    Today’s trace file UpdateIteminventory is very similar in length and content to the first one I sent. The UpdateCustomer.XML appears to be normal.

    Today my error message in UpdateIteminventory is DIFFERENT. Today I have an error about min quantity must be less than max quantity. Both are 0.

    I just changed Max to 3 and left ReorderPoint at 0, and then got this error: There was an error when converting the quantity “0000000.00000” in the field “reorder point”. QuickBooks error message: The min quantity must be less than the max quantity. I attached the UpdateIteminventory.xml for that update.

    The UpdateIteminventory.xml files all remain seemingly truncated.

    I really hope this helps. Being able to update Iteminventory is, of course, critical for us.

    Thanks in advance,
    Pat

    Attachments:
    You must be logged in to view attached files.
Viewing 15 posts - 1 through 15 (of 33 total)