Good day! I broke my head, I can’t make a formula for calculating the required quantity of goods for correction. The essence is as follows: there are two types of goods - piece and boxed. Can be sold and those and others. If a piece commodity is credited, then the boxed item will go to “-”, if a boxed item has been taken, then the piecework will have a negative balance. For example, the juice “I” in a box of 6 pieces each has an article number of 111,000. One pack of the same juice has an article number of 222,000. 6 packs of juice were sold, respectively, the remainder of article 222,000 will be “-5”, and article 111,000 will remain unchanged. Need a formula that would put the correct amount in the correction of the goods, ie the article 111000 corrected on "-1", and the article 222000 on "+6". By the way, there are about 1500 articles of such products, the multiplicity of packaging is different everywhere (beer, soft drinks, water, etc.), so it’s very difficult to manually find the number for correction. The basis is the EXCEL file, where the code of the boxed goods is registered opposite the code of each piece article.

    1 answer 1

    If you actually have the same nomenclature with different articles, then you will have to do a complete set / disassembly of the nomenclature in accordance with the costs for each movement.

    That's right (conveniently, if you want) to consider such positions as one nomenclature with different units of measure, for which the multiplicity is prescribed. Each item has a basic unit of measurement (usually the smallest, for example, pieces), which takes into account any movement. When moving in other units, automatic conversion to the base unit of measurement should be carried out.

    What is written in Excel is good, we must now take this into account in your system.

    The use of several articles (bar codes) is justified from all sides and true and convenient, however these packages can be different only for storekeepers and logistics, in the warehouse (and boo) accounting the nomenclature should be one.