Does Menu Engineering Report pull historical recipe data, even if recipe is changed after menu items were originally sold?

Good morning {@005D0000005WERQIA4}​,

Thank you for your queries.

In regards to the cost specifically, our Menu Engineering Report Article outlines the logic that:

https://fc.force.com/customer/s/article/Adaco-Menu-Engineering-Report

Product Cost

Displays the cost of the menu item. The Product Cost is calculated as follows:

• The cost per serving at the time of the sales posting if Reduce Inventory when Posting Sales Transactions is enabled.
• The cost per serving at the time the report is run if Reduce Inventory when Posting Sales Transactions is not enabled.

Note: The flag Reduce Inventory when Posting Sales Transactions is found at Property>Administration>Property Preferences>Inventory.

I believe the 'Menu Name' & 'Selling Price' are from current tables, whereas 'Quantity Sold' & 'Total Sales' are from historical transaction tables; I am confirming this with our development team & will come back with clarity on these items shortly.

Best

David

Fourth

Good morning {@005D0000005WERQIA4}​,

Thank you for your queries.

In regards to the cost specifically, our Menu Engineering Report Article outlines the logic that:

https://fc.force.com/customer/s/article/Adaco-Menu-Engineering-Report

Product Cost

Displays the cost of the menu item. The Product Cost is calculated as follows:

• The cost per serving at the time of the sales posting if Reduce Inventory when Posting Sales Transactions is enabled.
• The cost per serving at the time the report is run if Reduce Inventory when Posting Sales Transactions is not enabled.

Note: The flag Reduce Inventory when Posting Sales Transactions is found at Property>Administration>Property Preferences>Inventory.

I believe the 'Menu Name' & 'Selling Price' are from current tables, whereas 'Quantity Sold' & 'Total Sales' are from historical transaction tables; I am confirming this with our development team & will come back with clarity on these items shortly.

Best

David

Fourth

Good morning @Halima Duncan​,

I just wanted to follow-up with confirmation from our Development Team that:

'Menu Name' & 'Selling Price' are from current tables, whereas 'Quantity Sold' & 'Total Sales' are from historical transaction tables.

Best

David

Fourth

Good morning @Halima Duncan​,

I just wanted to follow-up with confirmation from our Development Team that:

'Menu Name' & 'Selling Price' are from current tables, whereas 'Quantity Sold' & 'Total Sales' are from historical transaction tables.

Best

David

Fourth

Thank you David! A follow up question; what about the recipe cost field--is that also from the current tables, or does that stay with the recipe cost at the time of historical transaction?

Thank you David! A follow up question; what about the recipe cost field--is that also from the current tables, or does that stay with the recipe cost at the time of historical transaction?

Good morning {@005D0000005WERQIA4}​,

I believe this was covered in my initial response regarding the 'Product Cost' field (which is Product or Recipe):

Product Cost

Displays the cost of the menu item. The Product Cost is calculated as follows:

• The cost per serving at the time of the sales posting if Reduce Inventory when Posting Sales Transactions is enabled.
• The cost per serving at the time the report is run if Reduce Inventory when Posting Sales Transactions is not enabled.

Note: The flag Reduce Inventory when Posting Sales Transactions is found at Property>Administration>Property Preferences>Inventory.

If you wanted to see the various costs per transaction (if different), you could de-select 'Combine Same Lines' (following excerpt from the Menu Engineering Report Article previously referenced):

Combine Same Lines

Select the Combine Same Lines check box to combine recipes with different costs using average cost for this line instead. This option is enabled by default, as per Fig. 03.

Please let me know if there is further clarification required.

Best

David

Fourth

Good morning {@005D0000005WERQIA4}​,

I believe this was covered in my initial response regarding the 'Product Cost' field (which is Product or Recipe):

Product Cost

Displays the cost of the menu item. The Product Cost is calculated as follows:

• The cost per serving at the time of the sales posting if Reduce Inventory when Posting Sales Transactions is enabled.
• The cost per serving at the time the report is run if Reduce Inventory when Posting Sales Transactions is not enabled.

Note: The flag Reduce Inventory when Posting Sales Transactions is found at Property>Administration>Property Preferences>Inventory.

If you wanted to see the various costs per transaction (if different), you could de-select 'Combine Same Lines' (following excerpt from the Menu Engineering Report Article previously referenced):

Combine Same Lines

Select the Combine Same Lines check box to combine recipes with different costs using average cost for this line instead. This option is enabled by default, as per Fig. 03.

Please let me know if there is further clarification required.

Best

David

Fourth

The link to the Menu Engineering report in this discussion has been updated.

It is now: https://fc.force.com/customer/s/article/Purchasing-Inventory-Menu-Engineering-Report

Best,

Paul

Fourth

The link to the Menu Engineering report in this discussion has been updated.

It is now: https://fc.force.com/customer/s/article/Purchasing-Inventory-Menu-Engineering-Report

Best,

Paul

Fourth