Did you ever get the any information from anyone of the files used?

same as PLaLonde ... happy to respond, but want to ensure need is current.  ... a simple answer is create Crystal Reports report using ODBC driver and copy SQL into program ....

My needs are more complex then just a report although that is some of it  I am not a crystal guy (FYI:  I am NOT interested is hearing from contract labors and guns for hire.).  We use Sage 50 US.  I am building my own modules to track shipping and better integrate MISys and Sage combined reporting et cetera (FYI:  I am not interested any sales pitch about any Sage upgrades to other packages).  It is key that I have fast and efficient look-ups against Sage 50.  ODBC is not fast or efficient.

The original person asked about ODBC, is that what you are interested in?  You can do those types of lookups with the .net api.  Have you looked at the supplied samples that get installed with the SDK?

Apparently when you export Customer data the Credit Status (2) "Always Notify" IS exported but the Message is not.  I need to export it and import into a my repaired database. 

Note: Third party contractors, I am not interested in paying you to do it for me.

This should be enough to get you going.  The following SQL Statement will give you information on a specific Sales Journal with a reference of 12345.  You can add more fields and change your where clause for your needs.  

JrnlHdr.JrnlKey_Journal  where  3 = Sales Journal, 11 = Sales Orders

SELECT Customers.CustomerID, Customers.Customer_Bill_Name, JrnlHdr.TransactionDate, JrnlHdr.Reference, LineItem.ItemID, JrnlRow.RowDescription, JrnlRow.Amount, JrnlRow.Quantity
FROM (JrnlHdr INNER JOIN (JrnlRow INNER JOIN LineItem ON JrnlRow.ItemRecordNumber = LineItem.ItemRecordNumber) ON JrnlHdr.PostOrder = JrnlRow.PostOrder) INNER JOIN Customers ON JrnlHdr.CustVendId = Customers.CustomerRecordNumber
WHERE (((JrnlHdr.JrnlKey_Journal)=3) AND ((JrnlHdr.Reference)="12345"));

https://dscorp.com

can you please know me what is the field for item's Quantity, Cost, and Selling Price ?

can you please know me what is the field for item's Quantity, Cost, and Selling Price ?