Sage Evolution
Space shortcuts
Page tree

Versions Compared

Old Version 11

changes.mady.by.user Roozbeh

Saved on

compared with

New Version 12

changes.mady.by.user Roozbeh

Saved on

Key

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

...

  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 


Data structure 


Tables: 

Code Block
languagesql
titleHeader table
collapsetrue
CREATE TABLE [dbo].[PaymentBatchAccounts](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[AccountLink] [int] NOT NULL,
	[iAllowICPurchases] [bit] NOT NULL,
	[Master_Sub_Account] [nvarchar](max) NULL,
	[Account_Type] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[iAccountType] [int] NOT NULL,
	[AcLookup] [nvarchar](max) NULL,
	[iForeignBankCurrencyID] [int] NOT NULL,
	[CurrencyCode] [nvarchar](max) NULL,
	[CurrencyId] [int] NOT NULL,
	[BranchId] [bigint] NULL,
 CONSTRAINT [PK_PaymentBatchAccounts] PRIMARY KEY CLUSTERED

...