Report Print out food recipes List?

V5 Question
1

Good Day,

I was wondering, we have put in a huge food recipes, big list,
is there anyways to print recipes ? in a list or report ? anything ?

2

There are inventory report tags so expect there is a way.
Never used inventory/recipes myself.
Know @pauln was looking deeper into inventory reporting no long ago, he might offer a suggestion.

3

There are no Report Tags for Recipes at this time. You will need to use SQL to pull out Recipe data.

Here is a good start …

SELECT
 ri.[Id]
--,[RecipeId]
,r.[Name] as [Recipe]
,[Quantity]
,ii.[BaseUnit] as [Unit]
--,[InventoryItem_Id]
,ii.[Name] as [InvItem]
,[OrderTag]
--,[ItemType]
,mi.[Name] as [MenuItem]
--,[MenuItemPortion_Id]
,mp.[Name] as [Portion]
FROM [RecipeItems] ri
JOIN [Recipes] r on r.[Id]=ri.[RecipeId]
LEFT JOIN [InventoryItems] ii on ii.[Id]=ri.[InventoryItem_Id]
LEFT JOIN [MenuItemPortions] mp on mp.[Id]=r.[Portion_Id]-- ri.[MenuItemPortion_Id]
LEFT JOIN [MenuItems] mi on mi.[Id]=mp.[MenuItemId]
WHERE 1=1
AND [InventoryItem_Id] is not null
--AND [MenuItemPortion_Id] is not null