Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Group Buying - Price C...
Microsoft Dynamics GP (Archived)

Group Buying - Price Control question

(0) ShareShare
ReportReport
Posted on by Suki Lotay 65

Currently we place all “sales inventory” items orders to one creditor in GP.

The creditor (Our parent group) then in turn place purchase orders onto their suppliers to manufacture goods.

Due to cost down and re sourcing  we potentially can procure the same SKU from two different factories, Each SKU will have a different prices

Currently as were part of a group we cannot create another creditor on GP as our group will always invoice us.

So in turn I need GP to hold multiple price lists against one creditor for an individual SKU.

Is there a standard way to do this?

If not how are others overcoming this?

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Group Buying - Price Control question

    Apologies, as I need to ensure that my understanding of the issue is complete.

    You purchase your items from the only one creditor (the group), which in turn receives those items sometimes from several manufacturers (each of them has a different unit cost) , do I understand that well ?

    If that's the case, on you system, you can do one of the following for the only one vendor you have in GP;

    • In terms the unit cost is determined at the time of the shipment;
      record multiple ( Shipment Invoices ) from the only one creditor you have (on each shipment/invoice, you enter the actual unit cost).

    • In case the actual unit cost is not determined at the time of the shipment, record one shipment with an expected unit cost. When the actual cost is determined, you record several enter/match invoices for the same shipment, each of them has a different unit cost.

    In Dynamics GP, there is a manufacturer-vendor definition. Although, that is an informational piece of details. The liability is recorded on the vendor level, the manufacturer is just information value.

    Could you please illustrate further how is it that the above scenarios don't meet your requirements, I would appreciated you thorough justification.

  • Suki Lotay Profile Picture
    Suki Lotay 65 on at
    RE: Group Buying - Price Control question

    Thanks for your quick response.

    When my Buyers are creating purchase orders, potentially they do have an option to procure from more than one Creditor, each creditor has a separate purchase price.

    My issue is that I can only use one creditor due to Group buying.

    Is there any functionality to have a sub vendor? or a parent to a child relationship?

    If I could more than one creditor and raise a PO directly to them this will resolve this - but the issue is I cannot do this due to invoicing.

    Could I create a separate table in GP to hold such data and then point my purchase orders to this table for the price? I'm thinking about using Extender in conjunction with a VB mod on the window?

    Thanks in advance

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Group Buying - Price Control question

    I believe the case which you mention is quite simple and doesn't represent such a headache as you might imagine.  Initially, you need to differentiate between the item cost and price.

    Item Costing:

    Once you post a shipment, you will be asked to enter the unit cost of an item, which will be actually recorded in inventory tables. Later on, you can post several Enter-match invoices. In case of any cost variance, cost adjustment entries will be posted automatically to the system to adjust inventory cost, and associated GL accounts.

    Here is the core of your issue, you may post a shipment from your only creditor for a certain item/s. Unit cost entered will be recorded in inventory. Due to cost changes and variance, you may receive several invoices with different costs for the same shipment.

    In this essence, you may want to take a thorough look at the following article discussing a certain issue with partial enter match, this issue has been resolved in GP2010 with the release of the latest GP2010 SP4.

    Enter/Match Partial Cost Modification - Inventory versus General Ledger Test

    The resolution details are provided on the following link ; GP2010 SP4 “Issue Resolved” - Enter/Match Partial Cost Modification


    Item Pricing:

    There are two different pricing methods in Dynamics GP; which are Standard Pricing and Extended Pricing.

    • In Standard Pricing, you configure a price list which can be for an item/group of items. Each price list considers the following parameters; UOM, Price Level and currency.
    • In Extended Pricing, more complex criteria can be considered to set up base price list and promotional price list.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans