Creation and Posting of Counting journal in MS Dynamics AX 2012

 

Hi All,

Now we are going to discuss about Counting journal which is part of Inventory journals.

This is a process where we adjust Item’s On-hand as per the actual physical stock by posting a journal as per actual physical stock available in the warehouse.

The Counting journal lets you calculate the current on-hand inventory level that is recorded for a group of items, and then post the actual physical count to make the adjustments necessary to reconcile their differences.

In Dynamics AX, you will register the counted quantity in inventory journals. When posting the inventory journal, the difference between the counted quantity and the physical quantity available in Dynamics Ax will post as an item issue or receipt similar to an inventory profit/loss journal.

Process of creating and posting of Counting Journal

Inventory and warehouse management—>Journals—>Item Counting—> Counting 

· clip_image002t

Click Ctrl+N or New icon on the top of the form as shown in the below screenshot

clip_image004

· A new dimension form is opened, with only Storage and Tracking dimensions check boxes enabled.

· Select any dimension check box as required and click OK (AX displays On-hand quantity on journal form based on the Dimension selected, for example if Warehouse is selected AX displays On-hand quantity warehouse and Site (Default) wise in the journal form, if Warehouse is not selected it displays On-hand quantity as soon as Site is selected and before selecting warehouse itself)

· Select the journal name in the Name field for which you are running the counting.

· Click Lines option as shown in the above screenshot.

· By clicking Create in the Counting journal lines form, you can select one of the three methods of creating lines. This is shown in the below screenshot and following table.

clip_image006 

Method

Description

 

On-hand

 

Selecting this creates a journal listing only for those items for which on-hand inventory is registered—that is, on hand inventory is not equal to zero.

 

 

Items

 

Selecting this creates a journal listing for all items, and through the counting process, warehouse staff will identify those that are on-hand (by noting the number Counted) or not on-hand (zero).

 

 

Expired

batches

 

Selecting this creates a journal listing only for those items with an expired batch date. This enables warehouse staff to count only those items with expired batches so that these items can be removed from inventory or otherwise treated in a special manner.

 

· You can also enter new lines by clicking Ctrl+L and enter Item in the item field.

· In the Counted field, enter the actual physical quantity of items counted.

clip_image008

· The difference between the on-hand inventory and the counted quantity is calculated automatically and appears in the Quantity field. Notice that you must enter a quantity, even if the quantity is zero, for every line that appears in the counting journal.

· Enter any additional lines for items that were not generated when you created the counting journal lines.

· Click Post to post any differences in system counted and physically counted quantity.

By rambabuyelisetty

Modules names changes in MS Dynamics AX 2009 Vs. AX 2012

 

Hi All,

Here we going to discuss about module name changes with respect AX 2009 and AX 2012

Most of the modules names in MS Dynamics AX 2009 either changed or promoted into two modules with new names. some modules are completely removed and clubbed into other modules. these are explained in detail in below table.

 

 

 

MODULES IN AX 2009

 

 

 

MODULES IN AX 2012

 

Inventory Management

·       Inventory Management

·       Product Information Management

 

 

Accounts Payable

·       Procurement and Sourcing

·       Accounts Payable

 

 

Accounts Receivable

·       Sales and Marketing

·       Accounts Receivable

 

 

 

General Ledger

·       General Ledger

·       Budgeting

·       Fixed Assets

·       Compliance and Internal controls

 

Cost Accounting

·       Cost Accounting

 

Bank

·       Cash and Bank Management

 

 

CRM

·       Moved to Sales and Marketing module

 

Master Planning

·       Master Planning

 

 

 

Production

·       Production control

 

 

Product Builder

·       Moved to Product Information Management

 

 

 

 

 

 

Shop floor Control

This Module is split into three and can be accessed from Home, Human resources and Production Control Modules.

·       Time and Attendance     – Human resources.

·       Clock In and Out – Home

·       Manufacturing execution – Production        control.

 

Human Resource

·       Human Resources

 

Questionnaire

·       Moved to Home

 

Expense Management

·       Travel and Expense

 

 

Projects

·       Project Management and Accounting (PSA)

 

Service

·       Service Management

 

 

Basic

·       Organizational Administration

 

Administration

·       System Administration

 

By rambabuyelisetty

Write off Inventory and Build up or Increase Inventory in MS Dynamics AX 2012

 

Hi All,

Here we are going to discuss how to adjust inventory i.e. write off (decrease or removing) and how to increase or build up inventory in MS Dynamics AX 2012. This is common in day to day transactions to alter the stocks or inventory. To address this we have Inventory journals in AX 2012.

We have few journals in AX 2012, they are,

  • Inventory adjustment journal (Profit and Loss journal)
  • Movement journal
  • Counting journal
  • Tag counting journal

We can perform adjustment of item from above journals and these are explained in detail in my blog “ramdynamicsax”.

By rambabuyelisetty

Creation and Posting of Transfer journal in MS Dynamics AX 2012

 

Hi All,

Now we are going to discuss about changing Item or Product dimension from one value dimension to another dimension.

Transfer journals are used for transferring an inventory quantity from one dimension combination to another dimension combination.

In most cases, you will transfer from one warehouse or location to another. You may as well post a transfer to change the batch or serial number, however. In addition to the data recorded in profit/loss journal lines, you need to enter the applicable inventory dimensions to which the item should transfer. Dynamics AX posts ledger transactions for item transfers, because transferring a standard cost item between two sites, for which different standard cost prices apply, will change inventory value.

When you post a Transfer journal, for one journal line, two inventory transactions are created for one journal line. The two transactions are an inventory receipt and an inventory issue. The on-hand inventories at the two warehouses will be changed.

Postings to general ledger occur in the following cases:

• Items are moved to another dimension, for example if items were originally registered by using color=black and are moved to color=red. Postings occur whether this is in the same site or whether the transfer is other sites.

• Items are moved to another site, even if the inventory item dimensions are identical. This enables sites to have different costs for the same items.

Creation steps:

clip_image002

From the Navigation Pane, open Inventory and warehouse management –> Journals –> Item transactions –> Transfer.

Ø Click “New” button on the form.

Ø Select “Journal name” in Name field

Ø Select “Lines” button and journal form opens

clip_image004

Ø Select an Item number in the Item number field

Ø Select a From and To Site to transfer the item to.

Ø In the From warehouse field, select the location (if required) from which the item should be transferred.

Ø In the To warehouse field, select the location where the item is going.

Ø Use the From batch number and To batch number fields to specify batches.

Ø Use the From Size and To Size fields to specify batches (change the values if you require)

Ø Use the From Color and To Color fields to specify batches. (change the values if you require)

Ø Use the From Configuration and To Configuration fields to Specify batches. (change the values if you require)

Ø In the Quantity field, type the quantity to transfer. (Will have negative sign by default)

Ø Click Validate tab in the top of the form and click OK option shown in above screenshot

Ø If you get any Warning or Information or Error logs please address them and proceed for Posting.

Ø To post the journal, click Post tab on the top of the form and click OK in the Posting form.

Ø Now you will see an information log as Journal is posted successfully.

Note: Regarding creation of Journal names and processing of Movement, Tag counting, Inventory adjustment or P & L refer to my Blog “ramdynamicsax”.

By rambabuyelisetty

Creation and Posting of Inventory adjustment Journal in Microsoft Dynamics AX 2012 (Profit and loss Journal in AX old versions)

 

Hi All,

In this topic now I am going to explain importance and Creation & Posting of Inventory adjustment journal in Microsoft Dynamics AX 2012.

The Inventory adjustment or  Profit/Loss journal is generally used to write-off inventory or to make standard adjustments. It is an inventory adjustment journal for items lost, broken, or just found where item value and quantity must be updated to keep inventory accuracy. This kind of journal automatically applies financial transactions to preset accounts for profit and loss. This journal was known as Profit and Loss journal in earlier versions of AX prior to AX 2012.

To create and post Inventory adjustment journal follow below navigation.

Navigate to Inventory and warehouse management –>journals—> Item transactions —>Inventory adjustment

clip_image002

Click “New” tab on the Inventory adjustment journal form as shown in above screenshot

Select a Journal name as required say “IPL” from above screenshot.

Click Lines button the same form as shown in the above screenshot.

A new journal lines form is opened,

Select item number in the Item number field.

Enter if required dimensions like Item (Configuration, Size and Color),

Enter if required Storage dimensions like Site, Warehouse, Location and Pallet ID. (Warehouse is mandatory, Site is required if Site is activated).

Enter if required tracking dimensions like Serial and Batch number.

Enter some value in Quantity field.

If you are going to add or intake the inventory you need to put positive value in the Quantity field. If the value is positive you can edit the value displayed in Cost amount field as shown in below field.

clip_image004

