|
<< Click to Display Table of Contents >> ARCHG How to Match Customer Open Items Where Drs = Crs |
  
|
ARCHG How to Match Customer Open Items Where Drs = Crs
|
<< Click to Display Table of Contents >> ARCHG How to Match Customer Open Items Where Drs = Crs |
|
For open item transactions the key data field is the Invoice Number. Transactions other than sales invoices, as well as having a Reference field will also have an Invoice Number field. So when applying cash or credit notes against an open item customer, an existing open invoice number should be selected.
An open item invoice number becomes closed when all the transactions relating to the invoice number add to zero.
There are times when a credit has to be entered before a sales invoice has been created. In these cases it is most likely that the credit is entered with an unmatched invoice number, invoice number zero for example. When the invoice is created the invoice number will not match the credit's invoice number and therefore the transaction will not become closed even though the debits may equal the credits.
There are a number of ways to apply credits to invoice numbers:
| 1. | For credits you can edit the original credit transaction and change the invoice number |
to the correct invoice number.
| 2. | Go to Sales/Customers | Maintenance | Change InvNbr/Reference |
This screen enables the invoice number of credits to be changed to a valid invoice number.
| 3. | Where a credit has to be applied to multiple invoices you need to create journal entries to |
credit and debit the credit transaction to appropriate invoices.
Go to General Ledger | Transactions | Ledger Journal.
Alternatively go and edit the original credit transaction and apply the credit correctly.
Dealing with Head Office and Branch (Transfer-To) customer accounts.
To select transactions for a Branch (Transfer-To) customer:
Enter the Head Office customer in the Customer field and the Branch (Transfer-To) customer in the FromCustomer field.
To select all transactions for the Head Office customer:
Enter the Head Office Customer in the Customer field and use the wild card character " * " in the FromCustomer field. For this to work all FromCustomer have to use the same code structure.
EXAMPLE:
HO customer code = MICPCH
All branch codes are consistent, ie MICPBM, MICPCH, MICPDN. So therefore entering " MICP * " as the FromCustomer will return all branch transactions where the first 4 characters of the customer code = "MICP".
The incorrect allocation of payments to Branch invoices can be corrected by matching the FromCustomer and InvNbr. The FromCustomer for Payments and Journals can be changed to fix incorrect allocations.