Odyssey ERP Automated Casting Yield Reports
Every Monday, WebRun opens Odyssey ERP, compares each job's poured weight to its good shipped weight from last week, checks the job cost in QuickBooks to show the dollar impact of scrap and rework, and compiles a yield report by job and alloy in Google Sheets.
How do I turn poured weight into a weekly casting yield report?
WebRun turns last week's pours into a yield report automatically. Every Monday, it opens Odyssey ERP, compares each job's poured weight to its good shipped weight, pulls the job cost from QuickBooks to price the dollar impact of scrap and rework, and compiles a yield report by job and alloy in Google Sheets, sorted lowest yield first.
- Yield by job and alloy is compiled every Monday instead of chased down at month end
- Low yielding jobs are ranked with their dollar impact so the biggest problems surface first
- Yield trends by alloy are visible week over week
Built for foundries · die casters · foundry plant managers · metal casting operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.blinfo.comin a real browser with your saved login - no setup, no API keys. -
1
Odyssey ERP - compare poured weight to good shipped weight
blinfo.com
WebRun opens Odyssey ERP to compare poured weight to good shipped weight. - Open Odyssey ERP and pull every job poured last week with its total poured weight
- Pull the good shipped weight for each of those jobs
- Calculate the yield percentage per job and per alloy
Done when Every job poured last week has a poured weight, a shipped weight, and a yield percentage.
-
2
QuickBooks - pull the job cost for the dollar impact
- Look up the job cost for each job in QuickBooks
- Estimate the dollar value of the weight lost to scrap and rework at that job's cost
- Flag the jobs with the largest dollar impact
Done when Each job's yield is tied to a dollar value from QuickBooks job cost data.
-
3
Google Sheets - compile the weekly yield report
google.com
WebRun opens Google Sheets to compile the weekly yield report. - Add a row per job with poured weight, shipped weight, yield percentage, and dollar impact
- Roll up an average yield by alloy for the week
- Sort the report so the lowest yielding jobs sit at the top
Done when The week's yield report is compiled in Google Sheets with every job and an alloy rollup.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change how yield is calculated?
No. It uses the poured and good shipped weights already recorded in Odyssey ERP, so your existing yield definition doesn't change.
Where does the dollar impact number come from?
It prices the weight lost to scrap and rework using each job's cost in QuickBooks, so the yield report shows a dollar figure, not just a percentage.
Can it break yield down by alloy, not just by job?
Yes. The Google Sheets report rolls up an average yield per alloy for the week, alongside the per job numbers, so a pattern by alloy is easy to spot.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.