Table name for Posted invoices (sales) and posted receipts
(purcha

Hello everyone, I have to create a select for selecting some information from 
those two tables, the problem is that I don't work with Navision and don't 
know anything about it. I would really appreciate if someone could help me 
with this and tell me the names of those to database table where the info 
from posted invoices (sales) and posted receipts (purchase) is contained.

Thank you very much!

"Mariana Mazzero" wrote:

> Hello everyone, I have to create a select for selecting some information
from 
> those two tables, the problem is that I don't work with Navision and don't

> know anything about it. I would really appreciate if someone could help me

> with this and tell me the names of those to database table where the info 
> from posted invoices (sales) and posted receipts (purchase) is contained.

Posted Invoices (Sales) are stored in the tables "Sales Invoice
Header" and 
"Sales Invoice Line".
Posted Receipts (Purchases) are stored in "Purch. Rcpt. Header" and
"Purch. 
Rcpt. Line".

You'll have to put the companyname in front of the table-name, if you are 
using a SQL database (and replace . with _)

For example: 
CRONUS International Ltd_$Sales Invoice Header
CRONUS International Ltd_$Sales Invoice Line
CRONUS International Ltd_$Purch_ Rcpt_ Header
CRONUS International Ltd_$Purch_ Rcpt_ Line

Regards,
Luc Van Dyck
webmaster http://mibuso.com