Record how a material's units relate, such as 1 BOX = 100 EA, so SubBase can read invoices, quotes and receipts that arrive in a different unit from the one you order in.
Before you start
You need the Can edit material database permission to add, change or retire a conversion. By default that is Admins and Purchasers.
The tab is called Unit Conversions. Some companies see it as Units, with extra columns described below.
Steps
Open the menu at the top right, then click Material Database.
Click the material's row to open it.
Open the Unit Conversions tab.
Click Add conversion.
Enter a quantity and unit on the left, and what it equals on the right.
Choose the Kind.
Leave Supplier empty to apply it company-wide, or pick 1 vendor.
Click Add.
What happens next
The conversion appears as a sentence, such as 1 BOX = 100 EA, with a tag for its kind and a tag that reads Company-wide or the vendor's name. SubBase offers it when it asks a unit question about this material on an invoice or receipt.
SubBase also adds conversions on its own when someone answers those unit questions, so you may find some here that nobody typed in.
Pack size or price denominator
Pack size — converts quantity: the units hold different quantities. 1 BOX of 100 really is 100 EA.
Price denominator — converts price only: the vendor quotes a price per a bigger number of units, but you still receive the same quantity. It changes the money, never the quantity.
A vendor-specific conversion applies only to that vendor's documents. Use it when 1 supplier packs the item differently from everyone else.
Change or retire a conversion
Click the pencil on the row to change it. Saving retires the old conversion and records the corrected one.
Click the bin to retire it. SubBase asks Retire this conversion? before it goes.
A retired conversion is no longer offered on new invoices and receipts. Invoices already confirmed against it keep converting by it, and their lines show Unit conversion retired.
There is no button to bring a retired conversion back. To use it again, add it again.
If your tab is called Units
The tab also lists Units ordered in: each unit this material has been ordered in, with Lines, Qty ordered and Last ordered, and prices if your role can see them.
In default unit shows how that unit converts to the material's default unit. No conversion means there is none yet, and Add next to it opens the form.
Make default makes that unit the material's default. New lines start in it, and existing orders, requests and stock keep their own units.
Changing the default recalculates last, average and lowest price from lines in the new unit. If nobody has ordered in that unit, those prices are empty until someone does. They are not converted from the old unit.
Best practices
Add a conversion instead of a second material when you buy the same item in another unit. A second material splits your price history across both.
Choose Price denominator when only the price is quoted per 100 or per 1,000. A pack size there would multiply the quantity on the invoice as well as the price.
Correct a wrong conversion with the pencil rather than adding a second one beside it. Editing retires the old one, so only the corrected factor is offered from then on.
If this doesn't work
Start a chat from the Messenger in the bottom-left of this page, or email [email protected]. Include the order or project number and what you expected to happen.
