Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Receiving Contracted Inventory

Posted on by 100

I have been asked to figure out a way to track contracted Propane. Basically the company I work for has multiple contracts with companies that sell us propane, we are obligated to purchase so many gallons of propane from these companies and I was wondering if their was a way to track this in GP. My initial though was to create a PO for the contract and recieve against that PO. We use that method on a few other Inventory Items that we use. After some disscussion we found out that the Propane will not work that way because it is shipped to many different locations and we are not sure how much will go where. Is there a way to do this in the GP out of the box or will we need to use Extender to add Contract number to each line Item on a PO and create custom reports based on that data?

 Any Help would be greatly apprieciated.

 Thanks

Dave

*This post is locked for comments

  • Dave Hempen Profile Picture
    Dave Hempen 100 on at
    Re: Re: Re: Re: Re: Re: Receiving Contracted Inventory

    Thanks you for all of your responses, I am afraid I should have dug deeper into Great Plains functionality. When looking at the extra information for a PO I was able to find a Contract number field that works perfectly for what we are needing at this point. We eventually will want to track Contract amounts and this is probably going to be a function on GP Extender.

     

    Thanks again for all of the timely responses.

    Dave

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Receiving Contracted Inventory

    And - they want to keep track of the amount ordered so far under each contract.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Receiving Contracted Inventory

    Frank,

    I think it is because they may have multiple contracts.

    Leslie

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Re: Re: Receiving Contracted Inventory

    I don't understand why this creates an issue.  Why can't you issue the PO for xxx gallons of propane and then receive the correct quantity when the shipment(s) arrive at their destinations?  Why would you need a contract number on the PO/receipt to record the multiple receipts?

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Receiving Contracted Inventory

    Could you maybe hijack a field already on the line item? If you need it by line item I often use the 'Requested By' field that's in the Purchasing Item Detail Entry window. If you just need it in the header of the PO, then use the expansion button next to the Vendor ID and you will see there is a field named 'Contract Number' in the lower left-hand corner of the window.

    Kind regards,

    Leslie

  • Bron Profile Picture
    Bron 4,887 on at
    Re: Receiving Contracted Inventory

    I think your idea about extender is the way to go.

    Starting with V10 and SP4 - Microsoft expanded the functionality of the standard extender product.

    You could probably do what you need with the std extender (before SP4) - but the additional functionality might be useful to you.

    You should check it out......

    Regards,

    Bron

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans