Update on how perspectives went

Yahoo Archive
1
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Brian W. Spolarich " <bspolarich@...>
Date: Wed, 11 Nov 2009 22:03:49
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry

I'm not sure how to respond to that. :-)



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
���� bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of advantage@...
Sent: Wednesday, November 11, 2009 5:15 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry

Welcome back Brian see you survived Vegas. You'll have to give the rest of us pions a Synopsis

Sent from my Verizon Wireless BlackBerry



-----Original Message-----

From: "Brian W. Spolarich " <bspolarich@...>

Date: Wed, 11 Nov 2009 16:53:24

To: <vantage@yahoogroups.com>

Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry



I would guess these are fields that are in the epiDataView that the form uses and are calculated dynamically. This would make sense given that the total value of a PO is the sum of its lines. Vantage doesn't always store the 'rolled up' values for stuff like this.



Form controls are bound against an epiDataView, not the tables directly. Depending on the complexity of the screen/form, there may be multiple epiDataViews, and they may include fields that aren't on the physical database tables.



-bws





Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

���� bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung

Sent: Wednesday, November 11, 2009 4:43 PM

To: vantage@yahoogroups.com

Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry







If I view the form in developer mode, I see Order Total as BaseTotOrder

and Order Charges as BaseTotCharges - which are not in the PO Header

table in the data dictionary...8.03.408B







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf

Of ginevradellaquercia

Sent: Wednesday, November 11, 2009 3:27 PM

To: vantage@yahoogroups.com

Subject: [Vantage] POHeader.DocTotCharges - total charges in Purchase

Order Entry











Hi all,

I am hunting the elusive POHeader.DocTotCharges. I see it in the

Purchase Order Entry/Summary/Summary/Order Total field -- in the Field

Help Technical Details. However, I don't see it in the data dictionary

for that table.



How did you grab the order total for Dashboard use? Has anyone else had

this issue?



Thanks for the help!

Chris











[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/linksYahoo! Groups Links











[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/linksYahoo! Groups Links






[Non-text portions of this message have been removed]
2
Hi all,
I am hunting the elusive POHeader.DocTotCharges. I see it in the Purchase Order Entry/Summary/Summary/Order Total field -- in the Field Help Technical Details. However, I don't see it in the data dictionary for that table.

How did you grab the order total for Dashboard use? Has anyone else had this issue?

Thanks for the help!
Chris
3
If I view the form in developer mode, I see Order Total as BaseTotOrder
and Order Charges as BaseTotCharges - which are not in the PO Header
table in the data dictionary...8.03.408B



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ginevradellaquercia
Sent: Wednesday, November 11, 2009 3:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] POHeader.DocTotCharges - total charges in Purchase
Order Entry





Hi all,
I am hunting the elusive POHeader.DocTotCharges. I see it in the
Purchase Order Entry/Summary/Summary/Order Total field -- in the Field
Help Technical Details. However, I don't see it in the data dictionary
for that table.

How did you grab the order total for Dashboard use? Has anyone else had
this issue?

Thanks for the help!
Chris





[Non-text portions of this message have been removed]
4
I would guess these are fields that are in the epiDataView that the form uses and are calculated dynamically. This would make sense given that the total value of a PO is the sum of its lines. Vantage doesn't always store the 'rolled up' values for stuff like this.

Form controls are bound against an epiDataView, not the tables directly. Depending on the complexity of the screen/form, there may be multiple epiDataViews, and they may include fields that aren't on the physical database tables.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Wednesday, November 11, 2009 4:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry



If I view the form in developer mode, I see Order Total as BaseTotOrder
and Order Charges as BaseTotCharges - which are not in the PO Header
table in the data dictionary...8.03.408B



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ginevradellaquercia
Sent: Wednesday, November 11, 2009 3:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] POHeader.DocTotCharges - total charges in Purchase
Order Entry





Hi all,
I am hunting the elusive POHeader.DocTotCharges. I see it in the
Purchase Order Entry/Summary/Summary/Order Total field -- in the Field
Help Technical Details. However, I don't see it in the data dictionary
for that table.

How did you grab the order total for Dashboard use? Has anyone else had
this issue?

Thanks for the help!
Chris





[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/linksYahoo! Groups Links
5
Welcome back Brian see you survived Vegas. You'll have to give the rest of us pions a Synopsis
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Brian W. Spolarich " <bspolarich@...>
Date: Wed, 11 Nov 2009 16:53:24
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry

I would guess these are fields that are in the epiDataView that the form uses and are calculated dynamically. This would make sense given that the total value of a PO is the sum of its lines. Vantage doesn't always store the 'rolled up' values for stuff like this.

Form controls are bound against an epiDataView, not the tables directly. Depending on the complexity of the screen/form, there may be multiple epiDataViews, and they may include fields that aren't on the physical database tables.

-bws



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
���� bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Wednesday, November 11, 2009 4:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry



If I view the form in developer mode, I see Order Total as BaseTotOrder
and Order Charges as BaseTotCharges - which are not in the PO Header
table in the data dictionary...8.03.408B



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ginevradellaquercia
Sent: Wednesday, November 11, 2009 3:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] POHeader.DocTotCharges - total charges in Purchase
Order Entry





Hi all,
I am hunting the elusive POHeader.DocTotCharges. I see it in the
Purchase Order Entry/Summary/Summary/Order Total field -- in the Field
Help Technical Details. However, I don't see it in the data dictionary
for that table.

How did you grab the order total for Dashboard use? Has anyone else had
this issue?

Thanks for the help!
Chris





[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/linksYahoo! Groups Links






[Non-text portions of this message have been removed]
6
I'm not sure how to respond to that. :-)

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of advantage@...
Sent: Wednesday, November 11, 2009 5:15 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry

Welcome back Brian see you survived Vegas. You'll have to give the rest of us pions a Synopsis

Sent from my Verizon Wireless BlackBerry



-----Original Message-----

From: "Brian W. Spolarich " <bspolarich@...>

Date: Wed, 11 Nov 2009 16:53:24

To: <vantage@yahoogroups.com>

Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry



I would guess these are fields that are in the epiDataView that the form uses and are calculated dynamically. This would make sense given that the total value of a PO is the sum of its lines. Vantage doesn't always store the 'rolled up' values for stuff like this.



Form controls are bound against an epiDataView, not the tables directly. Depending on the complexity of the screen/form, there may be multiple epiDataViews, and they may include fields that aren't on the physical database tables.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung

Sent: Wednesday, November 11, 2009 4:43 PM

To: vantage@yahoogroups.com

Subject: RE: [Vantage] POHeader.DocTotCharges - total charges in Purchase Order Entry







If I view the form in developer mode, I see Order Total as BaseTotOrder

and Order Charges as BaseTotCharges - which are not in the PO Header

table in the data dictionary...8.03.408B







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf

Of ginevradellaquercia

Sent: Wednesday, November 11, 2009 3:27 PM

To: vantage@yahoogroups.com

Subject: [Vantage] POHeader.DocTotCharges - total charges in Purchase

Order Entry











Hi all,

I am hunting the elusive POHeader.DocTotCharges. I see it in the

Purchase Order Entry/Summary/Summary/Order Total field -- in the Field

Help Technical Details. However, I don't see it in the data dictionary

for that table.



How did you grab the order total for Dashboard use? Has anyone else had

this issue?



Thanks for the help!

Chris











[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/linksYahoo! Groups Links











[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/linksYahoo! Groups Links