9/13/2023 0 Comments Microsoft dynamics gp price list![]() Table Partitioningįirstly the rows are grouped together by the common factor each output row should be sharing. From experience, one company this solution is used with has 1,623,586 rows in the price table IV00108. This is unreadable to humans once you get, say 15,000 products, five currencies and ten or so price levels. Each row contains, the item sku, Currency of the price list, price list name, unit of measure, quantity break range and price. Natively the prices are held in the table IV00108 of your company database. Two key SQL server functions that many people I find are not familiar with but are vital for this kind of data manipulation are “ ROW_NUMBER()” and “ PARTITION BY”, one way to learn is to dive in with an example. ![]() These results may be squirted into excel with more columns as described by your business requirements. ![]() ![]() The following example assumes you know how many price breaks you have in your price lists and will result in output something like the following screen shot. It is possible to do this with a SQL table function to extract the prices from GP with price breaks. No doubt your sales team want to go on the road with a human friendly version of your prices for the customers to read. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |