Inventory Control & Features

Inventory Control & Features


From Highest Selling to lowest Selling Items

Microsoft Dynamics™ NAV e-Jewelry Software system will run your business in a completely graphical environment utilizing Microsoft® standards and open database connectively to interface with other industry financial software products such as Microsoft® Excel, Microsoft® Access, and others. As the jewelry industry evolves, long-term strategic planning and quick solutions are needed to compete in today’s high-tech marketplace. Why waste time using inefficient software programs that require time and effort to switch from sales to inventory and other functions, when e-Jewelry does it all for you in one complete and interactive package.

Inventory control and tracking are two of the main concerns of many companies. Keeping control of the raw material (diamonds, colored stones and mounting) is very important. Tracking the items that are being manufactured on the floor as well as outside vendors is critical. If you track your inventory by weight, or piece, e-Jewelry will be able to provide you with detailed information about your inventory.


  • Accurately record the receipt and usage of raw materials & all associated costing
  • Track individual finished good pieces by task or employee
  • Provide complete diamond lot tracking capabilities
  • Loose diamond inventory tracking
  • Product BOM configurator
  • Automatic or manual raw material consumption

Inventory Card

Microsoft Dynamics™ NAV e-Jewelry focuses on all the needs of the jewelry manufacturer/distributor from first order to final sales and from casting to payments. With the item cards and tabs related to every job and inventory, the complete history of each unique product can be traced. There are no “missing links” or excess paperwork. At a glance, you can change the weight or style of a piece still in the order process, put a piece in consignment, or locate an item on the manufacturing floor.
  • Metal type: items based on daily metal price of gold, platinum and silver
  • Master style and sub style tracking
  • Style components with individual costing
  • Diamonds with certificates
  • Multiple costing methods: LIFO, FIFO, Average, Standard, Specific
  • Bar code print out
  • Multiple location capability
  • Track finished goods, raw materials and loose stones
  • Track inventory by quantity, weight or pieces
  • Track inventory with bar code scanners
  • Track by lot numbers: If lot tracking is required, e-Jewelry will help you track down diamonds and colored stones by lots and provide you with a complete history of inventory consumption.

Inventory Features

Analysis Reports
Provide company decision-makers, especially those with overall responsibility for sales, purchases, and product portfolio management, with an efficient and flexible way to get meaningful information out of the system to inform day- to-day decisions. Built on item entries, this module provides a customizable, analytic view that enables people to add and combine analysis objects—customers, items, and vendors— according to their needs.
  • Present figures in both amounts and quantities and compare by periods as well as against budget. When the figures are put in a formula, they can become an indicator of the company’s performance.
  • Drill down to locate the cause of problems.
  • View sales dynamics; analyze inventory turnover; evaluate customers’ buying behavior; spot trends; reconsider product offerings, prices, and vendors; and make informed business decisions.
Alternative Vendors
Manage purchase of the same item from several different vendors. Set up alternative vendors for an item, specify typical lead times used by a specific vendor to deliver that item, and associate price and discount agreements for that item with each vendor.
Basic Inventory
Set up items that you carry in your stock and specify their unit of measures, costing method, inventory posting group, unit cost and price and other properties. Post item transactions, such as sales, purchase, and negative and positive adjustments from item journals. Quantity and cost records of the posted transactions are stored in the inventory ledger that is the basis for inventory valuation and other costing calculations. Integrated with General Ledger and with the posting processes in Sales and Receivables and Purchase and Payables, this module is required for the configuration of all other Inventory modules.
Organize your warehouse by assigning items to bins, the smallest unit in the warehouse logical structure. Bin assignment is done as according to the item journals or directly on the document lines (does not apply to order lines).
Cycle Counting
Manage cycle counting, a basic method of verifying inventory record data used to maintain and increase inventory accuracy. Set up cycle counting on the item or SKU level.
Item Budgets
Make sales and purchase budgets on the customer, vendor, and item levels, and in both amounts and quantities. Prepare and record a sales budget that can serve as input to decision-makers in other operational areas, such as purchasing and logistics. Decision-makers gain information about future expected demand that they can use for business discussions with the customers. After budgets are made, track the actual sales performance by means of calculating the variance. The ability to move budgeted figures between the system and Excel provides additional flexibility to the budgeting process.
Item Charges
Manage item charges. Include the value of additional cost components such as freight or insurance into the unit cost or unit price of an item.
Item Cross References
Quickly and precisely identify the items a customer is ordering on the basis of item numbers other than your own. Cross-reference information from customers, vendors, and manufacturers, as well as generic numbers, universal product codes (UPCs), and European article numbers (EANs) that can be stored and easily accessed.
Item Substitutions
Link items with the same or similar characteristics so that if a customer orders an item that is unavailable, you can offer substitute items and avoid losing the sale. Or, provide an extra service to your customer by offering lower-cost alternatives.
Item Tracking
Manage and track serial and lot numbers. Assign serial or lot numbers manually or automatically, and receive and ship multiple quantities with serial/lot numbers from a single order line entry.
Assembly Management
Specify a list of sellable items, raw materials, subassemblies and/ or resources as an Assembly Bill of Materials that comprises a finished item or a kit. Use assembly orders to replenish assembly items, to stock or capture the customer’s special requirements to the kit’s bill of materials directly from the sales quote, blanket, and order line in the assembly-to-order processes.
Location Transfers
Track inventory as it is moved from one location to another and account for the value of inventory in transit and at various locations.
Multiple Locations
Manage inventory in multiple locations that may represent a production plant, distribution centers, warehouses, show rooms, retail outlets and service cars.
Non-stock Items
Offer items to customers that are not part of your regular inventory but that you can order from the vendor or manufacturer on a one-off basis. Such items are registered as non-stock items but otherwise are treated like any other item.
Enable warehouse workers to create a pick from the released order. Pick is managed from a separate user interface when shipping items in an order-by-order environment.
Put Away
Enable warehouse workers to create a put away from the released order. Put Away is managed from a separate user interface when receiving items in an order-by-order environment.
Standard Cost Worksheet
Efficiently review and update standard costs with this worksheet. The Standard Cost Worksheet provides a company’s controllers with a reliable and efficient way to maintain accurate and up to-date inventory costs. Work with standard cost updates the same way you work with an Excel spreadsheet but within the framework of Microsoft Dynamics NAV. Because it provides an overview of the current standard costs, the worksheet is a convenient place to prepare for a cost update without the changes having an immediate effect in the system.
Stock Keeping Unit
Manage stock-keeping units (SKUs). Identical items with the same item number can be stored in different locations and managed individually at each location. Add cost prices, replenishment, manufacturing information, and so on, based on the location.
Warehouse Receipt
Enable warehouse workers to create a put-away from the receipt. Warehouse Receipt is managed from a separate user interface when receiving items in a multi-order environment.
Warehouse Shipment
Enable warehouse workers to create a pick from the shipment. Warehouse Shipment is managed from a separate user interface when shipping items in a multi-order environment.