Cash In, Cash Out
This page describes the Cash In and Cash Out forms in the Cash Book module.
---
The Cash In and Cash Out forms allow you to print records from the Cash In and Cash Out registers respectively.
A file containing samples of Form Templates suitable for use with each form is supplied with Standard ERP. This file includes sample Cash In and Cash Out Form Templates which have the Form Codes "CSHIN" and "CSHOUT" respectively. The Form Types of these Form Templates are "Cash In" and "Cash Out".
You can print cash transactions using the following methods:
- After opening a Cash In or Cash Out record in a record window, click the Printer icon in the Button Bar (Windows/macOS only) or select 'Print' from the File menu (all platforms). If you want to print to screen, click the Preview icon (Windows/macOS only).
- Open the 'Cash In: Browse' or 'Cash Out: Browse' windows, select one or more cash transactions in the list and then select 'Print' from the File menu. Documents for the selected records will then be printed.
If you are using Windows or macOS, you can highlight several cash transactions in the list by holding down the Shift key while clicking. If you need to apply a function to a number of Invoices that aren't in a range, highlight them while holding the Ctrl (Windows) or ⌘ (macOS) keys before selecting the function. If you are using iOS or Android, you can highlight a single record in the browse window by searching for it, so you will only be able to print a single record at a time using this method.
- Open the list of forms in the Cash Book module. If you are using Windows or macOS, you can do this by clicking the [Forms] button in the Navigation Centre or using the Ctrl-D/⌘-D keyboard shortcut. If you are using iOS or Android, tap the [Routines] button in the Navigation Centre and then tap [Forms]. Then double-click or tap 'Cash In' or 'Cash Out' as appropriate in the 'Forms' list.
The 'Specify Cash In' or 'Specify Cash Out' (depending on which option you selected in the previous paragraph) window will be shown.
Enter the Cash In or Cash Out Number of the single cash transaction that you need to be printed, or the highest and lowest Cash In or Cash Out Numbers of a range of transactions separated by a colon (:). You must specify a Cash In or Cash Out Number or range of Numbers: if you leave this field empty, no forms will be printed.
Press [Run] to start the printout.
You can use the fields listed below when you design the Form Templates to be used by the Cash In and Cash Out forms. Unless otherwise stated, you can use these fields in both Form Templates. If you do not want to print the decimal places in numeric fields, choose the
Cut Decimals option in the record in the
Values in Text setting for the Language specified in the
Company Info setting.
Header Fields
These fields will be printed once per Cash In or Cash Out.
| Field in Form Template | Prints (from Cash In or Cash Out) |
| |
| Address | Name (if you are using the Organisation name option in the Form Settings setting) and Address. This information will be printed on separate lines, so you should specify a Line Height for this field. Use the Form Settings setting to set the format of this field (e.g. to specify whether blank lines will be printed, whether parts of the address will be printed on the same line, etc.) |
| Address 1 | First line of Address |
| Address 2 | Second line of Address |
| Address 3 | Third line of Address |
| Address 5 | Fourth line of Address |
| Address 6 | Fifth line of Address |
| Comment | Specification |
| Comment 2 | Comment (only used in the Cash Out form) |
| Corresponding Mode | Expense A/C |
| Corresponding Mode Account | Account from the connected Expense Account record |
| Currency | Currency from the cash transaction or, if blank, Base Currency 1 |
| Currency Name | Name from the Currency record |
| Customer Name | Name (i.e. Customer or Supplier Name) |
| Customer Number | Customer (Cash In) or Supplier (Cash Out) |
| Day | The day from the Date. For example, the day from 2 January 2021 will be printed as "2" |
| Invoice Number | In a cash transaction that was created from an Invoice or Receipt, prints the No. of the originating record (e.g. Invoice Number or Receipt Number) (only used in the Cash In form) |
| Month | The month from the Date. For example, the month from 2 January 2021 will be printed as "1" |
| Month in words | The name of the month in the Date, taken from the record in the Days and Months setting in the System module for the Language in the Cash In or Cash Out record or, if that is blank, in the current user's Person record |
| Official Serial Number | Official No. |
| Payment Mode | Pay Mode |
| Payment Mode 2 | Comment from the Payment Mode |
| Payment Mode TAX Value | Total (only used in the Cash In form) |
| Payment Mode Total Including TAX | Tax (only used in the Cash In form) |
| Payment Number for Russia | Prints the No. of the Cash In or Cash Out record with the first three characters removed |
| Person | Person |
| Reference | Reference |
| Security Account | Account from the connected Expense Account record |
| Serial Number (Number Series) | No. |
| Signature | Name from the current user's Person record |
| Subtotal with VAT | Net + VAT (only used in the Cash In form) |
| Sum | Net |
| TAX Sum | Tax (only used in the Cash In form) |
| To Pay | Total |
| To Pay in Base Currency 1 | Total, converted to Base Currency 1 |
| To Pay in Base Currency 2 | Total, converted to Base Currency 2 |
| To Pay in Text | Prints the Total as a phrase. The phrase is constructed using the relevant record in the Values in Text setting for the Language in the current user's Person record or in the Company Info setting |
| Transaction Date (transdate) | Date |
| VAT | VAT |
| Year | The year from the Date. For example, the year from 2 January 2021 will be printed as "2021" |
Customer/Supplier Information
The following fields print information taken from the record in the Contact register for the Customer (Cash In) or Supplier (Cash Out)
| Field in Form Template | Prints (from the Contact record for the Customer or Supplier) |
| |
| Bank Account | Bank Account (only used in the Cash Out form) |
| Bank Name | Name from the Bank record specified in the Account Operator field (only used in the Cash Out form) |
| Customer Registration No. 1 | Reg. No. 1 |
| Customer Registration No. 2 | Reg. No. 2 |
| Customer VAT Reg. Number | VAT Reg. No. |
| Supplier VAT Reg. Number | VAT Reg. No. (only used in the Cash Out form) |
Invoice Information
If a Cash In record was created from a Sales Invoice, the following fields will print information taken from the originating Invoice:
| Field in Form Template | Prints (from Invoice) |
| |
| Invoice Number | No. |
| Sales Account | Prints a list of the Sales Accounts and VAT Output Accounts used in the Invoice, separated by commas. If the Cash In being printed was not created from a Sales Invoice, this field will print the Account from the connected Expense Account record |
| Sub Currency | Currency |
| Sub Currency Name | Name from the Currency record |
| Sub Customer Code | Customer No. |
| Sub Customer Name | Customer Name |
| Total in Base Currency 1, row | Base |
| Total Row | Base |
| Transaction Date | Trans. Date |
Person Information
The following fields print information taken from the record in the Person register for the Person specified in the cash transaction
| Field in Form Template | Prints (from Person record) |
| |
| Our Reference (ourref) | Our Ref |
| Person Account | Account |
| Person Comment | Comment |
| Person ID | Personal ID |
| Person Specification | Specification |
| Salesman Name | Name |
Purchase Invoice Information
If a Cash Out record was created from a Purchase Invoice, the following fields will print information taken from the originating Invoice:
| Field in Form Template | Prints (from Purchase Invoice) |
| |
| Invoice Number | No. |
| Sales Account | Prints a list of the Cost Accounts and VAT Input Accounts used in the Purchase Invoice, separated by commas. If the Cash Out being printed was not created from a Purchase Invoice, this field will print the Account from the connected Expense Account record |
| Sub Currency | Currency |
| Sub Currency Name | Name from the Currency record |
| Sub Customer Code | Supplier No. |
| Sub Customer Name | Supplier Name |
| Total in Base Currency 1, row | Base |
| Total Row | Base |
| Transaction Date | Trans. Date |
Row Fields
These fields will be printed once per row (on the
'Payments' card), so remember to specify a Line Height and to set the Format to "Matrix".
| Field in Form Template | Prints (from Cash In or Cash Out row) |
| |
| Bank Name 2 | If the Type is "Cheque" or "Own Cheque", prints the Name (Bank Name) from the connected Cheque or Own Cheque record (only used in the Cash Out form) |
| Bank Name per Row | If the Type is "Cheque", prints the Name (Bank Name) from the connected Cheque record (only used in the Cash In form) |
| Cheque Number | If the Type is "Cheque", prints the Cheque No. from the connected Cheque record. In the Cash Out form only, if the Type is "Own Cheque", prints the Cheque No. from the connected Own Cheque record |
| Corresponding Mode, Row | Expense A/C from flip B |
| Corresponding Mode Account, Row | Account from the connected Expense Account record |
| Description 1 | Comment from flip B |
| Invoice Number 2 | Number from flip A |
| Order Number | Order from flip A |
| Payment Mode, row | Prints the Pay. Mode from flip B or, if blank, from the 'Amounts' card |
| Payment Mode Comment, Row | Prints the Comment from the Payment Mode specified on flip B or, if blank, from the Payment Mode specified on the 'Amounts' card |
| Row Sum | Sum from flip A |
| Supplier Invoice Number | If the Type is "Purchase Invoice", prints the Supp. Inv. No. of the Purchase Invoice (only used in the Cash Out form) |
| Tag/Object | Tags/Objects from flip A |
| Text Type | Type from flip A |
Please refer
here for details about the standard fields that you can also include in the Form Template.
---
Go back to:
