Commercial Invoice

Here's the Crystal Report file (CommericalInvc.rpt), report definition
(CommercialInvoice.xml), and BAQ (PICO-CommercialInvoice.xml).

The query references data in UD tables. You'll want to remove those,
and adjust as you see fit. The idea was to select the right harmonized
tariff code based on the partclass and a lookup table, or something like
that.

But if you're going to do a commercial invoice, you're going to have
to deal with tariff codes, etc.

This is just essentially a variant of the Packing Slip report and is
printed at the time of shipment to include with the shipping docs.

-bws


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ephraim Feldman
Sent: Thursday, October 21, 2010 4:07 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Commercial Invoice

Hi Brian

Im working now again on starting to use commercial invoices and would
very
much appreciate your help.

First i would really appreciate if you are willing to give me the
report.
Secondly when do you print the Commecial invoice? from what module? and
from
where comes the info needed on that sheet?

Thanks

Ephraim


On Wed, Aug 18, 2010 at 1:31 PM, Ephraim Feldman
<effgroups@...>wrote:

> Hi Brian
>
> Im looking now for using commercial invoices from Epicor9.
>
> First i would really appreciate if you are willing to give me the
report.
> Secondly when do you print the Commecial invoice? from what module?
and
> from where comes the info needed on that sheet?
>
> Im just wonderin g why such a system should not have it as part of it
since
> alot of companies need it.
>
> Also we want to start using a BOL from the system but thats probably
just a
> Packing slip with some more info so i guess i can manage this by
myself
>
> Thanks
>
> Ephraim
>
>
> On Fri, Apr 30, 2010 at 10:06 AM, Brian W. Spolarich <
> bspolarich@...> wrote:
>
>>
>>
>> I have one I'll send offline. It's data includes some stuff in UD
table
>> based on what my shipping folks wanted, but you can bend it to your
will.
>>
>> -bws
>>
>> --
>> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
Photonix /
>> Picometrix
>> bspolarich@...
<bspolarich%40advancedphotonix.com>~ 734-864-5618 ~
>> www.advancedphotonix.com
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
>> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
>> deannam95125
>> Sent: Thursday, April 29, 2010 5:38 PM
>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
>> Subject: [Vantage] Commercial Invoice
>>
>> Does anyone have a Crystal Reports Commerical Invoice that they are
>> willing to share?
>>
>> Thanks!
>>
>> ------------------------------------
>>
>>
>> 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]
Has anyone created a Commercial Invoice, a la



http://www.woodlist.com/ref/customs_invoice_requirements.htm



or




http://www.dhl-usa.com/intlsvcs/harmonized/documentation/1%2C1715%2C3%2C
00.asp?nav=InternationalService/Documentation/IntlCI



Willing to share?



--

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

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
I have one that we use MS Word to complete. Most of our shipments go out
UPS so we use the UPS Docs in WorldShip.



Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, March 25, 2009 4:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commercial Invoice



Has anyone created a Commercial Invoice, a la

http://www.woodlist
<http://www.woodlist.com/ref/customs_invoice_requirements.htm>
.com/ref/customs_invoice_requirements.htm

or

http://www.dhl-
<http://www.dhl-usa.com/intlsvcs/harmonized/documentation/1%2C1715%2C3%2C>
usa.com/intlsvcs/harmonized/documentation/1%2C1715%2C3%2C
00.asp?nav=InternationalService/Documentation/IntlCI

Willing to share?

--

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

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com> photonix.com
<mailto:bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advanced
<http://www.advancedphotonix.com> photonix.com>

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





[Non-text portions of this message have been removed]
Does anyone have a Crystal Reports Commerical Invoice that they are willing to share?

Thanks!
I have one I'll send offline. It's data includes some stuff in UD table based on what my shipping folks wanted, but you can bend it to your will.

-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 deannam95125
Sent: Thursday, April 29, 2010 5:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commercial Invoice

Does anyone have a Crystal Reports Commerical Invoice that they are willing to share?

Thanks!



------------------------------------

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
Hi Brian

Im looking now for using commercial invoices from Epicor9.

First i would really appreciate if you are willing to give me the report.
Secondly when do you print the Commecial invoice? from what module? and from
where comes the info needed on that sheet?

Im just wonderin g why such a system should not have it as part of it since
alot of companies need it.

Also we want to start using a BOL from the system but thats probably just a
Packing slip with some more info so i guess i can manage this by myself

Thanks

Ephraim

On Fri, Apr 30, 2010 at 10:06 AM, Brian W. Spolarich <
bspolarich@...> wrote:

>
>
> I have one I'll send offline. It's data includes some stuff in UD table
> based on what my shipping folks wanted, but you can bend it to your will.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> bspolarich@... <bspolarich%40advancedphotonix.com> ~
> 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
> deannam95125
> Sent: Thursday, April 29, 2010 5:38 PM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: [Vantage] Commercial Invoice
>
> Does anyone have a Crystal Reports Commerical Invoice that they are willing
> to share?
>
> Thanks!
>
> ------------------------------------
>
>
> 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]
Hi Brian

Im working now again on starting to use commercial invoices and would very
much appreciate your help.

First i would really appreciate if you are willing to give me the report.
Secondly when do you print the Commecial invoice? from what module? and from
where comes the info needed on that sheet?

Thanks

Ephraim


On Wed, Aug 18, 2010 at 1:31 PM, Ephraim Feldman <effgroups@...>wrote:

> Hi Brian
>
> Im looking now for using commercial invoices from Epicor9.
>
> First i would really appreciate if you are willing to give me the report.
> Secondly when do you print the Commecial invoice? from what module? and
> from where comes the info needed on that sheet?
>
> Im just wonderin g why such a system should not have it as part of it since
> alot of companies need it.
>
> Also we want to start using a BOL from the system but thats probably just a
> Packing slip with some more info so i guess i can manage this by myself
>
> Thanks
>
> Ephraim
>
>
> On Fri, Apr 30, 2010 at 10:06 AM, Brian W. Spolarich <
> bspolarich@...> wrote:
>
>>
>>
>> I have one I'll send offline. It's data includes some stuff in UD table
>> based on what my shipping folks wanted, but you can bend it to your will.
>>
>> -bws
>>
>> --
>> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
>> Picometrix
>> bspolarich@... <bspolarich%40advancedphotonix.com>~ 734-864-5618 ~
>> www.advancedphotonix.com
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
>> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
>> deannam95125
>> Sent: Thursday, April 29, 2010 5:38 PM
>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
>> Subject: [Vantage] Commercial Invoice
>>
>> Does anyone have a Crystal Reports Commerical Invoice that they are
>> willing to share?
>>
>> Thanks!
>>
>> ------------------------------------
>>
>>
>> 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]