Exchange Production BOM

Exchange Production BOM Item Batch Job

To open this you have to goto Manufacturing --> Production Design --> Production BOM Item

You can use this batch job to replace items, which are no longer used in production BOMs. You can exchange an item, for example, with a new item or a new production BOM. You can create new versions while exchanging an item in the production BOMs. The program automatically generates these new versions.
You can determine what is used in the batch job by filling in the fields on the Options tab. Fill in the fields as follows

Options
Exchange Type: Enter what is to be exchanged here - Item or Production BOM.
Exchange No.: Enter the item number or the production BOM number, which is to be exchanged or click the AssistButton to the right of the field.
With Type: Enter your new selection that will replace what you selected in the Exchange Type field - Item or Production BOM.
With No.: Enter the new item number or production BOM number that should be filled in or click the AssistButton to the right of the field.
Create New Version: Place a check mark in the field if you want to make the exchange in a new version.
Multiply Qty. With: Enter the value of a quantity change here. If the quantity is to remain the same, enter 1 here. If you enter 2, the new quantities doubled in comparison with original quantity.
Starting Date: Enter the date from which these changes are to become valid.
Recertify: Place a check mark in the field if you want the production BOM to be certified after the change.
Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.

Item Picture Upload and Download

Item Picture Export and Import In Navision

To upload(Import) or Download(Export) in Navision you have follow following steps..

1. First up all you have to open an Item Card.
2. Then go to Item(Button)--> Picture.
3. Click on Picture(Button)
4. There 3 options will be there Import, Export and Delete
5. For Upload a picture to the Item card you have to select Import option, choose the path of the impage then press Ok.
6. For Download a picture to the Item card you have to select Export option, choose the path of the impage then press Ok.
7. For Delete an existing picture you have to select delete option.

Note: In the Navision you can upload impage with a format *.bmp.

Stockkeeping Units Setup

To Set Up Stockkeeping Units:
Open the Stockkeeping Unit Card window.
Fill in the fields on the card. The following fields are mandatory:
Item No.
Location Code and/or
Variant Code
After you have set up the first stockkeeping unit for an item, the program places a check mark in the Stockkeeping Unit Exists field on the Item Card.
Note
The information on the Stockkeeping Unit card has priority over the Item card.
To create several stockkeeping units for an item, use the Create Stockkeeping Unit batch job from Item Card-> Functions -> Create Stock Keeping Unit.

Stock Keeping Unit ( SKU )

What is Stock Keeping Unit ( SKU )?

Definition- SKU (stockkeeping unit, sometimes spelled "Sku") is an identification, usually alphanumeric, of a particular product that allows it to be tracked for inventory purposes. Typically, an SKU (pronounced with the individual letters or as SKYEW) is associated with any purchasable item in a store or catalog.

You can use stockkeeping units to record information about your items for a specific location and/or a specific variant code.

Stockkeeping units are a supplement to item cards, they do not replace them, although they are related to them. Stockkeeping units allow you to differentiate information about an item for a specific location (such as a warehouse or distribution center) or a specific variant (such as different shelf numbers and different replenishment information), for the same item.

It is important to note that the information on the Stockkeeping Unit card has priority over the Item card.

How to apply Exice entries while posting adjustment entries?

How to apply Exice entries while posting adjustments?
To apply the Excise entries you have to place a check mark in the Exice Entry field at the time of posting the Item Journal entries, then RG 23 A Part I gets updated but it does not update Part II.

Different Price Levels In Sales

Different Price Levels In Sales

For selecting different prices for an Item in the Sales Order you have to follow mainly 2 steps.

• Setting Sales Price in the Item Card
• Selecting price in the Sales Order
  

• Setting Sales Price in the Item Card

1. Open Item Card


2. Sales --> Prices. This is Sales Price window where, You enter the selling price per unit in the Unit Price field on the item card, but you may also need to set up some individual sales prices for items. You do this in the Sales Prices window, which you find by clicking Sales, Prices on the item card.
   In the Sales Prices window, you can specify the conditions that must be met before a customer can be offered an individual unit price for a specific item when quotes, orders, invoices and credit memos are set up. For example, the conditions can require that the customer is linked to a particular customer price group or the invoice is in a particular currency. They can also contain a starting date and an ending date, between which the sales price is valid, and they can contain a specific unit of measure code. You can also define a combination of the conditions under which the sales price applies. You can set up several sales prices for each item, but each must have a different set of conditions.
   Because a sales price is often a reduced price, you can specify in the Sales Price window whether you also want the program to combine line and invoice discounts when a sales price is offered.
   When you enter an item on an invoice, for example, the program automatically looks in the Sales Price table to see whether it contains a sales price for the item. If it does, the program checks whether the starting date has arrived and the ending date has not. If the conditions are met, the program will enter the sales price in the Unit Price field on the invoice. If not, the program will use the basic unit price from the item card.

For example view following picture..

• Selecting price in the Sales Order

1. Open Sales Order(Sales & Marketing--> Order Processing Orders)
2. Fill the header part as normal.
3. In the line part first enter an Item number & Quantity , then goto Functions -> Get Price... There you will get the Sales Price window just now we had updated.
4. Select the appropriate price line and press OK button to apply.

SQL Server - 2005 Reporting Services

what is SQL Server 2005 reporting service?

SQL Server Reporting Services is a comprehensive, server-based solution that enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft Business Intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.

Reporting Service Architecture:-

SQL Server Reporting Services supports a wide range of common data sources, such as OLE DB and Open Database Connectivity (ODBC), as well as multiple output formats such as familiar Web browsers and Microsoft Office System applications. Using Microsoft Visual Studio .NET and the Microsoft .NET Framework, developers can leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats, and deliver to a variety of devices.