# Changelog
All notable changes to this project will be documented in this file.


## [Released]
## [14.1.0-600-f43ad93] - 24/02/2023


### Enhancements - Core
#INTRD-12047 - [JPA] Performance issue on Subscription API 
#INTRD-12580 - Review the need for em.flush() and service.commit()
#INTRD-13213 - [Performance] API /v2/mediation/cdrs/chargeCdrList
#INTRD-13386 - Job errors on application startup

### Enhancements - Portal
#INTRD-13406 - [MACO/Portal] : Update API Maco

### Issues - Core
#INTRD-10571 - CLONE - [NSBF] Problème génération xml suite à la création d'une facture détaillée via l'interface
#INTRD-11041 - V13.1.1 - Performance issue on FRAMEWORK AGREEMENTS
#INTRD-11694 - V13.2 - XLSX export price matrix export ERROR- value shift
#INTRD-11768 - cannot create a framework agreement if sub starts before
#INTRD-11844 - CLONE - V13.1.1 - Price grid succession problems
#INTRD-11875 - [back] Invoice line job doesn't apply aggregation setting
#INTRD-11977 - Exceptionnal Billing Run - Impossible to use the filter with Usage DATE
#INTRD-12013 - display of product from order - reinstantiation of a terminated product
#INTRD-12065 - [Accessible Entities] - Generic API syntax which is not supported when enabling accessible entities
#INTRD-12096 - Error on Production - Out of range integer
#INTRD-12111 - discounts on offer or product not taken into account
#INTRD-12199 - Deactivation of Control : \Price plan's period should not be before contract's start date\
#INTRD-12256 - [INT][11.1.10+] SQL error, when application start
#INTRD-12291 - RT_JOB Aggregation ERROR javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
#INTRD-12327 - dataset non utf8?
#INTRD-12463 - [back][data] Missing default articles configuration
#INTRD-12473 - Error when publishing the quote offer
#INTRD-12710 - REVERT WO saving in RatingService.rateCharge since it raises error: org.hibernate.TransientPropertyValueException
#INTRD-12723 - Job category ???jobCategoryEnum.ordering??? ???jobCategoryEnum.ordering???
#INTRD-12724 - commercial number 180f290a-17c5-475d-8564-957d4ee1e93c
#INTRD-12727 - TriggerCollectionPlanLevelsJob_Job : From email is missing, email sending skipped
#INTRD-12747 - [Back] Exceptional invoicing creates 3 invoices where 2 shouldn't
#INTRD-12764 - [BACK] error while evaluating invoice amount expression
#INTRD-12794 - [back][api] Failed to instantiate products in subscription: charge instance already exists
#INTRD-12795 - [back][api] Order validation: java.lang.ClassCastException
#INTRD-12798 - Quote: quantity of 0,5 is not allowed
#INTRD-12806 - [JOB] unavailable record configuration and descriptor script
#INTRD-12808 - As a user I want to be able to update a published product version
#INTRD-12825 - [back] Arjuna doesn't want me to delete a tax mapping
#INTRD-12826 - \Priority\ Attribute on price plan
#INTRD-12830 - cannot change offer
#INTRD-12835 - Back- validation EL is mandatory for type=EL and the same for Script (Rule creation)
#INTRD-12851 - Invoice is not validated well by CompareInvoiceAmount (amount is always validated)
#INTRD-12859 - cannot change offer
#INTRD-12881 - cannot remove electronic billing: 
#INTRD-12884 - ADMIN - Impossible to navigate / create / update etc. on Administration - > Entity customization
#INTRD-12886 - Subscription - patch/ version must not trigger CREATE SUB notification
#INTRD-12895 - [Dunning] - Sellers email
#INTRD-12901 - RTE Request URI: /opencell/pages/admin/job/invoiceJobErrors.jsf
#INTRD-12902 - menu Entities not working
#INTRD-12903 - APIv2PermissionsSyncJob NPE
#INTRD-12905 - job DunningCollectionPlanJob: return result processed not threads
#INTRD-12913 - Rating price plan lines ordering and priority
#INTRD-12925 - [back] Script doesn't use trading language codes for translations
#INTRD-12966 - [AO] - AO status is wrong (checked reason on DB)
#INTRD-12968 - Invoicing_Job_V2 KO 
#INTRD-12972 - [FrAgs] - Contract date field
#INTRD-12995 - [JOB] credit note creation doesn't generate adj. invoice
#INTRD-13006 - EDR event versioning and Rerate Job
#INTRD-13013 - [back] Incorrect script names: trailing \Script\
#INTRD-13065 - [back] change type of InvoiceValidationRule.validationScript to ScriptInstance and resolve impact
#INTRD-13073 - [Back] API Download a file does not work
#INTRD-13075 - [Lettering] - Missing lettering in the report
#INTRD-13104 - API - entityCustomization iis forbidden with opencell.admin
#INTRD-13105 - BR Exceptionnal - Not working
#INTRD-13107 - Front Portal- Impossible to access to data with opencell.admin
#INTRD-13142 - |rounding rules] : JAVA limitation on the use of the BigDecimal builder
#INTRD-13151 - [back] Impossible to create invoice for a customer without a seller, even if seller is set on invoice
#INTRD-13153 - [BACK][API] forbid product code update when product is already Activated
#INTRD-13175 - \isRateTriggeredEdr\: \true\ --> Misbeahvior with the API chargeCdrList
#INTRD-13178 - [Quote] - Unable to publish quote version
#INTRD-13192 - [Reg | BACK] abnormal behavior on service instance creation
#INTRD-13220 - Order amendement does not support product multi-instantiation
#INTRD-13253 - the given endDate 2022-12-31 is incorrect , the endDate must be greater than today
#INTRD-13260 - email sender must be changed
#INTRD-13267 - mass customer import as ZIP: nothing happens
#INTRD-13268 - org.meveo.admin.exception.PaymentException: No payment gateway for customerAccount:OPENSOFT-11
#INTRD-13297 - [CreateOrUpdateCRMAccountHierarchy API] - create or update account Hierachy with paymentMethod 'DIRECTDEBIT'
#INTRD-13307 - Webhook does't support EL
#INTRD-13313 - [Reg] Unit price is 0 on an invoice generated by a BR
#INTRD-13338 - Rerate Job en EDR versionning with more than 3 versions of the EDR injected
#INTRD-13339 - cannot modify the label of an invoicing plan
#INTRD-13340 - all invoices in draft although validated
#INTRD-13344 - [ContactApi] - Error when update contact
#INTRD-13346 - [API] json formatting exceptions on generic api
#INTRD-13394 - [back] Processing a REJECTED billing run should re-check all invoices 
#INTRD-13413 - create customer, set as Enterprise, all is ok on portal, but displayed as individual in invoice
#INTRD-13445 - Rerate_Job Error on Evaluation new charge from version 2 of EDR
#INTRD-13449 - null in quote price columns
#INTRD-13464 - [BACK] execute query on background doesn't function
#INTRD-13484 - [Reg] converted unit price is wrong when the rate applied is not the current one
#INTRD-13485 - [Reg] the manually applied tax rate on an invoice line is not used
#INTRD-13517 - Exceptionnal Billing Run - Missing Subscription ID information at the Invoice LINE
#INTRD-13518 - Aggregation RTs , come fields are NULL
#INTRD-13532 - [Wallet operations] org.hibernate.QueryException: could not resolve property
#INTRD-13541 - Rerate_Job Error on New Trigger EDR from version more than 2 of EDR
#INTRD-13608 - remove the report DWH_Job_CHURN
#INTRD-13629 - [back][db init] Incorrect filter for default billing cycles
#INTRD-13646 - Make not mandatory E-invoicing fields
#INTRD-13722 - Malfunction of Sub_Status_Job
#INTRD-13786 - [API] batch exception when generating an invoice for OS charge 
#INTRD-13814 - [Regression][price-matrix] Error : org.jboss.as.ejb3@26.1.2.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx ......
#INTRD-13819 - InvoiceLinesJobBean::addExceptionalBillingRunData missing rt.status assignement in query.
#INTRD-13826 - details of invoice are not consistent when price change for the same label
#INTRD-13835 - V14.0.1 : API DELETE data from Custom Table returns ERROR
#INTRD-13836 - SEPA request lot generation
#INTRD-13900 - [reg] Unable to generate an invoice from open RTs
#INTRD-13910 - invoice line job : null
#INTRD-13956 - Error when trying to export reports (NullPointerException)
#INTRD-13958 - Error when creating adjustement
#INTRD-14017 - [Reg | API | GUI] runtime exception when executing the query
#INTRD-14067 - [14.1.0] Add Counters in Charges / Impossible to add and save pre-configured counters.
#INTRD-14116 - Unable to activate contracts in some cases
#INTRD-14136 - [API | GUI] correct the attribute types verification
#INTRD-14167 - [back] Discount matrix doesn't apply if not \separate\ and discount matrix doesn't care about product attribute values
#INTRD-14186 - [Reg | API] display only selected fields in query results
#INTRD-14213 - Price simulation is wrong when the attribute value is not set
#INTRD-14310 - Update END DATE of PriceVersion on PORTAL ERROR
#INTRD-8564 - Exceptionnal Billing Run with SQL ERROR : .SQLGrammarException: could not extract ResultSet // Caused by: org.postgresql.util.PSQLException: ERROR: column rt.article_id does not exist
#INTRD-9157 - [front] On the login page Opencell icon is too close to border

### Issues - Portal
#INTRD-10128 - exceptional bill run save requires new mandatory fields but impossible to set
#INTRD-10972 - [OO] - General settings (design non-sens)
#INTRD-10976 - Charges / Change Name and Description / FAILED and Uncompleted or Unexplicit Error message
#INTRD-10998 - Error when reactivating a product from the product instance screen
#INTRD-11008 - [Invoicing plan] list view search bar
#INTRD-11172 - The breadcrumb appears with a bug, after having duplicated the charges.
#INTRD-11281 - Accounting period settings
#INTRD-11309 - CLONE - price should be allowed all decimals
#INTRD-11977 - Exceptionnal Billing Run - Impossible to use the filter with Usage DATE
#INTRD-12012 - Performance issue on Subscription display
#INTRD-12028 - filter on status KO for DRAFT
#INTRD-12311 - Impossible to delete an access point for a subscription.
#INTRD-12361 - Entering End Date of Published Product Version is not allowed
#INTRD-12367 - customer name missing
#INTRD-12376 - Check the fields validity on the product 0 / Products list is not valid
#INTRD-12435 - CF displays problem : can superpose value and description
#INTRD-12473 - Error when publishing the quote offer
#INTRD-12592 - [Front] Don't try to load the app-role.json file if APP_ROLES_CONFIGURATION_FILE_PATH is empty
#INTRD-12658 - [Reg] Something went wrong when adding a new quote offer
#INTRD-12680 - cannot create a line on an order draft or new
#INTRD-12695 - [Reg] Error on invoices screen
#INTRD-12706 - export list is missing name
#INTRD-12708 - wrong customer name display
#INTRD-12712 - [Front] Simulation is not working in price matrix screen
#INTRD-12724 - commercial number 180f290a-17c5-475d-8564-957d4ee1e93c
#INTRD-12730 - on a new invoice line I must be able to set a quantity that is not a round number
#INTRD-12750 - MATCHED status color error
#INTRD-12754 - [Reg] For input string: \false\ when opening a product instance
#INTRD-12770 - cannot modify text: The following parameters are required or contain invalid values: calendar
#INTRD-12778 - The customer's seller is not propagated when creating a new subscription from the customer view
#INTRD-12787 - main.babe9c4c.chunk.js:1 GET https://bugbounty.oc-sb.eu/opencell/api/rest/admin/files/downloadFile?file=app-roles.json 500
#INTRD-12789 - customer not displayed on collection plan
#INTRD-12793 - article ID instead of article label
#INTRD-12801 - [GUI] invalid subscription templates
#INTRD-12812 - [Customer 360 Invoice tab] The yellow overlay is applied to the description, when searching by invoice number
#INTRD-12826 - \Priority\ Attribute on price plan
#INTRD-12829 - order: The quantity for product code PR_BUILD_RUN_RECURRING must be great than 0
#INTRD-12839 - duplicate offer with code change
#INTRD-12841 - missing customer name on invoice view
#INTRD-12850 - [GUI] unmarking whole results throws an exception
#INTRD-12854 - access point start date must nor be mandatory
#INTRD-12878 - Invoice - Create adjustement for RT line detail is not possible : ERROR
#INTRD-12879 - [GUI] query tool advance filter corrections
#INTRD-12880 - Filter \Payment status\ not functionning well
#INTRD-12892 - [Price versions] - Status not updated on front when Published (recurring issue)
#INTRD-12897 - [C.Offer] - Picker for products
#INTRD-12914 - [Quotation] - Customer picker on quote creation
#INTRD-12915 - [Quote] - Able to modify some fields when quote in ACCEPETED status
#INTRD-12920 - missing customer name on payment log
#INTRD-12921 - [Order] - VALIDATE button available though no consumers. Missing surface check
#INTRD-12929 - translation error
#INTRD-12930 - Quotes : Wrong behavior when you delete the offer to select a new one
#INTRD-12938 - [OOQ] - Product name is false
#INTRD-12944 - [Reg | GUI] reload query action and date type adaptation
#INTRD-12964 - [FRONT] EDR settings does not appear in the portal
#INTRD-12967 - [Invoice] - Unable to select type from 360 view tab
#INTRD-12972 - [FrAgs] - Contract date field
#INTRD-12973 - Can't filter EDR by subscription
#INTRD-13007 - [GUI] resource name is undefined 
#INTRD-13008 - [GUI | API] query changes are not saved
#INTRD-13011 - [Export] - Export button not functionning in the \Accounting entries\ report
#INTRD-13015 - [Reg] Automatic logout when I log in with a user having PORTAL_USER and a specific application role
#INTRD-13023 - [Reports] Missing filter: \Lettering\
#INTRD-13026 - [front] Remove/hide Voucher feature
#INTRD-13035 - [GUI] correct the search and filter WOs by status
#INTRD-13065 - [back] change type of InvoiceValidationRule.validationScript to ScriptInstance and resolve impact
#INTRD-13074 - [reg] Invoicing plan is not displayed on the order although it's set
#INTRD-13097 - pricePlan.rangeMode.excludeTheMaxValue = false is rejecting bornes values
#INTRD-13108 - respect , and .
#INTRD-13119 - [Create quote] seller becomes empty when filling default consumer
#INTRD-13130 - [front] Breadcrumbs UNDEFINED for general settings application
#INTRD-13133 - 77.5c5a45a2.chunk.js:2 PUT https://epe.oc-sb.eu/opencell/api/rest/user 500
#INTRD-13147 - WO : allign prices always to right
#INTRD-13154 - [FRONT] do not allow product code update when its status is Activated
#INTRD-13164 - CLONE - V13.2.1 - Anomalie performance alimentation du champ \Subscription\ dans la saisie des One-shot
#INTRD-13174 - [Price Version] - After publishing, Status is not updated
#INTRD-13176 - [OOT] - product name is wrong
#INTRD-13233 - Performance issue on \Subscription\ when creating CONSUMPTION item
#INTRD-13244 - cannot create composite tax: error 500 + cannot commit
#INTRD-13256 - history on period closing is empty
#INTRD-13259 - orders: id instead of company names
#INTRD-13264 - import customers: many issue in default dataset
#INTRD-13269 - [Deposit] Getting an error when creditting a security deposit
#INTRD-13272 - [Quotes] - Amounts on quote do not respect normal convention
#INTRD-13288 - order: display code + description or code + first+last name
#INTRD-13366 - [GUI] select the default consumer for order advancement
#INTRD-13371 - [FRONT-ItNewVision] revert code on generic renderer
#INTRD-13392 - attributes: show disables does not work
#INTRD-13404 - [Reg] Cannot select Monthly Invoice Cycle 1 when creating a customer
#INTRD-13412 - changing group: can't set client category which is mandatory
#INTRD-13420 - Account operations reports cannot be exported in XLSX file
#INTRD-13460 - [Reg] Empty page when adding product article mapping line
#INTRD-13462 - [Billing account tab on Customer 360 view] - Seller field missing
#INTRD-13466 - [Order] - Consumer check is faulty
#INTRD-13581 - display problems on the red portal in production.
#INTRD-13849 - Could not apply discount plan in \Create Order\ product configuration that is in \IN USE\ status
#INTRD-13901 - [front][reg] aggregation function have disappeared
#INTRD-13912 - [GUI] order offer ignores accounting article price
#INTRD-13966 - {\status\:\FAIL\,\errorCode\:\GENERIC_API_EXCEPTION\,\message\:\java.lang.NullPointerException\}
#INTRD-13970 - [GUI | API] display the background execution results
#INTRD-14017 - [Reg | API | GUI] runtime exception when executing the query
#INTRD-14048 - Refresh issue when creating a new contract line
#INTRD-14053 - Unable to view a newly created Custom discount grid contract line
#INTRD-14054 - [front][reg] aggregation function have disappeared (again)
#INTRD-14067 - [14.1.0] Add Counters in Charges / Impossible to add and save pre-configured counters.
#INTRD-14136 - [API | GUI] correct the attribute types verification
#INTRD-14194 - GUI - Hidde Tax summary if not Price Summary 
#INTRD-14211 - [FRONT] Problem when creating an adjustment

### Story 
#INTRD-1506	[qb] Searchable and sorted available fields list
#INTRD-9192	[reports] Export of the Aged trial balance (synchronous)
#INTRD-9908	[dynBC] (3.2) Add billing cycle configuration screen Operations/Billing rules/Billing cycles - Advanced filters tab
#INTRD-9907	[dynBC] (3.1) Add billing cycle configuration screen Operations/Billing rules/Billing cycles - General tab
#INTRD-9905	[dynBC] (2) Billing cycle list on Portal (Operations/Billing rules/Billing cycles)
#INTRD-11828	[dynBC] (1.1) Add priority to Billing Cycles and billing run prioritization rules
#INTRD-11771	[adv] (10) Advance payment and multi currency - FLAWED DESGIN
#INTRD-11413	[payment] Implement Stripe recurrent SEPA payment
#INTRD-11249	[payment] Implement Stripe recurrent CB payment
#INTRD-11229	[dynBC] (3.4) Add billing cycle configuration screen Operations/Billing rules/Billing cycles - Split rules tab : group by (BA,SU,ORD) + script
#INTRD-11228	[dynBC] (3.3) Add billing cycle configuration screen Operations/Billing rules/Billing cycles - Invoicing threshold tab
#INTRD-10928	Display and sequence parameters added on offers
#INTRD-10545	[e-invoice] (2) Electronic billing - mandatory data fields in objects
#INTRD-10544	[e-invoice] (1) Electronic billing - mandatory data table
#INTRD-12354	[dynBC] (4.1) Delete billing cycle from billing cycle page
#INTRD-12232	[dynBC] (4) Create a new billing cycle from billing cycle list
#INTRD-12016	[FRONT] cache management to portal/tunnel/selfcare
#INTRD-11946	[order oso] (6) FRONT - Displaying and Filtering Order Number at Customer Rated Item Tab 
#INTRD-11945	[order oso] (9) FRONT- Improve attribute displaying NAME & LIST if too many
#INTRD-11943	[order oso] (5) FRONT - Add New Order Line Type for applying One shot charge (Other)
#INTRD-11942	[order oso] (3) BACK - Order Line Type for applying one shot charge (Other) 
#INTRD-11941	[order oso] (1) FRONT- Add Custom Field Tab for Order (header level)
#INTRD-11940	[order oso] (2) BACK+FRONT - Add new One shot charge Other type dedicated for "invoice plan" usage in Order
#INTRD-11903	[adv] (6.1) List linked advances on order (with type, due date and payment status) and payment status color
#INTRD-11896	[roles] (4.3) Configuration file for Portal role-permission for App/Menu/Page (OPERATIONS)
#INTRD-11894	[roles] (4.1) Configuration file for Portal role-permission for App/Menu/Page (FINANCE)
#INTRD-12471	[order oso] (7) Front - Add Pricing synthesis at Order Line Level
#INTRD-12470	[order oso] (8) FRONT - Add Pricing synthesis at Order LEVEL
#INTRD-12276	[dynBC] (5) Update invoicing jobs to handle filter-based billing cycles
#INTRD-12545	[dynBC] (1.7) Display billing cycle type on billing run list
#INTRD-12529	[order oso] (4) BACK and FRONT - Add the configuration to allow a specific list of order line type
#INTRD-12487	[dynBC] (6) Invoice line aggregation rules on billing cycle and updated aggregation options
#INTRD-12779	[qb] Add possibility to use GenericPagingAndFiltering on QB 
#INTRD-13315	[dynBC] (7) Make Billing Cycle code optional and initialize it in backend if missing
#INTRD-13379	[invoice valid 1] (19) FIX CompareOfferLinesAmount will test all lines if offerlist is empty
#INTRD-13514	[dynBC] (9) *ABORTED* Billing cycle becomes optional on billing account
#INTRD-13513	[dynBC] (8) Allow to select split mode on billing cycle CREATE
#INTRD-13453	[contract] (0.0) Contract discounts can generate separate discount lines
#INTRD-13537	[FRONT] Fix major screens lacks, speedup performances 
#INTRD-9281	[currency] Modify exchange rate if current rate application date = today for role CFO
#INTRD-6490	[mass os] (1) New API to massively apply one shot charge