Commit Graph

3363 Commits

Author SHA1 Message Date
Layda Salas dbcfd9af14
IDEMPIERE-5437 Improve description for SysConfig SYSTEM_NATIVE_SEQUEN… (#1511)
* IDEMPIERE-5437 Improve description for SysConfig SYSTEM_NATIVE_SEQUENCE #resolve

* IDEMPIERE-5437 Improve description for SysConfig SYSTEM_NATIVE_SEQUENCE #resolve

* revert unwanted changes in launcher

* revert unwanted changes in launcher

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-09-30 12:31:33 +02:00
Nicolas Micoud c9005bd601
IDEMPIERE-5245: Fix missing capitals on first letter of elements starting with "Date..." (#1509)
https://idempiere.atlassian.net/browse/IDEMPIERE-5245
2022-09-30 12:04:13 +02:00
Nicolas Micoud 297dbc73df
IDEMPIERE-5438: Web Service Security > Access tab should allow to sel… (#1506)
* IDEMPIERE-5438: Web Service Security > Access tab should allow to select WS roles only

https://idempiere.atlassian.net/browse/IDEMPIERE-5438

* IDEMPIERE-5438: Web Service Security > Access tab should allow to select WS roles only

Role with RoleType = null can also be used for WS, so must be included in available roles

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-09-30 12:00:55 +02:00
Nicolas Micoud 98c9dfc844
IDEMPIERE-5434 : Allow to define db view component with DISTINCT (#1505)
https://idempiere.atlassian.net/browse/IDEMPIERE-5434
2022-09-30 13:52:43 +08:00
Nicolas Micoud 011ac10a4f
IDEMPIERE-5243: More columns to increase length - AD_Val_Rule.Code to 4000 (#1507)
https://idempiere.atlassian.net/browse/IDEMPIERE-5243
2022-09-30 10:33:12 +08:00
Carlos Ruiz cdf36a785f
IDEMPIERE-4297 GardenWorld Periods 2023 to 2030 (#1491) 2022-09-21 13:44:56 +08:00
Elaine Tan 0b8b7da8e5
IDEMPIERE-5396 Replace CreateFrom form with Info Window Process (#1469)
* IDEMPIERE-5396 Replace CreateFrom form with Info Window Process
2022-09-19 18:30:24 +08:00
Carlos Ruiz 08c61a7207
IDEMPIERE-3340 Fix issue not allowing to delete a user (#1485) 2022-09-14 10:26:00 +08:00
Carlos Ruiz 52e5e17fed
IDEMPIERE-5354 Manage use case for microsoft OAuth2 preferred_username (FHCA-3757) (#1483)
* IDEMPIERE-5354 Manage use case for microsoft OAuth2 preferred_username (FHCA-3757)

* IDEMPIERE-5354 Manage use case for microsoft OAuth2 preferred_username (FHCA-3757)
2022-09-13 18:57:13 +02:00
Carlos Ruiz 3c69ba56a4
IDEMPIERE-5415 Incomplete process log when output is > 2000 chars (#1476) 2022-09-11 15:22:52 +08:00
Jasper Siepkes 861e3ad01f
IDEMPIERE-5013 Implement HikariCP as a replacement for c3p0 (#926)
* Replaced PostgreSQL and Oracle connection pools with HikariCP.

Replaced C3P0 with HikariCP. HikariCP is a Apache licensed connection pool with substantially better performance and better resilience to failure (DB disconnects, etc.) then C3P0. Read more about it here: https://github.com/brettwooldridge/HikariCP .

Cleaned up the `getCachedConnection` method. With HikariCP there is no need to retry to obtain a connection since getting an connection will block until a free connection is available or until a timeout is reached (default 30 seconds) at which point an `SQLException` is thrown. This also removed calling `Runtime.getRuntime().runFinalization();`. HikariCP is currently configured to detect / log leaks when a connection hasn't returned to the pool for longer then 5 minutes.

Loading of pool config properties was cleaned up. Defaults are now loaded from a single file instead of defaults coming from both file and hardcoded properties. It is now also possible to specify any HikariCP property in the user pool property file.

Initialization of the datasource must happen in the `getDataSource()` method because at object construction not all JDBC config is known. However this method could (as far as I could tell) be called concurrently from multiple threads but had no mechanism to prevent initializing the DB pool multiple times. The variable in which the pool itself was stored (`m_ds`) also was not marked volatile or immutable which could lead to visibility issues. Instead of lazy initialization of the pool in the `getDataSource()` method the pool could probably better be initialized at object construction. However I wasn't able to achieve that without breakage therefor I made the initialization mechanism work correctly with concurrent invocations.

Various config options such as the `MaxStatementsPerConnection` options were removed because HikariCP doesn't support them.

* (Re)added Sequence time-out.
2022-09-10 12:21:57 +02:00
Peter Takács 005a1847e8
IDEMPIERE-5412 - Improve Dashboard Theme Look (#1471)
* IDEMPIERE-5412 - Improve Dashboard Theme Look

* IDEMPIERE-5412 - added message: NoDataAvailable

* IDEMPIERE-5412 - update default theme version
2022-09-09 14:55:54 +08:00
Peter Takács 27d01814e7
IDEMPIERE-5400 - Gauge Indicator Style and Color Improvement (#1470)
* IDEMPIERE-5400 - Gauge Indicator Style and Color Improvement

* IDEMPIERE-5400 - patch pr1470
2022-09-09 14:14:50 +08:00
Peter Takács 1f4a23657a
IDEMPIERE-5400 - Dashboard Goal Content should render as single Gauge Indicator (#1458)
* IDEMPIERE-5400 - Dashboard Goal Content should render as single Gauge Indicator

* IDEMPIERE-5400 - better css responsivity

* IDEMPIERE-5400 - add update goal

* IDEMPIERE-5400 - fixes

* IDEMPIERE-5400 - resolved conflict, migration fix

* IDEMPIERE-5400 - fix bad merge
2022-09-07 21:40:29 +08:00
Peter Takács ee3476c3eb
IDEMPIERE-5409 - Dashboard Content - Maximizable checkbox (#1467)
* IDEMPIERE-5409 - Dashboard Content - Maximizable checkbox

* IDEMPIERE-5409 - IsMaximizable default 'Y'

* IDEMPIERE-5393 - fixes

* IDEMPIERE-5409 - fixed script name
2022-09-07 17:00:18 +08:00
Nicolas Micoud f22d2a512f
IDEMPIERE-5342 : Increase remaining ProfileInfo columns to 4000 (#1459)
* IDEMPIERE-5342 : Increase remaining ProfileInfo columns to 4000

https://idempiere.atlassian.net/browse/IDEMPIERE-1575

* IDEMPIERE-5342 : Increase remaining ProfileInfo columns to 4000 (to v9)

moving from v10 to v9
2022-09-02 13:32:15 +02:00
Carlos Ruiz 8cd20b9e88
IDEMPIERE-5399 Data type Time is mostly useless (#1456) 2022-08-30 20:14:17 +08:00
Nicolas Micoud 79d9efb8f5
IDEMPIERE-5395 : Validation Rules at Client level (#1451) 2022-08-30 13:25:01 +02:00
Peter Takács e528c6f8cb
IDEMPIERE-5389 - Dashboard row layout (#1448)
* IDEMPIERE-5389 - Dashboard row layout

* IDEMPIERE-5389 - taking changes related to ticket 5393

* IDEMPIERE-5389 - added Flex Grow to Preference

* IDEMPIERE-5389 - fixing gadget heights

* IDEMPIERE-5389 - center alignment for Status Line

* IDEMPIERE-5389 - fall back to column layout

* IDEMPIERE-5389 - pr1448 patch

* IDEMPIERE-5389 - FixOracleMigration patch
2022-08-30 10:11:42 +02:00
Peter Takács 0aaf904e34
IDEMPIERE-5393 - Allow rendering status line as widget/gadget in dashboard (#1449)
* IDEMPIERE-5393 - Allow rendering status line as widget/gadget in dashboard

* IDEMPIERE-5393 - css class for status line

* IDEMPIERE-5393 - update default theme version
2022-08-24 15:49:06 +08:00
Peter Takács e670ebbd14
IDEMPIERE-5302 - Drill Assistant Feature with re-generated migration scripts (#1390)
* IDEMPIERE-5302 - Drill Assistant Feature with re-generated migration scripts

* IDEMPIERE-5302 - added IsShowInDrillOptions, ID fixes

* IDEMPIERE-5302 - added IsShowInDrillOptions default Y

* IDEMPIERE-5302 - creating Table Print Formats on Run Report

* IDEMPIERE-5302 - applied pr1390_fixes patch

* IDEMPIERE-5302 - applied pr1390_badimports patch
2022-08-17 18:08:45 +08:00
Layda Salas 05dcc275a9
IDEMPIERE-5372 Wrong default for IsApproved column on C_Order, C_Invo… (#1436)
* IDEMPIERE-5372 Wrong default for IsApproved column on C_Order, C_Invoice and C_CashPlan #resolve

* IDEMPIERE-5372 Wrong default for IsApproved column on C_Order, C_Invoice and C_CashPlan #resolve
2022-08-12 19:20:58 +02:00
Carlos Ruiz 5e5c977733
IDEMPIERE-5382 Allow just one MFA registration per mechanism (FHCA-3822) (#1439) 2022-08-12 17:15:28 +08:00
Alan Lescano 11962e1713
IDEMPIERE-5259 Labels feature (#1357)
* IDEMPIERE-5259 Labels feature
* IDEMPIERE-5259 Update the theme version timestamp
* IDEMPIERE-5259 Better javadoc
* Update 202205131118_IDEMPIERE-5259.sql
* Update 202205131118_IDEMPIERE-5259.sql
* IDEMPIERE-5259 New window Label Assignment
* IDEMPIERE-5259 Toggle issue
* IDEMPIERE-5259 MSysConfig is ordered alphabetically
* IDEMPIERE-5259 Default SysConfig
* IDEMPIERE-5259 Avoid duplicated records
Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-08-01 21:51:38 +02:00
Peter Takács c62a9ad066
IDEMPIERE-1965 - Implement Generate Invoices (manual) as Info Window (#1400)
* IDEMPIERE-1965 - Implement Generate Invoices (manual) as Info Window
* IDEMPIERE-1965 - fixes
* IDEMPIERE-1965 - Deprecate Form
* IDEMPIERE-1965 - backwards compatibility
* IDEMPIERE-1965 - vendor RMA form legacy
* IDEMPIERE-1965 - merge patch
* IDEMPIERE-1965 - 1965_PR patch
2022-08-01 20:41:39 +02:00
hengsin 9f22430aad
IDEMPIERE-5359 Unit test not working with Oracle (#1414) 2022-07-31 19:22:06 +02:00
Peter Takács 5918702166
IDEMPIERE-1963 - vendor RMA form legacy (#1409) 2022-07-25 16:13:56 +08:00
Carlos Ruiz cd42ba5220
IDEMPIERE-5353 Entity type field in the Column tab becomes read-only when you enter a wrong value (#1405)
IDEMPIERE-5353 # resolve
2022-07-21 17:08:05 +02:00
Nicolas Micoud 58027792d8
IDEMPIERE-5342 : Ability to hide the title of the chart when displaye… (#1392)
* IDEMPIERE-5342 : Ability to hide the title of the chart when displayed on Home page
2022-07-21 20:09:11 +08:00
Carlos Ruiz b0e7389f0a
IDEMPIERE-1963 Implement Generate Shipments (manual) as Info Window / Oracle fix (#1404) 2022-07-20 20:10:53 +02:00
Carlos Ruiz 96e0870efd
IDEMPIERE-1963 Implement Generate Shipments (manual) as Info Window / fixes (#1403) 2022-07-20 14:48:50 +02:00
Peter Takács c001169a5f
Idempiere-1963 - Implement Generate Shipments (manual) as Info Window (#1394)
* IDEMPIERE-1963 - Implement Generate Shipments (manual) as Info Window

* IDEMPIERE-1963 - reverting changes commited by mistake

* IDEMPIERE-1963 - Implement Generate Shipments (manual) as Info Window

* IDEMPIERE-1963 - patches for fixes and deprecation
2022-07-20 14:47:32 +02:00
Deepak Pansheriya dc67ae816d
IDEMPIERE-5295: Correcting oracle migration script (#1389)
* IDEMPIERE-5295: Correcting oracle migration script

* Update 202206282000_IDEMPIERE-5295.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-07-19 14:03:39 +02:00
Carlos Ruiz e4f4999220
IDEMPIERE-5295 Trial Balance Report creates wrong Opening Balance / fix oracle script - caused by mismatch in primary key name IDEMPIERE-5227 (#1387) 2022-07-08 13:48:56 +02:00
Carlos Ruiz 1846439e92 Revert "IDEMPIERE-5302 - Drill Assistant Feature (#1345)"
This reverts commit 809e3ae734.
2022-07-08 13:25:19 +02:00
Deepak Pansheriya 9a64a1a11c
IDEMPIERE-5295: Trial Balance Report creates Opening balance per orga… (#1378)
* IDEMPIERE-5295: Trial Balance Report creates Opening balance per organization and setting opening date day before from date.

* IDEMPIERE-5295: Correction as per Hengsin's code review vomment.

* IDEMPIERE-5295: Opening Balance should be on first day of Period

* IDEMPIERE-5295: Removed unused import

* IDEMPIERE-5295: Fixing report view is not set on default print format
Co-authored-by: hengsin@gmail.com
2022-07-06 19:53:15 +08:00
Peter Takács 809e3ae734
IDEMPIERE-5302 - Drill Assistant Feature (#1345)
* IDEMPIERE-5302 - Drill Assistant Feature
2022-06-30 20:08:22 +08:00
Carlos Ruiz 7246c56266
IDEMPIERE-5331 Create Production from Order (all Lines) (#1375)
* IDEMPIERE-5331 Create Production from Order (all Lines)

* Refactoring to remove redundant or unused code and parameters

* Clear the order line reference on production when voiding and reversing
2022-06-30 10:05:33 +08:00
lHeidbreder ddaf0d6af3
IDEMPIERE-4269 shipment (on availability) should be created only if products are available (#1329)
IDEMPIERE-4269 shipment (on availability) should be created only if products are available

Co-authored-by: hengsin <hengsin@gmail.com>
2022-06-29 22:15:08 +08:00
Peter Takács 5303a10da2
IDEMPIERE-5319 - Delete Record with Confirmation Logic (#1371)
* IDEMPIERE-5319 - Delete Record with Confirmation Logic

* IDEMPIERE-5319 - modified listener for more correct behavior

* IDEMPIERE-5319 - modified listener for more correct behavior

* IDEMPIERE-5319 - improved validation

* IDEMPIERE-5319 - exception, message translation, removed new buttons

* IDEMPIERE-5319 - merged validation on close
2022-06-27 11:26:38 +02:00
Peter Takács 1f9955fcc9
IDEMPIERE-2058 - ** New Report ** - improve for handling Forms too (#1335)
* IDEMPIERE-2058 - ** New Report ** - improve for handling Forms too

* IDEMPIERE-2058 - error fixed

* IDEMPIERE-2058 - dialogs added

* IDEMPIERE-2058 - latest WIP commit until final design stated

* IDEMPIERE-2058 - added cancel button, mandatory handling
2022-06-25 15:07:07 +02:00
iDempierePatch 06c41d2c68
IDEMPIERE-5300 ErrorMsg doesn't show full message + LifeTime Msg conf… (#1342)
* IDEMPIERE-5300 ErrorMsg doesn't show full message + LifeTime Msg configurable

* IDEMPIERE-5300 ErrorMsg doesn't show full message + LifeTime Msg configurable / peer review / solve issues requested by Heng Sin

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-06-24 16:34:19 +08:00
Layda Salas 34458fa8a1
IDEMPIERE-5245-ad_message Fix typos in dictionary (#1361)
* IDEMPIERE-5245-ad_message Fix typos in dictionary
2022-06-09 17:41:22 +02:00
PeterTakacs300 0dd6c2b4a9
IDEMPIERE-5304 - Missing Message from Payment (#1346)
* IDEMPIERE-5304 - Missing Message from Payment

* IDEMPIERE-5304 - replaced message type and Msg.translate method
2022-05-31 15:25:50 +08:00
PeterTakacs300 13e0c8e1a4
IDEMPIERE-5275 - Tabular Report Re-Query button/close paramater window (#1306)
* IDEMPIERE-5275 - Tabular Report Re-Query button/close paramater window

* IDEMPIERE-5275 - fix bug with asynch. threads

* IDEMPIERE-5275 - BusyMask not showing correctly fix

* IDEMPIERE-5275 - icons added

* IDEMPIERE-5275 - sysconfig added

* IDEMPIERE-5275 - patch 1306_PeerReview applied

* IDEMPIERE-5275 - requested changes applied

* IDEMPIERE-5275 - small fixes

* IDEMPIERE-5275 - fixed wrong merge
2022-05-13 22:14:59 +08:00
Carlos Ruiz 6edaf7374d
IDEMPIERE-5057 Implement Deductible and non deductible input tax for purchasing and costing / fix oracle script (#1330) 2022-05-13 11:21:50 +02:00
Carlos Ruiz f692c933da
IDEMPIERE-5287 Minor issue in 'sql where' from Window 'User Preference' (impact Report function) - thanks to Ken Longnan (#1328)
IDEMPIERE-5287 #resolve
2022-05-13 10:14:11 +08:00
hengsin a41aeb2205
IDEMPIERE-5057 Implement Deductible and non deductible input tax for purchasing and costing (#1277)
* IDEMPIERE-5057 Implement Deductible and non deductible input tax for purchasing and costing

* IDEMPIERE-5057 Implement Deductible and non deductible input tax for purchasing and costing

* IDEMPIERE-5057 Implement Deductible and non deductible input tax for purchasing and costing

- Fix rounding error
2022-05-12 11:12:05 +02:00
hengsin 9e43a36862
IDEMPIERE-5260 Enhance Discount Schema for Fixed Pricing (#1313)
* IDEMPIERE-5260 Enhance Discount Schema for Fixed Pricing

* IDEMPIERE-5260 Enhance Discount Schema for Fixed Pricing

- Fix unit test error.
2022-05-11 18:39:58 +02:00
Nicolas Micoud 416824b57c
IDEMPIERE-1575 : Increase AD_System.ProfileInfo to 4000 (#1321) 2022-05-11 18:34:35 +02:00
Carlos Ruiz 9bc016dc3d
IDEMPIERE-5288 org.zkoss.poi.POIXMLException attaching XLSX file (#1320) 2022-05-11 23:12:26 +08:00
Nicolas Micoud 440b9c27a1
IDEMPIERE-4863 : Enable save column width in WListBox - fix when panel has lots of columns (#1311) 2022-05-06 10:27:57 +08:00
hengsin a8958bf29d
IDEMPIERE-5261 Workflow EMail notification enhancement (#1299)
* IDEMPIERE-5261 Workflow EMail notification enhancement

* Update 202204190945_IDEMPIERE-5261.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-05-05 18:51:11 +02:00
hengsin e91aa9d0d3
IDEMPIERE-5082 Drop Shipment: Pass shipper and tracking number from MR to Customer Shipment (#1284) 2022-05-04 23:05:54 +02:00
Layda Salas c648eafa05
IDEMPIERE-5245 Fix typos in dictionary #resolve (#1312)
* IDEMPIERE-5245 Fix typos in dictionary #resolve

* Update 202205031611_IDEMPIERE-5245.sql

* Update 202205031611_IDEMPIERE-5245.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-05-04 12:36:06 +02:00
hengsin 3f6ec68f37
IDEMPIERE-5088 Implement Bank Transfer as Transactional Document like… (#1281)
* IDEMPIERE-5088 Implement Bank Transfer as Transactional Document like Payment

* IDEMPIERE-5088 Implement Bank Transfer as Transactional Document like Payment

- default to charge and to bpartner from the corresponding from fields
- add DateAcct, C_ConversionType_ID and IsOverrideCurrencyRate columns
- remove mandatory org linked bp requirement
- rename window to Bank/Cash Transfer and deactivate existing Bank/Cash
Transfer process.

* IDEMPIERE-5088 Change Bank Transfer Process to use (optionally) the new document

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-05-01 11:22:32 +08:00
Nicolas Micoud 5476274f59
IDEMPIERE-5265 : Wizard for Chosen Multiple Selection List editor (#1289)
* IDEMPIERE-5265 : Wizard for Chosen Multiple Selection List editor

Co-Authored-By: hengsin <152246+hengsin@users.noreply.github.com>
2022-04-28 19:48:47 +08:00
hengsin 13b37c4acc
IDEMPIERE-5093 Scheduler cron pattern scheduling is always using serv… (#1270)
* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

* minor fix for oracle/202203240830_IDEMPIERE-5093.sql

* IDEMPIERE-5093 cheduler cron pattern scheduling is always using server time zone

- add time zone comment for cronpattern field
- use fix format for elapsed time (day'hour:minutes:seconds.millisecond)
- use time zone formatting at server monitor
- include etc/gmt* timezone id. fix handling of invalid user input
- fix wrong editor (date) use for timestamp with time zone field

* IDEMPIERE-5093 cheduler cron pattern scheduling is always using server time zone

- Fix MSchedule.getNextRunMS call.

* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

- add T_Timestamp to Test table and window.
- fix date time editor doesn't capture seconds for timestamp with time
zone.
- date time editor: use tenant time zone (if set), fallback to browser
time zone.
- date time editor: fix processing of timestamp with time zone value.
- time zone editor: drop the confusing etc/gmt* entries and support
entry of GMT(+/-)hh:mm custom zone id.

* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

Fix NPE

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-04-22 21:28:51 +02:00
Nicolas Micoud d6bd0b2247
IDEMPIERE-5247 : ReportLineSet_Copy do not copy Operands (#1271) 2022-03-31 19:33:56 +02:00
Layda Salas d949963135
IDEMPIERE-5243 More columns to increase length #resolve (#1272)
* IDEMPIERE-5243 More columns to increase length #resolve

* IDEMPIERE-5243 More columns to increase length - change field clob #resolve
2022-03-31 18:46:24 +02:00
Carlos Ruiz 1eae34965f
IDEMPIERE-4753 Make printing filename configurable / peer review (#1274) 2022-03-31 15:01:09 +02:00
PeterTakacs300 a1d58852ed
IDEMPIERE-4753 Make printing filename configurable (#1251)
* IDEMPIERE-4753 Make printing filename configurable

* IDEMPIERE-4753 - Jasper report

* IDEMPIERE-4753 - fix NPE
2022-03-31 14:59:45 +02:00
Nicolas Micoud 10fca86adf
IDEMPIERE-4771 - fix typo in message (#1269) 2022-03-29 05:20:49 +08:00
Layda Salas 3f8ecbece6
IDEMPIERE-4550 Fix columns length difference between AD and DB #resolve (#1267)
* IDEMPIERE-4550 Fix columns length difference between AD and DB #resolve

* IDEMPIERE-4550 Fix columns length difference between AD and DB #resolve
2022-03-28 12:16:32 +02:00
Carlos Ruiz 78a1fdddb8
IDEMPIERE-4669 Adding RfQ responses manually is prohibited, because the field for the RfQ is read only (#1264)
IDEMPIERE-4669 #resolve
2022-03-27 10:06:17 +08:00
Carlos Ruiz f39696a02e
IDEMPIERE-5242 RfQ Issues (#1265)
IDEMPIERE-5242 #resolve
2022-03-27 10:04:32 +08:00
Carlos Ruiz b032430a4b
IDEMPIERE-3219 Reset Accounting can't reset documents without fact acct (#1266)
IDEMPIERE-3219 #resolve
2022-03-27 10:02:28 +08:00
Nicolas Micoud 0b54d2f4c6
IDEMPIERE-5241 : bugfixes for charts (#1262)
* IDEMPIERE-5241 : bugfixes for charts

fix WhereClause, WinHeight, TimeUnit (see details in ticket)

* IDEMPIERE-5214 : Bugfixes for charts - fix TabEditor when no chart is defined on field
2022-03-25 12:01:05 +01:00
hengsin 3090f2384b
IDEMPIERE-5056 Order and Invoice: Tax lookup interface (#1253)
* IDEMPIERE-5056 Order and Invoice: Tax lookup interface

* IDEMPIERE-5056 Order and Invoice: Tax lookup interface

- add default value for MSysConfig.getValue call.
2022-03-23 15:00:08 +01:00
hengsin d4532196a2
IDEMPIERE-5083 add FREIGHTCOSTRULE_CustomerAccount (#1261) 2022-03-22 19:27:04 +01:00
Nicolas Micoud 22c238e0d2
IDEMPIERE-5232 : Chart field at tenant level (#1249)
* IDEMPIERE-5232 : Chart field at tenant level

* IDEMPIERE-5232 : Chart field at tenant level - Change AccessLevel to System+Client

* IDEMPIERE-5232 : Chart field at tenant level - migration scripts to iD10

* IDEMPIERE-5232 : Chart field at tenant level - DataSource tab must be advanced

* IDEMPIERE-5232 : Chart field at tenant level - fix migration scripts

* IDEMPIERE-5232 : Chart field at tenant level - fix script
2022-03-22 18:57:53 +01:00
Carlos Ruiz 12c5c2d727
IDEMPIERE-5221 Performance - indexes on heavily used queries / FHCA-3486 (#1257) 2022-03-22 13:11:06 +08:00
Layda Salas e3a44d924d
IDEMPIERE-2975 Password Validator translations (Passay lib) / integrating patch from Tomáš Švikruha (#1259) 2022-03-19 11:56:37 +01:00
hengsin 0f0ee411eb
IDEMPIERE-5089 Add MSysConfig.ALLOW_REVERSAL_OF_RECONCILED_PAYMENT (#1254) 2022-03-18 14:48:11 +01:00
Diego Ruiz 4f5c3360fc
IDEMPIERE-5233 - Invoice created from the Commission Run window cannot be easly found after created (#1256) 2022-03-18 14:37:31 +01:00
PeterTakacs300 ccda5e4495
IDEMPIERE-5225 - HTML Report minification (#1237)
* IDEMPIERE-5225 - HTML Report minification

* IDEMPIERE-5225 - SysConfig added

* IDEMPIERE-5225 - minification default set to true
2022-03-17 15:36:02 +01:00
Nicolas Micoud 540aa7b1fa
IDEMPIERE-5168 : rebuild Oracle indexes (#1245) 2022-03-15 10:29:07 +01:00
Layda Salas d7485ea4c9
IDEMPIERE-2494 Attribute Value allowing duplicated values #resolve #fixversion 10 (#1241) 2022-03-15 09:32:31 +01:00
Carlos Ruiz 1a51e92c42
IDEMPIERE-4586 Update translation of Client to Tenant (#1233)
* IDEMPIERE-4586 Update translation of Client to Tenant

* Exclude AD_Ref_List.Name from the update as it impacts too many constants generated in X_ classes

* * update the Updated column too so that it is easier to trace back which records have been updated (as suggested by Heng Sin)

* * Update some additional messages that becomes duplicated (as reported by Nicolas)

* * Add updates to AD_Tab.CommitWarning (as reported by Nicolas)
2022-03-12 16:59:32 +01:00
hengsin 9d0eea8fe3
IDEMPIERE-5094 Implement validation for costing level change ( Accounting Schema and Product Category Accounting ) (#1235) 2022-03-11 12:43:22 +01:00
Carlos Ruiz 4510623381
IDEMPIERE-5220 Duplicated indexes in postgresql (and mismatch against oracle) / FHCA-2740 (#1229) 2022-03-09 10:36:17 +08:00
Tony Snook a2f2b0acec
IDEMPIERE-4297 Improve test data (#1228)
- Fix missing data in customer rma line (preventing completion of document) 
- Minor fixes to Order, Shipment & Invoice print formats (fit on one page)
2022-03-08 13:17:22 +01:00
Carlos Ruiz d3e74faa32
IDEMPIERE-5222 Add Attach button to report viewer (similar to Archive but with Attachment) (#1230) 2022-03-08 12:22:30 +08:00
Layda Salas dfb366f363
IDEMPIERE-1450 Translation missing for Matching Purchase Order #resolve #fixversion 10 (#1225) 2022-03-08 12:18:09 +08:00
hengsin 89a1d0cd23
IDEMPIERE-5213 Flat view improvement for menu tree (#1212)
* IDEMPIERE-5213 Flat view improvement for menu tree

* IDEMPIERE-5213 Flat view improvement for menu tree

- fix annotation warning
2022-03-04 11:03:00 +01:00
Carlos Ruiz 715dfe8192
IDEMPIERE-5202 Implement auto save of current tab / add ZK_AUTO_SAVE_TABS_EXCLUDED, exclude Request windows (#1221) 2022-03-04 15:59:53 +08:00
Layda Salas 60fb790b17
IDEMPIERE-2081 Class OrderLineCreateProduction and OrderLineCreateShi… (#1211)
* IDEMPIERE-2081 Class OrderLineCreateProduction and OrderLineCreateShipment exception messages are not translated! #resolve #fixversion 10

* IDEMPIERE-2081 Class OrderLineCreateProduction and OrderLineCreateShipment exception messages are not translated! #resolve #fixversion 10

* IDEMPIERE-2081 Class OrderLineCreateProduction and OrderLineCreateShipment exception messages are not translated! #resolve #fixversion 10
2022-03-04 09:52:28 +08:00
Carlos Ruiz 063788242c
IDEMPIERE-5218 Improvements for Record Info dialog (#1219)
* IDEMPIERE-5218 Improvements for Record Info dialog #resolve #comment Permalink as a button + new button Copy SELECT

* Use navigator.clipboard and PO.get_WhereClause - as suggested by Heng Sin
2022-03-04 09:51:43 +08:00
Nicolas Micoud 7cabc12ebd
IDEMPIERE-5214 : Add AD_Role.IsClientAdministrator (#1220)
* IDEMPIERE-5214 : Add AD_Role.IsClientAdministrator

* IDEMPIERE-5214 : Add AD_Role.IsClientAdministrator - move scripts to i9

* IDEMPIERE-5214 : Add AD_Role.IsClientAdministrator - set value for new tenants

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>
2022-03-03 16:19:54 +01:00
PeterTakacs300 32f26f8752
IDEMPIERE-5206 - HTML Report CSS style - add AD_FieldStyle_ID on AD_PrintFormatItem table (#1206)
* IDEMPIERE-5206 - HTML Report CSS style - add AD_FieldStyle_ID on AD_PrintFormatItem table

* IDEMPIERE-5206 - migration scripts

* IDEMPIERE-5206 - AD_FieldStyle_ID check, styleBuilder check added

* IDEMPIERE-5206 - moved the added code block to the right place
2022-03-03 16:13:39 +08:00
Tony Snook fa4792d530
IDEMPIERE-4297 Improve test data (#1213)
- update Fertilizer and Furniture Org/Warehouse address in Germany and France
- update vendors 'Chemical Product, inc' and 'Wood, Inc’ to address in Germany and France
- new Customer Agri-Tech based in Germany 
- new Import purchase price list in EURO
2022-03-02 14:17:44 +01:00
Nicolas Micoud 2bd20ff26e
IDEMPIERE-5168 column AD_AuthorizationAccount.AccessToken is short on some case - fix oracle script when table has data (#1210) 2022-03-02 13:55:20 +01:00
Layda Salas 31b758cd76
IDEMPIERE-2567 RfQResponseRank's message is hard coding,cannot transl… (#1205)
* IDEMPIERE-2567 RfQResponseRank's message is hard coding,cannot translaten #resolve #fixversion 10

* IDEMPIERE-2567 RfQResponseRank's message is hard coding,cannot translaten #resolve #fixversion 10
2022-03-01 16:06:22 +08:00
hengsin 1ae1aa040e
IDEMPIERE-5202 Implement auto save of current tab (#1201)
* IDEMPIERE-5202 Implement auto save of current tab

* IDEMPIERE-5202 Implement auto save of current tab

- Fix auto save trigger for every keystore on text field.

* IDEMPIERE-5202 Implement auto save of current tab

- Fix handling of the confirmation dialog for close of tab.
- Focus tweak for child to parent tab navigation.
- Restore focus if user abandon closing of tab.

* IDEMPIERE-5202 Implement auto save of current tab

- Fix infinite error loop when auto save fail with error
2022-03-01 16:05:36 +08:00
Carlos Ruiz 10997b2a95
IDEMPIERE-4706 New field "Dynamic Validation (Lookup)" in AD_Column>AD_Val_Rule_Lookup_ID not working (#1204) 2022-02-26 12:34:34 +08:00
Nicolas Micoud 5fdc5464b6
IDEMPIERE-5188 : Reset content of color field (#1177)
* IDEMPIERE-5188 : Reset content of color field

* IDEMPIERE-5188 : Reset content of color field - cleaner way but does not work

* IDEMPIERE-5188 : Reset content of color field - new editor

* IDEMPIERE-5188 : Reset content of color field - open color picker from button and popup menu

* IDEMPIERE-5188 : Reset content of color field - integrate patch from hengsin

Co-Authored-By: hengsin <152246+hengsin@users.noreply.github.com>

* IDEMPIERE-5188 : Reset content of color field - messages/icons

* IDEMPIERE-5188 : Reset content of color field - remove unnecessary changes

* IDEMPIERE-5188 : Reset content of color field - headers

* IDEMPIERE-5188 : Reset content of color field - remove ColorBox.java

* IDEMPIERE-5188 : Reset content of color field - changes suggested by hengsin

Co-authored-by: hengsin <152246+hengsin@users.noreply.github.com>
2022-02-25 19:31:02 +08:00
Layda Salas 02905cc5bd
IDEMPIERE-1981 Context Help can have multiple messages #resolve (#1200)
* IDEMPIERE-1981 Context Help can have multiple messages #resolve

* IDEMPIERE-1981 Context Help can have multiple messages #resolve
2022-02-25 11:42:42 +01:00
Nicolas Micoud ee3df039bf
IDEMPIERE-5180 : Add client name on RoleAccessUpdate process and add … (#1159)
* IDEMPIERE-5180 : Add client name on RoleAccessUpdate process and add client validation

* IDEMPIERE-5181 : RoleAccessUpdate add role validation

* IDEMPIERE-5181 : RoleAccessUpdate fix client validation

* IDEMPIERE-5181 : RoleAccessUpdate - remove on Client parameter
2022-02-22 14:33:47 +08:00
Layda Salas adeaa0f1ed
IDEMPIERE-2946 Review beta definition of menu entries #resolve (#1190) 2022-02-17 20:51:32 +01:00
Tony Snook 3eb28c74b4
IDEMPIERE-4297 Fix GW accounting issues (#1184)
- Fix missing account combinations and doctype in payment allocations
- Fix Tree Farm Vendor Liabilty posted to different account in euro schema
- Add equivalent Intercompany Journal to euro schema
2022-02-16 12:48:48 +01:00
Layda Salas ce71d55adf
IDEMPIERE-3595 Postal in document views is incorrect #resolve (#1187)
* IDEMPIERE-3595 Postal in document views is incorrect #resolve

* Fixing oracle script - Lines with length > 2499 - this will cause SP2-0027

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-02-16 11:57:11 +01:00
Carlos Ruiz 1dac88e6e9
IDEMPIERE-2580 Error with taxes and country groups (#1186) 2022-02-15 19:38:57 +01:00
Layda Salas 05261fa747
IDEMPIERE-4788 Spelling mistake menu "Accounting Fact Reconcilation (manual)". Correct to "Reconciliation" #resolve (#1179) 2022-02-12 14:09:06 +08:00
Tony Snook 0ee5faec8e
IDEMPIERE-5184 Cost Adjustment sets incorrect cost for other schema … (#1175)
* IDEMPIERE-5184 Cost Adjustment sets incorrect cost for other schema when currency blank on header
- also add check to unit test

* IDEMPIERE-5184 Cost Adjustment sets incorrect cost for other schema
- add currency id check to minventory before save
2022-02-12 11:27:15 +08:00
Carlos Ruiz c90afc0948
IDEMPIERE-5174 Disable System User (#1172)
* IDEMPIERE-5174 Disable System User - change approach to replace System user instead of removing it

* restore login-info.zul
2022-02-08 20:10:33 +08:00
Tony Snook fc5b2eebf2
IDEMPIERE-4297 Improve test data / fixes for Garden World data (#1168)
- Intercompany GL Journal Line has wrong Org
- Replace old ADempiere images & URL's with iDempiere
2022-02-08 11:00:06 +08:00
Carlos Ruiz 32a312a875
IDEMPIERE-5174 Disable System User (#1170)
Database Error when query/ReQuery in info window "Info System Element" as System User
2022-02-08 10:58:03 +08:00
Carlos Ruiz 6f5d7edf87
IDEMPIERE-5168 column AD_AuthorizationAccount.AccessToken is short on some case (#1165)
Fix ORA-22858: invalid alteration of datatype
2022-02-07 10:45:44 +01:00
Carlos Ruiz 3177c05b51
IDEMPIERE-4297 Improve test data / fix some wrong data in GardenWorld seed (#1162)
Co-authored-by: Chuck Boecking <chuck@chuboe.com>
2022-02-07 10:17:59 +01:00
Carlos Ruiz 496fce5434
IDEMPIERE-5168 column AD_AuthorizationAccount.AccessToken is short on some case (#1154)
* IDEMPIERE-5168 column AD_AuthorizationAccount.AccessToken is short on some case

- Allow reference Text with length 0 to be managed as CLOB/TEXT
- Increase AD_ChangeLog.OldValue/NewValue to 4000 to allow saving more information about changing long texts
- Change AD_AuthorizationAccount.AccessToken to CLOB/TEXT
- Change some important actual columns defined as Text Long, to Text with length 0 (this allows changelog, better 2Pack, encryption)

* Fix problem reported by Hiep Lq with Text/Text Long not shown correctly as encrypted
2022-02-04 11:27:44 +01:00
Nicolas Micoud 81bb438237
IDEMPIERE-1104 : SysConfig for posting using bank statement line date (#1149)
* IDEMPIERE-1104 : SysConfig for posting using bank statement line date

* IDEMPIERE-1104 : SysConfig for posting using bank statement line date - compare periods using IDs

* @nmicoud IDEMPIERE-1104 : SysConfig for posting using bank statement line date

change method's name and javadoc
2022-02-01 17:37:20 +01:00
Nicolas Micoud 35220381f7
IDEMPIERE-5170 : Reverse Prepare Payment process (#1148)
* IDEMPIERE-5170 : Reverse Prepare Payment process

* Move button to toolbar (oracle)

* Move button to toolbar (postgresql)

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-02-01 12:54:07 +01:00
Deepak Pansheriya 19681ec33d
IDEMPIERE-5175: on GL Journal Batch window, DateAct on line defaulted from GL Journal Batch instead of Journal (#1152) 2022-02-01 12:11:48 +01:00
Deepak Pansheriya 16d06fb1b1
IDEMPIERE-2853: Fixing bug of usage of isSortTab flag on display logic (#1139)
* IDEMPIERE-2853: Fixing bug of usage of isSortTab flag on display logic

* Update 202201190848_IDEMPIERE-2853.sql

* Update 202201190848_IDEMPIERE-2853.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-01-19 13:17:41 +01:00
Nicolas Micoud d3b9d99e81
IDEMPIERE-3044 : Add IsHighVolume on Tab (#1140)
* IDEMPIERE-3044 : Add IsHighVolume on Tab

* Update 202201191000_IDEMPIERE-3044.sql

* Update 202201191000_IDEMPIERE-3044.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-01-19 12:51:11 +01:00
Carlos Ruiz 1702a5f1e0
Revert "IDEMPIERE-5126 Virtual column lazy loading - move scripts to iD10 (#1123)" (#1134)
Move back scripts to i9
This reverts commit 1c8948d462.
2022-01-16 10:52:45 +01:00
Carlos Ruiz 847e2a5238
IDEMPIERE-5146 Load/Import Bank Statement issues (#1125)
* Add org.compiere.model.MBankStatementLoader.getLastSavedLine() to allow further processing of the saved I_BankStatement record on plugins
* Increase size of columns:
        I_BankStatement.EftMemo -> 4000
        I_BankStatement.Memo -> 4000
        C_BankStatementLine.EftMemo -> 4000
        C_BankStatementLine.Memo -> 4000
        I_BankStatement.LineDescription -> 1000
        C_BankStatementLine.Description -> 1000
        I_BankStatement.EftTrxType -> 255
        C_BankStatementLine.EftTrxType -> 255
        I_BankStatement.EftReference -> 255
        C_BankStatementLine.EftReference -> 255
        I_BankStatement.ReferenceNo -> 255
        C_BankStatementLine.ReferenceNo -> 255
* Add process "Create Payment" on bank statement header to process all lines with pending payments to create
2022-01-15 17:25:30 +01:00
Nicolas Micoud a891ca988a
IDEMPIERE-5152 : Add title on broadcast messages (#1130)
* IDEMPIERE-5152 : Add title on broadcast messages

* Broadcast messages : use all the width of the panel to display the message

* IDEMPIERE-5152 : Add title on broadcast messages

* IDEMPIERE-5152 : Add title on broadcast messages - model class for v9

* IDEMPIERE-5152 : Add title on broadcast messages - improve mobile usage

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* Delete pr1130_PR.txt

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-01-15 16:12:03 +01:00
Carlos Ruiz 1c8948d462
IDEMPIERE-5126 Virtual column lazy loading - move scripts to iD10 (#1123) 2022-01-07 15:34:27 +01:00
Saulo José Gil 0eb89932fd
IDEMPIERE-5126 Virtual column lazy loading (#1095)
* IDEMPIERE-5126 Virtual column lazy loading

Virtual columns are now loaded only whenever their respective getters are invoked. This functionality works irrespective of the PO constructor used.

Query class now uses lazy loading by default as well.

* IDEMPIERE-5126 Virtual column lazy loading

Have the model generator ignore virtual columns with the @SQL prefix, as
their generated getters would always return null.

* IDEMPIERE-5126 Virtual column lazy loading

Added quoting to virtual column names

* IDEMPIERE-5126 Virtual column lazy loading

Reload virtual columns if the record was reloaded.

* IDEMPIERE-5126 Virtual column lazy loading

Fixed class cast exception in unit test.

* IDEMPIERE-5126 Virtual column lazy loading

Support for loading selected virtual columns along with regular table
columns, skipping lazy loading.

* IDEMPIERE-5126 Virtual column lazy loading

Fine-grained virtual column loading support for Query.

* IDEMPIERE-5126 Virtual column lazy loading

Support for loading selected virtual columns along with regular table
columns, skipping lazy loading.

* IDEMPIERE-5126 Virtual column lazy loading

Improved support for the constructor PO.PO(Properties, int, String,
String...).

* IDEMPIERE-5126 Virtual column lazy loading

Refactoring. Reduced size of messages sent and received from database
engine when lazy loading virtual columns. Other minor changes.

* IDEMPIERE-5126 Virtual column lazy loading

Added testing assertions.

* IDEMPIERE-5126 Virtual column lazy loading

Silenced Eclipse warnings.
2022-01-05 21:14:50 +08:00
Nicolas Micoud 2fe6f5bba5
IDEMPIERE-5136 : Set Messages at tenant level (#1113)
* IDEMPIERE-5136 : Set Messages at tenant level

* IDEMPIERE-5136 : Set Messages at tenant level : remove loop of clients to load messages

* IDEMPIERE-5136 : Set Messages at tenant level : fix migration scripts + fix imports

* IDEMPIERE-5136 : Set Messages at tenant level - callout to fill fields

* IDEMPIERE-5136 : Set Messages at tenant level - language field must be mandatory

* IDEMPIERE-5136 : Set Messages at tenant level - callout to fill fields (used at tenant level only)

* IDEMPIERE-5136 : Set Messages at tenant level - add IsActive check + close pstmt

* IDEMPIERE-5136 : Set Messages at tenant level - patch from Carlos

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-5136 : Set Messages at tenant level - check for active records on Trl table

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-01-05 11:34:20 +01:00
Nicolas Micoud 887d75067b
IDEMPIERE-3561 QuickEntry panel doesn't use ZoomCondition (#1102)
* IDEMPIERE-3561

* IDEMPIERE-3561

fix logic for isSOTrx = N

* IDEMPIERE-3561 - move migration scripts to i9 folder
2022-01-05 15:00:35 +08:00
hengsin 55e9e87f0b
IDEMPIERE-5139 BOM validation for Deactivation of Product (#1111) 2022-01-04 15:24:07 +01:00
Carlos Ruiz 57d4caa101
IDEMPIERE-4448 Autocomplete/Info Window doesn't work correctly with Search fields with Reference / fix IDEMPIERE-5141 (#1114) 2022-01-04 14:42:14 +01:00
Carlos Ruiz 7c116c2dd8
IDEMPIERE-5132 Enable filling Purchase Order in Material Receipt (#1099) 2022-01-03 15:04:55 +08:00
Carlos Ruiz fa62f421b9
iIDEMPIERE-5109 Release 9 Horizon - set master in v10 (#1092) 2021-12-24 17:18:24 +01:00
Carlos Ruiz adba43ced0
IDEMPIERE-5109 Release 9 Horizon (#1088)
* IDEMPIERE-5109 Release 9 Horizon

- Fill UUID in missing AD_TreeNodeMM_UU

* - IDEMPIERE-1052 - set as Search for High Volume tables

* - Fix supported versions in SECURITY.md

* - Script to set the Version number

* - Set credits and image

* - script to clean trailing space from elements

* - Set entity type EXT for Web Service tables

* - IDEMPIERE-4214 Javadoc: correct warnings on newest java version

* - Improvements to model generator classes

* - Model classes

* - Folders script maintenance new version
2021-12-24 18:05:32 +08:00
Carlos Ruiz 01b3c9d84f
Move to 8.2 to solve unit test failing (#1087) 2021-12-23 13:32:10 +01:00
Carlos Ruiz b69fd6a329
IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID (#1072)
* IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID

Solve AD_Element_Trl, AD_Process_Para_Trl, AD_PrintForm

* Add AcctSchemaDefaultCopy *_Acct tables, M_Product_PO, Fact_Reconciliation
2021-12-23 12:06:29 +01:00
Carlos Ruiz 1d8e34e3e4
IDEMPIERE-4882 On Inventory Move, Adding Warehouse and Warehouse To field on header (#1085)
* IDEMPIERE-4882: Supproting warehouse To on inventory Move to filter locator

* IDEMPIERE-4882 On Inventory Move, Adding Warehouse and Warehouse To field on header / peer review

Co-authored-by: dpansheriya <deepakpansheriya@gmail.com>
2021-12-23 10:29:09 +01:00
hengsin b88a77ffec
IDEMPIERE-5118 MUOMConversion fix and improvements (#1075) 2021-12-23 10:21:26 +01:00
Saulo José Gil a3872deb23
IDEMPIERE-5110 Manufacturing performance enhancements (#1080)
* IDEMPIERE-5110 Manufacturing performance enhancements

Added indexes for BOM. Rewritten virtual columns for m_productionline.

* Update 202112210930_IDEMPIERE-5110.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-12-23 10:07:02 +01:00
Carlos Ruiz 7c94192533
IDEMPIERE-5116 Recent Item on System Configurator revealing too much information (#1074) 2021-12-21 21:37:09 +08:00
Carlos Ruiz 85cb32f2d8
IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID (#1068)
* IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID / fix role access uuids

* more on AD_Document_Action_Access

* Improve performance for trl recreate or insert - using update instead of record by record

* - add AD_PInstance_Log.AD_PInstance_Log_UU
2021-12-20 11:29:36 +08:00
Carlos Ruiz d748293553
IDEMPIERE-5109 Release 9 Horizon / add year 2022 in GardenWorld (#1060)
* IDEMPIERE-5109 Release 9 Horizon / add year 2022 in GardenWorld - fixes broken unit test InvoiceCustomerTest.testOpenAmt

* Revert file committed by mistake
2021-12-19 14:07:23 +08:00
Deepak Pansheriya da97b08d2c
IDEMPIERE-4836 : Document status access tab (#1001)
* IDEMPIERE-4836 : Document status access tab

* IDEMPIERE-4836 : Adding unit test

* IDEMPIERE-4836 : Fixing as per review comment

* IDEMPIERE-4836 : Fixing review comments
2021-12-18 16:03:06 +01:00
Carlos Ruiz cafe018404
IDEMPIERE-4448 Autocomplete/Info Window doesn't work correctly with Search fields with Reference (#1055)
* Change 188 reftables to use the ID for display - this displays the reference based on the identifiers of the table, making it consistent with Search/Table without reference
* Use the MSysConfig.IDENTIFIER_SEPARATOR for the cases where reference is displaying value and another column
2021-12-17 13:44:55 +08:00
hengsin 52c423dfeb
IDEMPIERE-5102 Deactivate AD_Desktop and AD_Workbench (#1053) 2021-12-17 11:10:48 +08:00
hengsin dc698ff655
IDEMPIERE-5073 M_InOutLineMA.DateMaterialPolicy should comes from MStorageOnHand or Shipment instead of through user entry (#1027) 2021-12-14 15:35:04 +01:00
Carlos Ruiz 5f15207cba
IDEMPIERE-5075 Many oracle constraints defined as non deferrable (#1029) 2021-12-09 09:44:25 +08:00
hengsin 055c614336
IDEMPIERE-5069 Completion of Shipment for Close Order produce inconsistent order line data (#1030) 2021-12-07 13:12:52 +01:00
Carlos Ruiz 8617a74f53
IDEMPIERE-1302 Validate flag IsPurchased and IsSold on Price List, Order, InOut, and Invoice (#1018)
Implemented as adding IsSold/IsPurchased in Product Info window with the same management as IsCustomer/IsVendor on BP Info window
2021-12-01 09:55:22 +08:00
Carlos Ruiz feebea8691
IDEMPIERE-5052 Date Min/Max Validation wrong with 5 digit years (#1016)
* IDEMPIERE-5052 Date Min/Max Validation wrong with 5 digit years

* IDEMPIERE-5052 Date Min/Max Validation wrong with 5 digit years / enable for Cost+Price and String
2021-12-01 09:46:53 +08:00
hengsin 05447b38ce
IDEMPIERE-5040 Stall M_InOutLine.QtyOverReceipt (#1005)
* IDEMPIERE-5040 Stall M_InOutLine.QtyOverReceipt

* IDEMPIERE-5040 Stall M_InOutLine.QtyOverReceipt

Drop the user of M_InOutLine.QtyOverReceipt column
2021-11-29 16:01:52 +01:00
Carlos Ruiz 744e84ccc5
IDEMPIERE-5059 Import the database view definition into dictionary (#1011) 2021-11-29 10:25:08 +08:00
Carlos Ruiz 143ef24a58
IDEMPIERE-5060 iDempiere dictionary view doesn't support UNION ALL (#1009) 2021-11-29 10:22:30 +08:00
Carlos Ruiz 6dbbb73a32
IDEMPIERE-5051 PaymentExportClass must be advanced field (#1000) 2021-11-25 12:31:32 +08:00
Carlos Ruiz 4d9faf5fae
IDEMPIERE-2620 Customer Drop Ships not implemented / Drop BP and Location must be mandatory when Drop Ship is enabled (#998) 2021-11-23 16:00:47 +08:00
Nicolas Micoud 2486ff8148
IDEMPIERE-4858 : Helper process "Make Table a Document" - fixes for t… (#990)
* IDEMPIERE-4858 : Helper process "Make Table a Document" - fixes for translation tables

see details in tickets

* IDEMPIERE-4858 : Helper process "Make Table a Document" - add TableIndex records

* IDEMPIERE-4858 : Helper process "Make Table a Document" - AD_Message / tick IsTranslated on main table

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* Delete pr990_PR.txt

commited by error

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-11-19 17:02:54 +01:00
hengsin 5ccd54caf8
IDEMPIERE-4900 SQL statement added as an option to define WF Next Nod… (#981)
* IDEMPIERE-4900 SQL statement added as an option to define WF Next Node Condition

Base on pull request 813 (Anton Mostovenko) and patch from
IDEMPIERE-1832 (Deepak Pansheriya)

* IDEMPIERE-4900 SQL statement added as an option to define WF Next Node Condition

Incorporate patch from carlos

* IDEMPIERE-4900 SQL statement added as an option to define WF Next Node Condition

Incorporate patch from Carlos
2021-11-17 12:06:42 +01:00
Carlos Ruiz a1cef5b0fd
IDEMPIERE-2620 Customer Drop Ships not implemented (#985)
* IDEMPIERE-2620 Customer Drop Ships not implemented

* IDEMPIERE-2620 Customer Drop Ships not implemented / fix help

* IDEMPIERE-2620 Customer Drop Ships not implemented / clear display logic in sales order

In sales order the drop ship doesn't change anything important in the system behavior,
is more like a printing agreement with the customer,
so it doesn't make sense to restrict it just to standard orders,
it can be used in any type of order
2021-11-17 09:28:24 +08:00
Carlos Ruiz 549a9ddef1
IDEMPIERE-4808 Payment Allocation should be IsSOTrx neutral + Product Window (#984) 2021-11-17 09:25:52 +08:00
Tony Snook e27a8b8aab
IDEMPIERE-4956 fix unmatched quotes in displaylogic (#980)
* IDEMPIERE-4956 fix unmatched quotes in displaylogic

* IDEMPIERE-4956 fix additional logic errors

* IDEMPIERE-4956 set ReadOnlyLogic to NULL instead of empty string

* IDEMPIERE-4956 fix additional logic fields

* Remove byte order mark (BOM) character from oracle/202111132224_IDEMPIERE-4956.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-11-16 11:32:26 +01:00
Deepak Pansheriya 9c747a6f0d
IDEMPIERE-4086: Allow Product without price list on some document type (#974) 2021-11-12 10:57:30 +01:00
hengsin f937cdbf35
IDEMPIERE-5029 User can make Shipment/Receipt Line Product different … (#968)
* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

Merge patch from Carlos

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

Make consistent with previous patch - always use oLine.M_Product_ID for
reservation

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

add safe guard against oLine is Charge and sLine is Product.

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

- need to apply the oLine.getM_Product_ID changes to reservation log
too.

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

More fix for update of qtyreserved not using product id from oLine.

* IDEMPIERE-5029 User can make Shipment/Receipt Line Product different from Order Line Product

update of qtyreserved: should use warehouse and issotrx from order too
2021-11-11 18:48:27 +01:00
hengsin d0340e70d5
IDEMPIERE-5031 Implement auto produce upon shipment for mfg light (#969)
* IDEMPIERE-5031 Implement auto produce upon shipment for mfg light

* IDEMPIERE-5031 Implement auto produce upon shipment for mfg light

Fix clean up of unit test
2021-11-09 14:23:49 +01:00
hengsin ea3b147fb1
IDEMPIERE-5021 Implement Storage Reservation Log (#961)
* IDEMPIERE-5021 Implement Storage Reservation Log

- implement log table for movement of QtyReserved and QtyOrdered

* IDEMPIERE-5021 Implement Storage Reservation Log

update javadoc and license header

* IDEMPIERE-5021 Implement Storage Reservation Log

increase documentno column length to 255

* IDEMPIERE-5021 Implement Storage Reservation Log

Fix migration script
2021-11-03 12:27:57 +01:00
hengsin ed4c1a81d0
IDEMPIERE-4472 Window Advanced Search - Allow select column from wind… (#959)
* IDEMPIERE-4472 Window Advanced Search - Allow select column from window tabs - 2pack compatibility

Based on pull request #170 from igorpojzl.
Difference from #170:
- use AD_Tab_UU instead of AD_Tab_ID
- use Combobox for table list

* IDEMPIERE-4472 Window Advanced Search - Allow select column from window tabs - 2pack compatibility

Fix attribute search

* IDEMPIERE-4472 Window Advanced Search - Allow select column from window tabs - 2pack compatibility

Merge patch from Carlos (increse length of AD_UserQuery.Code)
2021-11-01 22:05:49 +08:00
Carlos Ruiz 7380c99a58
IDEMPIERE-4863 Enable save column width in WListBox / add maintenance window (#958) 2021-10-29 15:38:02 +08:00
Carlos Ruiz 180b11bd65
IDEMPIERE-5020 Allow to show products without price in Info Product window (#957) 2021-10-29 15:35:40 +08:00
Carlos Ruiz 9356fc1d76
IDEMPIERE-5017 DateAcct on Find Window of M_InOut display wrong (#951) 2021-10-29 14:42:31 +08:00
Carlos Ruiz 9abc2c09e2
IDEMPIERE-5018 Vendor changed to customer when edited using Quick Entry (#950)
IDEMPIERE-3705
2021-10-27 15:14:03 +02:00
Carlos Ruiz 750a58cabd
IDEMPIERE-4994 Generate invoice (manual) tries to look for vendors (#947) 2021-10-25 13:58:10 +02:00
Carlos Ruiz 3cab0992d5
IDEMPIERE-4863 Enable save column width in WListBox / fix oracle script (#940) 2021-10-22 12:08:26 +02:00
Tony Snook 0d36f61cb4
IDEMPIERE-4297 Improve test data (#932)
Correct Delivered Qty on Garden World PO 800000, 800001 & 800002
2021-10-20 19:07:19 +08:00
Carlos Ruiz cb07d78293
IDEMPIERE-2901 Period Control Management (#923) 2021-10-14 13:06:09 +08:00
Carlos Ruiz 5f39c14e31
IDEMPIERE-4997 Allow to use product (or charge) in commissions configuration (#919) 2021-10-12 12:04:59 +02:00
gsjeffen eb3db56364
IDEMPIERE-4863 Enable save column width in WListBox (#883)
* IDEMPIERE-4863-1 Enable save column width in WListBox

This PR is the base for implementing save of column width of a wlistbox in forms and windows.

* IDEMPIERE-4863-1 Enable save column width in WListBox implementation example

This commit is showing examples implementation of this PR, it is for infoProductWindow and infoWindow
2021-10-12 09:27:26 +08:00
Nicolas Micoud 9c220f0be3
IDEMPIERE-4985 : Missing index on AD_UserDef sub tables (#907)
Adding indexes on AD_UserDef_Tab, AD_UserDef_Field, AD_UserDef_Info_Column, AD_UserDef_Proc_Parameter
2021-10-06 17:45:46 +02:00
hengsin 8fbac60b1a
IDEMPIERE-1250 Multiple BOM (formulas) support for mfg-light (#906)
* IDEMPIERE-1250 Multiple BOM (formulas) support for mfg-light

* IDEMPIERE-1250 Multiple BOM (formulas) support for mfg-light

Fix deprecation warnings

* Update 202109291600_IDEMPIERE-1250.sql

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-10-06 17:06:26 +02:00
Nicolas Micoud 488715260e
IDEMPIERE-4983 : Fix Russian Ruble currency (#903)
* IDEMPIERE-4983 : Fix Russian Ruble currency

update currency currency code from RUR to RUB
2021-09-30 13:21:21 +02:00
Carlos Ruiz 557c483fc9
IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / Shell script (#891)
* IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / Shell script

* IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / Java Shell script -> beanshell/groovy

* IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / Remove java class option, fixes for script

* IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / rename to ScriptJSR223

* IDEMPIERE-4968 Enable 2Pack to run java class or script (FHCA-3112 FHCA-3113) / add audit information to SQL statements, shell and JSR223 scripts
2021-09-24 16:38:07 +08:00
Carlos Ruiz d51333aa57
IDEMPIERE-4976 Wrong parameter in Initial Client Setup (duplicated IsUseSalesRegionDimension) (#894) 2021-09-23 15:37:17 +08:00
Nicolas Micoud 86c21dafda
IDEMPIERE-4866 : Multiple smtp per tenant (#884)
* IDEMPIERE-4866 : Multiple smtp per tenant

Same PR as https://github.com/idempiere/idempiere/pull/783

* IDEMPIERE-4866 : Multiple smtp per tenant - various fixes

Fixes suggested by Carlos on https://github.com/idempiere/idempiere/pull/783 (remove System.out, change AD_Element name, tab in SingleRow mode) + fix NPE

* IDEMPIERE-4866 : Multiple smtp per tenant : implement cache

* IDEMPIERE-4866 : Multiple smtp per tenant : process EMailTest was not set on column

Fixes by Carlos

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-09-21 14:56:56 +02:00
Carlos Ruiz 8cb8b9ad67
IDEMPIERE-4906 Dashboard showing donation message on first log-in (#882)
* IDEMPIERE-4906 Dashboard showing donation message on first log-in

* IDEMPIERE-4906 Dashboard showing donation message on first log-in / make dashboard collapsible
2021-09-20 17:02:37 +02:00
Carlos Ruiz 078d130cd7
IDEMPIERE-4969 Clean non-working 2Pack Code for File and CodeSnippet (#886) 2021-09-19 15:31:18 +08:00
Nicolas Micoud a1da95cfff
IDEMPIERE-4946 : Add IsShowInDashboard, SeqNo and ImageURL on AD_User… (#866)
* IDEMPIERE-4946 : Add IsShowInDashboard, SeqNo and ImageURL on AD_UserDef_Info

* IDEMPIERE-4946 : Add IsShowInDashboard, SeqNo and ImageURL on AD_UserDef_Info

Use customized image from tenant level when opening the panel

* IDEMPIERE-4946 : Add IsShowInDashboard, SeqNo and ImageURL on AD_UserDef_Info - fix migration scripts name
2021-09-17 15:56:44 +02:00
Carlos Ruiz 5979f65bbd
IDEMPIERE-2853 Panel tab as a factory - preserve AD_Tab.IsSortTab for backward compatibility (#885) 2021-09-17 21:07:50 +08:00
Nicolas Micoud e0a8637880
IDEMPIERE-4721 : Financial Report : exclude all adjustement periods (#872)
* IDEMPIERE-4721 : Financial Report : exclude all adjustement periods

* Change warning to info

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-09-15 14:29:11 +02:00
hengsin f8c72c0451
IDEMPIERE-4949 Desktop tab enhancements (#868)
* IDEMPIERE-4949 Desktop tab enhancements
* ConfigurationLevel=C

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-09-08 13:40:00 +02:00
Carlos Ruiz 69794ff936
IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not (#864)
* Revert "IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not (#850)"

This reverts commit 39ad82ebf0.

* IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not

Based on pull request 170
Co-authored-by: Igor Pojzl <igor.pojzl@cloudempiere.com>

* IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not

Fix naming of migration scripts as suggested by Heng Sin
2021-09-03 23:01:24 +02:00
Carlos Ruiz 39ad82ebf0
IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not (#850)
* IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not

Based on pull request 170
Co-authored-by: Igor Pojzl <igor.pojzl@cloudempiere.com>

* IDEMPIERE-4470 Window Advanced Search - New operator types: AND Not, Or Not

Rename migration scripts as suggested by Heng Sin
2021-09-03 22:20:50 +08:00
lHeidbreder 6fb4ebbf2f
IDEMPIERE-1575 Increase some columns length AD_ImpFormat_Row.Callout (#852)
* addendum to IDEMPIERE-1575 with regards to IDEMPIERE-4724

* Regenerated scripts, added register line and increased the size up to 4k to safely accomodate multiple callouts

Co-authored-by: mschnbeck <ms.github@schoenbeck.de>
2021-08-31 14:11:56 +02:00
Nicolas Micoud 0ace1aa246
IDEMPIERE-4936 : Add IsDisplayedGrid on UserDefWindow (#849) 2021-08-30 15:41:45 +02:00
Deepak Pansheriya 96baf0b7cd
IDEMPIERE-2853: Support for IADTabPanel as factory to add custom Tab … (#579)
* IDEMPIERE-2853: Support for IADTabPanel as factory to add custom Tab types
sh: q: command not found

* IDEMPIERE-2853: adding requested Java doc, fixing seq mismatch in oracle and postgresql, Using Interface method instead of manual isSortTab check,

* IDEMPIERE-2853: Adding default implementation for isEnableCustomizeButton in IADTabpanel

* IDEMPIERE-2853: renaming reference label and Added support for allowing implementor to update toolbar state.

* IDEMPIERE-2853: Fixing compilation issue due to merging to master branch
2021-08-30 13:56:34 +02:00
Martin Schönbeck 111eab35d3
Idempiere 4724 (#637)
* IDEMPIERE-4724
allow to concatenate parts at import
allow to prefix them which also is necessary to separate them when concatenating
allow to concatenate callouts and provide sort of parameters

* Update CalloutEngine.java

minor - typos in comments

* Update ImpFormatRow.java

is better to raise the exception when the callout cannot be found - the results can be unexpected for end users if the callouts are not called

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-08-27 11:22:18 +02:00
Carlos Ruiz 0167c91424
IDEMPIERE-4911 Silent fail when translated column is shorter than original column (FHCA-2888) (#844)
* IDEMPIERE-4911 Silent fail when translated column is shorter than original column (FHCA-2888)

Changes:
* Saving a value that doesn't fit in the translation now fails with a proper user understandable message
* Synchronize Doc Translation now fails with a user understandable message in case it fails because a value doesn't fit
* When updating a column on a translation table, check for the size of the original column and update the size accordingly
* When updating a translated column, show warnings to user about creating the table, or creating the column, or updating the column size

* IDEMPIERE-4911 Silent fail when translated column is shorter than original column (FHCA-2888)

Improve message for end user
2021-08-20 13:59:35 +02:00
Carlos Ruiz c20e76bc13
IDEMPIERE-3494 Implement DocStatus/DocAction for Project Issue (#840)
Minor fix entity type in migration scripts
2021-08-17 19:01:35 +02:00
hengsin 461b597c8e
IDEMPIERE-3494 Implement DocStatus/DocAction for Project Issue (#839) 2021-08-17 18:59:14 +02:00
hengsin 184e8191e6
IDEMPIERE-4904 Add custom query clause support to report parameter (#821) 2021-08-12 15:02:01 +02:00
Carlos Ruiz b3637f0ff7
IDEMPIERE-4902 : Record migration scripts with Dictionnary EntityType (#819)
Fix oracle build broken
2021-08-06 11:13:45 +02:00
hengsin d3d1a735b0
IDEMPIERE-4899 Report: print product instance attribute name and valu… (#814)
* IDEMPIERE-4899 Report: print product instance attribute name and value as column

* IDEMPIERE-4899 Report: print product instance attribute name and value as column

- use parenthesis for display logic
- fixed display logic evaluation exception
- fixed index out of bound exception for xls and xlsx

* IDEMPIERE-4899 Report: print product instance attribute name and value as column

- Fix css for columns that have been shifted to the right
2021-08-06 11:12:05 +02:00
Nicolas Micoud 997018233f
IDEMPIERE-4902 : Record migration scripts with Dictionnary EntityType (#816)
* IDEMPIERE-4902 : Record migration scripts with Dictionnary EntityType

* IDEMPIERE-4902 : Record migration scripts with Dictionnary EntityType - fix migration scripts

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4902 : Record migration scripts with Dictionnary EntityType - move migration scripts to i8.2

* IDEMPIERE-2523

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-08-05 14:51:14 +02:00
hengsin 1fb4067c01
IDEMPIERE-4894 OSGi Interface to support custom header and footer (#804)
* IDEMPIERE-4894 OSGi Interface to support custom header and footer

* IDEMPIERE-4894 OSGi Interface to support custom header and footer

incorporate migration script fix from Carlos
2021-07-30 13:53:28 +02:00
Deepak Pansheriya 3c8e05c9d6
IDEMPIERE-4770: Cross tenant issue while broadcasting message to System tenant role (#806) 2021-07-30 11:17:43 +02:00
Nicolas Micoud de795e4e15
IDEMPIERE-4808 : Payment Allocation should be IsSOTrx neutral - fix Default SQL variable parse failed (#797) 2021-07-28 10:12:15 +02:00
hengsin f5dc3ba2c8
IDEMPIERE-4059 Print format editor (#794) 2021-07-26 14:42:29 +02:00
hengsin 8f758ed904
IDEMPIERE-1994 Ability to organise process and report parameters by F… (#791)
* IDEMPIERE-1994 Ability to organise process and report parameters by Field Group functionality

* IDEMPIERE-1994 Ability to organise process and report parameters by Field Group functionality

Fix collapsed by default not working.
2021-07-24 11:05:49 +02:00
Nicolas Micoud a4dfd191ec
IDEMPIERE-4858 : CreateTable process (#774)
* IDEMPIERE-4858 : CreateTable process

* IDEMPIERE-4858 : CreateTable process - fixes

Changes following Carlos's remarks - see details in the ticket

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4858 : CreateTable process - fixes migration scripts

See details in ticket

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4858 : CreateTable process - various fixes

fix migration scripts names / constants in uppercase / remove check of table length

* IDEMPIERE-4858 : CreateTable process - various fixes

default value for EntityType param / replace numeric name/value params by boolean ones / enhance creation of system element (name/print name/description)
see https://idempiere.atlassian.net/browse/IDEMPIERE-4858?focusedCommentId=47325

* IDEMPIERE-4858 : CreateTable process : optional columns

* IDEMPIERE-4858 : CreateTable process : remove wrong temporary migration scripts

* IDEMPIERE-4858 : CreateTable process :

add org.adempiere.base.process as required plugin (and not as imported package)
add missing content on migration scripts

* IDEMPIERE-4858 : CreateTable process : fixes / reordering / renaming

Failed creating Description column: ** Fill mandatory fields: : Length
Value and DocumentNo are not usually mandatory
Some minor reordering and renaming of variables

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4858 : CreateTable process : can be used to add columns on existing table

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4858 : CreateTable process - fix default value for TableName parameter

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

* IDEMPIERE-4858 : CreateTable process  - restore default value for Description, Name and AccessLevel parameters

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-07-23 15:37:22 +02:00
Carlos Ruiz 1a01a70b2b
IDEMPIERE-4886 Synchronize multiple columns on ALTER (#788) 2021-07-23 13:20:36 +02:00
Nicolas Micoud 0ce2bde958
IDEMPIERE-4884 : Austrian states (#785)
* IDEMPIERE-4884 : Austrian states

* IDEMPIERE-4884 : Austrian states : move scripts to i8.2z
2021-07-20 11:51:21 +02:00
hengsin 3dcef18868
IDEMPIERE-4841 Info Window: Implement auto hide empty columns (#781) 2021-07-15 17:03:33 +02:00
Deepak Pansheriya 72ba9fd9d3
IDEMPIERE-4837:on Product Info, only defaulting price list when window has UserPriceListInProductInfo ctx variable set. (#754) 2021-07-05 21:27:41 +02:00
Nicolas Micoud 458a12fda0
IDEMPIERE-4860 : MRole.updateAccessRecords insert active records based on deactivated objects / post migration scripts (#763)
Co-Authored-By: Carlos Ruiz <carg67@gmail.com>
2021-07-05 21:06:40 +02:00
hengsin 93bc73c257
IDEMPIERE-4865 Find window enhancements (#766) 2021-07-05 20:37:28 +02:00
Carlos Ruiz 0e58005d6f
IDEMPIERE-4853 Process to copy a Packout definition (FHCA-859) (#756)
* IDEMPIERE-4853 Process to copy a Packout definition (FHCA-859)

* IDEMPIERE-4853 Process to copy a Packout definition (FHCA-859)

Do not copy inactive details (as suggested by hengsin)
2021-07-01 22:14:46 +08:00
Carlos Ruiz c4444bef5d
IDEMPIERE-4806 System Configurator window must be Advanced (#755) 2021-07-01 21:03:43 +08:00
Carlos Ruiz d7286128bb
IDEMPIERE-4856 Setting an attribute with type reference doesn't work in german / IDEMPIERE-2999 (#752) 2021-06-30 17:22:42 +02:00
Carlos Ruiz 3af91f69c1
IDEMPIERE-4851 Tenant Admin can deactivate his own client. (#749) 2021-06-30 11:14:41 +02:00
Nicolas Micoud 0e6e5efc7d
IDEMPIERE-4829 - Add SeqNoGrid on UserDefWindow (#718)
* IDEMPIERE-4829 - Add SeqNoGrid on UserDefWindow

* IDEMPIERE-4829 : scripts moved to i8.2z
2021-06-28 16:11:42 +02:00
hengsin ded9693163
IDEMPIERE-4835 Grid View: Implement optional hide empty column feature (#727)
* IDEMPIERE-4835 Grid View: Implement optional hide empty column feature

* IDEMPIERE-4835 Grid View: Implement optional hide empty column feature

- fix issue with save width saving 0px width to
ad_tab_customization.custom
- added ad_tab_customization.IsAutoHideEmptyColumn
2021-06-19 09:24:08 +02:00
hengsin 66a15865d6
IDEMPIERE-4838 Update pdf.js to v2.9.359 (#728) 2021-06-18 22:41:10 +02:00
hengsin bb0ef7ebb3
IDEMPIERE-4832 Fix bad boolean *logic expression in dictionary (#720) 2021-06-14 17:47:52 +02:00
Diego Ruiz 2110322149
IDEMPIERE-4823 RV_C_Invoice does not have a key column (#715)
* IDEMPIERE-4823 RV_C_Invoice does not have a key column

* IDEMPIERE-4823 RV_C_Invoice does not have a key column - Move scripts to 8.2 folder
2021-06-10 17:07:52 +02:00
Carlos Ruiz d0346f6819
IDEMPIERE-4782 Multi-factor authentication (FHCA-2034) (#713)
Move migration scripts to folder 8.2
2021-06-09 15:27:47 +02:00
Carlos Ruiz fa0b52abd6
IDEMPIERE-3980 (#711)
* IDEMPIERE-3980

* IDEMPIERE-3980

Restrict uploading just to valid safe image file types

* IDEMPIERE-3980
2021-06-08 22:42:47 +08:00
Carlos Ruiz a4f67eb852
IDEMPIERE-4782 Multi-factor authentication (FHCA-2034) (#705)
* IDEMPIERE-4782 Multi-factor authentication (FHCA-2034)

Implement suggestions from Heng Sin

* IDEMPIERE-4782 Multi-factor authentication (FHCA-2034)

Fix security warning advised by github/CodeQL

* IDEMPIERE-4782 Multi-factor authentication (FHCA-2034)

Implement an incremental delay in zk when the validation code is wrong (to avoid brute-force attacks)
As suggested by Ricardo Santana:
* ensures one-time only use of an OTP
* Log failures in AuthFailure.log

* IDEMPIERE-4782 Multi-factor authentication (FHCA-2034)

* Log failures in AuthFailure.log - add case for login with email
* Implement incremental delay also for login panel
2021-06-08 19:49:46 +08:00
igorpojzl 3e64dc6737
IDEMPIERE-4479 - Allow define columnSql in AD_Field (#710)
* IDEMPIERE-4479 - Allow define columnSql in AD_Field

* IDEMPIERE-4479 Added View Update, ColumnSql fix FieldLength

* IDEMPIERE-4479 Updated AD_Field Model

* IDEMPIERE-4479 MFIeld update model logic

* IDEMPIERE-4479 Move Migration scripts to 8.2
2021-06-04 10:03:05 +02:00
Nicolas Micoud 98dc9e796c
IDEMPIERE-4808 : Payment Allocation should be IsSOTrx neutral (#703)
* IDEMPIERE-4808 : Payment Allocation should be IsSOTrx neutral

* IDEMPIERE-4808 : forms can use IsSOTrx from AD_Menu

* IDEMPIERE-4808 : add IgnoreIsSOTrxInBPInfo to be used on BPartner InfoWindow

Co-Authored-By: Carlos Ruiz <carg67@gmail.com>

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-06-04 09:29:37 +02:00
Carlos Ruiz d9826c775f
IDEMPIERE-4813 Process Customization Cross Tenant Error (#707)
* Implement for Window, Process and Info Window Customization:
  * Change to non-updateable the columns that have related children
  * Change default to NULL in role, user and language
  * Disable the autofilling of name, description and help
2021-06-03 15:40:30 +02:00
igorpojzl 6da6bc1d85
IDEMPIERE-4796 Request EMail Processor - Html email processing type parameter (#696)
* IDEMPIERE-4796 EmailSrv Parse Html Images

* IDEMPIERE-4796  Request EMail Processor - Html email processing type parameter

* IDEMPIERE-4796 Migration Scripts Added

* IDEMPIERE-4796 Added Register_Migration_Script

* IDEMPIERE-4796 Html Attachment Type Variable Logic Update

* IDEMPIERE-4796 ImageList null check added
2021-06-03 21:05:22 +08:00
Carlos Ruiz b914083d31
IDEMPIERE-4804 Message in Reset Password Panel is misleading (#702) 2021-05-31 11:29:43 +02:00
hengsin beaaf31d9a
IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler (#679)
* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

Fix initial output type selection for csv. Fix handling of binary vs
text media type.

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

- Change AD_AuthorizationAccount scope from single value to multiple
selection list (AD_AuthorizationScopes replace AD_AuthorizationScope)

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

Fix isIntersectCSV db function

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

add back AD_AuthorizationScope Configured dynamic validation filter
2021-05-12 13:42:55 +02:00
Carlos Ruiz da3dc2c472
Move scripts to 8.2 (#683) 2021-05-11 13:12:52 +02:00
Nicolas Micoud ad8de98fe5
IDEMPIERE-4781 : Dashboard / Report : use @SQL= syntax (#677)
* IDEMPIERE-4781 : Dashboard / Report : use @SQL= syntax

* IDEMPIERE-4781 : Dashboard / Report - be able to use Range parameters

* IDEMPIERE-4781 : Dashboard Content as Advanced

* Update DashboardController.java

Implement partial solution for IDEMPIERE-4779

Fix issue with Timestamp not working for IDEMPIERE-4781
it was throwing:
12:58:07.928-----------> DashboardController.render: Failed to create dashboard content [358]
java.lang.NumberFormatException: Error at index 6 in: "474671+02"
	at java.base/java.lang.NumberFormatException.forCharSequence(NumberFormatException.java:81)
	at java.base/java.lang.Integer.parseInt(Integer.java:735)
	at java.sql/java.sql.Timestamp.valueOf(Timestamp.java:239)
	at org.adempiere.webui.desktop.DashboardController.fillParameter(DashboardController.java:974)

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-05-11 13:10:25 +02:00
Nicolas Micoud cdc867eb6d
IDEMPIERE-4780 : Dashboard / Report : hardcoded messages (#676) 2021-05-10 10:15:11 +08:00
Carlos Ruiz 713aa09a46
IDEMPIERE-4709 Print Format Item: implement script column (expression) (#663)
Peer review and tests
2021-04-22 21:15:40 +02:00
igorpojzl f74e6c7824
IDEMPIERE-4709 - Print Format Item: implement script column (expression) (#644)
* IDEMPIERE-4709 - Print Format Item: implement script column (expression)

* IDEMPIERE-4709 - Translated comments

* IDEMPIERE-4709 - Check Advanced Access, Null Script before save

* IDEMPIERE-4709 - Changed Naming

Changed Naming for Scripts.

* IDEMPIERE-4709 Remove Migration script mistake

* IDEMPIERE-4709 Logic and Value Name Fixes
2021-04-22 21:13:10 +02:00
Carlos Ruiz a9b224c25d
IDEMPIERE-4762 Add AD_StorageProvider_ID to AD_Attachment (FHCA-1165) (#662) 2021-04-22 15:13:33 +02:00
Carlos Ruiz c0927beaa4
IDEMPIERE-4763 Add IsDefault to AD_StorageProvider and use it when creating a new tenant (FHCA-1165) (#657)
* IDEMPIERE-4763 Add IsDefault to AD_StorageProvider and use it when creating a new tenant (FHCA-1165)

* Add column/field AD_StorageProvider.IsDefault
* Includes a minor refactoring of Login.loadDefault to add the ID column to the order by, to make predictable the ID returned when there are more than one record marked as default
* Context variable #AD_StorageProvider_ID is not created

* * Model class modified
2021-04-19 21:15:47 +08:00
Carlos Ruiz 355ef166f1
IDEMPIERE-4748 Window, Tab & Field: Fields that are not displayed in the frontend window are hidden also in the backend. (#650) 2021-04-12 13:28:20 +02:00
Ricardo Santana 6dd950a577
IDEMPIERE-4755 Change data access level of Report View to System+Client (#647)
* IDEMPIERE-4755 Change data access level of Report View to System+Client

* IDEMPIERE-4755 Change data access level of Report View to System+Client
 * mark table Report View as Advanced
 * disable filds classname and args
2021-04-08 19:05:27 +02:00
Carlos Ruiz 932ed8f498
IDEMPIERE-4727 Movement Window: a new line can be created for a movement that is completed. (#634)
* IDEMPIERE-4727 Movement Window: a new line can be created for a movement that is completed.

* IDEMPIERE-4727 Movement Window: a new line can be created for a movement that is completed.

Fix the problem also in model, to cover case when trying to add/modify lines for example via webservices

* IDEMPIERE-4727 Movement Window: a new line can be created for a movement that is completed.

Fix the problem also in model, change approach to use isProcessed instead of isComplete
2021-04-08 22:40:27 +08:00
Carlos Ruiz c8fd9a8805
IDEMPIERE-4736 FHCA-2461 IDEMP - ad_column table - Framework query improvement (#628)
* IDEMPIERE-4736 FHCA-2461 IDEMP - ad_column table - Framework query improvement

* * Rename migration scripts to normal convention
2021-03-16 17:03:40 +08:00
Carlos Ruiz 2e4daa8930
IDEMPIERE-4566 Translation Import/Export - output message is not visible (#624)
* Fix problem with wrong management of parameters when changing from Import to Export
* Delete the deprecated class, this is unused (IDEMPIERE-4723)
2021-03-12 10:45:39 +01:00
Carlos Ruiz 14d982abae
IDEMPIERE-4714 email password changes being displayed in the change log (#615)
* IDEMPIERE-4714 email password changes being displayed in the change log

* * minor fix adding a line to script
2021-03-09 15:00:12 +08:00
Carlos Ruiz 371afa054a
IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system) (#612)
* Minor fix for typo in process name
2021-03-06 15:41:51 +01:00
Carlos Ruiz 5f2d71347d
IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system) (#593)
* IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system)

WIP - initial version working on zk with google apps mail using OAuth2 Authorization Code Flow and Client Type = web application

* Enable imap reading with OAuth2 in RequestEMailProcessor
* Simplify the code - tested plain and OAuth2 can use the same methods
* Add +SCOPE parameter to AddAuthorizationForm according to IDEMPIERE-4713
* Rename the form AddAuthorizationMailForm to AddAuthorizationForm as is now more generic

* IDEMPIERE-4713
* Rename migration scripts to make it newer than IDEMPIERE-4713
* Add list of scopes attended by a credential
* Change form to accept other scopes, if no scope parameter is passed, then a list is shown, change the menu to fix the EMail scope
* Add MAuthorizationAccount.refreshAndGetAccessToken
* Add translation for messages

* make call generic oauth, avoid using specific google API

* Tests with microsoft as OAuth2 provider
* Add record for microsoft as provider
* Increase size of tokens
* Define mandatory and secure columns
* Update refresh token when it comes on the refresh call
* Revoke endpoint is optional

* Change the approach to a process instead of a form (WIP)
* Implement servlet to process the OAuth2 code

* Solve context suggestion from hengsin

* Implement the form in an automatic popup approach for running on zkwebui

* i18n - add translations for all messages that are shown to user
* on the form opted for click to avoid the problem with browsers forbidding popups
* clean spaces and tabs on line endings

* avoid logging and copy of the secure columns

* Fix problem reported by @d-ruiz about hidden NPE when SMTP Authentication is disabled

* Add writing to AD_PInstance_Para and AD_PInstance_Log the results of processing the servlet
* Control to avoid using the same authorization URL twice
2021-03-06 11:49:39 +01:00
Carlos Ruiz 41bf7ef3e6
IDEMPIERE-4488 Remove .classpath from repository (#608)
Fix project definition for migration folder - is not java nature
2021-03-04 13:55:47 +01:00
hengsin 1971b4f0dc
IDEMPIERE-4488 Remove .classpath from repository (#607)
* IDEMPIERE-4488 Remove .classpath from repository

* IDEMPIERE-4488 Remove .classpath from repository

add ignore for .classpath

* IDEMPIERE-4488 Remove .classpath from repository

remove ".settings/org.eclipse.jdt.core.prefs"

* IDEMPIERE-4488 Remove .classpath from repository

fix false status report for /bin and .project
2021-03-03 00:02:03 +01:00
Carlos Ruiz 47f7180eff
IDEMPIERE-4713 Allow definition of context variables to inject on menu and window definition (#600)
* IDEMPIERE-4713 Allow definition of context variables to inject on menu and window definition

* * Implement prefix "+" as suggested by @hengsin
* Clear the variable

* * Fix scope of methods and fix interface as suggested by @hengsin

* * Implement changes suggested by @hengsin
* Add control for clicking on new button on Favourites and menu
2021-02-23 16:24:39 +01:00
Carlos Ruiz 192354098c
IDEMPIERE-4705 Add grid toggle button to Detail Pane (#596)
Move to 8.2
2021-02-18 20:16:45 +01:00
hengsin b1d3f9c8fd
IDEMPIERE-4705 Add grid toggle button to Detail Pane (#594) 2021-02-18 19:38:46 +01:00
Martin Schönbeck 5e31c1fdb0
IDEMPIERE-4688 Adding Customs Tariff Number to products (#568)
* group1 and group2 also added to i_product
* Models generated for m_product and i_product, creating m_product from i_product extended with new fields.
2021-02-09 21:09:04 +01:00
Carlos Ruiz 0669760711
IDEMPIERE-3340 Adaxa's User Favorite which allow user to organize their menu, create folders (#569)
* Login Automatic Open Sequence -> buttons don't require names
* Login Automatic Open Sequence -> buttons look bad with non-font icons
* Clicking on + on an item of the favourites throws an NPE
* Implement same approach about checking for new button restricted on menu search, menu popup and quick entry popup
2021-02-04 21:39:15 +01:00
Deepak Pansheriya 373225a62c
Idempiere 3340 (#505)
* IDEMPIERE-3340 : User favorite with tree structure

* IDEMPIERE-3340: Marking write operation to safe for cross tenant safe

* IDEMPIERE-3340: Fixing Cross tenant access issue

* IDEMPIERE-3340: refactoring as review comment, Fixing renaming folder issue, Auto launch window shows all items irrespective of access

* Sync with IDEMPIERE-4251

* Sync with IDEMPIERE-4251

* IDEMPIERE-3340: Refactoring as review comment for caching,
 toolbar button restriction method with ID, tooltip messages, font base theme,
 remove double click event, etc.

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-02-04 21:36:25 +01:00
hengsin f5e9cd9336
IDEMPIERE-4654 Sales Order After Receipt Delivery Rule is not working (#536)
* IDEMPIERE-4654 Sales Order After Receipt Delivery Rule is not working

create shipment if it is fully paid and stock is available
use currencyconvertpayment
- rename after receipt to after payment
- added unit test for invoice payment

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-01-26 19:34:38 +08:00
hengsin e1ba21360f
IDEMPIERE-4653 Improve timeout handling of window tab (#534)
* IDEMPIERE-4653 Improve timeout handling of window tab

* IDEMPIERE-4653 Improve timeout handling of window tab

Fix error with find and refresh.
2021-01-20 13:27:58 +01:00
hengsin 59b83c3361
IDEMPIERE-4628 Implement configurable query timeout for info window (#532)
* IDEMPIERE-4628 Implement configurable query timeout for info window

* IDEMPIERE-4628 Implement configurable query timeout for info window

Move migration script from i8.2z to i8.2
2021-01-19 10:25:13 +08:00
Carlos Ruiz 0cfa1c182a
IDEMPIERE-4650 Problems with Language Management in PO (#530)
* IDEMPIERE-4650 Problems with Language Management in PO

* * Set GardenWorld to use multi-lingual documents
2021-01-18 19:57:33 +08:00