Skip to content
Permalink
Branch: master
Commits on Feb 14, 2020
  1. Jasper Report: `Account Sheet` - `Kontenblatt` (#6178)

    TheBestPessimist committed Feb 14, 2020
    * First draft of AccountSheetReport
    
    * Working draft of AccountSheetReport
    
    * Second working draft of AccountSheetReport; this one's faster
    
    * Add sql function `logDebug` which prints to the console
    
    * Update debug logs
    
    * Add how to use to `logDebug`
    
    * Add performance numbers
    
    * Rename column to `endingBalance` from `previousBalance` to better suggest the usage
    
    * Add the sql functions for AccountSheetReport and logDebug
    
    * Bugfix: Always show header for excel export, even if there are no rows
    
    This fixes an AIOUB exception when creating the header
    
    * Add Account Sheet Report Process
    
    * Rename the temporary table
    
    * Filter by `fact_acct.postingType=A`
    
    * Use `GET DIAGNOSTICS` instead of `select count`
    
    * `logDebug` is actually volatile, not immutable
    
    * Update Performance numbers
    
    * Add migration script
    
    * Add plea for help regarding performance
    
    * Properly create the temporary table, instead of using that trick
    
    * Cleanup
    
    * Return names instead of IDs
    
    Users finally know what they're looking at
    
    * Remove rows which have both amtacctdr == amtacctcr == 0
    
    * Add migration script
    
    * Update TRL
    
    * Update columns order
    
    #6121
  2. Jasper Report: Profit & Loss Report (#6160)

    TheBestPessimist committed Feb 14, 2020
    * Add ProfitAndLossBalance related sql functions
    
    * Element Values window: add AccountType to filters
    
    * Mark sql for deletion
    
    * Update function and columns name
    
    * Move sql file
    
    * Add Profit And Loss Report excel process
    
    * Mark ProfitAndLossBalanceForAccountInPeriod as stable
    
    * Add comment for function deprecation warning
    
    * Add IsSummary flag to ProfitAndLossReport
    
    * Change trls
    
    * Mark function as stable, not volatile
    
    * Update trl + add new ProfitAndLoss functions migration scripts
    
    #6148
Commits on Feb 5, 2020
  1. Bank Statement Import directly in Bank Statement window (#6089)

    TheBestPessimist committed Feb 5, 2020
    * Remove legacy fields from Import Bank Statement window
    
    #6061
    
    * Fix for LogicExpression "0" != "0.00"
    
    #6061
    
    * Add column `C_BankStatementLine.ImportedBillPartnerName`
    
    #6061
    
    * Update field C_BankStatementLine.ImportedBillPartnerName when running BankStatementImportProcess
    
    #6061
    
    * Annotations, etc.
    
    #6061
    
    * Mark PO-using method as deprecated and add RepoId alternative
    
    #6061
    
    * Add first draft of C_BankStatement_AllocateInvoice process and sql
    
    #6061
    
    * Add trl for Payment DocType
    
    #6061
    
    * Add BankStatementId RepoIdAware
    
    #6061
    
    * Add first test draft; refactor methods for easier testing
    
    #6061
    
    * Make all parameters of `C_BankStatement_AllocateInvoices` optional
    
    #6061
    
    * Add field C_BankStatementLine.ImportedBillPartnerIBAN
    
    #6061
    
    * Add and remove fields from  C_BankStatementLine webui
    
    #6061
    
    * Save `ImportedBillPartnerIBAN` to BankStatementLine during import process
    
    #6061
    
    * Link/Create Payments onComplete of BankStatement
    
    #6061
    
    * Add nullability annotations
    
    #6061
    
    * Handle the case where multiple payments might exist
    
    #6061
    
    * Retrieve BankAccount by Bpartner and Currency
    
    #6061
    
    * Refactor method name
    
    #6061
    
    * Add test depenency `de.metas.business` to `de.metas.banking`
    
    #6061
    
    * Add test for BankStatement completion
    
    Refactor classes around
    
    #6061
    
    * Add process `C_BankStatement_AddBpartnerAndPayment`
    
    #6061
    
    * Attempt #1 to fix pom.
    
    #6061
    
    * Better handle the case where multiple Payments for the same BankStatementLine exist
    
    #6061
    
    * Extract duplicate code to variable
    
    #6061
    
    * Refactor: Use Money instead of BigDecimal/Currency pair
    
    #6061
    
    * nullcheck
    
    #6061
    
    * Add process C_BankStatementLine_AllocatePayment
    
    #6061
    
    * Update trl
    
    #6061
    
    * Rename process
    
    #6061
    
    * Pass `additionalParameters` to `DataImportService`
    
    #6061
    
    * Add process for importing BankStatementLines from attachment
    
    #6061
    
    * Cleanup
    
    #6061
    
    * Cleanup
    
    #6061
    
    * Update doctype trl
    
    #6061
    
    * Move method to `IBankStatmentPaymentBL` from `BankStatementBL`
    
    #6061
    
    * Update possible test case
    
    #6061
    
    * Cleanup
    
    #6061
    
    * Deactivate redundant Process
    
    #6061
    
    * Add hardcoded BankStatementDataImport using the default Bank Statement format
    
    #6061
    
    * Add more trls
    
    #6061
    
    * Persist bpartner during the bank statement import
    
    #6061
    
    * Having DataImportConfigId hardcoded is fine
    
    #6061
    
    * Ignore my test package
    
    #6061
    
    * Use `LocalDate` instead of `Timestamp`
    
    #6061
    
    * Use DAO for saving Payment
    
    #6061
    
    * Deprecate `IProcessPreconditionsContext.getSelectedModel` and use instead `getSingleSelectedRecordId`
    
    #6061
    
    * Use DAO for saving BankStatement related POs
    
    #6061
    
    * Use explicit type when saving a PO inside DAOs instead of Object
    
    #6061
    
    * Update followup task name
    
    #6061
You can’t perform that action at this time.