OpenSync

Home Forums OpenSync Item receipt to Bill

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #64600

    jay6
    Participant

    We are importing received inventory via OpenSync. I wrote it into Quickbooks successfully. Now, I want to convert it to bills. I found that the itemreceipt and bill items are sharing using the same TxnID (if I use the convert function in quickbooks). How can we add new line item into bill table with using the same TxnID so it can properly linked to the TxnItemlinedetail items?
    Or do you have any recommendation for converting itemreceipt to bill?

    #64617

    Yudel Rosales
    Keymaster

    If you are updating you will need to have the QuickBooks assigned TxnID listed for the selected record. To post a bill you will need to include at least one item line or expense line and so you will insert a random number into the TxnID field in the Bill table and insert the same number into either the TxnItemLineDetail table and/or the TxnExpenseLineDetail tables in the IDKEY field.

    Supported Fields

    – Bill Table

    APAccount ListID or FullName
    DueDate
    Memo
    RefNumber
    Terms ListID or FullName
    TxnDate
    TxnID (Required) – Links to IDKEY in TxnItemLineDetail or TxnExpenseLineDetail
    Vendor ListID or FullName (Required)

    – TxnItemLineDetail

    Amount
    Class ListID or FullName
    Cost
    Customer ListID or FullName
    Description
    Item ListID or FullName
    Quantity
    IDKEY (Required) – Links to TxnID from Bill table

    – TxnExpenseLineDetail

    Account ListID or FullName
    Amount
    Class ListID or FullName
    Cost
    Customer ListID or FullName
    IDKEY (Required) – Links to TxnID from Bill table

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

You must be logged in to reply to this topic.