Last updated 2/10/17
Started on May 21, 2012 at Libman
Libman owns an Australian subsidiary, Sabco. They use our Syspro infrastructure via Citrix. Our hardware is in use at almost all hours.
Maintained the 100+ reports, hundreds of labels (although most do not have db connections).
Cneated/maintained several existing desktop applications (about ten). Migrated several (3 or 4) programs from VB6 to .NET.
Upgraded reports and applications to Syspro 7
Canada Customs report has a lookup table. We did not want to write a separate application to maintain this, so I wrote a report that showed the contents, of the table, and also allowed the user to enter new data into the lookup table via the same stored procedure that rendered it.
Syspro, Avantis, Wonderware, ADSI (shipping logistics 3rd party software. Worked with them to gradually give more functionality to their program and less reliance on Fedex and UPS software) Bartender, OnBase document management system, Citrix
Created barcodes for all the sales orders and invoices for OnBase to “Index” automatically, instead of by hand.
ChequeCombine
Combines cheque image file (front and back) into one image, and gives the combined file a name that can automatically be indexed by OnBase.
LibmanWinService
an elegant service. This has a table of stored procedures that are run at specified intervals. If a stored procedure detects that a condition is met it emails a report to a list of people specified in the stored procedure. This is used to notify clients that a shipment is on its way.
SiloBobImport, .Net program that reads .csv files generated by the silo, imports them to a database, and renders appropriate reports.
Full Truck paperwork, combines three separate reports into one report using sub-reports. This report has a dozen or so parameters.
ShippingLabel and ASNLabel
These click-once programs read data from Syspro tables, show them on the screen, allow user to make edits then render them to the label printer using Bartender. A flexible platform that allows easy configuration for creating labels for multiple vendors.
ShipNumHandler parses the .csv file produced by “Don’s program” for the Bill of lading number
Some labels can be rendered by Don’s program, but some go to ASNLabel via ShipNumHandler.
Don’s program instead of invoking Bartender would invoke ShipNumHandler, which would present the Bill of lading number to the user to edit or automatically print in the ASNLabel program.
Order Entry Metrics report (SQL triggers used triggers to get the needed data).
ConnectShipExport this small program that takes Syspro data, presents it to the user for modification, and then renders it to ADSI so that all these orders can be shipped.
Warehouse Loading app this Microsoft Access program tracks sales orders as they are being picked by forklift drivers. An additional benefit is that I created reports on what has recently been picked in case trucks need to be rescheduled earlier than anticipated or in case products need to be given to another customer.
SabcoNT, a small program on Citrix that creates a file for supply chain transfer info.
Web application using MVC to maintain the CanadaCustoms lookup data with parent/child relationship Tariff categories and associated stock codes and their abbreviations.
Gap report
Some of the easier things are sometimes the most effective. Before I arrived, they would index invoices by hand. Then I added a bar-code and it made this task much easier.
Then I wrote a report that showed if there were any consecutive invoice numbers missing. This was really effective at showing if there were any missing documents that had not been scanned.
You could see the difference by looking at the gaps in the invoices before and after this report had been implemented.
By the way, this involved querying the OnBase database, which had an unusual structure.
Three web forms applications:
Vendor agreements. Able to add rows, "expire" rows, edit rows.
TL Tracking.
LTL Tracking. Data comes from shipping info. You can edit each row and add comments.
Many reports
It's not just about report creation, but there are always tasks where you need to investigate why the report is showing a certain value. One time I spent several hours investigating why two dates were off by exactly one year. Eventually, I discovered that the data had been entered twice, once in the right place and once in the wrong place with different journal numbers,.
Gap report
Some of the easier things are sometimes the most effective. Before I arrived, they would index invoices by hand. Then I added a bar-code and it made this task much easier.
Then I wrote a report that showed if there were any consecutive invoice numbers missing. This was really effective at showing if there were any missing documents that had not been scanned.
You could see the difference by looking at the gaps in the invoices before and after this report had been implemented.
By the way, this involved querying the OnBase database, which had an unusual structure.
Three web forms applications:
Vendor agreements. Able to add rows, "expire" rows, edit rows.
TL Tracking.
LTL Tracking. Data comes from shipping info. You can edit each row and add comments.
Many reports
It's not just about report creation, but there are always tasks where you need to investigate why the report is showing a certain value. One time I spent several hours investigating why two dates were off by exactly one year. Eventually, I discovered that the data had been entered twice, once in the right place and once in the wrong place with different journal numbers,.
No comments:
Post a Comment