One moment please...
 
 
Exact Globe+   
 

Defining sales journal columns

Creating and Modifying Purchase Journal Columns

Introduction 

When you are creating or modifying a sales journal entry, you can add or remove the columns displayed on the Make sales entry screen by clicking columnnicon.png Columns at the toolbar.

Fields

Header section

This section refers to the columns in the sales journal header. If you want certain columns to be available in the sales journal header, select the relevant check boxes for the columns. For example, if you want the XRate column to be available in the sales journal header, select the XRate check box.

Date

Type the transaction date of the sales journal entry. By default, the date displayed is based on the system date. This information is mandatory.

Reporting date

Type the reporting date of the sales journal entry. By default, the reporting date displayed is based on the system date. This information is mandatory.

Entry no.

Type the entry number of the sales journal entry. By default, the Entry no. column displays an entry number after you press the TAB key at Jrnl column.

Note: The Entry no. column cannot be edited once you press TAB. This entry number is derived from the selected sales journal at System ➔ Finance ➔ Journals.

Our ref.

By default, the Our ref. column displays the our reference number after you press TAB at Jrnl column. The reference number displayed is based on the Sales journal defined at System ➔ General ➔ Settings ➔ Number settings. Type or select another reference number for the sales journal when there are others that need to be entered.

Currency

Type or select another currency for the sales journal entry when there are foreign currencies that need to be entered. By default, the currency displayed is based on the Default currency defined at System ➔ General ➔ Settings ➔ General settings.

XRate

Type an exchange rate for the sales journal entry when a foreign currency is entered. By default, the exchange rate displayed is based on the Exchange rate defined at the exchange rates maintenance (go to System ➔ General ➔ Countries ➔ Exchange rates and select the relevant currency).

Amount (EUR)

This column displays the default currency amount after you press TAB at Amount column.

Note: In this column, the default currency is EUR. Therefore, this column is displayed as Amount (EUR). If the default currency is USD, GBP, CNY, or others, this column will be displayed accordingly.

Invoice type

By default, the Invoice type column displays the sales invoice type based on the positive or negative amount entered. If you type in a positive amount, the sales invoice type will become Sales Invoice and if a negative amount is entered, the sales invoice type becomes Sales credit note.

Description

Type a description for the sales journal entry.

Cost center

By default, the Cost center column is displayed based on the resource who creates the sales journal entry. Type or select a different cost center if you do not want to use the default option.

Note: You can create cost centers at System ➔ Finance ➔ Cost centers/units ➔ Cost centers.

Cost unit

Type or select the cost unit for the sales journal entry.

Note: You can create cost units at System ➔ Finance ➔ Cost centers/units ➔ Cost units.

Project code

Type or select the project code for the sales journal entry.

Free field 1, 2, 3, 4, 5

There are five free fields allocated for the sales journal. Use this column(s) to enter additional information, if any. These fields can be used to suit your personal preferences. You can specify the names for these free fields by selecting the General ledger transactions table at System ➔ General ➔ Free fields.

Payment condition

Type or select a payment condition for the sales journal. By default, the payment condition displayed is based on the Payment condition defined at the Financial tab of the selected debtor at Finance ➔ Accounts receivable ➔ Maintain.

Inv due date

This column displays the invoice due date based on the payment condition selected. This column cannot be edited.

Line section

This section refers to the columns in the sales journal lines. If you want certain columns to be available in the sales journal lines, select the relevant check boxes for the columns. For example, if you want the Cost center column to be available in the sales journal lines, select the Cost center check box. 

SO no.

Type the sales order number for the sales journal entry. 

Item cd.

Type or select an item code for the sales journal entry.

Item - Description

By default, the Item - Description column displays the description of the selected item. This column is disabled the moment you create or modify a sales journal entry.

G/L - Description

By default, the G/L - Description column displays the description of the selected general ledger account. This column is disabled the moment you create or modify a sales journal entry.

Resource

By default, the Resource column displays the representative of the debtor. Type or select a different resource if you do not want to use the default option.

Project code

Type or select a project code for the sales journal entry.

Cost center

Type or select a different cost center if there are other cost centers that need to be entered. By default, the cost center displayed is based on the cost center selected from the header section. Otherwise, the cost center is based on the selected general ledger account. This is defined at Default Cost center from general ledger maintenance (go to Finance ➔ General ledger ➔ Chart of G/L’s and select the relevant general ledger account) under the Cost centers/cost units tab.

Note: You can create cost centers at System ➔ Finance ➔ Cost centers/units ➔ Cost centers.

Cost unit

