Difference between revisions of "GT:ASN Transactions"
From coolearthwiki
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
Whistle will create outbound ASN files for shipment transactions from either the Shipping Window, the Load/Ship Window and the WT Push Window. | Whistle will create outbound ASN files for shipment transactions from either the Shipping Window, the Load/Ship Window and the WT Push Window. | ||
| − | These ASN files come in different flavors (Flatfiles, XML | + | These ASN files come in different flavors (Flatfiles, XML, HL-XML and Database Table output). Whistle can provide one to many of each type for each shipment. |
=== ASN Settings === | === ASN Settings === | ||
| Line 9: | Line 9: | ||
* TARGET Path - Used to set the outbound file path for TARGET ASN FLATFILE and XML/HL-XML ASN file types. | * TARGET Path - Used to set the outbound file path for TARGET ASN FLATFILE and XML/HL-XML ASN file types. | ||
* X12 Compliant ASN - Used to additionally supply the XML/HL-XML ASN's with X12 Compliant (required) data elements. | * X12 Compliant ASN - Used to additionally supply the XML/HL-XML ASN's with X12 Compliant (required) data elements. | ||
| + | * Do ASN Interfaces - Used for QAD to turn ASN Generation on. | ||
Setting Switches : | Setting Switches : | ||
| Line 15: | Line 16: | ||
* Generate ASN XML - Switch to create output of XML file types. | * Generate ASN XML - Switch to create output of XML file types. | ||
* Generate ASN XML Hierarchical Levels - Switch to create output of HL (Hierarchical Level) - XML file types. | * Generate ASN XML Hierarchical Levels - Switch to create output of HL (Hierarchical Level) - XML file types. | ||
| + | * ERP Version (QAD) - Switch sends ASN output to a Database Table output format. Tables listed below. | ||
[[Image:ASN_Diagram.JPG|Image:ASN_Diagram.JPG]] | [[Image:ASN_Diagram.JPG|Image:ASN_Diagram.JPG]] | ||
=== Usage === | === Usage === | ||
| − | With the Switch(es) turned on and file paths configured, Whistle will generate all of the ASN | + | With the Switch(es) turned on and file paths configured, Whistle will generate all of the ASN output for each shipment where the ship-to is configured from each of the shipment transaction windows. |
These transaction will also be logged in the wmASNHistory table. The files are available for pick-up and transmission/translation upon creation. | These transaction will also be logged in the wmASNHistory table. The files are available for pick-up and transmission/translation upon creation. | ||
| + | |||
| + | === Configuring Ship-To's === | ||
| + | |||
| + | Whether in the ar_ship_ext or wms_arship_ext extension tables, Whistle is looking for the ar_ship_asn flag to be set that matches the ar_ship_key according to the shipment (sales or warehouse transfer) order. | ||
| + | |||
| + | Placing an entry for each ar_ship_key and setting the ar_ship_asn flag to (1) will trigger ASN generation. | ||
| + | |||
Tables: | Tables: | ||
| − | * wmASNHistory | + | * wmASNHistory (All ERP) |
| + | * ar_ship_ext (All ERP) | ||
* wms_asnhdr_tbl (QAD ERP) | * wms_asnhdr_tbl (QAD ERP) | ||
* wms_asndtl_tbl (QAD ERP) | * wms_asndtl_tbl (QAD ERP) | ||
| − | |||
* wms_arship_ext (QAD ERP) | * wms_arship_ext (QAD ERP) | ||
| + | * [[GT:QAD ASN Table Schema|QAD ASN Table Schema]] | ||
=== Examples === | === Examples === | ||
Latest revision as of 09:48, 1 July 2013
ASN Overview
Whistle will create outbound ASN files for shipment transactions from either the Shipping Window, the Load/Ship Window and the WT Push Window.
These ASN files come in different flavors (Flatfiles, XML, HL-XML and Database Table output). Whistle can provide one to many of each type for each shipment.
ASN Settings
Associated Settings :
- IBP Path - Used to set the outbound file path for IBP ASN Flatfile types.
- TARGET Path - Used to set the outbound file path for TARGET ASN FLATFILE and XML/HL-XML ASN file types.
- X12 Compliant ASN - Used to additionally supply the XML/HL-XML ASN's with X12 Compliant (required) data elements.
- Do ASN Interfaces - Used for QAD to turn ASN Generation on.
Setting Switches :
- Do IBP interfaces - Switch to create output of IBP ASN Flatfile types.
- Do TARGET interfaces - Switch to create output of TARGET Flatfile types.
- Generate ASN XML - Switch to create output of XML file types.
- Generate ASN XML Hierarchical Levels - Switch to create output of HL (Hierarchical Level) - XML file types.
- ERP Version (QAD) - Switch sends ASN output to a Database Table output format. Tables listed below.
Usage
With the Switch(es) turned on and file paths configured, Whistle will generate all of the ASN output for each shipment where the ship-to is configured from each of the shipment transaction windows.
These transaction will also be logged in the wmASNHistory table. The files are available for pick-up and transmission/translation upon creation.
Configuring Ship-To's
Whether in the ar_ship_ext or wms_arship_ext extension tables, Whistle is looking for the ar_ship_asn flag to be set that matches the ar_ship_key according to the shipment (sales or warehouse transfer) order.
Placing an entry for each ar_ship_key and setting the ar_ship_asn flag to (1) will trigger ASN generation.
Tables:
- wmASNHistory (All ERP)
- ar_ship_ext (All ERP)
- wms_asnhdr_tbl (QAD ERP)
- wms_asndtl_tbl (QAD ERP)
- wms_arship_ext (QAD ERP)
- QAD ASN Table Schema
Examples
Example/Description Output:
