pgrimstrup/walter

walter's Issues

Add Shipment Date to ASN (UBL XML)

For Briscoes who want a shipment date in the ASN, I have used the issue date of the ASN. Can you confirm please if the date the ASN is produced is the same day the goods are shipped.

In The Warehouse UBL XML there is an Actual Delivery Date in the header of the message which is mandatory.

use the expected delivery date from the header data to Walter

In summary, add:

• Shipment Date (date the ASN was created)
• Actual Delivery Date (estimated delivery date from Walter)

Add Carrier to ASN (UBL XML)

In the Briscoes ASN there is a tag that needs to be populated with a code for the delivery carrier. The two codes are 10 = Fastways and 20 = Toll. These are mandatory fields. I asked EDIS about this who are the EDI providers for Briscoes and I was told that Panasonics ERP system should have these values and be able to return them on the ASN.

Additional search criteria in the Manifest Search screen

I've been looking for a manifest to play around with (closing, reopening, sending ASN, etc), but it always requires a database query. I have added in additional search criteria to the Manifest Search screen to make it easier to find manifests.

Requirements:

• Improve performance of the query.
• Querying for a manifest number should take less than 20ms. Currently, it is taking 2 sec.
• Add a Manifest Status option (Any State, Open, Closed)
• Add a Carrier option (All, or query by selected Carrier. Carriers with "TESTING" in their name are excluded)
• Add a Sales Group option (All, or query by a selected Sales Group. Sales Group XXX is excluded)
• Add a Customer option (All, or query by a selected Customer. Customers in Sales Group XXX are excluded)

All requirements have been met, and the Manifest Search screen now works a lot quicker. Selecting a Sales Group will result in the list of Customers being filtered to only those Customers for the selected Sales Group.

This means that I can now quickly find Closed manifests using Fliways to Warehouse Stationery Manakau.

Next enhancement will be to select a date range for Closure/Invoice dates.

New Manifest file

As part of an ongoing customer portal project, we would like an additional file created whenever a manifest is closed.
Michelle has detailed the file layout below.
I am away until Monday so any questions please reply all so Michelle can help.
I think we should make the file TAB delimited and call it cop_Manifest_xxxx.txt where xxxx is a sequential counter starting at 1
We will probably need to take into consideration the fact that more than one person closing simultaneously.

Field Type	Comments
Carrier Ref/Tracking Number	Called both in different files - needed for courierpost only
Carrier Name	Sonic/Fliway/Courierpost
PNZ O Number	Masterpack O Number
Reference	Customer order number
Cnsignee	Send to
ToAddressLine1	Address1
ToAddressLine2	Address2
ToCity	City
Requested DeliveryDate	Date
Con NoteNumber	Consignment Note Number - Sonic/Fliway, not courierpost
CustomerNumber	Account number
GoodsDescription	Item Description
Number OfPieces	Shipped quantity
Pack Size	for batteries only
SKU	Item