{"type":"doc","content":[{"type":"paragraph","content":[{"type":"placeholder","attrs":{"text":"\n*****************************************************\n*****************************************************\n*****************************************************\n*****************************************************\n*****************************************************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n\nThis Confluence article was automatically generated from Asciidoc. Any changes you make to this document will be overridden!\n\nIf you want to change the content, consider leaving a comment.\n\nYou can edit the content directly here: https://gitlab.pricefx.eu/training/pricefx-knowledge-base/-/tree/dev/public/content/docs/concepts/price-lists/matrix-price-lists\n\n*****************************************************\n*****************************************************\n*****************************************************\n*****************************************************\n*****************************************************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n********************** WARNING **********************\n"}}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"User Story","type":"text"}]},{"type":"paragraph","content":[{"text":"\"As a Pricing Manager, I want to be able to pre-calulate regional online prices for products in all different volume tiers, so that we can publish all the prices already precalculated.\"","type":"text"}]},{"type":"paragraph","content":[{"text":"Generally, the use case covers many scenarios, where a ","type":"text"},{"text":"single product can have multiple prices","type":"text","marks":[{"type":"strong"}]},{"text":", for various:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Region/Country — The product is priced differently in different parts of the world.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Customer — Different customers pay different prices.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Volume Tiers — The price per product gets lowered as one purchases more items.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Solutions","type":"text"}]},{"type":"paragraph","content":[{"text":"Generally there are several solutions to how to implement this in Pricefx:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Multiple Price Lists","type":"text","marks":[{"type":"strong"}]},{"text":" — For example, there could be one Price List for France and another separate Price List for Germany. To identify which country the Price List is created for, there are several options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Naming convention","type":"text","marks":[{"type":"strong"}]},{"text":" of the ","type":"text"},{"text":"Price List name","type":"text","marks":[{"type":"strong"}]},{"text":" — for example, the name of the Price List could contain the ID of the customer.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Price List column holding the parameter value","type":"text","marks":[{"type":"strong"}]},{"text":" for which the price varies over — for example,\nif the price varies for different customers, a new Price List could be created for each\ncustomer and a column in the Price List would contain the customer ID.\nAll the cells in this column would contain the same value.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

SKU	Customer Id	List Price
MB-0001	CD-00001	4,74 €
MB-0002	CD-00001	17,60 €
MB-0003	CD-00001	21,36 €
…	…	…

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"SKU","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Customer Id","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"List Price","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"MB-0001","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CD-00001","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"4,74 €","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"MB-0002","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CD-00001","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"17,60 €","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"MB-0003","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CD-00001","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"21,36 €","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"…","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"…","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"…","type":"text"}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Customer assignment","type":"text","marks":[{"type":"strong"}]},{"text":" - A Price List can be assigned to a specific customer (but only after it has been created). This is a special use case that only works when the prices vary for different customers, i.e., it could not be used for country Price Lists.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":90.0},"content":[{"type":"media","attrs":{"width":1840,"alt":"pricelist assign to customer button","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/pricelist-assign-to-customer-button.png","height":512}},{"type":"caption","content":[{"text":"Figure 1. From the page where all the Price Lists are displayed, the Price Lists can be \"assigned\" to a customer","type":"text"}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a ","type":"text"},{"text":"Regular Price List","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":", where ","type":"text"},{"text":"one line","type":"text","marks":[{"type":"strong"}]},{"text":" will hold ","type":"text"},{"text":"more prices","type":"text","marks":[{"type":"strong"}]},{"text":" for single SKU - prices for different regions/tiers are in different ","type":"text"},{"text":"attribute","type":"text","marks":[{"type":"em"}]},{"text":" collumns. You are limited to 100 ","type":"text"},{"text":"attribute","type":"text","marks":[{"type":"em"}]},{"text":" columns here, but it’s enough in most cases.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a ","type":"text"},{"text":"Matrix Price List","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":", where ","type":"text"},{"text":"each SKU","type":"text","marks":[{"type":"strong"}]},{"text":" can appear repeatedly on ","type":"text"},{"text":"multiple lines","type":"text","marks":[{"type":"strong"}]},{"text":" in the ","type":"text"},{"text":"same Price List","type":"text","marks":[{"type":"strong"}]},{"text":", each time for different customer/region/tier etc.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"What is a Matrix Price List","type":"text"}]},{"type":"paragraph","content":[{"text":"A ","type":"text"},{"text":"Matrix Price List","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" is a Price List with two keys:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Primary key: SKU","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Secondary key: Any other dimension such as ","type":"text"},{"text":"country","type":"text","marks":[{"type":"em"}]},{"text":", ","type":"text"},{"text":"quantity tier","type":"text","marks":[{"type":"em"}]},{"text":", ","type":"text"},{"text":"customer id","type":"text","marks":[{"type":"em"}]},{"text":", etc.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Each product can appear on multiple rows in the same Price List. Each combination of the ","type":"text"},{"text":"sku","type":"text","marks":[{"type":"em"}]},{"text":" + ","type":"text"},{"text":"secondary key","type":"text","marks":[{"type":"em"}]},{"text":" has to be unique.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"If more than two keys are needed, for example a combination of ","type":"text"},{"text":"SKU","type":"text","marks":[{"type":"em"}]},{"text":" + ","type":"text"},{"text":"Region","type":"text","marks":[{"type":"em"}]},{"text":" + ","type":"text"},{"text":"Tier","type":"text","marks":[{"type":"em"}]},{"text":", you can concatenate the values of ","type":"text"},{"text":"Region","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"Tier","type":"text","marks":[{"type":"em"}]},{"text":" and use the concatenated value as the 2nd key.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example","type":"text"}]},{"type":"paragraph","content":[{"text":"In the example below, the ","type":"text"},{"text":"Volume Break","type":"text","marks":[{"type":"em"}]},{"text":" is a secondary key.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":90.0},"content":[{"type":"media","attrs":{"width":2082,"alt":"PriceGrid Final","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/PriceGrid_Final.png","height":632}}]},{"type":"paragraph","content":[{"text":"Different products have different volume breaks and different discount. The prices are calculated based on the combination of the ","type":"text"},{"text":"SKU","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"Volume Break","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The Volume Breaks could be defined in a Pricing Parameter:","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"59f455df-55a1-4deb-bf97-2507b21e32fd"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Product Group","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Volume Break","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Volume","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Discount","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":3},"content":[{"type":"paragraph","content":[{"text":"Meatball","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"VB-001","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0 %","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"VB-005","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"5","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"3 %","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"VB-020","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"20","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"8 %","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":2},"content":[{"type":"paragraph","content":[{"text":"Sausage","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"VB-001","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0 %","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"VB-005","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"5","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"2 %","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"How to Implement Matrix Price List","type":"text"}]},{"type":"paragraph","content":[{"text":"In order to be able to implement Matrix Price List, the following needs to be prepared in the partition:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix Logic","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" - Calculates values for the secondary key.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Price List Logic","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":" - Price List Line Item logic which calculates results based on both - ","type":"text"},{"text":"SKU","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"SecondaryKey","type":"text","marks":[{"type":"em"}]},{"text":" values.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"When the ","type":"text"},{"text":"business user","type":"text","marks":[{"type":"strong"}]},{"text":" creates a new Price List definition, the following needs to be specified in the ","type":"text"},{"text":"Set Parameters","type":"text","marks":[{"type":"em"}]},{"text":" steps:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix Logic — A reference to the Matrix Logic.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix Logic Element — The element.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":2283,"alt":"image 2020 09 02 14 28 48 718","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/image-2020-09-02-14-28-48-718.png","height":1091}}]},{"type":"paragraph","content":[{"text":"For the next code demonstration, we will expect the following Company Parameter","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":60.0},"content":[{"type":"media","attrs":{"width":1266,"alt":"PriceParameter VolumeTiers","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/PriceParameter_VolumeTiers.png","height":644}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Process of Execution","type":"text"}]},{"type":"paragraph","content":[{"text":"When the user starts the calculation, the Calculation Engine leverages both logics in certain order.\nReview the diagram to understand the flow of execution of the two different logics used in the Matrix Price List process.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":601,"alt":"matrix pricelist process.drawio","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/matrix-pricelist-process.drawio.svg","height":711}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Matrix Logic","type":"text"}]},{"type":"paragraph","content":[{"text":"Is a standalone logic, which provides values for the Secondary Key column of the Price List for one particular SKU.\nIt’s executed by the system each time, when the system adds new SKU into the Price List.\nThe system places the SKU, for which it needs the list of secondary key values, into the Context, and then it executes the Matrix logic.\nSo the Matrix logic can simply read the SKU from the Context or use API functions, which use the information implicitly.","type":"text"}]},{"type":"paragraph","content":[{"text":"The logic element, which returns the list of values, must have DisplayMode set to either “Price Lists” or “Everywhere”.\nThe element to be used for the Price List, will be set up by the business user while creating the Price List.","type":"text"}]},{"type":"paragraph","content":[{"text":"To create a new Matrix logic:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In IntelliJ, on the ","type":"text"},{"text":"Project","type":"text","marks":[{"type":"em"}]},{"text":" tool window, right-click on the project name and select ","type":"text"},{"text":"Pricefx","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"›","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Create Calculation Logic","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":476,"alt":"MatrixPL CreateLogic","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/MatrixPL-CreateLogic.png","height":362}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This will generate an updated formulaNature value:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":331,"alt":"MatrixPL FormulaNature","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/MatrixPL-FormulaNature.png","height":210}}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Next, we would need to identify the value that will be used for the secondary key of the matrix. For example, if based on the Region and Business Unit there was a volume breakpoint defined in a company parameter table:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"def region = input.Region //❶\ndef businessUnit = api.product(\"BusinessUnit\") //❷\n\nif (region != null && businessUnit != null) {\n\n def volumeBreaks = api.findLookupTableValues(\"VolumeBreaks\", \"VolumeBreak\",\n Filter.equal(\"Region\", region),\n Filter.equal(\"BusinessUnit\", businessUnit)\n )?.key3\n\n return volumeBreaks //❸\n\n} else {\n api.throwException(\"Region was not specified or product's Business Unit not found.\")\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"❶ Input value was entered by the business user during preparation of the Price List (the value is passed to the Matrix Logic via context).","type":"text"},{"type":"hardBreak"},{"text":"❷ We can use the value of SKU, because it’s provided in the context.","type":"text"},{"type":"hardBreak"},{"text":"❸ Return the list of values for the secondary key.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Price List Logic Leveraging the SecondaryKey Value","type":"text"}]},{"type":"paragraph","content":[{"text":"The use of the ","type":"text"},{"text":"api.getSecondaryKey","type":"text","marks":[{"type":"code"}]},{"text":" method is the same as using ","type":"text"},{"text":"api.currentItem(\"key2\")","type":"text","marks":[{"type":"code"}]},{"text":" (just remember, that api.currentItem() works only, when the item already exists) and it retrieves the secondary key field (in this case \"key2\") of a \"matrix record\" -\nit is a standard Price List line item logic and used to calculate the results based on the combination of the ","type":"text"},{"text":"SKU","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"SecondaryKey","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The value of the ","type":"text"},{"text":"SecondaryKey","type":"text","marks":[{"type":"em"}]},{"text":" is only available for execution in the Price List / LPG and not when testing the logic in Studio.\nSo for testing purposes, we will create one additional input (which will only be available in Studio):","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"if (!api.isDebugMode()) {\n\n return api.getSecondaryKey() // ❶\n\n} else {\n\n if (api.isInputGenerationExecution()) {\n api.option( // ❷\n \"VolumeBreak\",\n api.findLookupTableValues(\"VolumeBreaks\", \"VolumeBreak\")?.key3?.unique()\n )\n } else {\n return input.VolumeBreak\n }\n\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"❶ Reading the value of SecondaryKey column of the line item, only works in \"real\" execution.","type":"text"},{"type":"hardBreak"},{"text":"❷ So, during testing phase, we build additional input, so that you can select the value of Volume Break manually.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Additional Setting while Creating a New Matrix Price List","type":"text"}]},{"type":"paragraph","content":[{"text":"When the business user creates new Matrix Price List, they need to select both the Matrix logic and Matrix Element. Below, we show how at Price List creation time the Price List type of ","type":"text"},{"text":"MATRIX","type":"text","marks":[{"type":"strong"}]},{"text":" is selected:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":90.0},"content":[{"type":"media","attrs":{"width":2060,"alt":"NewGrid Step1","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/NewGrid_Step1.png","height":972}}]},{"type":"paragraph","content":[{"text":"As we continue to define the PL parameters, we can define the matrix logic and the logic element. In the following example, the setting specific for matrix will be:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix logic: \"PG_MatrixPriceGrid_Matrix\"","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix logic Element: \"Volume Breaks\"","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":90.0},"content":[{"type":"media","attrs":{"width":2060,"alt":"NewGrid Step3","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/NewGrid_Step3.png","height":1622}}]},{"type":"paragraph","content":[{"text":"Let’s describe here the most important parameter values defined on this panel:","type":"text"}]},{"type":"paragraph","content":[{"text":"Built-in Input Parameters","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Dynamic item mode: ","type":"text"},{"text":"Add & remove","type":"text","marks":[{"type":"em"}]},{"text":".\nThe requirement was to have the list of products in sync with the products available in the Product Master.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Default pricing logic: ","type":"text"},{"text":"PG_MatrixPriceGrid","type":"text","marks":[{"type":"em"}]},{"text":".\nThis is your line item logic.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix logic: ","type":"text"},{"text":"PG_MatrixPriceGrid_Matrix","type":"text","marks":[{"type":"em"}]},{"text":".\nThis is your ","type":"text"},{"text":"matrix","type":"text","marks":[{"type":"em"}]},{"text":" logic, which will supply the values for secondary keys.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Matrix logic element: ","type":"text"},{"text":"Volume Breaks","type":"text","marks":[{"type":"em"}]},{"text":"\nThis is the element, which actually returns the list of values.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Result Price: ","type":"text"},{"text":"List Price","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"paragraph","content":[{"text":"Custom Input Parameters","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Region: ","type":"text"},{"text":"Europe","type":"text","marks":[{"type":"em"}]},{"text":".\nThis input is created by the line item logic, and the user will select here, for which region are the prices in the LPG used.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Outputs, which are mapped to the Price List Line Items","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Output Elements: Select all your visible elements of the line item logic, the customer wants to see all the intermediate results.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"After calculation, the final “Matrix” Price List could look like this:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":90.0},"content":[{"type":"media","attrs":{"width":2082,"alt":"PriceGrid Final","type":"external","url":"https://pricefx.vercel.app/content/docs/concepts/price-lists/matrix-price-lists/images/PriceGrid_Final.png","height":632}}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"References","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Documentation","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"How to Create new Pricelist (and Matrix Pricelist)","type":"text","marks":[{"type":"link","attrs":{"href":"https://knowledge.pricefx.com/display/UNITY/How+to+Create+a+Price+List"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"How to Create and configure new LPG (and Matrix LPG)","type":"text","marks":[{"type":"link","attrs":{"href":"https://knowledge.pricefx.com/display/UNITY/How+to+Create+and+Configure+New+LPG"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Knowledge Base","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"How to Create a Matrix Price List","type":"text","marks":[{"type":"link","attrs":{"href":"https://knowledge.pricefx.com/display/KB/Create+a+Matrix+Price+List"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Groovy API","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Object pricelist(","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":"String","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":" listName, ","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":"String","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":" attributeName, ","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":"String","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":" sku, ","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":"String","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]},{"text":" key2)","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.pricefx.eu/api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#pricelist(java.lang.String,java.lang.String,java.lang.String,java.lang.String)"}}]}]}]}]}],"version":1}