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
Product Maintenance
Viewed 1352 times since Tue, Jun 26, 2012
Purchase Credit Notes - File Updating and Ledger Controls
Viewed 1358 times since Tue, Jun 26, 2012
Sales Invoices
Viewed 1445 times since Tue, Jun 26, 2012
Compact and Audit Database
Viewed 1122 times since Wed, Jun 27, 2012
Discount Matrix File Structure
Viewed 7586 times since Wed, Jun 27, 2012
Enter Prices Inclusive of VAT
Viewed 1346 times since Mon, Jun 11, 2012
Create New Account and Stock Record Maintenance Screens
Viewed 1211 times since Fri, Jun 8, 2012
Document Watermark - Document Design Manager
Viewed 1149 times since Wed, Jun 27, 2012
Add Matrix Entries
Viewed 4642 times since Wed, Jun 27, 2012
Set Auto Expand Files
Viewed 1187 times since Wed, Jun 27, 2012