Item receipt to Bill

[jay6Participant]

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?

[Yudel RosalesKeymaster]

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

[Author]

Posts