What's new v2.60
v 2.60 (Current)
  • Added explainable customer reorder signals to Additive PO Issuance using order cadence, typical order quantity, monthly average volume, and the recent three-month trend.
  • Added a lead-time-aware Covered by inbound status: ETA is preferred, RETA fills missing ETA, and adequately covered relationships are removed from the attention list.
  • Excluded product names whose material-code variants are all marked Unactive in Product Master from customer reorder signals.
  • Separated contact suggestions, due-soon patterns, and manual reviews with confidence levels so irregular or dormant history is never treated as an automatic customer reminder.
  • Collapsed same-name additive packaging variants into one product filter while preserving every underlying material code in the report and Excel export.
  • Added stale-request protection, bounded alert-table scrolling, responsive signal summaries, and regression coverage for scoring and combined packaging filters.
v 2.51
  • Corrected Pro Forma Invoice line totals when multiple material codes share the same product name but use different package sizes.
  • Made the exact material code and order-line UOM per piece authoritative, including legacy Finished Goods records with a blank UOM.
  • Added regression coverage for order 5717729595, where material 238082 now uses 18 L per pail and totals USD 2,304.00.
v 2.5
  • Added an unsaved-change reminder before leaving Order Details, opening another order, logging out, or closing the browser.
  • Updated Save & Stay and Save & Exit to save pending supplier prices, shipping costs, extra charges, insurance, and forwarder invoices together with the order.
  • Made Handling Type 5 supplier logistics optional, so users can record independent extra charges without first entering an unnecessary supplier logistics rate.
  • Preserved the active Order Detail tab after Save & Stay and kept recoverable cost edits on screen when a secondary save needs correction.
  • Strengthened logistics-cost regression coverage and advanced the browser asset cache key so every v2.5 client loads the updated behavior.
v 2.4
  • Rebuilt Custom Reports as a self-service pivot and detail-report builder with flexible filters across sales orders, purchase orders, products, shipments, equipment, dates, quantities, and weights.
  • Expanded pivot dimensions and measures, added TALUSIA LS 40 and 20ft Singapore-to-Busan examples, and kept on-screen results aligned with downloadable Excel workbooks.
  • Hardened report accuracy with grain-safe aggregation, active-invoice handling, stale-request protection, safe Excel values, real Excel dates, readable totals, and unobstructed filter menus.
  • Redesigned Follow-ups into a searchable work queue with Open, Completed, and All views plus open, due-today, and overdue summaries.
  • Added optional Outlook email subjects and follow-up dates, clearer editing and completion actions, validated inputs, and backward-compatible database migration.
v 2.3
  • Rebuilt Order Details into focused Sales Order, Purchase Order, Shipment, Billing & Invoices, and Handling Flow tabs, with compact headers, clearer reminders, responsive item editing, and cascading cancellation.
  • Introduced fulfilment-owned RETA and invoices so consolidated YLAS shipments keep separate PO invoices, while YLAN stock orders support multiple shipments and invoices without requiring artificial POs.
  • Added handling-aware supplier and shipping costing, reusable route/equipment rates, forwarder invoice reconciliation, net-weight allocation, flat extra charges, TE insurance calculation, and cost-aware pro forma invoices.
  • Added editable handling-type and forwarder selection, future-order rules, automatic LTT defaults, and estimated loading dates based on RETA and route transit time.
  • Restored the six historical LTT fulfilments for SO 5704582054 and hardened legacy invoice reconciliation, database readiness checks, and verified GitHub-to-ECS production deployment.
v 2.2
  • Reworked Orders into a readable two-row master list with full RETA visibility, PO counts, complete shipment and billing status counts, and direct row navigation.
  • Added aligned Shipment Status and Order Status filters, including combined filtering without hiding the other statuses belonging to a matching Sales Order.
  • Corrected PIC-specific follow-up counts and fixed the Needs Scheduling Buy & Sell filter with clearer operational typography.
v 2.1
  • Added multi-invoice forwarder reconciliation for Handling Types 2 and 3, with shipment-level expected versus actual cost comparison and clear overcharge, undercharge, matched, and missing-baseline states.
  • Added AIR CARGO equipment handling: selecting AIR now assigns and locks the only valid equipment type automatically, while startup migration corrects every historical AIR shipment.
v 2.0
  • Rebuilt Orders as a flat master search with direct row navigation, two-field AND search, compact columns, saved views, improved selection and copy output, and cancellation-aligned logistics status.
  • Redesigned Work Overview, Shipment Board, and Needs Scheduling around the logged-in user's PIC, with explicit PIC overrides, operational workload filters, corrected pending-billing rules, and lead-time-based arrival-risk queues.
  • Rebuilt Master Data as a responsive registry with row-to-edit interaction, forwarder contact details and annual PO references, plus validated Excel export/import for bulk maintenance.
  • Added fulfillment-owned invoices, consolidated shipment links, YLAN and buy/sell flow handling, estimated loading dates, supplier pricing, and shipment-aware logistics costing.
  • Hardened PostgreSQL deployment with 64-bit SAP identifiers, serialized fail-fast migrations, deterministic backfills, schema readiness checks, secure production configuration, and a versioned health endpoint.
v 1.90
  • Achieved 100/100 Lighthouse scores across all categories (Performance, Accessibility, Best Practices, SEO, and Agentic Browsing).
  • Migrated to modern Web APIs, modern CSS layout tokens, high contrast WCAG AA compliant theme badges, and Gzip compression.
  • Added asynchronous non-blocking script and font loading with BFCache optimization and WebMCP agent annotations.
