OpenSync

Home Forums OpenSync QuickBooks non-inventory items

This topic contains 2 replies, has 2 voices, and was last updated by  Yudel Rosales 4 months, 3 weeks ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #64614

    ccorbett1
    Participant

    Hi there, we have helped setup Open Sync for several of our clients. We have just installed a trial for a client wanting to report on item sales back to invoice accounts. We have successfully setup data sync to SQL including mapping invoice details lines to the iteminventory table to get the relevant sales account. We have tried to do the same thing for non-inventory items however there is no income account reference in this table (itemnoninventory). Any suggestion on how we link the relevant income account for a non-inventory item please?

    Attachments:
    You must be logged in to view attached files.
    #64639

    Yudel Rosales
    Keymaster

    -ItemNonInventory Table
    Name (Required)
    ParentRef FullName or ListID
    ListID (Required)
    SalesTaxCode ListID or FullName (Required)
    -SalesAndPurchaseDetail Table
    PurchaseCost
    PurchaseDescription
    PrefVendor ListID or FullName
    First Time Add Only
    ExpenseAccount ListID or FullName (Required)
    IncomeAccount ListID or FullName (Required)
    -SalesOrPurchaseDetail Table
    Amount
    AmountIsPercent
    Description
    First Time Add Only
    Account ListID or FullName (Required)

    #64640

    Yudel Rosales
    Keymaster

    -ItemInventory Table
    AssetAccount ListID or FullName (Required)
    CogsAccount ListID or FullName (Required)
    IncomeAccountRef ListID or FullName (Required)
    PurchaseCost
    PurchaseDescription
    ReorderPoint
    SalesDescription
    SalesPrice
    SalesTaxCode ListID or FullName
    PrefVendor ListID or FullName
    ListID (Required)
    Name (Required)
    ParentRef FullName or ListID
    First Time Add Only
    Income Account ListID or FullName (Required)

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

You must be logged in to reply to this topic.