Requirements: 

Phase1:

1. Loading supplier transactions which are not allocated and not paid yet. 
2. User can filter the transactions by 
   1. Supplier range 
   2. Due date
   3. on hold suppliers 
   4. Remittance cheque EFT
   5. transaction on hold
   6. Action date
3. Can see the total 
4. Can allocate the transactions individually or as a batch 
5. Can view the supplier information of the transaction 
   1. the user with permission should be able to modify the supplier bank information.
6. Can view attachments linked to that invoice
7. Due dates are color-coded (red, yellow, green) to indicate urgency.
8. Download the report of the transactions 
9. Can download the bank file. 
10. Can configure the bank file. (settings)
11. Every action is permission based
12. Email remittenace advise to the supplier, how much we are paying which invoice  
13. Batch should be validated against the bank file structure. 
    1. supplier bank information should be validated.
    2. should be validated if the line has been already paid or not.

...

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. We can't add lines that are already in the batch 
2. Making sure not to overpay a supplier
3. We can't send a negative value (total)

Design: 

Filter: 

1. Supplier filter: 
   1. supplier area
   2. supplier class
   3. supplier group 
   4. supplier on hold
   5. supplier range (from -to)
2. Transaction filter: 
   1. transaction on hold
   2. Due date
   3. action date

Settings:

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: 

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 

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 

...