Commercial invoices with international customer shipments - easi

Yahoo Archive
1
Bryan-

At my last company I used the BOL screen and form. We needed to be able to add multiple packing slips into a crate going over seas and have a single commercial invoice. Worked fairly well although a little more complicated than the packing slip option.

-Nick

---In vantage@yahoogroups.com, <cathy@...> wrote :

#ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069MsoNormal, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069MsoNormal, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 a:link, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069MsoHyperlink {color:blue;text-decoration:underline;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 a:visited, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 code {font-family:"Courier New";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 tt {font-family:"Courier New";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069cat {} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069ct {} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069HTMLPreformattedChar {font-family:Consolas;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069attach, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069attach, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069attach {margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:"Arial", "sans-serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069bold, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069bold, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069bold {margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Arial", "sans-serif";font-weight:bold;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069green, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069green, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069green {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";color:#628C2A;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069replbq, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069replbq, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069replbq {margin:3.0pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069ad, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069ad, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069ad {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069underline, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069underline, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069underline {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069yshortcuts {} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069ad1, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069ad1, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069ad1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069ad2, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069ad2, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069ad2 {margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 p.ygrps-yiv-956690718ygrps-yiv-2067096069underline1, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 li.ygrps-yiv-956690718ygrps-yiv-2067096069underline1, #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069underline1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";text-decoration:underline;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069yshortcuts1 {font-family:"Verdana", "sans-serif";font-weight:bold;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069yshortcuts2 {font-family:"Verdana", "sans-serif";font-weight:normal;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 span.ygrps-yiv-956690718ygrps-yiv-2067096069EmailStyle36 {font-family:"Calibri", "sans-serif";color:#1F497D;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 .ygrps-yiv-956690718ygrps-yiv-2067096069MsoChpDefault {font-size:10.0pt;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {margin:1.0in 1.0in 1.0in 1.0in;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 div.ygrps-yiv-956690718ygrps-yiv-2067096069WordSection1 {} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Symbol;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:"Courier New";} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 filtered #ygrps-yiv-956690718ygrps-yiv-2067096069 {font-family:Wingdings;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 ol {margin-bottom:0in;} #ygrps-yiv-956690718 #ygrps-yiv-956690718ygrps-yiv-2067096069 ul {margin-bottom:0in;}

I used the Packing Slip.

 

In our case, we could ship a partial and the commercial Invoice should match what you are actually shipping.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 09, 2016 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Commercial invoices with international customer shipments - easier process?

 

 

Hello all, thanks for the responses.  What RDD did you guys use to accomplish this task?  The packing slip or the order ack? 

 

Thanks, 

Bryan Davis

2
Does anyone know an 'easier' way to create/print a commercial invoice to include in an international customer shipment, than:

1) create customer shipment with lines
2) click 'shipped' on summary screen
3) go into invoice entry, create group
4) find the customer shipment above, create invoice
5) print "invoice" (in our case we've created another crystal report form from the invoice format that says "Commercial Invoice" at top)
3
We've seen a couple people do this as subreport in the packing slip.

On Tue, Mar 6, 2012 at 7:11 PM, jfmartin67 <jfmartin67@...> wrote:

> **
>
>
> Does anyone know an 'easier' way to create/print a commercial invoice to
> include in an international customer shipment, than:
>
> 1) create customer shipment with lines
> 2) click 'shipped' on summary screen
> 3) go into invoice entry, create group
> 4) find the customer shipment above, create invoice
> 5) print "invoice" (in our case we've created another crystal report form
> from the invoice format that says "Commercial Invoice" at top)
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
4
We created a separate "packing slip" report style that grabs info off the sales order and part master files. It isn't an "invoice" in the accounting sense of the word, but it suffices for international shipments and customs paperwork.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, John Driggers <waffqle@...> wrote:
>
> We've seen a couple people do this as subreport in the packing slip.
>
> On Tue, Mar 6, 2012 at 7:11 PM, jfmartin67 <jfmartin67@...> wrote:
>
> > **
> >
> >
> > Does anyone know an 'easier' way to create/print a commercial invoice to
> > include in an international customer shipment, than:
> >
> > 1) create customer shipment with lines
> > 2) click 'shipped' on summary screen
> > 3) go into invoice entry, create group
> > 4) find the customer shipment above, create invoice
> > 5) print "invoice" (in our case we've created another crystal report form
> > from the invoice format that says "Commercial Invoice" at top)
> >
> >
> >
>
>
>
> --
> *John Driggers*
> *High End Dev, System Design, Profit Drinking*
> *
> **:: 904.404.9233*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
5
Yep. I have always done it as a Report style (and revised data definition to get the pricing from the sales order) of the packer.
Doing as a variation of the sales order gets you close but if you ship different from the sales order, you have an issue.

Charlie Smith
2W Technologies LLC, Sr. Business Consultant
Phone: (312) 533-4033 x8046
               (860) 620-9553
     Fax: (847) 374-3620
2W Tech on Facebook www.2WTech.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Driggers
Sent: Tuesday, March 06, 2012 7:05 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Commercial invoices with international customer shipments - easier process?

We've seen a couple people do this as subreport in the packing slip.

On Tue, Mar 6, 2012 at 7:11 PM, jfmartin67 <jfmartin67@...> wrote:

> **
>
>
> Does anyone know an 'easier' way to create/print a commercial invoice
> to include in an international customer shipment, than:
>
> 1) create customer shipment with lines
> 2) click 'shipped' on summary screen
> 3) go into invoice entry, create group
> 4) find the customer shipment above, create invoice
> 5) print "invoice" (in our case we've created another crystal report
> form from the invoice format that says "Commercial Invoice" at top)
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[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
6
Hey Ernie, 
I believe I need to do exactly what you have stated you did with the packing slip.  Can I ask you how you went about doing this?  Did you use a BAQ report, just a crystal report?  I guess I just need a starting point to jump off from.  

We are on Epicor 9.05.702A progress 64bit.


Thank you so much for your help!

Bryan Davis
Ken Garner Manufacturing, Inc.  
7

We also created a new Report Style under PackSlip.

 

I used the same RDD and just formatted a new report that looks like our invoice.  For the fake Invoice # we used the Packing Slip #

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, February 4, 2016 8:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Commercial invoices with international customer shipments - easier process?

 

 

Hey Ernie, 

I believe I need to do exactly what you have stated you did with the packing slip.  Can I ask you how you went about doing this?  Did you use a BAQ report, just a crystal report?  I guess I just need a starting point to jump off from.  

 

We are on Epicor 9.05.702A progress 64bit.

 

 

Thank you so much for your help!

 

Bryan Davis

Ken Garner Manufacturing, Inc.  



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

8

We did the same thing for our Commercial Invoices –

 

For RMA’s we modified the price to be $1 for 0 dollar shipments and use the RMA # for the fake invoice.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, February 04, 2016 11:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Commercial invoices with international customer shipments - easier process?

 

 

We also created a new Report Style under PackSlip.

 

I used the same RDD and just formatted a new report that looks like our invoice.  For the fake Invoice # we used the Packing Slip #

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, February 4, 2016 8:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Commercial invoices with international customer shipments - easier process?

 

 

Hey Ernie, 

I believe I need to do exactly what you have stated you did with the packing slip.  Can I ask you how you went about doing this?  Did you use a BAQ report, just a crystal report?  I guess I just need a starting point to jump off from.  

 

We are on Epicor 9.05.702A progress 64bit.

 

 

Thank you so much for your help!

 

Bryan Davis

Ken Garner Manufacturing, Inc.  

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

9
Hello all, thanks for the responses.  What RDD did you guys use to accomplish this task?  The packing slip or the order ack? 

Thanks, 
Bryan Davis
10

I used the Packing Slip.

 

In our case, we could ship a partial and the commercial Invoice should match what you are actually shipping.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 09, 2016 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Commercial invoices with international customer shipments - easier process?

 

 

Hello all, thanks for the responses.  What RDD did you guys use to accomplish this task?  The packing slip or the order ack? 

 

Thanks, 

Bryan Davis

11
Thanks Cathy!  I appear to be having some success using the Packer as well.  I am still testing and working things out, but so far so good.  Thanks for the input!

Bryan Davis