on 03-17-2009 1:53 PM
Hi,
Anybody know how can obtain the default serie for a document throw a query??
I can`t see the relation between the ONNM and the NNM1 tables because the 'dfltseries' field of the ONNM not corresponding with the 'Series' field of the NNM1.
For example for an A/P Invoice
Thanks!!
Hi Mariano,
According to the SDK Help file, you need to query the NNM2 table
Series Default
Table name: NNM2
ObjectCode UserSign Series DocSubType
So, the query to retrieve the A/P default series for the manager user would be:
SELECT T0.Series FROM [dbo].[nnm2] T0 WHERE T0.ObjectCode='13' AND T0.UserSign = 1
From the SDK you can replace the T0.UserSign = 1 for T0.UserSign = oCompany.UserSignature to retrieve the default series for the current user...
Regards,
Vítor Vieira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.