asked on

Key Field or Unique Key Data in Quickbooks 17 SalesOrderLine Table

I am coordinating the build of a MS Access DB with some SQL and VBA on the backend that uses data from the Quickbooks (v17) SalesOrderLine Data to manage a production workflow system for a small parts manufacturing company. All data comes from the SalesOrderLine table exclusively. I am looking for a Unique identifier in that table to use as a filter for various sorting and prioritizing purposes. I have not been able to locate such a field in the SalesOrderLine Table.

The application is functioning well with one component dependent on this unique field value. I hope to deploy in production fairly quickly. We are in UAT testing now and learned that this one piece needs resolution.

QB has two fields labeled FQPrimaryKey and another FQTxnLinkKey but neither are unique. Is there a possible line count within the sales order that I can add to a record TXNID that would make it Unique? Some other avenue to pursue?

Does anyone have any experience or suggestion relevant to this area of QB specifically? If so, would you please share your thoughts and/or solutions?

ASKER CERTIFIED SOLUTION

John

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Deb Jackson

ASKER

Thanks John. I have the table lists and fields but the links are always a great resource for those who may read this string. In looking at the raw data in the way the business uses the QB application, there was no unique data to the records. I was guided to a compiled field that makes a pseudo unique field. Appreciatively, Deb J

Deb Jackson

ASKER

The links in your comment area great resource for anyone using QB for data control. Thank you!

John

You are very welcome and I was happy to help you resolve this.