Advertisements

Image Analysis feature in Dynamics NAV 2018

In Dynamics NAV 2018, the Image Analyzer extension uses the Computer Vision API to analyze images that are attached to contact persons and items.

For example, this is useful for items because it lets you build up a stockpile of metadata about what you sell and use it to fine-tune search results when someone is browsing your web shop.

Image Analyzer is free in Dynamics NAV, but there is a limit to the number of items that you can analyze during a certain period of time. By default, you can analyze 100 images per month.

After you enable the extension, Image Analyzer runs each time you import an image to an item or contact person. You will see the attributes, confidence level, and details right away, and can decide what to do with each attribute. If you imported images before you enabled the Image Analyzer extension, you must go to the item or contact cards and choose the Analyze Picture action.

Requirements

There are a few requirements for the images:

  • Image formats: JPEG, PNG, GIF, BMP
  • Maximum file size: Less than 4 MB
  • Image dimensions: Greater than 50 x 50 pixels

How to enable Image Analyzer

To enable the Image Analyzer extension, do one of the following:

Method-1 : Open an item or contact card. In the notification bar, choose Analyze Images, and then follow the steps in the assisted setup guide.

 

IA-1

This will launch Image Analyser assisted setup guide, follow the step.

 

IA-2

IA-3

IA-4

Once you are done It will import your image for Analysing.

IA-5

 

Method-2 : Access the Service Connections, and then choose Image Analysis Setup.

IA-5.1

Choose the Enable Image Analyzer check box, and then complete the steps in the assisted setup guide.

IA-5.2

For URL and Key follow these steps:

Click on Computer Vision API Documentation

IA-6

Click on Try Computer Vision API

IA-7

Select your API Computer Vision API and then Get API Key

IA-8

Agree to T & C select your Country/Region and then Next

IA-9

Sign-In with the preferred account sign-in method

IA-10

Once done you will land on page which will have your Endpoint URL and Key

You must add /analyze at the end of the API URI, if it isn’t already there.

IA-11

Enter your Endpoint URL and Key and close the window.

IA-12

Now you import your Image, or select Analyze Picture if already imported

IA-13

This will analyze the Image and provide you with the Attributes.

The Image Analyzer Attributes page displays the detected attributes, the confidence level, and other details about the attribute. Use the Action to perform options to specify what to do with the attribute.

 

This is how you enable and configure your Image Analyzer Service.

 

To see how many analyses you have left in the current period

You can view the number of analyses you’ve done, and how many you can still do, in the current period.

Enter Image Analyzer Setup, and then choose the related link.

The Limit type, Limit value, and Analyzes performed provide the usage information.

 

To stop using the Image Analyzer extension

Enter Service Connections, and then choose Image Analyzer Setup.

Clear the Enable Image Analyzer check box.

 

I will come with more details as I proceed.

 

 

 

Advertisements

Working with Item Attributes in Madeira

In Madeira you can assign item attribute values of different types to your items, which can then be used when searching for items.

Open your Item List/Card and in the right side of the window Factbox you see Item Attributes.

Today in this post we will see how to define, assign and use it for searching the items.

ItemAttribute-1

Either from the List Page or Card Page Select Attributes as shown in below screen shot.

From Home or Action Tab Ribbon.

ItemAttribute-2

It will show you all the Attributes and their Values assigned to the Item.

You can create New Attribute, Click on +New, a New Line will be inserted to Assign Attribute and its Value.

If you wish to create New Attribute for the Item from the Dropdown List click on +New.

ItemAttribute-3

Attribute definition window opens.

Define you New Attribute. Once Attribute is created you need to define available values for the same. In below Screen i have created New Attribute “TopMaterial”.

To define applicable values for this Attribute from Ribbon click on Item Attribute Values.

ItemAttribute-4

In Value window define all the applicable values and close the window.

ItemAttribute-5

You will be returned to the previous Page and you can see your Attribute and Value defined, just we created in our above steps. Click on OK to return to previous page.

ItemAttribute-6

Next we will Assign these Attribute and Values on the Item.

Select the Attribute and Value for the Item as shown in below screen.

After assigning click on OK to close the Page.

ItemAttribute-7

When you return to your Item Card or List Page you will see that your New assigned Attribute and its Value is displayed on Factbox.

ItemAttribute-8

Switch to your Item List Page.

From Ribbon click on Filter on Attribute a Filter window will open.

Select the Attribute and Value for filter that you want to assign.

Click on OK to apply the filter on the page.

ItemAttribute-9

Since we have asigned this Attribute and Value on one Item, It will be filtered and all Items satisfying the filter condition will be displayed.

ItemAttribute-10

The items in the Items window are filtered by the specified item attribute values.

Thats all for this post.

I will comeup with some more details in my upcoming posts.

Till then keep exploring and learning.

 

 

How Do I : Setup or Adjust Item Cost in Madeira

 

In this post we will see how we can Setup Adjust Cost and how to Run Manually Item Cost Adjust Batch or Schedule the same.

ItemCost-1

Search the Page Inventory Setup using Search Page in Right top corner of your screen.

Search for Inventory Setup Page.

ItemCost-2

Make Sure Automatic Cost Posting is Setup as required.

Also Setup frequency of Automatic Cost Adjustment.

ItemCost-3

Option Behavior
Never Costs are not adjusted when posting
Day Costs are adjusted if posting occurs within one day from the work date
Week Costs are adjusted if posting occurs within one week from the work date
Month Costs are adjusted if posting occurs within one month from the work date
Quarter Costs are adjusted if posting occurs within one quarter from the work date
Year Costs are adjusted if posting occurs within one year from the work date
Always Costs are always adjusted when posting, irrespective of the posting date

Now we will Run the Adjust cost Item Entries Batch.
ItemCost-4

Apply the desired filter for Item or Category as desired.

Next you can run Immediately or can schedule for later execution.

If you require Immediately choose OK.

If you wish to schedule for Later Run choose Schedule.

ItemCost-5

Enter your Date & Time and click OK.

ItemCost-6

To check the status of the Scheduled Run, Search and open the Page Job Queue Log Entries.

ItemCost-7

You can find the Status of your Scheduled Job for Adjust Cost Entries.

ItemCost-8

It’s easy na.

I will come up with more details in my upcoming posts.

Till then keep Exploring & Learning.

 

 

Unit Cost Field, Item Table

Contains the cost per unit of the item.

UnitCost-1

Depending on what you selected in the Costing Method field, the Unit Cost field is filled as follows:

  • If the costing method is Standard, then the field is grayed and non-editable.
  • If the costing method is FIFO, LIFO, Specific, or Average, then the unit cost is calculated as follows: Unit cost = inventory value of items on hand (expected cost + invoiced cost) / quantity on hand

If the costing method is FIFO, LIFO, Specific, or Average, then the Unit Cost field is updated in the following cases:

  • When the item is cost-adjusted, automatically or by the Adjust Cost – Item Entries batch job.
  • During the posting of purchase invoices, output, or positive adjustment if one of the following conditions is true:
    • The net invoiced quantity of the item changes from negative or zero to positive.
    • The current unit cost is zero.

If one of these conditions is true, then the Unit Cost field is updated with the value in the Last Direct Cost field on the item card.

Note The Unit Cost field is not updated if the current unit cost is higher than zero and the new unit cost is zero. A unit cost of zero is considered an exception from regular business. Therefore, the current unit cost is retained to provide the last known, relevant value. This exception applies even if the existing inventory has been revalued to zero.

If the item uses the costing method Average, then you can choose the field to open the Average Cost Calc. Overview window, which shows all the source value entries that are used to calculate the average cost, grouped and summarized by average cost period.

 

 

Adjust Item Costs/Prices… batch job

Just purchase one material on different rates with different vendors and consume it in manufacturing or do the negative adjustment and then run the batch job to see the effect.

The batch job is in the inventory section of Finance Module.

BatchJob-1
All this Batch does is updating the CARD Costs and Prices for an Item; it really has no connection to the costs posted to inventory, and in terms of Sales only affects the default sales price of an item. A better name might be “Item Card Cost/Price Update”
BatchJob-2
To test an example, run the batch on a test database, leave the defaults, but change the Adjustment factor to 1.1.
BatchJob-3
When you run this, all the Item Card Prices will be increased by 10%
BatchJob-4

Most of the processes relating to costing, discuss posted documents and entries. Like Posted Sales Invoice and Posted Purchase receipt and Item ledger entry and Value Entry and General Ledger and GL entries. All these tables (and others) are used to calculate the actual costs and prices in Navision, and are what is used for Accounting reporting such as financial Statements. This is all covered under Inventory Costing. The batch processes (periodic Activities) “Post Inventory Cost to G/L” and “Adjust Cost – Item Entries” all belongs in this category. But on the other side BEFORE you post anything you need to do setup, and amongst all the setup, are the fields on the Item card which ARE NOT POSTED to the GL, but are used as the default values before posting. For example Unit Price from the Item card is copied into the Line of a Sales Order as a SUGGESTED sales price. But you can change it here and post a different price. Most of the numbers that you see on the Item card are just defaults or suggestions; they are not the final number that is posted to the GL. All of this is covered by Inventory Setup, and includes the Batch Process “Adjust Item Costs/Prices”.

If you check the code you will find that:
BatchJob-5
In summary

Inventory Setup is what you do to setup Item Costs and Prices BEFORE they hit the GL. (including “Adjust Item Costs/Prices”). Inventory Costing is what you do with entries AFTER they are posted to correct any changes due to the difference between Expected costs and actual costs.
Just go through these steps and you will know what this batch job does-

1. Create a new Item. Complete all the fields with Unit cost and Unit price. Take a note of all the values you write.

2. Create a purchase order for any quantity with Unit cost other than what is on item card and post the order as received & invoiced.

3. Create a sales order with any quantity other than that of Item card and post as shipped and invoiced.

