Skip to main content

Next Generation - Multi Entity and Sales Ledger Debit Adjustments

This article aims to guide you through the rules for sub ledgers when using Multi Entity on a sales ledger debit adjustments.

If you are interested in creating a sales ledger debit adjustment without using multi entity, please refer to our Enter a sales ledger debit adjustment article.

This article will highlight the rules for you when using Multi Entity and will also provide you information about the sales ledger debit adjustment screen in general.

Access debit adjustments from the navigator

To access an invoice directly from the navigator, follow the steps below:

  1. Click Debtors then click Transactions.

  2. Select Debit Adjustment.

Important rules when using sub ledgers and or Multi Entity

  • When you use Sub Ledgers or Multi Entity and visit the Sales Debit Adjustment screen for the first time, the Sub Ledger field is going to default to empty regardless of you having a sub ledger set up for the Sales Ledger or if the user you are logged into Financials with is assigned a default sales sub ledger in their security profile.

  • Once you have saved a debit adjustment with a particular sub ledger, this sub ledger will be saved against your user as the user preference, so when you open the Sales Ledger Debit Adjustment screen again, the sub ledger field will be prefilled for you with the previously used sub ledger record.

  • You can change the sub ledger manually and if you have selected a different sub ledger than on the previous receipt, then this newly selected sub ledger will be saved against your user preference.

  • Your selected sub ledger drives the defaults on the Debit Adjustment screen and the Categories will be prefiltered based on the sub leger you are working with.

  • When you use a customer where you have assigned an analysis record that is assigned to a sub ledger but that sub ledger is different to the one you have last used on the debit adjustment, you must change the sub ledger to match the same sub ledger on the analysis record to avoid a validation error.

  • When you manually type over the default categories tied to the same sub ledger selected on the header, upon clicking Save on the transaction, you will encounter a validation error alerting you that the categories must align with those belonging to the same sub ledger specified on the header.

  • The project and cost centre that you selected on the Details section for a receipt are filtered based on the sub ledger you have used on the Header section of the debit adjustment making it easier for you to select a record.

Below is an explanation of how to enter your details on the header and details sections of a debit adjustment:

Tabs

Description

Header

  • You can enter the customer account code, If you're unsure of the code, you can click on the drop-down arrow and select the Show More option which displays several more records and offers you the option to search on the code and the name of the customer.

    • You can type in a customer who's been set to be On Stop as a prompt appears to confirm this action.

    • If your customer is set up as an any currency customer, after leaving the customer field, this enables the currency field and populates with the default currency the customer has been set up with.

    • You can change the currency either by:

      • Typing in the code.

      • Clicking the drop down arrow and select from the record list.

      • Clicking Show More.

  • For more information on setting up an any currency customer, follow our article on setting up an any currency customer.

    • When you select a currency that's different to the currency of the database, the Exchange Rate field presents with either the default rate that is assigned to the customer or the most relevant rate from the system which you can update manually.
      Note: Adding a manual rate only saves against the debit adjustment and not the customer or the exchange rates.

  • The Transaction Date is always default to the system date, you can either enter it manually or you can select it from the date picker via the calendar icon.

  • The Year and Period fields default to the closest year and period to the current date depending on the system settings. If you have permission to post to restricted periods or have future period posting permission, you're able to post to future periods and past years and periods depending on the start date in your system settings.

  • The Reference field allows you to enter an alphanumeric reference for the transaction.

  • The Description field, you can enter a brief description and this prints on the customers statement.

  • The Sub Ledger field, you can manually type in the code or name if you know it, click on the drop-down arrow and select from the list, or find the record by selecting Show More.

  • You can enter a GBP value or a Currency value for the transaction.

Customer

  • We removed the speech bubble next to the customer record and moved all the information regarding the customer in the Customer tab. You can view the Aged Debt, Account Balance, and Contact details.

  • Clicking the email hyperlink in the Contact Details section, opens your email application with the email populated.

Credit Control Notes

  • You can view any existing credit control notes and add new notes by clicking + New Note.

  • Any notes you add in through Credit Control Notes save against this transaction.

Custom

  • All Custom fields which are set up for your database group together. These can hold extra information about the transaction you're working with.

The Summary section

Field

Description

Sales Analysis

  • The Analysis field populates with the default sales analysis code.

    • If you assign your customer a default sales analysis code, this analysis displays on the debit adjustment.

    • If you don't have a default set against the customer, then the system default pulls through.

  • This determines how this line is being analysed in both your sales and nominal ledgers. You can change the code by entering a different code or by selecting one from the drop-down list or from the Show More option.

Project and Cost Centre

  • If you use the Costing module in Access Financials, you can add the project and cost centre. If you have Compulsory Costing set up, you need to enter both the project and cost centre otherwise a validation message appears when saving the order.

  • Clicking the drop-down in the Project Code/Name field, you can select the record you wish to work with, or you can access more records by selecting Show More.

    • Clicking + New Project, you can create a new project which automatically populates in the Project field.

    • Clicking + New Cost Centre, you can create a new cost centre. The project automatically populates with the previously created project. You can add the code and name then click Save. The Cost Centre Code/Name field pre populates with the newly created record.

  • If Transaction User Keys are set up on your database and are in the columns on the Details section, you can see these columns as default after the Project and Cost Centre columns. You can find more information on the Transactions user keys at the end of this article.

    • Note: The labels for the transaction user keys are customisable so you might see different labels display.

    • You can select a value from the drop-down or enter values into all of the Transaction User Key columns. Any manual values you enter only save for this transaction.

Transaction User Keys

If you're using transaction user keys, these display on the detail line of an credit note.

For more information on setting up transaction user keys, follow our article on transaction user keys.

For information on attaching a transaction user key to a transaction, follow our article on attaching transaction user keys.

Did this answer your question?