Type or select the cost unit for the sales journal entry. By default, the cost unit displayed is based on the selected general ledger account. This is defined at Default Cost unit from general ledger maintenance (go to Finance ➔ General ledger ➔ Chart of G/L’s and select the relevant general ledger account) under the Cost centers/cost units tab.

Note: You can create cost units at System ➔ Finance ➔ Cost centers/units ➔ Cost units.

Quantity

Type the quantity for the sales journal entry. You can enter a positive or negative amount in this column.

Tax

Type or select the tax or VAT code for the sales journal entry. By default, the tax or VAT displayed is based on the VAT defined for the selected customer at the debtor maintenance (go to Finance ➔ Accounts receivable ➔ Maintain and select the relevant debtor) under the Financial tab in the VAT section.

Note: You can create tax or VAT at System ➔ General ➔ Countries ➔ Tax codes.

Amount (EUR)

The Amount (EUR) column displays the sales journal entry amount in the default/local currency. This column cannot be edited.

Tax basis

By default, the Tax basis column displays the entered Amount of the sales journal entry.

Note: System uses this column as a basis to calculate the tax or value-added tax.

Tax amount

By default, the Tax amount column displays the tax or value-added tax amount that need to be paid by the customer.

Warehouse

Type or select the code of the warehouse where the selected item is stored. By default, the warehouse code displayed is based on the selected item. This information is mandatory.

Description

By default, the description displayed is based on the Description entered at the header section. Type another description if there are others that need to be entered.

Free field 1, 2, 3, 4, 5

There are five free fields allocated for every sales journal line. Use this column(s) to enter additional information, if any. These fields can be used to suit your personal preferences. You can specify the names for these free fields by selecting the General ledger transactions table at System ➔ General Free fields.

Setting: Dialog section

In this section, you can set the messages that you want to display on the sales journal entry screen when making changes to the entries. These messages serve to warn the user who is creating/modifying the sales journal entries of the changes before proceeding with the change. Select Always to always proceed with the changes without displaying a message, select Never to never proceed with the changes, therefore no message will be displayed, or select Ask user if you want the message to be displayed for the changes made to the sales journal before proceeding with the changes.

Are you sure you want to cancel?

The "Escape means cancelling the transaction. Are you sure you want to delete?" message is displayed whenever you press the ESC key on the sales journal entry screen. Click Yes to return to the Finance ➔ Entries ➔ Sales screen, or click No to return to the Make sales entry screen.

Delete entry line?

The "Delete entry line?" message is displayed when you select a sales journal entry line and click  Delete line. Click Yes to delete the sales journal entry line, or click No to return to the sales journal entry screen and the entry line will not be deleted.

Already used: Continue anyway?

The "Already used: Your reference #. Continue anyway?" message is displayed if the same number is used in Your reference for the same debtor. Click Yes to continue using the same your reference number, or click No to return to the Make salese entry screen and to key in another reference number at Your reference.

Already processed

The "Already processed. Would you like to continue?" message is displayed when you want to edit sales entries that have been processed. Click Yes to edit the sales journal entries, or click No to return to the Make sales entry screen without editing the entries.

INTRASTAT: Financial entries?

Select Yes to enable the INTRASTAT data to be entered in the sales journal for a debtor from another European Union (EU) country. Alternatively, select No if you do not need to enter any INTRASTAT data in the sales journal. For more information, see Creating and Maintaining INTRASTAT for Sales Journal Entries.

Entry already matched. Continue?

The "Entry aldready matched. Editing will unmatch this entry. Continue?" message is displayed when you want to edit a matched sales journal entry. Click Yes to edit the sales journal entry and the system will unmatch the entry, or click No to return to the Make sales entry screen without editing the journal entry.

Copy description from previous entry

Select Always to always copy the description in the header from the previous Make sales entry screen. Alternatively, you can select Never to never copy the description in the header from the previous Make sales entry screen.

Buttons

Restore defaults

Click this for the system to restore the original/default column(s).

Set as default

Click this for the system to set the selected column(s) layout as the default for all users.

Advanced

Click this to select all check boxes in the Header (except for XRate, Cost center, Cost unit and Payment condition) and Line (except for VAT basis and Final invoice) sections.

Simple

Click this to select the basic check boxes in the Header and Line sections such as Date, Entry no., G/L - Description, VAT, and Description.

Close

Click this to exit and to return to the Make sales entry screen.

Related documents

     
 Main Category: Attachments & notes  Document Type: Support - On-line help
 Category:  Security  level: All - 0
 Sub category:  Document ID: 17.754.635
 Assortment:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer