In the upper part of the set card (the Set window) there are the header fields — Code and Name. The lower part contains the following tabs: Main parameters, Calculation, Technology, Energy value, Other, Period attributes and Component detailing.
Set Header
Code — when saving a set, a numeric code is automatically generated for searching for the set in the dictionary. The continuous numbering is used throughout the dictionary.
Name — enter the set name in this field. For convenience, you can enter a name that matches the name of the goods linked with the set. This field can be filled in automatically when creating a set based on goods.
Main Parameters Tab
Group — this field specifies the set group that the open set belongs to. To change the set group, click on the Group line, open the tree of set groups by clicking on the triangle icon at the end of the line —
It is also possible to change the group which includes the created set in the window with the groups tree, by dragging the set from one group to another.
Modifier — this flag is set for sets that will be used without goods in the Requests to change the main set. Also, this flag allows creating sets that reduce or completely exclude any component from the goods set. This flag is set automatically for sets imported from r_keeper.
Calculation Tab
The Calculation tab contains all the working information on the set: version, period, ingredients. On this tab, you can view information on the set self-cost and the resulting markup.
The Period from and Version fields are interrelated: periods are created for a specific set version and do not apply to other versions. One set version can have multiple validity periods. Please find more details on each field and the rules for filling them out below.
Set Version
StoreHouse 5 allows working with multiple enterprises in one database. If StoreHouse is used in conjunction with r_keeper, which also allows working with several enterprises, then usually the menu is the same for all enterprises. Thus, for example, Coffee Americano is created as one item for all restaurants in r_keeper, and, if needed, different prices or rules of use are set for different enterprises. For more information, please, see the r_keeper 7 documentation. In StoreHouse, the import also creates a single goods item with exceptions by enterprises.
But when warehouse accounting is used, the method of preparing a dish with one name may differ depending on the enterprise. Different coffee machines may need a different amount of coffee grains for the same Coffee Americano.
To be able to maintain different sets for the same goods, StoreHouse 5 uses the Set version concept.
Set version — different simultaneous variations of cooking the same dish. It is possible to determine a separate version for each restaurant for the sake of write-off.
0 version — the version created automatically when creating the set, i.e. the default version defined on the goods card.
The use of different set versions is defined on the card of a specific goods item.
To create a new set version:
- Open the set in which you want to create a new version
- Open the Calculation tab
Select the version and period in regard to which you want to create a new set version
When creating a new set version, a copy of the selected set of ingredients, technology and Other tab is created, which can be further edited.
In the Version line, enter the set version number — any integer that is different from the already existing set versions
- If, in addition to the set version number, it is necessary to specify the version name, open the list of set versions and enter set versions names
- Save the new set version using the Document — Save Document menu item or using the button on the toolbar
- Make the necessary changes in the lower part of the window: delete unnecessary goods, add the necessary ones, change the Gross of goods
- Save the changes using the Document — Save Document menu item or using the button on the toolbar
- Close the Set window.
You can create periods for the newly created version of the set, as well as for the zero version.
All versions and periods of the set can be viewed by opening the list of set versions. To do this, call the context menu from the required set and select the Set versions item.
The list of versions is displayed in the left part of the window, the periods for the selected version are displayed in the right part.
To delete a set version:
- Open the Sets dictionary: go to Dictionaries > Goods > Sets
- Select the required set in the list of sets
- Call the context menu and select the Set Versions command or select the Document > Set versions main menu item
- The Set versions window will open
In the left part of the window, select the required set version and use the Delete set version context menu item or the Document > Delete set version main menu item
- You cannot delete the zero version of the set. If you want to delete the zero version, you must delete the set itself.
- You can delete set versions only if no goods were written off based on the set version being deleted. If necessary, the write-off can be canceled.
The system will ask you to confirm the deletion. Click Yes if you really want to delete the selected set version. Click No if you mistakenly selected the Delete set version menu item
Set period
Period from — field of the period validity start date. When creating a set, indicate its start date. The date one day before the start of the next set period is the end of the previous set period and is specified automatically.
When a set is created, the date 01/01/1980 is automatically entered. If you do not change this date, the set of components that you define will be valid from 01/01/1980. There is no end date for the set validity period.
StoreHouse allows creating several different periods of validity for one set version.
For example, a Seasonal Salad set might look as follows:
- from 05/01/16 it is fresh vegetable salad
- from 09/02/16 it is Russian vinaigrette
- from 12/02/16 it is Olivier salad
- from 02/02/17 it is fish salad.
The program automatically sets the last day of the current period to the previous day from the beginning of the next period.
Also, a periodic change in the set can be used to write off such goods as Dish from the Chef, Soup of the Day, etc., that is, for those goods whose cooking technology changes every day.
In addition to the above examples, changing the set period makes it easy to organize the write-off of buffet items.
The set of permanent goods may also change, for example, the yield per unit may change depending on the seasonal percentage of processing.
If several set periods with different composition and quantity of ingredients are created, then, when writing off the sale, the program will write off the goods that are indicated in the sets that are valid at the date of sale.
- To create a new set period, enter the start date of the new period in the Period from field.
- When you create a new set period, a copy is created that can be further edited. A copy is created according to a set of ingredients, cooking technology and the Other tab.
If several periods have already been created for the set, then when adding a new period, select the one you want to create a copy of, and specify the desired date of the new period in the Period from field.
The set selected for copying can be any, not necessarily the last one.
If two periods have already been created in the set, and you want to insert a third period before the start of the already existing second period, then enter the required date and save the set.
If the set has already been used in documents, then to create an earlier period and to further edit it, the user should have the right to recalculate already created documents.
If you save an earlier period or change it in an already written off period, the documents will be changed according to the new data. It will lead to a change in quantitative and total balances.
Used in delivery notes — the flag is automatically set by the program when this set is used in delivery notes. This flag is assigned to each period that was used in the active delivery note.
You cannot change the set start date to an earlier one in the Period from field. When the date is changed, a new period will be added.
For example, you saved a set with start dates at 01/01/1980 and 02/12/2016.
When entering the 01/25/2016 date, a new period will be added between the already created ones.
If you still need the period starting from a different date, do the following:
- Create a new set period with the desired date, basing on the period, the ingredients of which should be copied into the new period — 02/12/2016 in the example
- Delete the unnecessary period — 02/12/2016 in the example.
To delete a set period:
- Go to Dictionaries > Goods > Sets
- Select the desired set in the list of sets
- Call the context menu and select the Set versions command or use the Document > Set versions main menu item
- The Set versions window will open
- In the left part of the window, select the required set version
In the right part of the window, all periods created for this set version are displayed
If the set period is used in delivery notes, then in the Used in delivery notes tcolumn there will be a flag.
Select the desired period and use the Delete set period context menu item or the Document > Delete set period main menu item
The system will ask you to confirm the deletion. Click Yes if you really want to delete the selected set period. Click No if you have mistakenly selected the Delete set period menu item.
After that, you can open the set again and spesify the required period. In our example, it is 01/25/2016.
- If the period to be deleted was used in delivery notes, then when deleting such a period, the write-off will be recalculated according to the period that was set earlier than the period to be deleted.
- To be able to delete a period, the user must have the right to recalculate already created documents.
Therefore, the system will ask for confirmation of delivery notes recalculation. Click Yes to confirm deletion of the set period and delivery notes recalculation. Click No if you do not want to recalculate delivery notes.
The No answer to the message, in addition to refusing to recalculate delivery notes, will also cancel the deletion of the set period.
Yield per Unit and Set Unit of Measurement
Ratio (yield per unit), Ratio UOM (set unit of measurement) — the quantity of the ready product, obtained from the components specified on the Calculation tab, i.e. the resulting quantity of goods.
Starting from version 5.55.239, the ratio (yield per unit) can be changed for the set periods. This parameter has been moved to the Calculation tab.
Ratio UOM
Since the set itself is not used for creating StoreHouse documents but works only through links with the goods, then when specifying the set ratio UOM, you should first of all be guided by the UOMs used in the cards of the goods with which the set can be linked.
Only one UOM can be specified in the Ratio UOM field.
If a write-off was made for the set, then it is impossible to change the Ratio UOM.
If you need to change the Ratio UOM, you need to create a new set.
For goods imported from r_keeper, the Portion unit of measurement is created by default in the goods card, which is used for these goods when forming automatic requests. Accordingly, all sets are also standardly created with the Portion ratio UOM.
If you need to use another UOM for a set, then specify both UOMs in the goods card and specify the recalculation coefficient by which the amount of ingredients to be written off will be calculated.
If you change the ratio UOM for a set linked with goods to the UOM that the related goods do not have, the system will display an error message:
In the Ratio UOM field for semi-finished sets, the UOMs convenient for further use of the semi-finished products — l, ml, kg, piece, etc. — are specified.
Ratio Amount
Ratio (yield per unit) — the amount for which the set is created, in the set UOMs.
For goods imported from r_keeper, the standard quantity is 1.
Nevertheless, ANY number of PORTIONS can be specified.
For semi-finished sets, in the Ratio field, the actual output of the product in finished form is indicated, for example: 2 liters, 1.4 kg, 70 pcs., etc.
The ratio amount can be changed by periods.
- If the set has already been used in documents, to change the ratio amount of an earlier period, the user should have the right to recalculate already created documents.
- If you save the change in the ratio amount of the written-off period, the documents will be changed according to the new data. It will lead to a change in quantitative and total balances.
Component Calculation
By default, when specifying ingredients for the set, entering quantities proceeds from gross to yield. Thus, first you need to specify gross, then you can specify %1 of processing or net, then you can specify %2 of processing or yield.
In some cases, this method of filling quantities can be inconvenient. For example, when only the yield of ingredients and percentages of processing, both hot and cold, are known, and it is necessary to calculate the gross basing on the known data. Or when the net and processing percentages are known, and it is necessary to calculate the yield and gross basing on the known data.
For such cases, you can set the from net to gross and from yield to net in the set card.
The system works by summing the flags.
For example, if it is necessary to make calculation basing on yield — yield and processing percentages are known — then both flags must be set. If it is necessary to make calculation basing on net — net and processing percentages are known — then only one flag from net to gross must be set.
By default, the from net to gross and from output to net flags are not set in set cards. Thus, they must be set when opening the set, if you want to enter data NOT from the gross.
When the set is closed, the set flags are not saved.
If it is necessary to always use a certain set of flags for all sets, then you need to make the corresponding setting in the StoreHouse settings file — SH.INI. This file is located in the same working directory as the Store House application file — SH.EXE.
Each StoreHouse workstation (computer) uses its own file. Therefore, the settings made on one workstation will not match the settings of another workstation.
To define the default flags in the SH.INI file, make the following setting:
- CmpToBrutto = 0 (no flags set); 1 (from net to gross); 2 (from output to net) or 3 (both flags are set)
If there is no such line in the file, add it:
[sh] ; calculate quantity in CI CmpToBrutto = 0 (1; 2 or 3)
Calculation
Calculation — this area displays summary information on the set self-cost, on the basis of which you can make the necessary calculations of the set sale price for a particular enterprise.
Till — in this field, enter the date on the morning of which the set self-cost will be calculated according to the method specified in the system settings, taking into account the current documents for the specified date. The date can be selected from the open calendar or entered using the keyboard.
When the set is opened, the current computer date is displayed.
Also, this date affects the period of the semi-finished product set, according to which the set self-cost and energy value will be calculated.
Department — in this line, select the department, basing at the price of receipts for which the set self-cost will be calculated. The department is selected from the Departments dictionary that opens when the button is pressed at the end of the line.
The Legal entity and Enterprise lines are filled in automatically according to the selected department.
Markup % — in this field, you can enter a markup as a percentage to calculate the set sale price. Also, the markup can be calculated automatically if you fill in the Sale amount e/t field.
| Sale amount e/t – Self-cost e/t |
|
Self-cost e/t |
Self-cost/Sale price %, i.e. FoodCost of the set — the percentage of the set self-cost and its sale price. It can also be filled in manually for to calculating the sale price, or be calculated automatically, when filling in the Sale amount e/t field.
| Self-cost e/t |
|
Sale amount e/t |
Self-cost e/t (Self-cost excluding tax), Self-cost i/t (Self-cost including tax), VAT (Value Added Tax), Sales Tax — these fields are filled in automatically in accordance with the prices and tax rates for the goods contained in this set, in the documents that place the goods from the set to the selected department.
Set self-cost calculation method — FIFO (first in first out); based on the last receipt; based on the average price of the balance. The self-cost calculation method is defined for each StoreHouse client location in the StoreHouse settings file — SH.INI. This file is located in the same working directory as the StoreHouse application file — SH.EXE.
To define the self-cost calculation method in the SH.INI file, set CmpCostType = 0 (FIFO); 1 (based on the last receipt); 2 (based on the average price).
This setting does not affect the self-cost calculating method for write-offs. It ONLY influences the set self-cost calculation and the formation of the receipt price when processing returns.
If there is no such a line in the file, then add it:
[sh] ; How to calculate prime cost in sets (0 is FIFO; 1 is Last; 2 is Remns) CmpCostType = 0 (1 or 2)
- The self-cost is calculated based on the sum of the self-cost of the goods in the set according to the method specified in the settings, on the morning of the selected date, taking into account current documents
- If the Department field is not filled in, there are no remaining components in the specified department, or the self-cost of components is 0, then the self-cost will not be calculated
- If the Produce flag is set, the cost of semi-finished products is calculated according to the set period, which includes the date specified for calculating the self-cost.
Sale amounts (Sale amount e/t, VAT, Sale Tax, Sale amount i/t) — this field displays the sale prices of the set and the sale tax amounts. This field can be filled in manually or can be calculated automatically when filling in the Markup % or Self-cost/Sale price% fields.
The data in the Markup and Sale amounts fields is not saved when the set is closed.
The Sale amounts fields are filled in according to the data specified in the Ratio field.
Also, the fields will be filled in with values from the goods card if the set is opened from the goods or the list of goods. Moreover, if the set contains the Department for calculating the self-cost and there are price exceptions in the goods for the enterprise of this department, then the Sale price will be substituted regarding possible exceptions.
If the ratio (yield per unit) is specified for N ratio UOMs of the dish, then when opening a set from the goods card, the Sale amounts in the set will be recalculated for N ratio UOMs.
Set Contents
In the lower part of the Calculation window, there is a table in which the goods that are the set components are specified.
To be able to organize write-offs in StoreHouse, you should list all the set ingredients (goods and semi-finished products) and fill in the Gross column. All other columns are not used for write-offs and are used only for printing unified printed forms.
When working in StoreHouse 5, ONLY goods can be used in sets.
If you need to specify semi-finished products, you must first create an item for the semi-finished product.
To add a component to a set:
- Click in the table value area
- Press the Insert or ↓ key. You can also use the Add line context menu item or the Add line item of the Edit main menu item
- In the # column, the serial number of the sett component will be automatically set. Using the context menu, you can change the order of the components
- Position the cursor in the Product field and select the component to add from the list of goods.
The component can be selected as follows:
Option 1: Type a few letters from the name of the ingredient in the empty cell of the "Product" column and press the [Enter] key. The program will offer a list of products with a matching combination of letters, from which you can select the desired product.
The list displays the name of the product and the path to this product in the list of products - the name of the first and last group.
The drop-down list for selecting products can be replaced with a product search box. To do this, in the item "Environment settings" - "Design and windows" of the main menu item "Tools", set the setting "Open the object search form instead of the list".
Option 2: Click in an empty cell in the "Product" column. Click the button and double-click the required product from the Products dictionary that opens.
Option 3: use the product search in the product list. Position the cursor in the empty cell "Product" and press the key combination [Ctrl][Shift][F]. You can also use the Find product item of the main menu item "Edit"
Enter a part of the product name in the product search window that opens and click the [Search] button.
To reduce the list of displayed positions, check the boxes for which to search.
Position the cursor on the item to be added to the set and press the [Select] button.
The "Code" column will automatically contain the code of the selected product, assigned to it by the program during creation;
In the column "Unit. rev.» the unit of measurement of the goods will be automatically indicated, in which the "Calculation" flag is set in the goods card. If a component has several units of measure, you can select any of them from the list, then the Gross, Net and Output weights will be automatically recalculated in accordance with the coefficient of this unit of measure from the product card;
The order of filling in the columns Gross, Net, Output is determined based on the selected settings;
Gross - in this field, set the weight of the component to the bookmark rate before processing, i.e. "dirty weight" of the product. The column is required.
According to the "Gross" column, the component is written off and the cost of the kit is calculated.
If in the field "Unit. rev.» if NOT the base unit of measure of the product is selected, and the “Gross” field contains a quantity that, when converted into a base unit of measure, will be less than 0.0001, then if this quantity is saved, the system will display an error message.
%1 - in this column, specify the percentage change in the weight of the component after the first processing ("cold"). The value in this field will be set automatically if you specified it in the product card on the Extras tab. options. The entered value can be changed: a negative value - in case of a decrease in the weight of the component, a positive value - in case of an increase in weight. To automatically calculate the value in the %1 column, you can specify in the Net column the weight of the component after the first treatment;
Net - the weight of the component after the first processing, will be calculated automatically if you put a value in the %1 column. If you enter in this field the weight of the component after the first manual processing, the value in column %1 will be calculated automatically;
%2 - in this column, specify the percentage change in the weight of the component after the second treatment ("hot"). The value in this field will be set automatically if you specified it in the product card on the Extras tab. options. The entered value can be changed: negative value
Value - in case of a decrease in the weight of the component, positive - in the case of an increase in weight. You can specify in the Output column the weight of the component after the second processing, then the value in the %2 column will be calculated automatically;
Output - can be calculated automatically if you put a value in column %2. If you specify in this field the weight of the component after the second processing, the value in column %2 will be calculated automatically;
The order of filling in the columns Gross, Net, Output is determined based on the selected settings. If the flags "from net to gross" and "from output to net" are set, then the filling goes in the reverse order.
Manufacture - the flag set in this column means that the goods are produced at your enterprise. Those. a semi-finished product is used in the kit, when decommissioned, it will be “untwisted” to the ingredients. The flag is set automatically when adding a product associated with the kit. If the product is not required to be unwound to the ingredients when decommissioned, then uncheck the flag;
Bundle – this column automatically indicates a bundle if a bundle is indicated on the card of the selected product. If there is no associated kit, the field is left blank;
Amount w / n - the cost of the component excluding taxes. Calculated automatically using the FIFO method for receipt documents for the department specified in the "Department" field and on the date indicated in the "On the date" field of the "Calculation" area;
VAT – VAT amount of this component. Calculated automatically using the FIFO method for receipt documents for the department specified in the "Department" field and on the date indicated in the "On the date" field of the "Calculation" area;
NSP is the sum of the NSP of this component. Calculated automatically using the FIFO method for receipt documents for the department specified in the "Department" field and on the date indicated in the "On the date" field of the "Calculation" area;
Amount of VAT - the cost of the component, including taxes. As well as the cost of a w / n, it is calculated automatically according to the FIFO method according to receipt documents for the unit specified in the "Subdivision" field and on the date specified in the "On the date" field of the "Calculation" area;
Price w / n and w / n - the price of the component (excluding taxes and including taxes). Calculated automatically based on the amounts of the component and its quantity in the "Gross" column;
Base unit rev. (Name, Price w / n, Price w / n) - this group of columns displays information on the basic unit of measurement of the ingredient: name, price without taxes, price including taxes. The w/n price and the w/n price are calculated automatically using the FIFO method according to receipt documents for the unit specified in the "Subdivision" field and on the date specified in the "On the date" field of the "Calculation" area. Values can be changed, but will not be saved when closing the kit card;
VAT% - the tax rate of the base unit of measurement of the ingredient. Required to recalculate the cost of the kit when editing the prices of ingredients;
List all components of the kit and fill in the required fields;
Save the data entered into the set (the main menu item "Document" - "Save Document" or the button on the toolbar).
Only products can be components of a kit. If a product is added to a bundle that includes an editable bundle, it will not be possible to save it. When saving a set with such a product, the system will display a message.
If the ingredient was specified incorrectly during the process of filling in the kit composition, then the line can be replaced before saving the kit.
Position the cursor in the Product field on the line to be replaced.
Enter part of the name of the product to be replaced.
Select a product from the list.
This function is only available until the kit is saved. If changes need to be made in a saved set, then the line of the incorrectly entered product must be deleted and a line with the required product must be added.
Adding a semi-finished product
In the production in restaurants, cafes, canteens, etc., the concept of "semi-finished product" is used. A product that is prepared in advance by production and subsequently used in the production of ready-made meals or other semi-finished products.
When working in Store House V5, ONLY elements of the "Products" dictionary can be used in sets.
If you need to specify semi-finished products, you need to create not only a kit for the semi-finished product, but also the product itself associated with the kit.
For convenience and speed up work, you can first create sets for the necessary semi-finished products, and then create product cards based on the created sets.
Next, you need to decide on the rule for working with semi-finished products when writing off:
At the enterprise, when writing off, all semi-finished products are laid out to the ingredients. Those. semi-finished products are not stored on the leftovers and the ingredients are written off immediately
At the enterprise, “preparation of semi-finished products” takes place and the semi-finished products themselves are stored on the remains. Then, when writing off the sold dishes, the system will require the presence of ready-made semi-finished products on the balances
Combination of the first two methods
When adding a semi-finished product to a dish set, you need to decide on setting the “Produce” flag.
When adding a product associated with the kit to the kit, the "Produce" flag will be set automatically. If the semi-finished product is not required to be produced, the flag must be removed.
If the flag is set, then when writing off the main dish, the semi-finished product will be “untwisted” to the ingredients.
If the flag is unchecked, then when writing off the main dish, the system will search for the semi-finished product itself on the remainder.
You can set/uncheck the "Produce" flag for already written off sets, but the written off invoices will be automatically changed.
Product with the type "Calculation" included
To print flow charts or technical flow charts, users often want to indicate goods that do not need to be written off in the future when selling ready meals.
For example: a product such as Water. Often, water is not purchased for cooking, it is not delivered to subdivisions, but for the convenience of cooks, this product must be included in the printed forms of technological or technical and technological cards.
For such goods, the concept of "type of goods - costing" has been added. The product-calculation is added to the set itself according to the same rules as for a regular product.
When adding such a product to the set, the system will use this product to calculate the total output, print it, but will not participate in the write-off.
Goods with the "Calculation" type are displayed in the kit in blue font.
For this type of product, when used in the set, "% for d / c" is set to 0, because. this product should not participate in the distribution of the cost price in decommissioning.
Using an interchange group
To be able to write off the use of "Interchangeable goods" in the production of dishes or semi-finished products in their sets, you must specify groups of interchanges for goods with the possibility of replacement.
In the "Group of substitutions" field, select the group of substitutions from the drop-down list, which will be used when writing off this dish when using interchanges.
The selection of groups will contain only those groups that include the main ingredient of the kit.
For the "Modifier" set, interchangeable goods are not used when writing off. By default, the "Interchange group" column is hidden for the modifier kit.
If an interchange group was not specified for a product in a kit, or was specified, but it was changed or deleted, and kits with the “use interchanges” flag were created with this kit, then assigning / changing / deleting an interchange group for an item in the kit will not lead to a change already created invoices (the invoice recalculation procedure will not be called). If you want to apply the changes, deactivate and activate invoices.
Percentage for decommissioning
If the kit is used to generate the Decommissioning document, then for the convenience of generating the document in the kit, you can specify the percentage of cost distribution between the components of the kit. The indicated percentages will be automatically substituted in the decommissioning in the incoming part for the received ingredients.
The set percentages can be changed manually in the document. The service is intended only for specifying standard values.
The service is available from Store House version 5.105.365
Specify in front of each ingredient the % cost that will be used to allocate the cost in the decommissioning.
The total percentage cannot exceed 100%. The system will control the total percentage. If this value is exceeded, a message about exceeding the maximum percentage will be displayed.
When creating a new set, to simplify the work, 100% is added to the first line. The percentage can then be changed if necessary.
If the decompilation is not used in the enterprise, then you can leave 100% on the first line without making other changes.
Goods with the "Calculation" type do not participate in the formation of documents, so the percentage for decommissioning for them is 0.
Sets with the "Modifier" flag cannot be used when creating a Decommissioning document, so the "% for d/c" field is not available in such sets.
If the Store House sauna database was created on a version lower than 5.105.365, then when upgrading to version 5.105.365 or higher in the already created sets, “% for d / c” will be indicated in proportion to the number of ingredients in the set, excluding products with the “calculation” type.
You can automatically distribute the "% of the price of a / c" automatically according to two rules:
In proportion to the number of lines of ingredients in the set - 100% will be distributed among all lines of the set in the same proportion.
Items with type "Calculation" do not count the number of rows for distribution "% price d/c"
In proportion to the share of the cost of the ingredients in the kit - for each ingredient of the kit (except for products with the "Calculation" type), the percentage contribution of the cost to the total cost of the kit is calculated, the resulting percentages are substituted into the "% of the price d/k".
If the ingredients do not yet have a cost, you can enter the value manually before performing the automatic calculation of "% price d/c".
For automatic distribution "% price
d/k" use the corresponding item of the context menu /
Formation of the cost price in the kit
The cost price in the kit is by default calculated using the FIFO method.
You can also define another method for calculating the cost: by last receipt or by weighted average.
This setting is done in the SH.INI file.
Setting CmpCostType = 0 (1 or 2)
The setting is made on each user place of Store House V5.
If this item is not in the file, then add it.
[sh]
; How to calculate the cost price in a set (0-FIFO, 1-Last, 2-Remns)
CmpCostType = 0
When calculating the cost of ingredients, the entire gross quantity is taken into account. If the gross amount will be spent from several receipts, then all receipts will be taken into account in the cost price.
Example.
The base contains a semi-finished product. Bookmark rate 1000 gr. Ingredient consumption 2500gr. The cost price for the date for the division is calculated.
When using this semi-finished product in another set, the cost is 0 under the same conditions.
The reason for the discrepancy between the data is in the different amount of gross raw materials that will presumably be consumed when writing off the specified amount of the set bookmark rate.
Upon receipt of 1000 g of the semi-finished product, 2500 g of the ingredient will be written off.
Upon receipt of 1 portion of the finished dish, 30 g of the semi-finished product will be consumed, i.e. 75 gr of the original ingredient.
From the report "Movement of goods" we analyze the balances.
At the time of the report, the balance is 1500 gr. 500gr from the 1st invoice at 0 price and 1000gr at a price of 0.36.
At a consumption of 2500gr - the price will be taken from two invoices.
At an expense of 75 g - the price will be taken from the first invoice at 0 price.
Editing the prices of ingredients in the kit
In some cases, it may be necessary to obtain the cost of a set with goods that have not yet been in the enterprise. When working on new dishes, when changing recipes or pre-calculating banquets, you need information about the estimated cost of specific dishes with the ability to print this information.
In Store House V5, you can directly set the cost of the base unit of measure of the ingredient in the kit and get the estimated cost of the dish, taking into account this price.
The specified values are NOT STORED. After the kit is closed, the cost of ingredients will return to the calculated values.
To edit the price of an ingredient:
Position the cursor in the field "Basic unit. rev.» - “Price w/n” or “Price w/n”;
Enter the price for the BASIC unit. rev. ingredient;
Edit prices for all required ingredients;
If a product with the "produce" flag is used in the bundle, then, if necessary, also set the price for it manually;
Print the required layout;
After closing the package, the changes made will not be saved. The values will return to the calculated values.
The tax rate for the ingredient will be taken from the product card from the Purchase VAT field. If a subdivision for cost calculation is defined in the set and exceptions by enterprises are specified in the product, then VAT will be used from the exceptions. If the unit in the set is not specified or there are no exceptions, then the value will be taken from the "basic parameters".
Context menu items on kit ingredients
Up down
If the order of the ingredients in the set is important, and during the work the ingredients were specified in the wrong order, then use the Up/Down context menu items.
Up (or a combination of "hot keys" [Ctrl] + [Up]) raises the selected line one position up;
Down (or a combination of "hot keys" [Ctrl+[Down]) moves the selected line one position down.
Goods movement
This item opens the report "Product movement" to analyze the workflow for a specific product, on which the function from the set was called.
This report will help you analyze the cost of a particular ingredient if it is in doubt when calculating the cost of the kit.
Inclusion of goods in sets
This item opens the "Inclusion of goods in sets" report.
Story
This item opens the "Kit History" window when positioned on the "Calculation" tab.
Additional items for specific items may also be available in the context menu.
Product properties
This item is available when positioning in the "Product" field. This item is used to quickly open an ingredient product card for editing.
Kit properties
This item is available only for products, on the cards of which the connection with the kits is indicated. This item is used to quickly open a semi-finished product kit.
Groups of interchangeable goods
This item is available only when positioning in the "Interchange group" field. This item is used to quickly open the list of "Interchangeable Goods".
Filling in the "Technology" tab
Filling in the “Technology” tab is optional, it is necessary for printing a technological map or a technical and technological map and contains a description of the product manufacturing process.
The "Technology" tab is filled out for a specific period in one
kit version, because the description of the preparation technology depends on the ingredients of the kit. The version and period can be selected directly on the "Technology" tab. Also, the version and period can be selected on the “Calculation” tab, when you go to the “Technology” tab, the selected version and period will be filled.
On the "Technology" tab, information is entered in the form of text.
If you already have typed electronic text describing the preparation technology, then you can select the text in the electronic document and use the Copy (in the source file) and Paste (on the Technology tab) context menu items. You can also use the keyboard shortcut [Ctrl][C] and [Ctrl][V].
Filling in the bookmark "Calorie content"
On the "Calorie content" tab, the calorie content of the kit is calculated relative to the data from the cards of the product-ingredients of the kit.
The table is filled in automatically after the kit is saved, and its values cannot be changed.
The calculation takes place for all the ingredients of the kit. Semi-finished products are decomposed into ingredients, and the resulting ingredients are summed up. The number of ingredients for calculating calories is taken from the "Net" column.
The calculation of calorie content occurs for the quantity and unit of measurement of the norm of laying the set, without recalculation for 100 gr.
If the bookmark "1 serving" is indicated on the "Basic parameters" tab, then the calorie content is calculated for 1 serving. If the “Basic parameters” tab indicates the “1.5 kg” tab norm, then the calorie content is calculated for 1.5 kg.
Ingredients of semi-finished products, if the “Produce” flag is set, are taken from the period of the kit, which includes the date specified in the Date field of the Calculation kit area.
The values of the "Code", "Product" and "Output" fields are filled in in accordance with the values of the fields of the same name, filled in on the "Calculation" tab.
Values "Unit. rev.» is substituted from the cards of the corresponding goods from the "Units of measurement" tab. The calculation takes place in the unit of measurement, which has the "Calculation" flag.
If you change the unit of measurement of an ingredient product manually on the "Calculation" tab of the kit card, on the "Calorie content" tab, the unit of measurement will not change.
Values of the fields Proteins (gr), Fats (gr), Carb. (gr), Kcal are calculated relative to the values entered in the product card on the “Basic parameters” tab with the “calculate calorie content” flag set. The value of proteins, fats and carbohydrates are calculated for each ingredient relative to the amount entered in the "Net" column.
When using alcoholic products in the kit, the Kcal field takes into account the calorie content of alcohol calculated by the formula. The calculation also takes place according to the "Net" column.
When the table setting "Totals by table" is enabled, the values in each column are summed up.
The Period from and Version fields can be selected from the options created on the Costing tab. The values in the table will change according to the selected version and package period.
The table is not filled in when the "Modifier" flag is set on the "Main Parameters" tab. In this case, the following message is displayed on the "Calorie content" tab:
If there are kit attachments with multiple validity periods, then the calculation of the energy value will be made as follows:
Let, for example, the validity period from 01/01/1980 is set for the main set, the “to” field is not defined. The semi-finished product kit, which is part of the main kit, has two validity periods from 01/01/1980 to 12/31/16 and from 01/01/2017 the "to" field is not defined. With this option, the calculation of the energy value of the main set with a validity period from 01/01/1980 will be formed according to the energy value of the semi-finished product set with a validity period from 01/01/1980 to 12/31/16. To calculate the energy value of the main course for the last period of validity of the semi-finished product set, it is necessary to change the validity period of the main set.
Filling in the "Other" tab
The "Other" tab contains 7 tabs: Scope; Requirements for raw materials; Finished output; Foundation of production; Requirements for registration, implementation. and storage; Organoleptic indicators; Microbiological indicators.
Filling in the listed tabs is optional.
All the entered information is used to automatically fill in the unified form of the technical and technological map and its subsequent printing.
The “Other” tab is filled out for a specific period of one version of the kit selected on the “Calculation” tab, because Performance may vary depending on kit ingredients. The version and period can be selected directly on the "Other" tab. Also, the version and period can be selected on the "Calculation" tab, when you go to the "Other" tab, the selected version and period will be filled.
On tabs from the "Other" tab, information is entered in the form of text.
If you already have typed electronic text of all indicators for the “Other” tab, then you can select the text in the electronic document and use the context menu items
Copy (in the source file) and Paste (in the required tab of the "Other" tab group). You can also use the keyboard shortcut [Ctrl][C] and [Ctrl][V].
Period attributes tab
The "Period Attributes" tab contains a list of attributes created for a set period. These attributes can be used, for example, in printables when user information needs to change over periods of kit versions.
For example, in the layout of the Technical and technological map, predefined attributes of physical and chemical indicators are used.
Since the functionality has been added since version 5.62.255, the list of preset attributes of the set period may be empty if the Store House database was created earlier than the specified version.
In this case, the attributes must be created manually in the SDBMan.exe application. List of required attributes:
Component Detail tab
The “Detailing of components” tab contains detailed data on the component composition of the kit, listing the components included in the composition of semi-finished goods.
The "Level" field shows the nesting level of the component:
0 - specified for open kit components
1 - for goods components with the "Produce" flag of level "0"
2 - for components of goods with the "Produce" flag of level "1", etc.
The "Detailing of components" tab is filled in according to the Version and Period of the kit.
To determine the versions of sets of semi-finished products, if they differ by enterprises, select "Department" and "On the date" of the "Calculation" field.
Bookmark Allergens
The Allergens tab contains a list of allergens collected from the properties of the products used in the set.
The Allergens tab is filled in according to the Version and Period of the kit.
To define the versions and periods of semi-finished product sets, if they differ by site, select Division and As of the Date of the Settlement field.
Features of filling out the modifier kit card
Modifier sets are sets that change the main set of a dish when writing off the "Application" documents. A change can be either the addition of new ingredients or the deletion of ingredients when decommissioned. Also, a change will be an increase or decrease in any ingredient in quantitative or percentage terms.
In the application in the "Modifiers" area, only kits with the "Modifier" flag can be added.
Filling in the modifier kit:In the Name field, enter a name for the kit.
On the "Main parameters" tab, set the "Modifier" flag. This flag is set automatically for kits imported from R-Keeper.
For the "Modifier" set, interchangeable goods are not used when writing off. By default, the "Interchange group" column is hidden for the modifier kit.
Gross field - for the modifier in this field, you can set not only positive, but also negative values. Also, the values can be absolute and relative values, i.e. Gross can be indicated both in units of measurement of goods and as a percentage.
If any component is included in the standard set of goods, then by specifying a negative value for the modifier of this component, you will exclude it from write-off.
For example, the modifier is called "No sour cream". The modifier kit contains the only component "Sour cream", Gross "-10 g". When linking this modifier with the product "Salad", the component "Sour cream" 10 g will be excluded from the write-off.
For example, you can put a modifier called "Light salty" with a Gross value of "-50%" for the "Salt" component. When decommissioning the product with which this modifier kit is associated, the amount of the “Salt” component will decrease by 50%.
The Calorie tab is not populated.
The rest of the tabs can also be filled.