web
You’re offline. This is a read only version of the page.
close
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) / Price Level/Price ...
Microsoft Dynamics GP (Archived)

Price Level/Price List???

(0) ShareShare
ReportReport
Posted on by Community Member

I believe that in prior versions of Dynamics GP we were able to copy one Price List to another and adjust the items within the price list if needed.  However, in version 10 it doesn't appear as if we can do that.  What we want to be able to do is take Price Level x and copy it to Price Level y taking the associated Price Lists with it.  Does anyone know how to do this?

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Microsoft Dynamics GP -> Tools -> Utilities -> Inventory -> Price List Utilities

    This provides all of the same functions that were available in Versions 7.5, 8, and 9.  Using the restrictions, you can copy a Price Group and you can increase or decrease the prices by a percentage or amount as desired.

    If you had additional features, it might have been customized.

  • Community Member Profile Picture
    Community Member on at

    This procedure is what I was looking for.  Thanks anyway.

     

     declare
      @source_pricelevelcode varchar(250),
      @new_pricelevelcode varchar(250),
      @new_priceleveldesc varchar(250)

    SET @source_pricelevelcode = 'DIS 14'  -- SET YOUR SOURCE PRICELEVEL CODE
    SET @new_pricelevelcode = 'DIS 28'  -- SET YOUR NEW PRICELEVEL CODE
    SET @new_priceleveldesc = 'new price list' -- SET YOUR NEW PRICELEVEL DESCRIPTION


    -- PROCEED TO COPY PRICELEVEL SET INTO ANOTHER, THERE ARE 3 TABLES INVOLVED

    INSERT INTO iv00108(ITEMNMBR, CURNCYID, PRCLEVEL, UOFM, TOQTY, FROMQTY, UOMPRICE, QTYBSUOM)
    SELECT ITEMNMBR, CURNCYID, @new_pricelevelcode, UOFM, TOQTY, FROMQTY, UOMPRICE, QTYBSUOM
    FROM iv00108
    where prclevel = @source_pricelevelcode

    INSERT INTO iv00107 (ITEMNMBR, CURNCYID, PRCLEVEL, UOFM, RNDGAMNT, ROUNDHOW, ROUNDTO, UMSLSOPT, QTYBSUOM)
    select ITEMNMBR, CURNCYID, @new_pricelevelcode, UOFM, RNDGAMNT, ROUNDHOW, ROUNDTO, UMSLSOPT, QTYBSUOM
    from iv00107
    where prclevel = @source_pricelevelcode

    INSERT iv40800 (PRCLEVEL, DSCRIPTN)
    VALUES (@new_pricelevelcode, @new_priceleveldesc)

  • Community Member Profile Picture
    Community Member on at
    Being new to this board, I just realized who you are.  I have two of the Accolade books and they are very useful.  Thanks.
  • Menno T Bauman Profile Picture
    Menno T Bauman 10 on at

    I am trying to do the same thing seeyalatergator was and am in Dynamics GP 2015 R2 but the option does not seem to be there anymore, I thought I had done this last year

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans