Advertisements

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.

 

 

Advertisements

How do I : Adjust Inventory in Madeira

Do you know, it is very easy to Adjust Inventory in Madeira.

Let us see how this action can be done.

Start with Login to Madeira using your credentials.

InvAdj-1

From Landing page, choose Item from Navigation Bar in Left.

InvAdj-2

 

From the list of Item choose Edit or View to access the Card of selected Item.

InvAdj-3

Now from action choose Adjust Inventory.

InvAdj-4

Enter your New Inventory Value. Like in Below screen I want to Add 50 more Inventory.

I Enter 150 including Existing Inventory in System.

InvAdj-5

Select OK.

Inventory now increases by 50 adding 100 to existing inventory making total of 150 available inventory.

InvAdj-6

We are done with our task, Adjusting Inventory.

I will come with more details in my upcoming posts.

Till then keep exploring and learning.

 

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.

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: