Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Link the payments to the bank and directly pay them 
  2. Saving the batches as Draft and ability to load them later on
  3. Can create a batch from transactions and send it through approval


Different Flows: 

  1. a A batch is created and going though the workflow (similar to the existing one in EPO)
  2. 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? )
  3. 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)
  4. having the supplier lines aggrigated to one or we can pay suppliers line by line 

...

  1. Bank account 
  2. Payment line aggregation (summing up all the lines of the supplier into one group) 


UI/UX Design 


  • adding buttons to the top bar

Image Added


  • add the line to separate the filter form the title and also in a separate card also having animation when collapsing and opening. 

Image Added


  • 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. Image Added
  • 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,  Image Added



Data structure 


Tables: 

Code Block
languagesql
titleHeader table
collapsetrue
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
languagesql
titlePayment lines
collapsetrue
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 

...