{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Payout Records are lightweight Rebate Records which are useful in situations when you need to generate thousands of Rebate Records that represent all possible combinations of several attributes (customer, product, period, etc.). To avoid overloading the system, you can use lightweight Payout Records with a lot simpler data structure.","type":"text"}]},{"type":"paragraph","content":[{"text":"A Payout Record has the following features:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"It is an attributed object that stores the calculated rebate amount(s) (accruals) + customer (e.g., store) and product level attributes, i.e., primitive values – it is not intended for large data structures.","type":"text"},{"type":"hardBreak"},{"text":"A total of 100 generic attributes are available for this purpose.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"It has built-in fields to reference the original Rebate Record and identify the Payout Record by name, within the scope of the (top level) Rebate Record. This is the list of available built-in fields:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Field name	Label	Type
rebateRecordUN	Rebate Record	String
type	Type	String
name	Name	String
label	Description	String
startDate	Start Date	Date
endDate	End Date	Date
payoutDate	Payout Date	Date
rebateTypeUN	Rebate Type	String
status	Status	String
intgStatus	Integration Status	String
intgStatusDetails	Int. Status Details	String
intgStatusErpReference	Int. ERP Ref.	String

","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":"Field name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Label","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"rebateRecordUN","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Rebate Record","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"label","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"startDate","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Start Date","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Date","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"endDate","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"End Date","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Date","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"payoutDate","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Payout Date","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Date","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"rebateTypeUN","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Rebate Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"intgStatus","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Integration Status","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"intgStatusDetails","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Int. Status Details","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"intgStatusErpReference","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Int. ERP Ref.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]},{"type":"mediaSingle","attrs":{"layout":"center","width":89.0},"content":[{"type":"media","attrs":{"width":1920,"id":"1ed49036-06f4-46cf-a46c-7146eebfa91c","collection":"contentId-5483003946","type":"file","height":309},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Global attribute metadata, i.e., a single set of attribute meta config (not per agreement or any other level).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"There are no predefined Payout Record types or statuses. The rebate logic decides which Type and Status to initialize or update a Payout Record with. In the UI, there is an option of limited control on visibility of the records by Type and Business Roles, as well a status transitions when using the Mass-Edit functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"There is no workflow available.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Payout Records are created by a RebateRecord logic, i.e., in the context of the Rebate Record Calculation task (given that this is a background job, large amounts of records can be created). The logic bears the full responsibility for the Payout Record creation, update and deletion (by name).","type":"text"},{"type":"hardBreak"},{"text":"It has also full control over the content (field values) of the records.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Configure Payout Records","type":"text"}]},{"type":"paragraph","content":[{"text":"Payout Records definition is part of the Rebate calculation logic. Decide which attributes you want to have in your Payout Records and, in the logic, map payout record attributes to the corresponding original rebate record attributes.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Advanced Configuration Options","type":"text","marks":[{"type":"link","attrs":{"href":"https://pricefx.atlassian.net/wiki/spaces/UNITY/pages/5483200961"}}]},{"text":", create an entry with the name payoutRecordsConfiguration. Make the following settings:","type":"text"},{"type":"hardBreak"},{"text":"Name = ","type":"text"},{"text":"payoutRecordsConfiguration","type":"text","marks":[{"type":"code"}]},{"type":"hardBreak"},{"text":"Value = ","type":"text"},{"text":"{ \"validToFromStateTransitions\": { \"Approved\": [ \"Pending\" ], \"Denied\": [ \"Pending\" ], \"Paid\": [ \"Approved\" ] }, \"businessRolesConfig\": { \"SALES\": { \"types\": [ \"Accrual\" ], \"canEdit\": true }, \"ADMIN\": { \"types\": [ \"Summary\" ], \"canDelete\": true } }, \"editableFields\": [ \"payoutDate\", \"endDate\", \"status\", \"attribute1\", \"attribute3\" ] }","type":"text","marks":[{"type":"code"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Visibility and editability by record type and business roles:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set up business roles if you want to limit visibility/editability to only some groups of users.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add a ","type":"text"},{"text":"type2BusinessRoles","type":"text","marks":[{"type":"em"}]},{"text":" entry in the configuration value, mapping record type(s) to the business role(s) that a user is required to have (a user only needs to have one of the roles listed).","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define the set of statuses and allowed transitions:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define the set of statuses in the ","type":"text"},{"text":"validToFromStateTransitions","type":"text","marks":[{"type":"em"}]},{"text":" entry.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Define valid status transitions by mapping each status to the set of statuses it can be transitioned from. In the example above a record can move from Pending to Approved and Denied and from Approved to Paid.","type":"text"},{"type":"hardBreak"},{"text":"You can use this property in mass edit operation where it filters out records which are ","type":"text"},{"text":"not","type":"text","marks":[{"type":"em"}]},{"text":" in a state that is allowed to transition to the \"to-state\" (if defined) passed in by the user.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n\"validToFromStateTransitions\": {\n\"Approved\": [ \"Pending\" ],\n\"Denied\": [ \"Pending\" ],\n\"Paid\": [ \"Approved\" ]\n},\n\n\"businessRolesConfig\": {\n\"RebateAdmin\" : {\n\"types\" : [\"Accrual\"],\n\"canEdit\" : true\n},\n\n\"FinancialAdmin\" : {\n\"types\" : [\"Summary\"],\n\"canDelete\" : true\n}\n},\n\n\"editableFields\" : [\"payoutDate\", \"endDate\", \"status\", \"attribute1\", \"attribute10\"]\n}","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"It is important to note that these limitations do not apply to the Rebate Record. Visibility of records is applied to the Payout Record data grid in the UI, while status transition control is applied to Mass-Edit of the record.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add Payout Record generation code to your Rebate calculation logic.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"def rr = ... // get a rebate record from which to initialize some payout record attributes from\ndef customer = rr.attribute1\ndef accrual = rr.attribute3\n// breakdown the accruals by store (while for ex. the rebate record level's accrual is on customer level)\nfor (def store : stores) {\n\tdef storeAccrual = ..... // some breakdown calculation\n\tpayoutRecords.add(\"Accrual\", store, [attribute1: customer, attribute2: storeAccrual , attribute3: rr.attribute5] )\n}\npayoutRecords.add(\"Summary\", \"Total\", [attribute1: customer, attribute2: accrual] )\n","type":"text"}]},{"type":"paragraph","content":[{"text":"See also the ","type":"text"},{"text":"API documentation","type":"text","marks":[{"type":"link","attrs":{"href":"https://qa.pricefx.eu/pricefx-api/groovy/master/net/pricefx/formulaengine/PayoutRecordManager.html"}}]},{"text":" for the complete list of available methods.","type":"text"},{"type":"hardBreak"},{"type":"emoji","attrs":{"id":"atlassian-warning","text":":warning:","shortName":":warning:"}},{"text":" Note that the 'payoutRecords' binding is only available from a Rebate Record calculation context, i.e., the logic that calculates rebate records in a ","type":"text"},{"text":"Rebate Record Calculation","type":"text","marks":[{"type":"link","attrs":{"href":"https://pricefx.atlassian.net/wiki/spaces/UNITY/pages/5482217871"}}]},{"text":" task (one default task is created automatically for every Rebates module implementation).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to ","type":"text"},{"text":"Rebates","type":"text","marks":[{"type":"strong"}]},{"text":" > ","type":"text"},{"text":"Rebate Calculations","type":"text","marks":[{"type":"strong"}]},{"text":" and edit the default calculation task or create a new one. The logic with the Payout Record generation code must be selected in the Logic drop-down list on the Calculation tab. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Run the Rebate Calculation task.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Once the calculation is finished, the Payout Records are available on the ","type":"text"},{"text":"Rebates","type":"text","marks":[{"type":"strong"}]},{"text":" > ","type":"text"},{"text":"Payout Records","type":"text","marks":[{"type":"strong"}]},{"text":" page. It is a single page with a filterable data grid.","type":"text"}]}]}]}],"version":1}

Browser not supported