walter's People
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
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.