OpenSync

Home Forums OpenSync Problem with data type of Quantity field in invoicelinedetail table

This topic contains 4 replies, has 3 voices, and was last updated by  Raymond 3 weeks, 2 days ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #63384

    Raymond
    Participant

    OpenSync (v3.0.18) sets the data type of the Quantity field in the invoicelinedetail table to int (SQL Server). In my humble opinion, that is a bad decision because many QB users invoice items in partial quantities. It should have been a decimal data type.

    So now I have a problem in that all the calculations and reports I generate from OpenSync invoice data are inaccurate. My plan is to change the data type of this field from int to decimal but then I need to repopulate all the data. Solvable but time consuming.

    #63385

    Raymond
    Participant

    I noticed that the Quantity field in the salesorderlinedetail table is set to decimal. That’s good.

    Invoices in QB are usually generated from Sales Orders so naturally the Quantity field in both of these tables should have been the same (decimal).

    #63389

    Yudel Rosales
    Keymaster

    That is correct. Thanks for the advise.

    #65118

    BTH
    Participant

    OpenSync was working fine until a recent upgrade to v3.0.25. Some of our invoices use decimals in the quantity field. It appears that the quantity column in the invoicelinedetail table is an integer! An example of our problem is an invoice with qty=.5. OpenSync stored the value as -0-. That created a big problem because it was Qty .5 of a $10,000.00 invoice. This situation needs to be addressed ASAP. Quantity needs to be stored as a decimal.

    #65122

    Raymond
    Participant

    @bth

    While we wait for them to fix this in their next release, you can just do what I did and change the data type of the quantity field yourself.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.