Catch Weight Functionality for Receiving of Goods in Microsoft Dynamics AX 2012

Many industries receive raw material in a different packaging unit, while payment may be made in a different unit. This post will help you understand how to receive product in different packaging using Catch Weight. Let’s take an example of cotton in Textile Industry, Cotton is received in unit “Bales” and normally companies need to pay the vendor after weighing in Kilograms. This weight may be different in each case because the Bale has a catch weight. Users face great difficulties while receiving goods because in AX 2012 we can give only one Unit of Conversion against single item. Lets have a look on how to resolve this:

First of all go to Product Information Management –> Common –> Released Product then click on New

Do not forget to mark CW Product Check Box while creating new Product

CW

Then click OK button and you can see the New Product in Product Information Management

 

New Item

Define unit of conversion of Product; remember that we have taken Inventory and Purchasing unit “KG”

Unit of Conversion

UOC

After setting unit of conversion go to the Product and edit that then go to Manage Inventory tab and select catch weight unit as Bales

Edit Prduct

and add minimum and maximum quantity to be received. Note that minimum and maximum quantity will be the quantity to be received in Kilograms not bales

Setups have been done. Now, we need to receive the same Product for this follow the below navigation

Go to Procurement & Sourcing –> Common –> Purchase Orders –> All Purchase Orders then click on New PO

PO

Select vendor and click Okay

Then select the Product on Purchase order lines

PO Lines

After taking Product and its quantities click on Update Line tab and select Registration

Update Line

This will be done after confirmation of Purchase order and before Receiving of Goods but at this stage user must know the actual weight of the Product which user is going to receive.

Now click on Auto create

Auto Create

After clicking on Auto Create checkbox, the total quantity of that Product will copy in Register now

Now user can register the actual weight of the goods received. Let’s say we have set the conversion from Bales to Kilograms 150 kg but at the time of receiving when Product was measured on weighing bridge user came to know that actual conversion is 1 Bale = 200 kilograms then here user will register the quantity with actual weight even batch number wise

Batch Wise registeration

But registration is only based on minimum and maximum quantities setup on Catch Weight you can see in the above screen shot that setup conversion was 150 kilogram but registration has been done with 200 kilograms conversion

After this go to the Product Receipt for receiving the Product

Product Receipt 1

Enter Product Receipt number

Product Receipt 2

In above Posting Product Receipt screen you can see on lines The CW quantity remains same but conversion factor has been changed from 150 kg conversion to registered 200 kg conversion

Now click Ok for receipt.

Now you can check “On Hand” inventory will show the inventory of received product

On Hand

You can see the receiving of goods in different batches with actual weight of the Product received.

Hope this post will help to solve the Catch Weight receiving issues that you may have.

 


Dynamics AX 2012: Textile Industry and Issues Solved!

This will be a series of posts in which we will learn about the Manufacturing Processes and solutions offered by Dynamics AX 2012. Most logical and frequently occurring issues include:

Inefficient purchase activities

Vendors tracking

Realizing savings in purchase

Outsourcing services

Maintaining minimum stock levels

Reservation of stock

Visibility of slow moving inventory

Pallet wise inventory management and transportation

Food and safety risks

Quality testing functionalities

Losing customer’s trust

Long lead time to develop new product

Poor sales and promotion

Traceability of customers

Growth rate

Price discounts to valued customers

Variable production demand on seasonal basis

Production on customers demand

Short lead time

Production yield

Poor sales and promotion

Traceability of customers

Growth rate

Price discounts to valued customers

 

Many of the complicated supply chain business requirements have been fulfilled by Dynamics AX 2012 through the following modules:

Product Management

Defining BOMs and Formula lines with costing effects

Demand, Supply and Inventory forecasting

Master Planning and Scheduling, Resource Planning, Machine Capacity Calculations

Procurement and Sourcing

Inventory and Warehouse Management

Quality Management

Production handling in critical scenarios like outsourcing of WIP products, inventory reservations

Pallet wise management of inventory using different locations, inventory picking methodologies, shipments, transportation management

In a series of blog posts, we will uncover the following areas that will help in defining how supply chain can be set up for an organization:

 

Adding company in Dynamics (Creating Legal entity for your organization)

Number sequences

Setting up Ledger

Charts of Accounts

Setting up Currency

Product Information Management

Creating Formula and BOMs

Setting up Locations, warehouse, sites, aisles etc.

How to Create and set up Vendors

Forecasting

Resource and Machine Capacity Calculations

Master Planning

Configuring Procurement and Sourcing Parameters

Setting up Procurement and Sourcing Work Flows

Procurements Setups

Business Cycle Mapping of Procurement

Creating of Purchase Orders of different types e.g. return, quotation, purchase and sales agreements etc.

Pallet wise Inventory Management

Pallet Transport

Production Control Parameters

Routes

Production Cycles with FMCG Scenarios

Configuring Customers / Sales Agreements

Business Process Mapping of Sales with using different Scenarios

Managing Return Orders

Creation of Sales and Purchase Invoices

Posting of Invoices in General Ledger

Our blogs will cover all the processes of FMCG industry from Purchasing of Raw Material till dispatch of Orders (Exports and Local) and their financial impacts as well.

Stay Tuned!