Infusion Knowledge Base

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    Product Ratios

    ​Product ratios allow products to be purchased in bulk then receipted and sold individually. Stock is ordered in units containing multiple quantities of an item, and the ratio multiplies stock levels on products to reflect that more than one item has been ordered and received.

    For example, a box of chocolate bars has ten bars and is purchased by the box. The ratio is recorded as ten. When an order is placed to the supplier, a quantity of one box is ordered. When it is receipted into stock, the product stock level increases by ten.

    If a product includes only one item and increases the stock levels by one, the ratio is one. 

    You can add a product ratio on the suppliers tab from within a product, or directly onto a purchase order. 

    Add a product ratio on the product's Suppliers tab

    Go to Products > [Specific product] Suppliers tab and select +Add. 

    The New Supplier window opens.

    Complete the fields with the Supplier details. Select Use as preferred supplier if this is the main supplier the product will be purchased from. 

    Enter the pricing information for the product.

    • Latest Cost: this is the complete cost to purchase the quantity of items.
    • Ratio: the number of items in the unit (required field).
    • Units: how the product is received (such as in a box, mtrs, ea, kgs and so on).
    • Lead Time (Days): enter if required.

    Save to complete. The supplier and ratios are added to the product. Continue to add more suppliers if required.  

    Edit a product ratio on the Suppliers tab

    Within the Supplier tab, select the pencil beside the supplier to open the Supplier window. Make changes as required and select Save.

    Add or edit a product ratio on a purchase order 

    When you create a purchase order, you can add or edit ratios against the product. If you have already created a purchase order, open the record and select Edit in the taskbar to edit the details.

    Adding or editing a product ratio on a purchase order only applies to the specific purchase order, and does not update the original product record. For a product ratio to be included every time a product is purchased, you need to add the product ratio on the Product record in the Suppliers tab (see above for how to do this).

    Untick the Compact View checkbox to show all fields. Ratio, Supplier Unit, and Unit Cost ($) fields can be completed or edited. Select anywhere on the product line to edit the available fields. As you edit the fields, the details will update on the product line. 

    Select Close and then select Save in the taskbar and your edited ratio will be saved.

    Was this article helpful?

    Still can't find what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Powered by