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.

In ERP, Go to Work Orders → Work Order Processing and retrieve any Open Work Orders

You can then get a list of open work orders, you can select all and select Produce.  This will finish producing any work orders that can complete and leave any that still have issues.

You can then go into the work orders and select Allocate to see where the issue is.

Usually, this is due to a small amount of shortage on a work order for 1 particular ingredient and it already allocated most of the ingredients.