Home » Categories » Solutions by Business Process » Utilities

Import Payments and Allocate

Datafile Software Solutions

Import Payments and Allocate


The Sales and Purchase Batch Update definitions allow the facility to import a payment transaction and allocate this payment against an invoice with a matching payment allocation reference. This new feature allows the imported payment transaction to be matched against multiple invoice and credit transactions that share the same payment allocation reference.

Installation

Batch Update Installation Details

A new parameter has been added to the Optional Features of the Batch Update to extend the allocation matching process to multiple transactions. To update select Utility Programs from the main menu followed by Sales Ledger Batch Update or Purchase Ledger Batch Update as required, then select Installation Details followed by the required update definition before selecting Optional Features.

The key parameter settings for this facility are:

Payment Alloc Reference Item on Pay Trans – here you reference the item on the imported payment transaction that includes the reference being paid.

Item to Match on Inv – here you reference the item on the invoice / credit transactions that holds the matching reference value. If this item is left as 0 then the payment allocation reference is presumed to be the standard invoice reference. For the payment to be matched against multiple transactions you should set this value.

Payment Alloc against ALL Transaction Types – this parameter, new in Release 6.7, allows the facility for the payment allocation reference to be matched against multiple invoice and credit transactions. 

Note 

The value of the imported Payment transaction must equal the outstanding value of the transactions with the matching allocation reference – if values do not match the payment is imported but not allocated and a later manual allocation is required.

Custom Fields
  • Release ID: 6.7
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
End of Batch Update - Sales/Purchase Batch Updates
Viewed 1820 times since Thu, Jul 5, 2012
Data Items Cross Reference - Job Costing Batch Update
Viewed 1711 times since Thu, Jul 5, 2012
Link to Map Websites
Viewed 1817 times since Wed, Jun 13, 2012
Optional Features - Sales/Purchase Batch Updates
Viewed 1910 times since Thu, Jul 5, 2012
Import Payment Transactions and Summarise
Viewed 1931 times since Tue, Jun 12, 2012
Network File In Use
Viewed 1464 times since Wed, Feb 12, 2020
Job Costing Batch Update
Viewed 1696 times since Thu, Jul 5, 2012
ProFiler Options
Viewed 1690 times since Thu, Jul 5, 2012
Confirm Update Definition - Order Processing Batch Updates
Viewed 1746 times since Thu, Jul 5, 2012
Alternate Allocation Match Option
Viewed 2009 times since Fri, Jun 8, 2012