The Self-Cost (COGS) Types directory is required to set up COGS (cost of goods sold) import from Store House. Several COGS types are created if the restaurant uses several Store House databases.
Properties page of the Self-Cost Types directory.

Basic
Use in reports – if this flag is set, the cost type is used in the cube “Cube for reports on consumption”;
Allow overridings - this field is used for network objects when working with local prices;
Import Only – this flag means that manual input of values ​​is prohibited (only import from SH)
Local Prices - The value of this price type is stored and modified on the local reporting server, not on the directory server.
Commodity group – SH commodity group;
This field is required. If the name contains a space, the name should be separated with quotation marks.
Store House Config – settings for communication with Store House;
Warehouse Code – SH warehouse code;
Special Accounting Import – if this flag is set, then import from SH will be taken from Special Accounting;

Main 
Code – a unique code of a directory element in the system. It is assigned automatically, but can be changed manually;
Name – the name of the directory element;
Status – the status of the directory element;

Restrictions
Object privilege – restriction of access to an object.

Importing COGS from Store House

It is possible to import COGS data from Store House v4 into R-Keeper v7. To do this, use the Import Self-Cost Data from Store House pop-up menu operation. You can call this operation by selecting:

  • Menu Item;
  • category (highlighted in the Dish Categories directory);
  • menu group.

When you select a menu group, the COGS for all menu items in this group and menu item in nested menu groups will be imported.
When performing the Import Self-Cost from Store House operation, the cost price of goods for which there were no receipts will be equal to 0.00.

The calculation of the export cost in R-Keeper v.7 is based on either the most recent delivery of a dish or the latest deliveries of the component products used to prepare the dish.

Menu item cost import settings window:


ActiveOnly - whether to import cost for all items, or only for active ones;
CalculationDate – the date of cost calculation;
GroupCode – warehouse product group code – selection is made from a list that includes the values ​​of the parameter SH4 (SH5) Product group code;
Directory element - an element (including subelements and child elements) for which cost import should be performed;
Item Type – the item type for which the cost price will be imported;
SelfCostType – The COGS type for which the import is being performed.
Calculation method – accounting from the last delivery;
Warehouse Code – select a warehouse from the list to calculate the cost price (the list includes warehouse codes entered in the SH4 (SH5) Warehouse Code parameter);
TaxesInc – include taxes when calculating COGS;
To perform this operation correctly, it is necessary to configure the parameters of the group Installation Subgroups Store House 4 (SH5).

  • No labels