Showing posts with label Supply Chain Management. Show all posts
Showing posts with label Supply Chain Management. Show all posts

Thursday, June 30, 2016

Physical Vs. Financial Inventory transactions in AX 2012

Many of the AX community  often wonder what could be the difference between Physical & Financial transactions and when does the differentiation occurs and/or what sense does it make to have physical inventory transactions in books. In this article below, I tried to show the differences between Physical & Financial Inventory and the necessity of having Physical inventory on the books.

Physical inventory transactions occur when the goods are actually picked up or moved from within the company. The goods may have moved out as part of sales commitment or lined up for production requirements, the goods have been received from the vendor at the warehouse.

Normally during the Physical Inventory transactions, we only create an accrued liability or accrued asset and the transaction is not complete fully. This is done to recognize a transaction of inventory movement is in the process.

For Example: Product Receipt of PO, Packing Slip for a Sales order or a Picking list for production.

Financial inventory transactions occur when a PO or SO is invoiced and a Production Order is completed, when a financial Inventory transaction occurs, the same physical transaction is updated by AX and is treated as one single transaction that is complete in all respects.

Previous accruals, if any (done at the time Physical inventory transaction) shall be reversed and the final revenue or expense/asset transaction is posted.

is the Physical Inventory required?

Many legal entities that implement AX have larger workplaces spread across multiple regions. a purchase or a sale transaction normally spreads across multiple period.

For Example: A purchase order that was initiated on 15th June, the goods receipt is taken place on 30th June and the invoice was received and posted on 4th July.

The books are normally closed on a monthly basis, in the above case the inventory has already been received in our premises, but if the physical inventory is not recorded the inventory counting exercise cannot be properly carried out. If the Physical inventory is recorded, the system shows accuracy of inventory on hand for the counting exercise to be smooth.

A thumb rule that always needs to be noted is that 

"A financial inventory transaction will have a physical inventory transaction posted,

 but 

a Physical inventory transaction may not have a financial inventory transaction posted"


Some broad examples of Physical & Financial inventory transactions are :




Physical
Financial
Receipt (Stock Increase)
Ø Purchase order receipt 

Ø Sales Returns (SO Returns) packing slip return 

Ø Production order report as finished  
Ø Vendor invoice 

Ø Sales Returns (SO) invoice for a return 

Ø Production order costing

Ø Inventory Journals with positive stock
Issue (Stock Decrease)
Ø Sales order packing slip

Ø Purchase returns (PO returns) product receipt return 

Ø  Production order picking list
Ø Sales order invoice 

Ø Vendor invoice return (Purchase returns invoiced)

Ø Production order ended 

Ø Inventory Journals with negative stock


Saturday, May 30, 2015

Strengthening the Supply Chain Management in Ax 2012 r3

Supply chain management is a broad term in regular use ever since AX 2012 is released replacing the erstwhile term "Trade & Logistics" used in versions AX 2009, 4.0 and so on to represent Purchase, Sales and inventory moment activity.
Many of us already understand distribution of a company's product through efficient dealership network and timely logistics supplying these dealerships from the point of manufacture is the key to sales.
Meeting the given demand is a key to a company's success irrespective of how popular or quality of the product is being offered, which makes this network a very key in enhancing a company's sales.
Same is also the factor with the raw material procurement, maintaining the Economic order quantity, re-order levels and minimum order quantity is the key along with many other important business requirements.
Assume an FMCG companies such as Proctor & Gamble or Unilever is planning to implement Microsoft Dynamics AX 2012 to meet their complete business requirements. Can standard Ax meet the business needs of such a big network with thousands of dealerships across the globe?

YES.

The Answer is a Yes with the introduction of the enhanced AX 2012 R3. Let us study various modules (With detailed features for new modules) that enables these key requirements.
Warehouse Management: This module integrates better and improved Warehouse management capabilities into Microsoft Dynamics AX. This provides for real-time handling of inventories at warehouse permitting user of scanners, creating orders for pick and pack, setting up container groups, wave processing. All the requirements of a modern warehouse are provided for in this new module introduced in R3 release

Transportation Management: This module provides for freight movement planning across business. AX provides for centralized and distributed (warehouse / site) level movement. The new features include Advanced load planning, rate and route calculations.

Trade allowance management: There is always a demand for implementing advanced price management functionality in AX. Microsoft has come out with Trade allowance management to solve the pricing riddle.This module can be used to create, maintain, and quickly determine status of trade allowances apart from managing prices and discounts that are offered at various times as part of promotional incentives.

apart from the above new modules a host of existing modules such as Product Information Management, Inventory Management, Procurement and sourcing, Accounts Receivable, Accounts Payable, Sales and Marketing.
Not to limit here the Project management module provides for Product research & development related activities.
Continuous Improvements are fast reinforcing the existing functionality to build a better product for the customers in the form of Microsoft Dynamics AX.