Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Coversion of one item ...
Microsoft Dynamics GP (Archived)

Coversion of one item into another

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are marble and granite company. When a marble slab is purchased it is given a code of R (means raw material). If customer purchases the whole slab, R is sold and it is simple. But when customer asks to cut it to size then R is converted into two further types one is R1 (Small pieces of marble and granite which is further sold as scrap) and F (finished marble slabs that are sold to customer). Now question is how to deal this siuation in GP 2013. We don't have manufacturing module.

Currently we have posted the opening balances of all three categories. We have added the items by creating the following item IDs series

For R (Marble slab) ST-MR-R-0001 (ST for stone MR for Marble R for Raw material mean complete slab and 0001 is series code)

For R1 (small pieces of marble) ST-MR-R1-0001 ( R1 is for small pieces of marble and all other abreviations are same as above in case of R)

For F (Cut to size finished marble) ST-MR-F-0001 (F is for finished marble and all other abreviations are same as above in case of R1 and R)

In this situation if customer order only R then it is simple to sale the R. but when he orders to cut the slab and provide him finished marble as per his requirement then how to move quantities from R to R1 and F.

Kindly suggest me the solution and explain how this situation can be dealt with. 

Thank

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Coversion of one item into another

    Mr. Bill Thank you very musch :) I think this will work, However let me test.

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Coversion of one item into another

    Praveen, I think that the only problem in this case is you are 'unbuilding' your raw material.

    You are starting with one item and during the process you are coming out with 2 or more items.

    As I recall GP BOM can not handle the 'deconstruction' of materials.  If I am wrong, I will stand corrected, but have a look at the process that is getting completed and try to map out what your BOM tree would look like - it would ( in my picture ) look like 1 becomes 2 rather than 2 becomes 1

    Comments?

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Coversion of one item into another

    If you want to do it manually, we have done so in the past, here is what we did.

    Assume that R is into the Inventory for 100.00 and that there are 100 units of R

    What you need to have happen is R - full slab has to be removed from inventory and the same amount of R1 and F need to take the place, both in dollars and Quantity - dollars more important

    Using Inventory Adjustment - reduce the count of R by the size that is being removed - in our case 100 unit of R will then take 100.00 dollars from inventory

    Using Inventory Adjustment - increase the count of R1 by the size of the remaining stone to be sold as scrap - by the amount of units say in our case 20 - thereby increasing the QTY by 20 and the dollars in the inventory control by 20

    Using Inventory Adjustment - increase the count of F by the size of the finished cut - in our case 80 units - thereby increasing QTY by 80 and dollars in the inventory control by 80

    Here we have a balanced environment - 100 out - 100 in - no change to finance at this point as everything is in and out of inventory control account for the stone.

    Now you sell the F cut for the QTY desired and the selling price desired.  The system will take care of removing and adjusting inventory qty and dollars.

    When you sell the R1 scrap - use the right code and the qty will take care of itself.

    This seems like a long process but it is inventory / manufacturing on a bit of a budget - nothing new to setup and configure and no new learning required.

    Hope this helps.  Best if you can do this in a test system to learn and practice.  Keep on on posting.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Coversion of one item into another

    I have sent you the test mail.  Thank you very much

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Coversion of one item into another

    Yes Rashid, it will be helpful.

    Like other posts, i am unable to attach the document, i don't know what's issue in my system or network.

    If possible please sent me test mail to praveenkrr@gmail.com, i will send the BOM document to you.

    Thanks,

    Praveen

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Coversion of one item into another

    Thanks you Praveen.

    Will this bill of material be helpefull in my specific case, as I have already created the codes as mentioned above.

  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Coversion of one item into another

    Hi Rashid,

    You can explore BOM Feature in GP (Bill of Material).

    Ideally it is meant for the Item Consumption towards Production.

    Hopefully this will help you.


    Thanks,

    Praveen

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans