Setup > A/P-A/R accounting > Files > Treasury 

This function is used to set up the content of specific fields sent to the cash management software, when exporting the payment schedule (see the documentation Export of the Sage cash management payment schedule).

Knowing that this export function only takes into account open items that are associated with posted invoices (invoices in a general sense, including credit memos, debit notes etc.), the setup principle is as follows: for a triplet [Module of origin of the invoice]+[Cash Management file field]+[Document type], it is possible to define which context data must be used in the generated file.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Fields

    The following fields are present on this tab :

    Header

    • Module (field MODULE)

    Used to create the parameterization according to the module of origin of the invoices whose open items are exported.
    The various possible values are thus: Sales, Purchasing and A/P-A/R Accounting.

    • Zone code (field CODCAS)

    Code of the field in the open item export file whose content can be set up.
    This code matches the code under which it is known in the cash management software:

    • local menu 2672, for the interface to the Sage Concept Cash Management software,
    • local menu 2675, for the interface to the Sage 1000 Cash Management software,
    • local menu 2685, for the interface to the Sage FRP Cash management.software.

    SEEINFO In these three cases, the local menu must contain codes in capital letters.

    Grid List

    Used to modify the content of the fields of the generated file on the basis of the journaltype of the invoice entry whose open items are read.
    They are the journal types 'Customer invoices', 'Customer credit memos', Supplier credit memos', etc.
    The particular case of the posted open item statements should be underlined: the latter are duly taken into account (if they are not closed, etc.) by the open item export. The open items associated with the 'Statement' journal type can thus be the subject of a particular parameterization.

    • Formula (field CLCFOR)

    The parameterization formula can be entered with the help of the formula assistant.
    The main tables accessibles are proposed by default: 

    • the open item table (GACCDUDATE),
    • the entry table (GACCENTRY, GACCENTRYD, GACCENTRYA),
    • the invoice header tables (PINVOICE and SINVOICE),
    • the Purchase and Sales invoice header tables (PINVOICEV and SINVOICEV) depending on the selected module,
    • the BP tables (BPARTNER, BPSUPPLIER and BPCUSTOMER),

    Close

     

    Length and content of the fields

    The export file of the open items has a fixed length (see the documentation Export of the Sage cash management payment schedule).
    Therefore, the content of a field can be truncated if, because of the setup, it contains too many characters with respect to its maximum length in the cash management software.

    Concerning the interface to the Sage Concept Cash Management module:

    • for the Nature code (CPTA) = 16 characters max
    • for the Annex code (CDC) = 16 characters max
    • for the Comment (DESCR) = 32 characters max
    • for the Reference code (CODRIF) = 8 characters max
    • for the Check number (NASS) = 8 characters max

     SEEWARNING The setup of some fields must also take the followingconstraintsinto account:

    • the Nature (CPTA) and Annex (CDC) fields
      At the level of the cash management software, these fields point to a value table; it is thus recommended to load them in the same way for the export of the open items.
    • the Check number field (NASS)
      This field should not be used to recover a check number, which does not exist at this stage in the life cycle of the open items, but rather to recover additional information (if, for instance, CODRIF and DESCR are not sufficient)

    Concerning the interface to the Sage 1000 Cash Management module:

    • for the Transfer code (TRANS) = 128 characters max
    • for the Description code (DESCR) = 128 characters max

     SEEINFOThese fields do not point to value tables, at Sage 1000 Cash Management module level.

    Concerning the interface to Sage FRP Treasury

    • for the Description code (DESCR) = 32 characters max,
    • for the Reference code (REFXRT) = 16 characters max.

     SEEINFOThese fields do not point to value tables, at Sage FRP Treasury module level.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation