Look at the InvcHead table at the InvoiceType field.
Mike
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, October 20, 2004 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AR table(s)
Hi,
We are migrating from Dataflo to Vantage.
In Dataflo there is a table called AR that has a field called TYPE.
The different TYPEs are CI (Credit Invoice, CM (Credit Memo), DI (Debit Invoice), DM (Debit Memo) and DP (Deposit).
I've been studying Vantage AR & how they correspond.
Can anybody tell me how Vantage keeps track of the different types of AR records & what tables are used?
Or stock reports that include the differing types?
So far I've looked at InvcHead, InvcDtl and CashHead but I have not found a field that corresponds to type.
Thanks,
Bruce Ordway
Viking Engineering
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1297rs3io/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1098379197/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=944487710>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Mike
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Wednesday, October 20, 2004 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] AR table(s)
Hi,
We are migrating from Dataflo to Vantage.
In Dataflo there is a table called AR that has a field called TYPE.
The different TYPEs are CI (Credit Invoice, CM (Credit Memo), DI (Debit Invoice), DM (Debit Memo) and DP (Deposit).
I've been studying Vantage AR & how they correspond.
Can anybody tell me how Vantage keeps track of the different types of AR records & what tables are used?
Or stock reports that include the differing types?
So far I've looked at InvcHead, InvcDtl and CashHead but I have not found a field that corresponds to type.
Thanks,
Bruce Ordway
Viking Engineering
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1297rs3io/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1098379197/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=944487710>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]