If you want to remove or outtake or decrease inventory you need to put negative value in the Quantity field. Here you can’t edit the values displayed in Cost amount field.

Now if require adding some more items create another line and enter all related values in related fields.

Now journal is ready to post.

Click Validate tab in the top of the form and click OK option shown in above screenshot

If you get any Warning or Information or Error logs please address them and proceed for Posting

To post the journal, click Post tab on the top of the form and click OK in the Posting form.

Now you will see an information log as Journal is posted successfully.

By rambabuyelisetty

Creation and Posting of Movement Journal in Microsoft Dynamics AX 2012

 

Hi All,

Here we are going to discuss about importance and process of Movement journals posting in Inventory management.

The Movement journal can be used  to bring in opening Inventory balances during system setup and offset these adjustments to specific ledger accounts.

  • To create and post Movement journal follow below navigation.
  • Navigate to Inventory and warehouse management—>Journals—>Item transactions—>Movement

          clip_image002

  • Click “New” icon on the Movement journal form as shown in above screenshot
  • Select a Journal name as required say “Imov” as shown in above screenshot
  • Click Lines icon in the same form as shown in the above screenshot
  • A new journal lines form is opened,

         clip_image004

  • Select item number in the ‘Item number’ field
  • Enter if required item dimensions like Configuration, Size and Color.
  • Enter if required Storage dimensions like Site, Warehouse, Location and Pallet ID. (Warehouse is mandatory, Site is mandatory if Site is activated).
  • Enter if required Tracking dimensions like Serial and Batch number.
  • Enter some value in ‘Quantity’ field.
  • If you are going to add or intake the inventory you need to put positive value in the ‘Quantity’ field. If the value is positive you can edit the value displayed in Cost amount field.
  • If you want to remove or decrease inventory you need to put negative value in the ‘Quantity’ field. Here you can’t edit the values displayed in ‘Cost amount’ field(As shown in above the screenshot).
  • Select a Ledger account as per the requirement in the ‘Offset account’ field. (This is applicable and visible only for Movement journal and this is specialty of this journal).
  • Now if required, add some more items by creating another line and enter all related values in related fields.
  • Now journal is ready to post.
  • Click ‘Validate’ icon in the top of the form and click ‘OK’ option to validate whether the data entered is correct or not before actually posting the journal.
  • If you get any Warning or Information or Error logs please address them and proceed for Posting
  • To post the journal, click ‘Post’ icon on the top of the form and click ‘OK’ in the Posting form.
  • Now you will see an information log as Journal is posted successfully.
By rambabuyelisetty

Creation of Inventory Journal Names and Assigning to Journals in Microsoft Dynamics AX 2012

In Inventory Management to adjust Inventory we need to perform those adjustment operation through Inventory Journals. Inventory Journals are Movement, Adjustment (previously known as Profit & Loss in earlier versions) , Transfers and BOM (Bill of Materials)

To create and post any Journal there are few prerequisites, like Journals names and Number sequence code or voucher series.

Now let us discuss regarding Journal name creation and assigning to related Inventory journals in MS Dynamics 2012.

To post any Journal we need to create a related journal name and need to assign to related Journal type. Another one is we need to assign related Number sequence code or voucher series to Journal.

For creating journals Navigate through below path

Inventory and warehouse management—>Setup—>Journals—>Journal names.

image

In the journal names form we can create the name and description of the journal also we can assign the Number sequence voucher series.

Click New tab in the top of the form and enter a specific name in the Name field and in description field.

Select Journal type as required in the Journal type field. 

Select Voucher series code in the General pane section in Voucher series field (Number sequence code)

Select Selection by option as required, options are Posting and Entry.

select New voucher by option as required, options are Change date and change date or item

Select option in Detail level field. options are Summary and Detail.

Select the check box Delete lines after posting if required. if selected journal lines are deleted after posting.

select ledger account in the Offset account field as required. (Note: This is applicable or enabled only for Movement journal type only)

The Journal names which were created should be assigned to the related Journals in below mentioned path.

Navigate to Inventory and warehouse management—>setup—>Inventory and warehouse management parameters—> Journals Fast tab –>All the Inventory Journals are displayed—> select the related journal names from the drop down menu.

image

Now Journals are ready for usage.

Regarding creation and posting  of Inventory journals like Movement, Inventory Adjustment, Transfers and BOM Journals are explained in other posts of my ramdynamicsax.com blog.

By rambabuyelisetty