Databases
StackOverflow2013
Postsdbo
POHow do you find the TxnLineID of a payment line from a Quickbooks transaction if it is part of a Sales Receipt?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do you find the TxnLineID of a payment line from a Quickbooks transaction if it is part of a Sales Receipt?
    primarykey
    data
    text
    <p>I can query for the SalesReceipt object:</p> <pre><code> public bool GetSalesReceipt(string sRefNum, string sAccount, out ISalesReceiptRet ret) { ret = null; IMsgSetRequest msr = sm.CreateMsgSetRequest("US", 4, 0); msr.Attributes.OnError = ENRqOnError.roeStop; ISalesReceiptQuery q = msr.AppendSalesReceiptQueryRq(); q.metaData.SetValue(ENmetaData.mdMetaDataAndResponseData); q.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.RefNumber.SetValue(sRefNum); q.ORTxnQuery.TxnFilter.ORRefNumberFilter.RefNumberFilter.MatchCriterion.SetValue(ENMatchCriterion.mcContains); q.ORTxnQuery.TxnFilter.AccountFilter.ORAccountFilter.FullNameList.Add(sAccount); q.IncludeLineItems.SetValue(true); IMsgSetResponse resp = sm.DoRequests(msr); if (resp.ResponseList.Count == 0) return false; IResponseList rl = resp.ResponseList; if (rl.Count == 1) { IResponse r = rl.GetAt(0); if (r.Detail == null) return false; if (r.StatusCode != 0) return false; if (r.Type.GetValue() == (short)ENResponseType.rtSalesReceiptQueryRs) { ISalesReceiptRetList crl = (ISalesReceiptRetList)r.Detail; if (crl.Count == 1) ret = crl.GetAt(0); } } if (ret == null) return false; return true; } </code></pre> <p>The SalesReceipt has a list of SalesReceipt Lines in ORSalesReceiptLineRetList, but none of those lines are the payment line. There is no way to get the TxnLineID from the SalesReceipt object for the payment line (that I can find).</p> <p>What I'm trying to do is find a particular TxnLineID from the SalesReceipt, so that I can mark it as cleared. When I do a search, I can see there is a transaction line (the one below in the Credit Card Batches:Visa/MC account). How can I find the TxnLineID For that particular line?</p> <p><img src="https://i.stack.imgur.com/wb8GR.png" alt="qb transaction"></p> <p>Here is a screenshot showing the transaction marked as cleared which I accomplished through the UI by clicking the box in the Cleared column.</p> <p><img src="https://i.stack.imgur.com/KoMQ1.png" alt="enter image description here"></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMichael Pryor
    1. USMichael Pryor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do you find the TxnLineID of a payment line from a Quickbooks transaction if it is part of a Sales Receipt?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow do you find the TxnLineID of a payment line from a Quickbooks transaction if it is part of a Sales Receipt?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do you find the TxnLineID of a payment line from a Quickbooks transaction if it is part of a Sales Receipt?
      1. USMichael Pryor
      1. VTBountyStart
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload