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 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
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)
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.
#1
André Arnaud de Cal...
293,020
Super User 2025 Season 1
#2
Martin Dráb
231,837
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
