Interacting with the Business Objects

Hi Thom,



We don't use our credit cards much and do not have a lot of repeat
activity for any one supplier. I hope someone can answer your question
though as I can see where it could be useful.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Wednesday, January 06, 2010 9:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Interacting with the Business Objects





I thought of doing that, and it is not a bad idea.

The reason I want to go the payment route is that I want to know all I
spend with, say, Delta Airlines. Sometimes we might use one company
credit card, and sometimes another company card to buy Delta tickets. If
I use payments, I can report against the vendor's activity. If I use the
GL, it is not as easy to extract one supplier's activity.

Also, entering items as payments is more truly representative of the
actual nature of the transaction. Any time we use a credit card, we are
making a payment to a supplier.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Linda Lowney
Sent: Wednesday, January 06, 2010 6:30 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

Hi Thom,

I don't know how to connect to the BO, but we put our download from the
credit card company into Excel. We enter a lump sum in Accounts
Payable to a clearing account, then import the Excel data into General
Ledger (after some tweaking and formatting of the Excel version of the
download.) offsetting the clearing account.

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Thomas Rose
Sent: Wednesday, January 06, 2010 9:19 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

My immediate interest is to input a whole bunch of payment information.
We get a big bill from our credit card company every month. Instead of
putting in the bill as one big lump, I would like to break out most of
it by the individual items being purchased. I get an electronic
statement from the credit card company, and I could automate the input
of all the details if I could use VB.Net or VBA to get directly at the
Payment Entry BO. I suspect an example from another BO would give me the
clues I need to figure this one out. Thanks, Mark.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Mark Wonsil
Sent: Tuesday, January 05, 2010 7:21 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

> From time to time there has been some discussion about
> inputting via scripting. In one of those discussions, someone
> suggested you could input data by interacting directly with
> the appropriate Vantage business object via code. The person
> even provided a C++ or C# code sample. I am literate in VBA
> and semi-literate in VB, but I have a hard time deciphering
> any of the C dialects. Does anyone have any sample code they
> would be willing to share in VBA or VB that demonstrates the
> interaction with a Vantage BO?

What are you trying to accomplish Thom? I think I have some VB.Net code
back
in the office somewhere...

Mark W.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
From time to time there has been some discussion about inputting via scripting. In one of those discussions, someone suggested you could input data by interacting directly with the appropriate Vantage business object via code. The person even provided a C++ or C# code sample. I am literate in VBA and semi-literate in VB, but I have a hard time deciphering any of the C dialects. Does anyone have any sample code they would be willing to share in VBA or VB that demonstrates the interaction with a Vantage BO?

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[Non-text portions of this message have been removed]
> From time to time there has been some discussion about
> inputting via scripting. In one of those discussions, someone
> suggested you could input data by interacting directly with
> the appropriate Vantage business object via code. The person
> even provided a C++ or C# code sample. I am literate in VBA
> and semi-literate in VB, but I have a hard time deciphering
> any of the C dialects. Does anyone have any sample code they
> would be willing to share in VBA or VB that demonstrates the
> interaction with a Vantage BO?

What are you trying to accomplish Thom? I think I have some VB.Net code back
in the office somewhere...

Mark W.
My immediate interest is to input a whole bunch of payment information. We get a big bill from our credit card company every month. Instead of putting in the bill as one big lump, I would like to break out most of it by the individual items being purchased. I get an electronic statement from the credit card company, and I could automate the input of all the details if I could use VB.Net or VBA to get directly at the Payment Entry BO. I suspect an example from another BO would give me the clues I need to figure this one out. Thanks, Mark.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Tuesday, January 05, 2010 7:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Interacting with the Business Objects



> From time to time there has been some discussion about
> inputting via scripting. In one of those discussions, someone
> suggested you could input data by interacting directly with
> the appropriate Vantage business object via code. The person
> even provided a C++ or C# code sample. I am literate in VBA
> and semi-literate in VB, but I have a hard time deciphering
> any of the C dialects. Does anyone have any sample code they
> would be willing to share in VBA or VB that demonstrates the
> interaction with a Vantage BO?

What are you trying to accomplish Thom? I think I have some VB.Net code back
in the office somewhere...

Mark W.



[Non-text portions of this message have been removed]
Hi Thom,



I don't know how to connect to the BO, but we put our download from the
credit card company into Excel. We enter a lump sum in Accounts
Payable to a clearing account, then import the Excel data into General
Ledger (after some tweaking and formatting of the Excel version of the
download.) offsetting the clearing account.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Wednesday, January 06, 2010 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Interacting with the Business Objects





My immediate interest is to input a whole bunch of payment information.
We get a big bill from our credit card company every month. Instead of
putting in the bill as one big lump, I would like to break out most of
it by the individual items being purchased. I get an electronic
statement from the credit card company, and I could automate the input
of all the details if I could use VB.Net or VBA to get directly at the
Payment Entry BO. I suspect an example from another BO would give me the
clues I need to figure this one out. Thanks, Mark.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mark Wonsil
Sent: Tuesday, January 05, 2010 7:21 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

> From time to time there has been some discussion about
> inputting via scripting. In one of those discussions, someone
> suggested you could input data by interacting directly with
> the appropriate Vantage business object via code. The person
> even provided a C++ or C# code sample. I am literate in VBA
> and semi-literate in VB, but I have a hard time deciphering
> any of the C dialects. Does anyone have any sample code they
> would be willing to share in VBA or VB that demonstrates the
> interaction with a Vantage BO?

What are you trying to accomplish Thom? I think I have some VB.Net code
back
in the office somewhere...

Mark W.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I thought of doing that, and it is not a bad idea.

The reason I want to go the payment route is that I want to know all I spend with, say, Delta Airlines. Sometimes we might use one company credit card, and sometimes another company card to buy Delta tickets. If I use payments, I can report against the vendor's activity. If I use the GL, it is not as easy to extract one supplier's activity.

Also, entering items as payments is more truly representative of the actual nature of the transaction. Any time we use a credit card, we are making a payment to a supplier.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Linda Lowney
Sent: Wednesday, January 06, 2010 6:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Interacting with the Business Objects



Hi Thom,

I don't know how to connect to the BO, but we put our download from the
credit card company into Excel. We enter a lump sum in Accounts
Payable to a clearing account, then import the Excel data into General
Ledger (after some tweaking and formatting of the Excel version of the
download.) offsetting the clearing account.

Linda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Thomas Rose
Sent: Wednesday, January 06, 2010 9:19 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

My immediate interest is to input a whole bunch of payment information.
We get a big bill from our credit card company every month. Instead of
putting in the bill as one big lump, I would like to break out most of
it by the individual items being purchased. I get an electronic
statement from the credit card company, and I could automate the input
of all the details if I could use VB.Net or VBA to get directly at the
Payment Entry BO. I suspect an example from another BO would give me the
clues I need to figure this one out. Thanks, Mark.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mark Wonsil
Sent: Tuesday, January 05, 2010 7:21 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Interacting with the Business Objects

> From time to time there has been some discussion about
> inputting via scripting. In one of those discussions, someone
> suggested you could input data by interacting directly with
> the appropriate Vantage business object via code. The person
> even provided a C++ or C# code sample. I am literate in VBA
> and semi-literate in VB, but I have a hard time deciphering
> any of the C dialects. Does anyone have any sample code they
> would be willing to share in VBA or VB that demonstrates the
> interaction with a Vantage BO?

What are you trying to accomplish Thom? I think I have some VB.Net code
back
in the office somewhere...

Mark W.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]