Home » Categories » Solutions by Business Process » Utilities |
Import Payment Transactions and Summarise |
Article Number: 219 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 4:22 PM
|
Datafile Software Import Payment Transactions and Summarise The batch update definition allows for the import of individual invoice / credit transactions for a single account but, on update to Datafile, to summarise this input as one invoice (or credit depending on total value) transaction; this allows for the import of (say) cash sales transactions from a till at the end of the day. This new feature allows for the same type of process to
be used when importing payment and payment adjustment transactions and is of
particular use when a customer supplies a CSV ‘remittance’ of the individual
invoices and credits they are paying for a BACS payment of a single amount. Summarise All Input into 1 Record (e.g. Shop) – set to summarise the import as one transaction. Note the assumption is made that the import file only contains transactions for the one account and that the account code is set as the ‘Tx Item for Run-Time Input’ on the first screen of parameters. If Summarise, is this a Payment-Only Run – if the input file is for a ‘CSV Remittance’ and contains details of the invoices and credits being paid and is to be used to generate an imported payment transaction then setting this option creates a single payment transaction for the total value (or a payment adjustment if total value is negative) Allocating
Invoices and Credits The idea is you would also use this process to allocate the imported payment against the invoices and credits included in the CSV Remittance. Parameter screen 1 has a parameter ‘Payment Alloc Reference item on Payment Trans’ that allows you to reference an item on the Sales Ledger Transaction database that contains the invoice / credit the imported payment relates to (this item being populated from the import file). In practice, when summarising payments, the system is still processing each import record individually so this option can be used to auto-allocate the invoices on the CSV remittance. |
Attachments
![]() There are no attachments for this article.
|
User Defined Reports - Set ‘From’ Address on Email Reports
Viewed 99 times since Thu, Jan 9, 2025
End of Batch Update - Job Costing Batch Update
Viewed 1718 times since Thu, Jul 5, 2012
Confirm Input File and Date - Sales/Purchase Batch Updates
Viewed 1773 times since Thu, Jul 5, 2012
Scanning Options on the Ledger Enquiry
Viewed 1872 times since Wed, Jun 13, 2012
Custom Features - Job Costing Batch Update
Viewed 1756 times since Thu, Jul 5, 2012
Installation Details - Stock Batch Update
Viewed 1564 times since Thu, Jul 5, 2012
Report Specification - Job Costing Batch Update
Viewed 1885 times since Thu, Jul 5, 2012
Create / Update Accounts - Order Processing Batch Updates
Viewed 1730 times since Thu, Jul 5, 2012
Negative Discount Amounts on Payment Transactions
Viewed 1711 times since Tue, Jun 12, 2012
Batch Update Processing - Stock Batch Update
Viewed 1690 times since Thu, Jul 5, 2012
|