IM-1007 Unit of Measure Conversion Factor with Six Decimals
Allows for six decimal places in the Unit of Measure Conversion factor in Product Line Maintenance and in I/M Maintenance for the Sales and Purchase Units of Measure The Inventory Item Listing will show the Sales and Purchase Unit of Measure Conversion Factors to six decimals.
IM-1008 Inventory Reports Not To Choose Zeros
Adds the following options to the Inventory Reorder report: exclude items having a Recommended Order Quantity of zero; exclude items with both a Recommended Order Quantity and On-Hand Quantity equal to zero; exclude items within a warehouse that have a zero in all the following columns: On Hand, On P/O, On S/O, On B/O, Avail, Reorder Point, Min Order, Econ Order, Max On Hand, Recom Order and Purch Qty. Also added is the option not to print lines with all zeros on the Inventory Trial Balance.
IM-1011 I/M Transaction Entry Import Utility
Imports Inventory Transaction data from an ASCII data file directly into the MAS 90 MAS 200 Inventory Transaction files for Sales, Issues, Transfers, Receipts and Adjustments. It also imports Physical Count records into the Physical Inventory file. The record format required for the import file is included on the last pages of this manual.
IM-1030 Valuation Report With Summary Option
Adds a Summary Option to existing Inventory Valuation Report.
IM-1038 Alternate Unit Of Measure
Adds an Alternate Unit of Measure (AUM), and Alternate Unit of Measure Factor (AUMF) to Product Line Maintenance and Item Maintenance.
IM-1042 Customer Specific Item Numbers
Adds an option to the Inventory Maintenance screen for Customer Specific Item Number Maintenance. An Alternate Part Number, two Sales Unit of Measures, two Alternate Selling Prices and four User Defined Fields may be maintained by Customer Number and (if desired) S/O Ship To Code. All of the fields are available to print on Sales Orders, Sales Order Picking Sheets and Sales Order Invoices.
IM-1046 Warehouse/Company Merge Utility
Creates a new utility that allows a range of item numbers to be merged from one warehouse to another, either within the same Company Code or across Company Codes.
IM-1047 Inventory Commitments To A Job
Provides the ability to track commitments of an item to a job by warehouse.
IM-1049 Vendor Rebates
Allows Vendor Rebates to be set up and maintained for Item Number/Customer combinations. A report can be generated that reflects rebate information and totals by Invoice.
IM-1050 Price List by Price Level
Produces an Inventory Price List report showing item pricing by price level. The report will print Standard Price information and up to five additional Price levels, or will print up to six Price levels without printing the Standard Price information.
IM-1055 Calculate Standard Price From Vendor Price
Adds the ability to calculate an item's Standard Price from the ‘Vendor Price’ (value held in Category 3 field). Three utilities have also been provided to ‘Change Conversion Rate’ for a range of Product Lines, ‘Recalculate Standard Price’ for a range of Product Lines, and ‘Recalculate Standard Cost’ for a range of Product Lines.
IM-1059 Lot/Serial Information To Job Cost Detail
Changes the way Inventory Issues post to Job Cost, to Post in Detail by Lot/Serial Number.
IM-1060 Last Cost by Warehouse
An item’s Last Cost, updated through Inventory Transactions and Purchase Order Receipts, will be retained by warehouse. This Extended Solution now also records Last Costs by Warehouse from I/M Transfers. Inventory Maintenance and Inquiry will display the Last Cost By Warehouse on the Quantity On Hand and Reorder Data screens.
IM-1063 Detail Transaction Report with Lot/Serial Number Range
Adds the ability to select a range of Lot/Serial Numbers (Lot or Serial depending on the item’s valuation method) during Inventory Maintenance Transaction Detail Inquiry, Inventory Inquiry Transaction Detail, and for the Detail Transaction report.
IM-1069 Contract Pricing By Valid Date
Adds three additional options for Customer/Date, Price Level/Date, and Customer/Price Level/Date to Inventory Item Pricing. Sales Orders and Sales Order Invoices will check for this new pricing method and, if a match is found, will substitute this pricing method over the MAS 90 MAS 200 standard pricing method.
IM-1088 User Defined Fields For Warehouses
Creates 30 new User Defined Fields for each I/M Warehouse Code.
IM-1089 Sales History Report Enhancement
Modifies the Inventory Sales History Report to print Year-To-Date Total Quantity, Total Dollars, Total Profits and Total Profit Percent. A ‘super sort’ by Salesperson is available.
IM-1090 Extended Item Information Posting to Job Cost
When used in conjunction with the Sage Software Extended Solution JC-1009: Full Item Descriptions, causes the Inventory Transaction Item Number, Description and Header Comment to be updated to JC-1009. This allows them to be printed on Job Cost Invoices and various reports. Refer to the JC-1009 manual for information regarding which reports are affected.
IM-1097 Additional Pricing Tiers for Item Pricing
Adds new tiers, for a total of 20 tiers, to Customer and Item Pricing and Price Codes. Each tier can be based on a Unit Price or Flat Fee pricing method. Optionally, you may associate a standard comment line with each pricing tier and have that comment automatically added to a Sales Orders or Sales Order Invoice.
IM-1099 User Defined Fields In Product Line Maintenance
Creates up to 30 User Defined Fields (UDFs) for Product Line Maintenance.
IM-1111 Security For Inventory Inquiry
Adds security to the Inventory Inquiry Screen, I/M Detailed Sales History Inquiry Option, and Purchase Order Inquiry from Inventory Inquiry. The security prevents the user from entering certain options and seeing cost or vendor information.
IM-1114 Expanded Numeric Mask For Price/Cost/Quantity
This Extended Solution ships as part of DP-1000. Please see DP-1000 for pricing.
IM-1115 Six Decimal Precision For Inventory
This Extended Solution ships as part of DP-1000. Please see DP-1000 for pricing.
IM-1119 'Physical Count' Entry By Ticket Number
Adds data entry options for ‘Ticket Number Entry’ to the Inventory Management Physical Count process for all valuation methods, except Lot and Serial Number. Multiple item records may now be entered for each ‘Ticket’ Number. You can specify in Setup which Unit of Measure you wish to use for the counting process.
IM-1124 Transaction Detail Purge by Item Range
Adds an Item Number range to Period End’s Transaction Detail File Purge.
IM-1126 Line Duplication In Receipt Entry
Adds the ability to duplicate information from a preceding line during Inventory Receipt Entry.
IM-1135 Instant Item Description Key Word Search
Extended Solution to the Inventory Management, Sales Order and Purchase Order modules: adds the Quantity Available column and additional search capability to Inventory Item Lookup. And from the Sales Order Inquiry Menu: ‘Key Word Search into Standard Pricing’ and ‘Key Word Search into Customer Pricing.’
IM-1137 Always Taxable Item Designation
Adds the ability to make an Inventory Item always taxable regardless of the Customer’s Tax Exempt status.
IM-1146 Item Listing With Warehouse Designation
Provides two alternatives to the listing for the Item Number lookup I/M Maintenance and Inquiry, Sales Order and S/O Invoice Entry. You can have a listing with one item number, and a quantity available column which uses data from the item’s default warehouse, or you can have an expanded list which displays one row per Item/Warehouse and shows a quantity available in that warehouse.
IM-1153 Reorder Information Recalculation Utility
Adds a utility for recalculating the Minimum Order Quantity, Reorder Point and the Maximum On Hand Quantity for each item based on the item’s Average Monthly Usage. The Average Monthly Usage (AMU) is calculated as Sales (including returns), Issues and Transfers of an Item within a warehouse over a specified period. Any item which had reorder information changed as a result of the recalculation process will have its reorder information written to the log file.
IM-1154 Security by Warehouse
Adds security by warehouse to Bill Of Materials, Inventory Management, Purchase Order and Sales Order. Users without clearance will not be allowed to enter Warehouse Codes in various Reports, Inquiry and Data Entry Screens. You may choose if users should be included or excluded in the Setup for this Extended Solution.
IM-1161 Item Cost Change Utility
Adds the Item Cost Change Utility for inventory items with a FIFO/LIFO/Lot/Serial number valuation method.
IM-1163 Inventory Maintenance Defaults
Adds several new Setup options. You may choose to default the Unit Cost to the Item’s Standard Cost during Inventory Receipt and Adjustment Transaction Entry, and enter in an override Unit Cost for negative quantity Issues on Lot/Serial Items during Issue Entry.
IM-1179 Item Pricing Lookup By Price Level
Adds ‘Item Price Lookup’ to the I/M Main Menu. This Extended Solution is also compatible with IM-1135, Instant Item Description Key Word Search.
IM-1191 User Defined Fields for Lot/Serial (Obsolete)
This product was replaced with CM-1003 and CM-1020 at version 4.10. Click here if you owned IM-1191 previously and require data conversion information.
IM-1196 Open Order Display of Lot Valued Item
Adds Open Order Lot/Serial Distribution Inquiry to the ‘Main’ and ‘Cost Detail’ tabs in I/M Inquiry and I/M Maintenance.
IM-1197 Pricing Records With Range Of Dollars
Adds a ‘Dollar Ranges’ flag to pricing records to indicate whether a record is to be read as ranges of dollar amounts or, in the standard manner, ranges of quantities.
IM-1199 Cost Code/Cost Type by Item Number
Adds the ability to create an association between Inventory and non-Inventory Items and a Job Cost Code/Cost Type. Each Inventory/non-Inventory Item can be assigned one associated Cost Code/Cost Type. These values will default into the appropriate fields during Inventory Transaction Entry and Purchase Order Entry.
IM-1200 Enhanced Warehouse Transfer Functionality
Changes the I/M Transaction Register Update to copy the Bin Location of the ‘From’ Item Warehouse to the ‘To’ Item Warehouse.
IM-1203 Extended Description Display in I/M Inquiry
Adds an expanded display of an item’s description to Inventory Inquiry. The word ‘Description’ will be removed. Two lines of text (40 characters each) will display the first 80 characters of the item description. The Extended Description button will still be available for normal display of the item’s entire description.
IM-1205 Batch Processing for I/M Transaction Entry
Adds Batch Processing in Inventory Transaction Entry for all Transaction Types.This Extended Solution is not compatible with IM-1113: Batch Processing of Inventory Transaction Entry.
IM-1206 Alternate Mask for Base Commission
Allows you to select the number of decimals in the Base Commission field.
IM-1208 Customer Price Record Copy Utility
Creates a utility that copies one Customer’s Item Pricing records into other Customers Item Pricing records.
IM-1209 Lot Number Change During Warehouse Transfer
Allows you to change an existing Lot Number during a Warehouse transfer via a new I/M Transaction type called ‘Lot Transfer.’
IM-1210 Virtual Warehouse
Allows you to specify virtual MAS90 warehouses and associate them with a physical warehouse. Sales Order and Purchase Order entry have been modified to check that only warehouses associated with a single physical warehouse are referenced on the lines.
IM-1211 Credit Account by Line in I/M Transaction Receipts
Adds the ability to specify a G/L Account number on each Transaction line for the Credit posting during I/M Transaction Receipts.
IM-1212 Item Pricing by Customer/Ship To/Warehouse
Adds a new Item Pricing option: by Customer/Ship To Code/Warehouse.
IM-1214 Item Memo Pop-up in SO and PO
Adds the ability to specify certain I/M Memos to pop up during Purchase Order and/or Sales Order line entry.
IM-1215 Additional Amount Field in Item/Price Code Pricing
Modifies Inventory Price Code Pricing and Inventory Item Pricing by allowing the user to add an additional dollar amount to the calculated Unit Price for certain Pricing Methods.
IM-1217 Additional Pricing Methods in Item Pricing
Adds a new Pricing Method ‘% Markup of Avg Cost.’ to I/M Item Pricing.
IM-1220 Apparel Matrix for Inventory and Sales Order
Enables you to specify an item as a ‘Master’ Item and to setup a list of ‘Associated’ Items for each Master Item. During Sales Order Entry, as you key in a Master Item, a list of all of its Associated Items will pop up. You can browse this list, filling in quantities to order for each of the Associated Items. As you exit this window, Sales Order lines will be populated with the selected items in the window and the appropriate order quantity.
IM-1222 Enhanced Detailed Transaction Inquiry
Modifies Detailed Sales History Transaction Inquiry, Detailed Receipt History Transaction Inquiry and Detailed Quantity History Transaction Inquiry in Item Maintenance and Item Inquiry for NON-LOT/SERIAL valued items only.
IM-1224 Item Pricing by Delivery Code
Adds two new Pricing Options: Item/Delivery Code Pricing and Customer/Delivery Code Pricing.
IM-1225 I/M Inquiry Display of Avg Cost by Warehouse
The Inventory Management module modifies Inventory Inquiry to display the ‘Current Average Cost per WHS’ in the warehouse quantity recap box.
IM-1226 I/M Transfers With Additional Costs
Add an Additional Cost field and a G/L Account Number field to the lines tab of I/M Transaction Transfers. You can add costs to Items as they are transferred from one Warehouse to another. and specify the G/L account that will hold the difference.
IM-1227 Lot and Serial Number Search and Inquiry
Adds a lookup to I/M Maintenance and Inquiry. This lookup allows you to search for an item number by an on file serial number and will display data relating to quantities, costing and receipt date for that serial number.
IM-1228 Fractional Quantity Entry in Item Pricing Maint.
Modifies the From Quantity and To Quantity fields in Item Pricing Maintenance to allow for fractional quantity entry.
IM-1229 Enhanced Item Vendors Maintenance
Change the way the entries are displayed in I/M Vendor Maintenance. Entries are sorted by Warranty Code/Landed Cost and Vendor Name.
IM-1231 Production Scheduling Report
Add a new Production Scheduling Report to the Inventory Reports menu.
IM-1232 I/M Transaction Issue to Display Cost Extension
Make the Extension Field display during I/M Transaction Issue Entry.
IM-1235 Quantity Required For Bill Of Materials
Uses Item Warehouse Detail `Quantity Required For WO` field to store `Quantity Required for BM` for all Standard or Kit type Bills referenced on Sales Orders. These Component quantities will subtract from `Qty on Hand` in `Qty Available` calculation.
IM-1236 Alias Item Search in Inventory
Adds the Alias Item Search to Inventory Maintenance and Inquiry.
IM-1237 UPC Code Creation
Adds a UPC Maintenance/Inquiry to Inventory Maintenance and Inquiry.
IM-1238 Enhanced Inventory Inquiry Tab
Makes the following changes to the Inquiry tab of the Inventory Maintenance screen: • Adds the P/O Header Comment to the P/O Inquiry • The Sales Order header ‘Ship Date’ replaces the ‘Order Date’ column on the S/O Inquiry The Work Order Comment + the Work Order’s Release Date replaces the CustNo/Step No and Due Date columns.
IM-1239 Royalty Calculation and Maintenance
Adds Royalty Maintenance to the I/M Setup menu, a Royalty Percent field to Item Vendors Maintenance, a Royalty Edit Maintenance feature to AP Setup, and a Royalty Purge Utility to the A/P Period End menu. Available in 4.10.
IM-1241 Unique Serial Numbers per Item
Checks for use of a Serial Number in all Warehouses (rather than just the warehouse the Item is being received into) when Serial Numbers are received in Purchase Order Receipt Entry and I/M Receipt Entry.
IM-1242 I/M Inquiry to Display Many Warehouses
Expands the I/M Inquiry window to display more warehouses and their quantities in a separate list box. This list box contains some alternate columns and uses an alternate calculation of Quantity Available.
IM-1244 Inactive Item Designation
Allows you to designate certain items as ‘inactive’ by means of a check-box type Inventory Item Custom Office UDF. Sales Order Entry, Sales Order Invoice Entry, Purchase Order Entry, P/O Receipt of Goods Entry, P/O Return of Goods Entry, and I/M Transaction Entry will all be modified to disallow entry of Items that have a checked ‘inactive’ UDF.
IM-1245 Enhanced CM-1003 Lot/Serial UDFs
Further enhances CM-1003, Lot and Serial User Defined Fields for Distribution by allowing the user to restrict the Validation values by Vendor in Purchase Order Receipt Entry.
IM-1249 Warehouse Item Sales History File for Orders
The Inventory module when enabled will write to a new multi-keyed file during sales order entry. Custom Office is required. The described feature was developed for a specific client to its specifications and may not conform to generally accepted MAS 90 MAS 200 standards and procedures. These features may or may not benefit you in your application of MAS 90 MAS 200.
IM-1250 Enhanced Physical Count
Will modify freezing to take a picture of the Quantity Available rather than the Quantity On Hand.
IM-1251 Kit Pricing Equals Sum of Components Retail Price
Recalculates the standard price on Kit items (either an Inventory Sales Kit or a Kit Type Bill of Material) when the retail price on a component item changes.
IM-1252 Price Letter Report for IM-1069
Adds a Price Letter Report to the Library Master Report Manager. Suitable for distribution to Customers, it provides a listing of Inventory Items and prices for which that Customer has ‘Customer/Date’ contract pricing records. *IM-1069: Contract Pricing By Valid Date must be enabled in order for this to function.
IM-1255 Historical Stock Status Report
Adds a Historical Stock Status report to the IM Reports menu.
IM-1256 Reorder Report with Purchase Order Detail
Modifies the Inventory Reorder Report to • reflect Purchase Order Detail when the Purchase Order Quantity is greater than zero • include On Purchase Order and On Work Order quantities in the Qty Available for reorder calculation when the Inventory Option Include in Qty Available is set to ‘No PO’s and WO’s’
IM-1259 I/M Inquiry to Toggle Display of P/O's On Hold
Adds a checkbox option to the Inquiry tab of I/M Maintenance and I/M Inquiry allowing you to chose whether to include data for Purchase Orders that are on hold.
IM-1261 Alternate Calculation of Cost Markup %
Changes the calculation of the I/M Item Pricing, Price Method ‘Cost Markup percent’ to be [unit cost divided by (one minus the percentage entered)].
IM-1262 Item Pricing Purge Utility
Adds an Item Pricing Purge Utility to the Inventory Management module.
IM-1263 Vendor Quote Maintenance
Creates a single screen view of various Inventory Item related data currently found in I/M Maintenance, P/O Receipt History and A/R Invoice History. It also adds a place to record and maintain Vendor quotes.
IM-1264 Multiple Same Components in I/M Sales Kits
Allows an item to be entered multiple times in Inventory Sales Kit Maintenance.
IM-1269 I/M Valuation Report with Lot/Serial UDFs
Modifies the Inventory Management Valuation Report to print up to four specified CM-1003, Lot Serial User Defined Fields on the report.
IM-1270 Enhanced I/M Transactions Tab
Replaces the Lot/Serial number field with the Customer Number and Sales Order number fields from Invoice History when available for Sales Order transactions.
IM-1271 Serialized Items with Average Costs
Allows serial valued Inventory items to be received into and relieved from the inventory transaction file at average cost. They will have their distribution tier cost set to zero.
IM-1272 Average Cost Display for Kit Items
Displays the average cost of Items with the product type of Kit in the Avg Cost field on the Main tab of Inventory Maintenance/Inquiry.
IM-1273 Vendor Last Purchase Inquiry
Inquiry into the Item Vendor file from Inventory Maintenance and Inventory Inquiry screens. The last purchase information will be displayed for each vendor. The Last Purchase Cost is calculated as the Last Cost minus the Allocated Cost.
IM-1276 Qty On Hand Check for I/M Transfer & P/O Return
Produces a warning that prevents a transfer or a return of a quantity that is not on hand in the warehouse in I/M Transactions Transfers and Purchase Order Return of Goods.