web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX Unit Conversion
Microsoft Dynamics AX (Archived)

AX Unit Conversion

(0) ShareShare
ReportReport
Posted on by Community Member

I am facing a challenge with a client. The client is into shoe manufacturing, They buy leather and make shoes. When leather is bought it has got two units .

1 Piece ( counting of leather happens in piece)

2. Sqft ( Value of leather is in Sqft and all issues happen in Sqft)

Leather is bought in piece with sqft being the measurement used for the piece. 1 piece may be 10 sqft of leather and another piece may be 20 Sqft of leather. Now this measurement being non standard how to configure this in AX. They generally do stock counting with piece but they value leather based on Sqft and also issue leather to production in Sqft.

Kindly help me in giving a solution to this problem.

 

Regards,

Santhosh Kumar R

*This post is locked for comments

  • arijitbasu Profile Picture
    arijitbasu Microsoft Employee on at

    Hi,  Which UOM is used in Inventory valuation? I came across a similar scenario in the Steel Industry where Steel plates are procured in MT and issues as pieces. However valuation was in MT. We had to go and create a dual UOM for this and I think you may also need to go for the Dual UOM.

    Hope it helps.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thanks for your reply. My client would use for valuation purpose Sqft and for taking stock count they would use pieces. Now I do not understand how this Dual UOM can be applied. May I request for a detailed explanation. I

     The challenge in my case I do not have standard measurement for a piece. Each piece will have its own measurement.

    I cannot define 1 Piece =10 or 20 Sqft. Each time whenever I buy leather it will vary. Hope I am making it clear to you.

     

     

     

  • Community Member Profile Picture
    Community Member on at

    To create the Units follow the path:

    • Company / Basic / Basic Area
    • Select Units > Units

    Here create the required Unit (i.e. Gr - to represent Grams) with required information:

    • Identification > Units (Create individual stock-keeping units)
    • Formatting > Decimals (Specify the number of decimals for the stock-keeping unit to display)
    • Description > Name (Enter descriptive text to identify the inventory unit)

    Click >

    if you want to specify this conversion to a single item only than you may select the specific item otherwise leave it blank.

    1. Click New
    2. Leave First Conversion Line as it is, Click New again for second line
    3. In the field, specify the conversion factor and any quantity added upon conversion
    4. In the field, specify the inventory unit you want to convert to
    5. In the field, select a rounding method for the

    7. Close the form and you can then choose the alternative unit for the item in the form

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thank you for your reply. You did not answer my question. I have explained my scenario. I am not asking how to create a UOM . Please understand my scenario and try to explain.

  • Community Member Profile Picture
    Community Member on at

    I get that, it really is a big challange.

    As I too had been the part of an implementation at a shoe manufacturing concern but didn't faced such issue. The reason behind is that our client was educated about the quantity of an item in detail. This is common with shoe manufacturers that they go for peices and sqft both. However, in my case my client understood the concept of quantity so he was given a standard UOM and conversion was used whenever there was pieces involved but they always were counted 1pcs=10sqft.

     

    I hope you can convince your client as well, and if you find any solution you have my email address, so don't forget to post me too.

     

  • Community Member Profile Picture
    Community Member on at

    Hi Waqar,

    Thank you once again for your reply. Its interesting to know you also had similar experience and really appreciate the fact for convincing the client. But here in my case what is happening is if I set the standard as 1 Piece =10 Sqft then the client may end up loosing lot of value in leather if the measurement is larger than 10 sqft. For eg :A calf leather mesures different from cow . Likewise each cow, buffalo, goat, sheep will be of different size and they will measue different sqft per piece. So it becomes difficult for the client to loose out so much sqft per piece. I will definitely let you know if I get a solution. But in the meantime if you get any idea please share it with me.

    Regards,

    Santhosh Kumar R

    +919884190307

  • Community Member Profile Picture
    Community Member on at

    Thank you for your understanding, but this issue has really got me finding solution for it too.

    I had a discussion with one of my frineds and came to the following conclusion you may follow the procedure below, hope that can help you resolve it.

    Purchase should be made in SQFT unit and inventory should be updated by PCS unit.

    I was unable to give it a try due to the tight schedule, please do try it and don't forget post your feedback.

     

  • diana g Profile Picture
    diana g 689 on at

    Standard AX can't handle this. It's also known as catch weight and is common in the food industry where they buy for eg a chicken and it also has a weight. You basically need two units of measure... one for the quantity and another for weight (food) or length (steel or wood) or area (in your example).

    You can check with fullscope. I know they have some catchweight functionality in their processing manufacturing module. Do a search for AX and catch weight and you'll find a few options.

  • Community Member Profile Picture
    Community Member on at

    http://www.scalable.com.au/microsoft_dynamics_ax.htm

    www.scalableds.com.au/Whitepapers&Brochures/SDS%20Add%20ons/Catch%20Weight%20Management.pdf

    better check these links, cause you are right no solution within AX, though the functionality can be achieved by getting Scalable module in it.

    This was a really nice and useful information for me aswell. Thank you.

  • Community Member Profile Picture
    Community Member on at

    Hi Diana,

    Thank you very much for your reply. Many thanks to you for understanding my scenario and giving me reference.

     Regards,

    Santhosh Kumar R

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans