Add New Formulas
When in Feed Production, you may get an error that says Work Order Formula code XXXX was not found in ERP, No effective formula found. That means it needs to be added to ERP.
Item Master
Go to Master → Inventory →Item, Select the Inventory Type your item should be in.
You can verify that it is not in the item master by searching for that formula.
You can either hit New and create the formula from scratch or Duplicate an existing Formula.
Enter in the New formula code and Description
Set Unit of Measure, Pack Quantity, and Pack UOM
Save the item
Formula Master
Go to Work Order → Formula Master
You can verify that it is not in the formula master by searching for that formula. Look to see how other formulas are set up in the system as you will want to set this one up the same way.
You can hit Add, then select the calendar button
Select Add a New effective date and select an older date such as 1/1/2020 and accept.
Then select the Item, Fill in Description, Select any Work Order configurations that need to be set.
Go to Markups Tab and enter any markups for the formula.
Go to Divisions Tab and select the division and the GL to use when the formula is created in the work order.
This will become the template that CONNECT uses to create new effective dates when the nutritionist file is inserted.
Aeros LIVE Formula Management
You can go into Aeros LIVE and check that the formula exist there. However, if it was in your nutritionist file, it will create the formula in Aeros LIVE automatically so most likely it should be there.
Feed Management → Feed Formulas → Formula Management
Right click on the header and select Show Auto Filter Row to search the table.
Work Order needs to be Manually Processed in ERP ERROR
Work Order: Formula: XXX returned with an error: Error completing work order for Staging AAI record and needs to be manually processed in ERP.