4. Check the invoicing tab on item card and make a note of all values.

5. Repeat steps 2 and 3 for two-three times by changing the cost and prices every time (also note the values)

6. Now run Adjust cost-item entries and check the Invoicing tab on card. The Cost fields must have updated, but not the prices.

7. Now run Adjust item-cost prices with adjustment factor 1.5 and check the values. The Unit price over the card must have been updated with 50%.

You can see that the batch job is used to change the prices (Sales prices) of items. After running this batch job, every time when you make a Sales order, the updated Price will be copied to Sales Order field “Unit price Excluding VAT”.
BatchJob-6

Above listed all fields can be adjusted accordingly, specifying Adjustment Factor and Rounding Method.

Similarly it works for SKU also.

Give it a try to understand it more precisely. Follow above steps defined above.

Defining Discount & Sales Price for an Item

This set of demonstration will present the new, simplified way of setting sales prices and discounts for items in Microsoft Dynamics NAV 2015.
SPND-1

  • On the Role Center, choose Items to open the list of existing items.
  • Select item 1000, and then, on the Home tab, in the Manage group, choose Edit.
  • In the Item Card window, on the Sales Prices and Line Discounts FastTab, create a new line.

SPND-2

Set a Discount for an Item

  • On the line, set the following values:

Line Type: Sales Line Discount

Sales Type: All Customers

Type: Item Disc. Group

Minimum Quantity: 50

Line Discount %: 30.00

Starting Date: August 1 2015.

Ending Date : Sep 1 2015

  • Choose the OK button

Pick an existing item, for example, item number 1000.

Set a 30 percent line discount for the item for all customers who buy 50 or more of these items in one invoice. The discount will be valid from Aug 1, 2015 to Sep 1, 2015.
SPND-3
Set a Sales Price for an Item

  • On the line, set the following values:

Line Type: Sales Price

Sales Type: Customer

Sales Code: No. 10000

Type: Item

Minimum Quantity: 30

Unit Price: 3200.

  • Choose the OK button

Pick an existing item

Set a lower sales price for this item, for a specific customer, with the condition that the customer buys 30 or more of these items in one invoice.
SPND-4

Useful Tips for Technical as well as Functional (Saving Customer/Vendor/Item as Template)

Normally we see Template is created at on Interface and the Customer/Vendor/Item are created via other interface.

We can make it more user friendly, in below article I will show some readymade tips available in Navision It is available in 2013 and 2015, for lover version please verify accordingly.

First Lets have a look at what all is available to us then we will see how we can make the more meaningful to our customers. Obviously if any out of box customization is required that we have to carry out.

Template-CVI-1

Others too available check it out, I will show one of them rest you apply same skill to accomplish others.

Let’s Start with Page 1300 Mini Customer Card what it looks like.

Template-CVI-2

In this Page on Action Tab we have Save as Template the functionality which we are going to use in our Article for today.

Template-CVI-3

Let’s First Link this Page (1300) with our Std. Customer Card Page (21).

I will Add New Action on my Page and set following Properties.

Open the Page 21 in Design Mode & Access View -> Page Actions.

Template-CVI-4

We have added this Link Just for information you can Skip this step, it is not compulsory for what we are going to perform below in next step.

Here other tabs of Mini Customer Card is only visible following certain Conditions. So nothing wrong with code or design. Technical can review the code and find out the reason for same.

Like :

Template-CVI-5

Template-CVI-6

Next we will copy one Functionality from Page 1300 to our Page 21. Save as Template.

Open the Page 1300 in Designer and access to View -> Page Actions.

Template-CVI-7

Save the object no further any coding or Variable definition will be required. As this Functionality is properly designed as plug and Play. Required Variables are defined local and it takes the Current Record as Parameter.

TempMiniCustomerTemplate.SaveAsTemplate(Rec);

Now Open your customer card, scroll to record which you want to save as Template and Select Save as Template from Action Tab. Give the Template name to save and click OK.

Template-CVI-8

Your Template is saved. Now you can use the same to apply to your New Customer.

Now Create New Customer and Select Template to Apply.

Template-CVI-9

Template-CVI-10

You are done.

This way you are able to give something new to your Customer without any major customization.

Similarly you can do for Item & Customer too.

Explore there are few more which will be helpful in certain conditions.

Important

Most of the contents you find in this blog will be either inherited from MSDN or Navision Developer IT Pro Help. Some places images are also directly taken from these sites. Purpose is simple to try those stuffs and re-produce adding few things as per my understanding to make easy understanding for others and quick reference.

Here nothing under my own brand or authorship of the content. At any point of time we are just promoting Microsoft stuffs nothing personnel with same.

Hope stuffs used here will not violate any copyright agreement with them. In case by mistake or in-intestinally it happens and the Microsoft feels these should not be used Microsoft have full right to inform me about same and will be glad to take down any such content which may be violating the norms.

Purpose is to promote Navision and share with community.

FB Profile

Like FB Page

%d bloggers like this: