Topic Options
#12224 - 04/10/08 03:52 PM Customs/NAFTA invoices
Andre Kuehnemund Offline
Adagio Guru

Registered: 08/10/07
Posts: 127
Loc: Emeryville, CA U.S.A.
I have been trying to find a table in Gridview that will allow me to extract order detail information as well as certain IC information. There is one such composite table, but it does not contain the optional fields from IC. We intend to use those fields for information we need to put on Customs/Nafta invoice. we have set up those optional fields as follows:

String field 1: harmonized Code
String field 2: Country of Origin
String field 3: Materials
Unit field 1: MP Units ('MP' stands for Master Pack)

How do I access those fields through GridView? the only table I found that listed those fields was the I/C Master table. However, I also need to order detail information so that I can query the item information for a particular order or number of orders.

Andre

Top
#12225 - 04/10/08 03:57 PM Re: Customs/NAFTA invoices [Re: Andre Kuehnemund]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello Andre,

We can create a composite table for you that has the additional fields you need. Send me an e-mail with the details.
_________________________
Andrew Bates

Top
#12226 - 04/10/08 04:10 PM Re: Customs/NAFTA invoices [Re: Retired_Guy]
Andre Kuehnemund Offline
Adagio Guru

Registered: 08/10/07
Posts: 127
Loc: Emeryville, CA U.S.A.
That would be great! I'll send it to support at softrak dot com. thanks!

Andre

Top
#12356 - 04/21/08 04:53 PM Re: Customs/NAFTA invoices [Re: Andre Kuehnemund]
Andre Kuehnemund Offline
Adagio Guru

Registered: 08/10/07
Posts: 127
Loc: Emeryville, CA U.S.A.
Custom table worked like a charm. Thanks much!

Andre

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 45 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70660 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30