A Sales Item, or a 'Sell Only' Item, is an item you are going to sell to a Customer but are not going to enter in your POS system. It may be something such as consulting services or rental of equipment. It is an item that you will add to an AR Invoice and send to your customers for payment.
Create a Sales Item
Sales Items can be created using the following methods in R365:
- Manually - Hover over the 'Item' menu in the top ribbon and then the 'Setup' sub-menu and select 'New Sales Item'
- An Existing Purchased Item - Check the 'Available in AR Invoice' checkbox on the Purchased Item record to display the 'Sales' tab on the Purchased Item. Complete all the required fields on the 'Sales' tab, and then the Item will be available for use on the AR Invoice
- Copying from an existing Sales Item - Use the 'Copy' option found in the 'Save' menu of an existing Sales Item
- Via the Import Tool - Items can be added to a template and imported into R365 in bulk
This article will detail each piece of the Sales Item record and how you can get the most out of this powerful feature in the R365 AR Module.
As Sales Item records are created, be sure to save periodically to protect your data.
In addition to saving, Users can 'Copy' an Item to create a duplicate of the existing Sales Item record in a new tab. Copied Sales Items will prepend '[COPY]' to the Sales Item Name.
All relevant Sales Item information will be copied over to the new record.
- Note: Transactions information will not be copied.
1) Name - The Name of the Sales Item
2) Type - The Type is set automatically to 'Sell Only'. This cannot be changed
3) Measure Type - This will identify the manner in which this item is measured throughout the system (Vendor Items, Item Locations, Recipe, and Inventory Transactions). Once set, Units of Measure can then be assigned. Ensure that the Measure Type is entered correctly because once the Item record is saved, the Measure Type will be locked and unchangeable. However, copying this item record will enable the Measure Type to be editable. These types include:
- Note: To connect different Measure Types, you must set an equivalency since equivalencies will not be automatically created
4) Number - A number for the Sales Item. Numbers are optional and can be used for sorting purposes
5) Description - A Description for the Sales Item. Descriptions are optional and can be used for sorting purposes
6) Active - This box is checked by Default and signifies that the Item is Active. Uncheck this box to deactivate the Sales Item
7) Actual as Theoretical - When checked, the Actual usage will be used in place of the Theoretical usage for calculations on the AvT Report. When unchecked (default), the Theoretical Usage will be used as expected.
8) Commissary Item - When checked, the Sales Item will also be a Commissary Item. Click here for more information on Commissary Items
9) Available in AR Invoice - When checked, this allows the Sales Item to be selected on the AR Invoice and AR Credit Memo forms. This is checked by default
10) Catering Item - When checked, the Sales Item will also be a Catering Item and the 'Catering' tab will appear where Catering specific settings are required. Click here for more information on Catering Items
1) Selling U of M - The Selling U of M. This will be automatically set when selling the Item on an AR Invoice
2) Price Type - The Price Type. Depending on the selection, #3 will be updated to reflect the type
- Set $ Amount - Enter a set dollar amount in the 'Price (selling)' (#3) field for the selling price of the Sales Item. Each time the Sales Item is added to an AR Invoice or Commissary Order, it will use the set price
- Cost % Markup - Enter a Markup Percent for the sales price of the Item. This option should only be used on Purchased Items that are also set as AR Sales Items or Commissary Items, as the Inventory Cost is set on the Purchased Item record and can therefore be used to calculate the Cost % Markup value. When properly used, the Inventory Cost value will be multiplied by the Markup Percent value, then added to the Inventory Cost value to get the Selling Price. For example: Inventory Cost = $100, Cost % Markup = 15%, Selling Price = (100 * .15) + 100 = $115
3) Price - This value is used in conjunction with the 'Price Type' option and is described above
4) Commissary Category - Select a Commissary Category for the Sales Item for Sales Items that will be used with the Commissary feature
5) Sales Account - Select the Sales Account where the Sale of the Item will be recorded
6) Taxable - Check this box if the Sales Item should be considered Taxable. This setting will override the 'Taxable' setting set on the Customer record. When checked, the 'Tax' checkbox will be checked on the AR Invoice form during Item entry. Taxable Items will be calculated against the set Tax Rate on the AR Invoice
This tab will contain each Transaction that has used the Sales Item. Existing Sales Items can be viewed in the 'Sales Items' list of the 'Accounts Receivable' subsection in the Accounting module or in the 'Items' list in the 'Inventory' subsection of the Operations module.