Page tree
Skip to end of metadata
Go to start of metadata

This page is a manual for the use of Sage master data. For each page is a chapter. 

Table of contents

1. Sales representative

Overview

TODO: explain purpose 

After logging in navigate to > Account receivable > Sales representative. 

Shows an overview of sales representatives. (Shown in the next figure)

  1. New sales representative: Open modal to create a sales representative. 
  2. Export: Export shown data to an excel Microsoft Excel Open XML Format Spreadsheet file.
  3. Column chooser: Manage the visible columns. 
  4. Options: Manage data grid settings and functionalities.
  5. Search: Enter a search filter to search through all sales representative columns for the given filter. E.g. a first name, part of the address or bank account.
  6. Edit: Edit a sales representative; can also double click on the row to trigger the edit. 
  7. Remove: Remove the sales representative. 

Edit / Create sales representative

  1. Sales representative: Insert/edit the representative's code, name, address, back account and if on hold. 
  2. Commission method: Set Turnover for commission on revenue or Profit for commission on profit. Set the target amount with the linked Commission (same line-height on the right) from 0-100%.
  3. Comments: Add multiple comments for clarification. 
  4. Save: Save the current sales representative.
  5. Close: Cancel the current create/edit. 

Connected tables

_btblNotes linked in Sage but not used in EVO. 

Data 

On hold: Y=true | N=false

Method: Turnover=1 | Profit=2

Validations

Create: Linked with BranchId

Read: None

Update: None

Delete: Can't delete if Sales Rep Id is used in: InvNum.DocRepID, Client.RepId, PostAR.RepId, _btblJCMaster.iSalesRpID. 


Possible to add functionality if linked id found: Suggestion: "Do you rather want to set the sales rep representative on hold?" 


2. Ageing period

Connected tables

_btblNotes linked in Sage but not used in EVO. 

Uses _etblPeriod to get periods, not particularly linked.

Validations

Create: Linked with BranchId.

Intervals and 

Read: None

Update: None

Delete: Can't delete if Ageing Period is used in: Vendor.iAgeingTermsId, Client.iAgeingTermsId.


_etblTerms.iModule = 0 = Accounts Payable = Supplier/Purchases
_etblTerms.iModule = 1 = Accounts Receivable = Customer/Sales 


No version differences in Sage DB version 7.2, 10.0, 11.0, 11.1.

















  • No labels