...
- Link the payments to the bank and directly pay them
- Saving the batches as Draft and ability to load them later on
- Can create a batch from transactions and send it through approval
Different Flows:
- a A batch is created and going though the workflow (similar to the existing one in EPO)
- upon Upon receiving an invoice we can select an option and and the payment which is already linked to a bank would be generated (and paid? )
- We set a flag on the invoice and the invoices with this flag would be already in a batch generated automatically (with option to add more)
- having the supplier lines aggrigated to one or we can pay suppliers line by line
...
- Bank account
- Payment line aggregation (summing up all the lines of the supplier into one group)
UI/UX Design
- adding buttons to the top bar
- add the line to separate the filter form the title and also in a separate card also having animation when collapsing and opening.
- moving bank selection to the topbar where we have buttons and batch no.
- Put a filter icon near the title of the filter to indicate it is a filter.
- Adding spaces between cards. like Job card page
- scrolling of the grid should only happen in the grid and not the entire page. so the rest of the page remains steady and only the information in the grid is being scrolled.
- Remove the column headers.
- The amount should be aligned right.
- Change the checkbox to a square. instead of a rectangle.
- move the amount to the below and we can have a full text of the supplier name and invoice info,
Data structure
Tables:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE TABLE [dbo].[PaymentBatchAccounts_as_EvoOnline_PaymentBatchHeader]( [Id] [int] IDENTITY(1,1) NOT NULL, [AccountLinkBankAccountId] [int] NOT NULL, [iAllowICPurchasesDescription] [bit] NOT NULL, [Master_Sub_Account] [nvarchar](max250) NULL, [Account_TypeForeignBankCurrencyID] [nvarcharint](max) NULL, [Description] [nvarchar](max) NOT NULL, [iAccountTypeCurrencyId] [int] NOT NULL, [AcLookup] [nvarchar](max) NULL, [iForeignBankCurrencyIDAllocated] [intbit] NOT NULL, [CurrencyCode] [nvarchar](max) NULL, [CurrencyIdBankFileGenerated] [intbit] NOT NULL, [BranchId] [bigint] NULL, CONSTRAINT [PK_PaymentBatchAccounts] PRIMARY KEY CLUSTERED |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE TABLE [dbo].[PaymentBatchPayableLines_as_EvoOnline_PaymentBatchLine]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [AccountNumberAccountId] [nvarcharlong](max) NULL, [AccountName] [nvarchar](max) NULL, [Bic_Swift] [nvarchar](max) NULL, [IBAN] [nvarchar](max) NULL, [IsBankAccountValid] [bit] NOT NULL, [ExtOrderNum] [nvarchar](max) NULL, [InvoiceDate] [datetime2](7) NULL, [TxDescription] [nvarchar](max) NULL, [Reference] [nvarchar](max) NULL, [Order_No] [nvarchar](max) NULL, [UserName] [nvarchar](max) NULL, [cReference2] [nvarchar](max) NULL, [cAuditNumber] [nvarchar](max) NULL, [TrCodeDesc] [nvarchar](max) NULL, [Branch] [nvarchar](max) NULL, [Balance] [float] NOT NULL, [DocTotal] [float] NOT NULL, [UBD_DueDate] [datetime2](7) NULL, [UBD_Terms] [datetime2](7) NULL, [DCBalance] [float] NOT NULL, [fForeignBalance] [float] NOT NULL, [fForeignOutstanding] [float] NOT NULL, [OutstandingHome] [float] NOT NULL, [Module] [nvarchar](max) NULL, [Debit] [float] NOT NULL, [Credit] [float] NOT NULL, [DCLink] [int] NOT NULL, [Account] [nvarchar](max) NULL, [Name] [nvarchar](max) NULL, [Tax_Number] [nvarchar](max) NULL, [PurchaseOrderID] [bigint] NULL, [VendorID] [int] NOT NULL, [CurrencyID] [int] NOT NULL, [RemittanceChequeEFTs] [bit] NOT NULL, [TxOnHold] [bit] NOT NULL, [OnHold] [bit] NOT NULL, [BranchId] [bigint] NULL, CONSTRAINT [PK_PaymentBatchPayableLines] PRIMARY KEY CLUSTERED |
...