Home » Categories » Solutions by Business Process » Order Processing and Invoicer » Invoicer and Discount Matrix

Sales Credit Notes - File Updating and Ledger Controls

Datafile Software

Sales Credit Notes - File Updating and Ledger Controls

When a sales credit note is generated the effect on the sales ledger is as follows:

The outstanding balance on the account is reduced by the total including tax, unless a payment adjustment is also updated where it would be unaffected.

The turnover figure on the account is reduced by the total excluding tax.

The last transaction date for the account is updated

The cost figures for the account are reduced

The debtor control total is reduced by the credit note total including tax, unless also marked as paid, in which case the total remains the same.

A credit note transaction is written to the transaction file, followed by an analysis line for each detail line.

A payment adjustment transaction is written to the file if the credit note is marked as paid (which you may do if the credit is for a cancelled invoice that was paid)

If stock is updated, the following occurs for each stock item:

The current stock level is increased by the quantity credited.

Period and year demand figures are reduced by the quantity invoiced.

Period and year sales values are reduced by the line total excluding tax.

Period and year cost values are reduced

The last transaction date is updated

A sales issue (with negative quantity) is written to the transaction file.

If job costing is updated the following occurs:

The amount invoiced on the job is reduced by the total excluding tax.

An ‘invoiced’ transaction is written to the job transactions file with a negative value
Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Compact and Audit Database
Viewed 1296 times since Wed, Jun 27, 2012
View System Status
Viewed 1345 times since Tue, Jun 26, 2012
Purchase Credit Notes
Viewed 1394 times since Tue, Jun 26, 2012
Sales Invoices - Printing the Document and Updating Files
Viewed 1732 times since Tue, Jun 26, 2012
Save and Exit - Document Design Manager
Viewed 1241 times since Wed, Jun 27, 2012
Set Database Profiles - Discount Matrix
Viewed 1617 times since Wed, Jun 27, 2012
Sales Invoices - Header Information - All Invoice Types
Viewed 1460 times since Tue, Jun 26, 2012
Product File Listings - Application User Facilities
Viewed 1231 times since Wed, Jun 27, 2012
Select Key Definition
Viewed 1278 times since Wed, Jun 27, 2012
Discount/Supplier Matrix in Use
Viewed 1279 times since Wed, Jun 27, 2012