d0-production-plan

Automating ERP D0 production instruction uploads involves extracting SP3M3 planning data, generating Excel files via COM, uploading through the ERP web interface, and verifying results with MES checks. This process replaces manual entry to reduce cycle time and errors.

Running ERP D0 automation requires Python, PyWin32 for Excel COM object generation, Playwright for browser automation to handle web uploads, and access to a mapped Z drive data path for source files.

MES validation works by verifying the uploaded D0 production instructions directly within the Manufacturing Execution System after the ERP web upload completes. This step ensures the uploaded SP3M3 and SD9A01 data is correctly registered and parsed.

Yes, you can process SD9A01 Outer plans and SP3M3 weekly plans in the same run. The automation filters OUTER SD9A01 blocks, maps them to ERP D0 formats, and executes night or weekly planning data extraction together.

ERP D0 upload automation uses Excel COM to generate xlsx files instead of direct generation to ensure server parsing correctness. This guarantees the uploaded production instruction files meet the ERP system's strict formatting requirements.

The command to start SP3M3 night plan and SD9A01 Outer updates is running the Python script with the evening session flag. Executing this command triggers the extraction and ERP upload workflow automatically.