v 1.80
  • Added Microsoft 365 Copilot Integration Gateway API (/api/ai/*) with OpenAPI 3.0 specification, Entra ID / Bearer authentication, and comprehensive audit logging.
v 1.77
  • Added editing support for Customer Code, Vendor Code, and PIC Name primary key fields in Master Data tables with automatic reference updates.
  • Added Active / Unactive status toggles with uncompleted order validation warnings for Customer and Supplier tables.
  • Filtered out Unactive Customers and Suppliers when creating or updating order detail selections.
v 1.76
  • Formatted Customer and Supplier select options in Order Detail page to "Customer Code - Customer Account" and "Supplier Code - Plant code" respectively.
  • Sorted Customer and Supplier dropdown options in ascending order by Customer Code and Supplier Code.
v 1.75
  • Fixed PostgreSQL integer range issue for 10-digit SAP SO/PO numbers in COA record database tables (migrated columns to BIGINT).
  • Moved COA Report Date into individual Shipment Batch Breakdown rows with interactive date selector support per batch.
v 1.74
  • Added PostgreSQL-compatible automatic database migration for additional shipping charges columns (Sea Freight, FOB, Insurance, Other).
  • Added zero-default SQL query fallback in get_order_so ensuring order details load smoothly even if database columns are pending migration.
v 1.73
  • Wrapped order detail endpoints in top-level exception handlers returning explicit JSON error messages.
  • Added universal VARCHAR CAST formatting across all PostgreSQL joins and lookup queries.
  • Enhanced frontend alert to display detailed server exception messages directly if HTTP 500 occurs.
v 1.72
  • Fixed PostgreSQL database type-safety for order lookup queries on AWS (added explicit CAST for PO & SO fields).
  • Added database transaction rollback safeguards for PostgreSQL error recovery.
  • Enhanced frontend HTTP error status extraction for proxy and HTTP/2 deployments.
v 1.71
  • Resolved order detail loading issue by enabling flexible order lookup by Customer PO Ref, SAP PO, and Line ID.
  • Added string quote safety for all tree table order row click handlers across all report and dashboard views.
  • Enhanced backend API error reporting for order detail navigation failures.
v 1.70
  • Added Customer Prices master data management with Excel template download, bulk upload, and editing by Customer Account Number.
  • Added Pro Forma Invoice (PI) PDF generator with aspect ratio logo scaling, 2-column metadata, and custom PDF filenames.
  • Added support for customer notify address selection for multiple addresses, with automatic 6-line capping.
  • Added per-order additional shipping costs (Sea Freight, FOB & Local Handling, Insurance, Other Charges) saving & borderless PDF table row formatting.
  • Added automatic liquid UOM volume-based price calculations (e.g. $200/100L for 205L drums).
v 1.60
  • Added Certificate of Analysis (COA) template management per product name under Master Data.
  • Added multi-batch COA test results matrix input and PDF generator in Order Details page.
  • Multi-batch shipments render dedicated 1-page COA documents per batch with custom customer PO filenames.
  • Added UOM (Unit of Measure) column to Product Master Data, with defaults for Additives (KG) and Finished Goods (L).
v 1.52
  • Added active/inactive status toggle support for PICs with warning prompts for uncompleted orders.
  • Added a Delete button for Forwarder records in the Forwarders master table.
  • Defaulted order creation PIC selection to the user's mapped PIC name instead of their login username.
v 1.51
  • Added a new "Follow-up Reminders" page to jot down and complete follow-up tasks on order shipments.
  • Introduced a comprehensive "Users" management tab under Master Data to add, edit, and delete user profiles.
  • Resolved a bug preventing user records from being edited, and improved case-insensitive safety for administrator account deletion checks.
  • Made user-to-PIC links optional (e.g., for Admin logins) and set 'admin' as the only protected system fallback account.
v 1.50
  • Added a new "Abnormal Inputs Report" page under Reporting to detect logical errors and formatting anomalies across order lines and shipments.
  • Implemented dynamic searching, sorting, and filtering options by Anomaly Type, Severity, and Person in Charge (PIC).
  • Integrated redirection from anomalies list directly to the PO Details editor for instant corrections.
v 1.46
  • Added product deletion capability for Administrators in the product Master Data table.
  • Implemented "Unactive" product status blocking to prevent creating/adding order lines with inactive products.
v 1.45
  • Minor UI refinements and performance optimizations.
v 1.44
  • Corrected details input container spacing by wrapping fields with prefix icons.
  • Replaced standard checkboxes with premium Material/iOS-style switch toggles.
  • Redesigned left PO selector items with status icons and active borders.
  • Implemented interactive timeline step navigation to scroll and highlight target logistics fields.
  • Added mini-summary widgets for PO Totals (Net Weight, Line Items, and Total Quantities).
  • Enabled internal vertical scrollbars for all page tables with sticky opaque headers and wider horizontal scrollbars.
v 1.43
  • Added Save & Stay button to allow saving modifications without leaving the detail page.
  • Implemented PO Duplication to quickly copy supplier/lines while clearing tracking, invoice, remarks, and shipment dates.
  • Enlarged the product selection autocomplete field container width to 420px.
  • Swapped product display representation sequence to: Material code - Product name - Packaging - Volume.
  • Enforced strict required field validation (and added red asterisks) for SO Date, PIC, SAP PO, PO Date, RETA, Equipment details, Transportation, POL, and POD on both client and server.
  • Enlarged font sizes and timeline spacing on the Order Handling Flow widget for improved legibility.
v 1.42
  • Fixed PIC desynchronization in scheduling/shipment views.
  • Fixed product search dropdown overflow clipping issues at the container boundaries.
  • Implemented column resizing and full-column copying on Reports to Customer view.
v 1.41
  • Resolved clipboard copying failures in restricted browser environments by automatically falling back to an interactive modal highlighting the plain-text/address content for quick manual copy (Ctrl+C / Cmd+C).
v 1.4
  • Implemented client-side Packing List PDF and Excel generation from the Order Detail page, aligned with corporate layout formatting.
  • Resolved blank PDF page downloads by integrating string-based document generation with canvas scroll offset resets and rendering delays.
  • Optimized grid layout alignment: relocated SAP No, removed Order No row, and flattened colspan cells to resolve overlapping vertical border rendering bugs.
v 1.34
  • Added Copy Material to copy product line items in Excel/SAP compatible TSV format, automatically appending supplier plant code and stock flow.
  • Added Copy Address to copy customer consignee and notify party addresses, with an interactive picker dialog if multiple notify parties exist.
v 1.33
  • Redesigned order creation flow to directly open the full Order Edit & Detail view, bypassing the simplified modal form.
  • Restored historical billing and shipment details in SQLite database from backup.
v 1.32
  • Added Plant Code, Consignee Address, and Notify Party columns in Customer Master data table.
  • Added Plant Code and Stock Flow columns in Supplier Master data table.
v 1.31
  • Replaced raw JSON textareas with a modern Interactive Steps Builder in Master Data editor.
  • Implemented automatic color coding and icon mapping based on Selected Related Party.
  • Added controls to move steps up/down and delete steps with full validation.
v 1.3
  • Implemented dynamic Order Handling Flow stepper timeline on the Order Details view (real-time updating on supplier/equipment change).
  • Added rule versioning matching based on the order's Requested ETA (RETA) date, with wildcard fallback (ANY) support.
  • Added **Logistics Flow Reminder** fields to Customers, Suppliers, and Forwarders, displaying custom info cards dynamically.
  • Integrated a new **Forwarders Master Lookup table** in Settings.
  • Supported Excel spreadsheet export and import validation for mapping rules.
v 1.21
  • Added Pivot Table column totals and row totals to Additive PO Issuance.
  • Added download Excel button to Additive PO Issuance Report.
  • Fixed default user login credentials verification.
  • Filtered Customer Status Report to only show orders with ETA in the last 7 days or future.
  • Refined Customer Status Report layout for single-product orders.
v 1.20
  • Rebuilt the Reports section completely with specialized Additive PO Issuance Report and Reports to Customer.
  • Implemented a dynamic 12-month rolling window chart and nested pivot table for Additives POs.
  • Added Sales Order and Product line item remarks across order creation, details, and reports.
  • Added copy-to-clipboard functionality for customer reports compatible with Excel (TSV).
v 1.10
  • Replaced all Custom Report single-select filters with premium multi-selection checkbox dropdowns.
  • Added a new Shipment Status filter (allowing selection of Pending Schedule, Not Loaded, In Transit, Arrived, and Cancelled) to the Custom Reports panel.
  • Enabled full backend array parameter matching for all custom reports and Excel exports.
v 1.09
  • Made PO Date a mandatory field during order creation (defaults to today's date), and defaulted SO Date to today's date automatically.
  • Enforced SAP PO number as a mandatory input field during order creation.
  • Added a validation constraint requiring Document Received Date to be filled when saving/updating order details or shipment schedules with an SAP Invoice number or SAP Invoice date.
v 1.07
  • Enabled search by SAP Invoice and Supplier Invoice numbers in Scheduling and Orders pages, and Customer Ref in the Scheduling search box.
  • Changed the PIC field in Order details/edit view to a dropdown select populated from the PIC Table lookup.
  • Replaced the product select dropdowns in Create Order and Order edit/detail product lines with a premium searchable autocomplete text box (matching starts-with first, formatted as code - product name - vol L - Packaging).
v 1.06
  • Enabled editing the Material Code in the Master Product Lookup modal, updating references database-agnostically.
  • Added a Delete Sales Order button for administrators in the Sales Order Header details, enabling full cascade deletion of SOs, linked POs, lines, and orphaned shipments with a confirmation warning.
v 1.05
  • Grouped Schedule Board and new Pending Schedule board under "Scheduling" sidebar section.
  • Revamped Schedule Board: Removed pending schedule card lane; replaced SO numbers with Customer Codes and Shipment numbers with Customer PO Refs in "Not loaded" and "In transit" lanes; configured "Arrived" lane to display Customer Code, Customer PO Ref, and ETA.
  • Created a new Pending Schedule page showing unscheduled Sea transit shipments, categorized into Urgent, Semi-Urgent, and Not Urgent based on average route lead times in the past 6 months.
  • Added automated user provisioning startup hook for admin user "wai".
v 1.04
  • Show country code prefixes on Customer and Supplier selectors and filter checklists (both sidebar and column filters).
  • Added "Unbilled Only" checkbox filter on the Orders page.
  • Product-supplier matching validation on order edit (frontend & backend database check).
  • Selection checkboxes on all Orders grid rows (with parent-child cascade check behavior) and a "Copy Selected" toolbar button to copy selected rows as a table/TSV to clipboard.
v 1.03
  • Mandatory Equipment Type and Quantity inputs on new order creation.
  • Fixed database foreign key constraint error when adding purchase orders on Order line details.
v 1.02
  • Added "Clear Filters" button on the Orders page.
  • Added a RETA (Requested ETA) column with descending default sort (newest/future on top).
  • Set page limit calculation to be based on Sales Orders (50 SOs per page) rather than order lines.
  • Added a summary banner at the bottom showing total weight and package breakdown for the active view.
v 1.01
  • Sorted product dropdown list alphabetically (A-Z) by name.
  • Formatted product dropdown display strings to show packaging at the end (e.g. 160297 - Atlanta Marine D 4005 - Flexi).
  • Fixed table columns to shrink dynamically when columns are hidden.
  • Added version labels to the login page and sidebar footer.
v 1.00
  • Initial deployment of the secure SPA dashboard and collapsible tree grid orders page.
  • Added interactive timelines, lookups masters registers, and dynamic report generators.

Dashboard

APAC operations statistics and trends summary

Today

What needs attention

Open a work queue to move urgent orders forward.

Updating…
Performance

Operations snapshot

Additives Weight (Invoiced) 0 kg
Additives Weight (Pending) 0 kg
Avg Additives Weight (6m) 0 kg
Avg Sales Orders (6m) 0

Order Volume & Weight Trend

PIC Avg Invoices (3m)

PIC Avg Invoices / Month
Open0
Due today0
Overdue0
Reminder queue

Pick up where you left off

0 follow-ups

Open follow-ups

0 open
Quick views
SO No.
PO No.
Customer Ref
Customer
Supplier
Product Name
RETA
Unbilled queue
Filtered workload 0 orders / shipments All PICs · All flows · LTT shown
Not departed 0 Prepare & confirm departure
In transit 0 Monitor & prepare billing
Ready to bill 0 Arrived without invoice
Arrival risk planning

Schedule the orders most likely to miss RETA first

Each unscheduled SEA shipment is compared with its route's recent transit history and a 10-day preparation allowance.

Today 10 days preparation 6-month average transit Projected arrival
0 unscheduled SEA shipments

Exact route history is used where available; otherwise the recent SEA network average or a 20-day fallback is shown.

Urgent 0 Projected to miss RETA
At risk 0 0–10 days of margin
Lower risk 0 More than 10 days of margin
Urgent0 shipments The recommended schedule-by date has passed; historical lead time projects arrival after RETA. Select any row to add ETD and ETA
Order & PICCustomer / SupplierRoute historyRETA targetRisk if scheduled now
At risk0 shipments Ten days or less of schedule margin remain, so the order should be arranged next. Select any row to add ETD and ETA
Order & PICCustomer / SupplierRoute historyRETA targetRisk if scheduled now
Lower risk0 shipments More than ten days of schedule margin remain; monitor these after higher-risk orders. Select any row to add ETD and ETA
Order & PICCustomer / SupplierRoute historyRETA targetRisk if scheduled now
Reference data

Customers

Customer identities, contacts, billing accounts, and logistics instructions.

0 records
Showing 0 records Select any row to edit Export, amend in Excel, then import to update many records

Additive PO Issuance Report

Filters

Ordering history + inbound context

Customer Reorder Signals

Highlights customer and product patterns near their usual reorder point, while checking scheduled ETA/RETA arrivals before suggesting contact.

Decision support, not an inventory forecast
Contact suggested—
Due soon—
Needs review—
Covered by inbound—

Additive Order Net Weight Timeline

Loading additive report…

Pivot Table: RETA Net Weight (kg)

Reports to Customer

Customer Ref Products Qty Packaging RETA ETD ETA SO Remark

Abnormal Inputs Report

0
Total Anomalies
0
High Severity
0
Medium Severity
SO / PO / Line Shipment Customer / Supplier Fault Category Description Severity Action
Analyzing data inputs...
Self-service analytics

Turn operational data into an answer

Filter the records, arrange a pivot, compare periods, and export the finished analysis to Excel.

Step 1

Choose the records to analyze

Use the common shortcuts below, then add rules for any other reportable field.

Flexible filters

Filter by any field

Product, equipment, identifiers, dates, weights, quantities, route details, and more.

No additional rules. All values are included.

Common shortcuts and flexible rules are combined with AND. “Is any of” values inside one rule are combined with OR.

The date basis drives both the range filter and Month, Quarter, or Year pivot fields.
Step 2

Shape the pivot

Rows answer “when or what,” columns create the comparison, and values define the metric.

Equipment quantity is counted once per shipment, even when that shipment contains multiple product lines.

Your pivot analysis will appear here

Choose the date basis, filters, rows, columns, and value—then run the analysis.

Settings & Profile Preferences

User Profile

Change Account Password

Personalization

Dark Mode
Light Mode

Reset Preferences

Reset all column visibilities, custom column widths, and settings back to system defaults.

Order Line Details

Complete the required fields to keep this order moving.
0% complete

Sales Order

Customer and SAP order information

Remark & customer logistics reminder No notes

Sales Order Products All fulfilments

Combined quantities from every purchase order or stock shipment in this sales order.

Product Product Name Package / UOM SO Total Qty Total Net Weight (kg) Used in
SO Net Weight0 kg
Unique Products0
SO Total Quantity0

Fulfilment Schedule 0 fulfilments

Each purchase order or stock shipment keeps its own requested arrival date.

PO / Stock Shipment Supplier / Warehouse RETA ETD ETA Billing
Purchase flowPO required

Purchase Order

Selected supplier purchase order

Pending
Remark & supplier logistics reminder No remark

Selected PO Items

Line ID Product (Code) * Product Name Qty * Pkg / UOM Net Weight (kg) Remark Actions
Total Net Weight 0 kg
Total Line Items 0
Total Quantities 0

Supplier Commercials

Expected product cost, supplier invoice amount, and reusable USD/100 UOM prices.

Selected PO

Supplier Product Cost

Prices are frozen on this PO. Save selected prices as defaults for future matching product, packaging, and UOM lines.

Product Package Qty UOM / pc USD / 100 UOM Amount Future default
Product cost$0.00 Supplier logistics$0.00 Expected supplier invoice$0.00 Actual variance—

Shipment & Logistics

Consolidate with another PO in this SO

Order Handling Flow

Handling for this fulfilment Choose a handling type and forwarder.
Not allocated
Only required for Handling Types 2 and 3.
Select Supplier and Equipment Type to view logistics flow