Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Include Currency Accounts in Auto-Payment Procedures

Purchase Ledger only

The Purchase Ledger includes a series of actions – termed the auto-payment procedures – that allows for the system to create payments for suppliers based on their outstanding invoices.  In a currency environment, however, only base currency accounts could be processed.  This new feature allows for accounts in other currencies to be processed.

Run Proposed Payments

Selecting this option will still ask for the currency to process but instead of restricting this to the base currency (STG / GBP) the system will also allow other currencies to be selected.

 

Only one currency can be processed in any one run, however, you can run for multiple currencies one after another (you don’t have to complete your GBP run to payment creation before starting your EUR run).  Note that values displayed for total value of proposed payments / settlement discount are in the currency of the ‘run’.

Print Supplier Payments 

This report processes all accounts subject to normal criteria – payment dates / P-to-Pay checks etc. – but also allows the ‘Report Which Currencies’ option to restrict the report to accounts in a particular currency (leaving blank processes all applicable accounts).

The report displays the values as per the data items configured (i.e. if print item Total from the transaction file then is the base currency always, if print FC-Total is in the currency of the transaction). 

The exceptions to this is the special item 162-Payment Amount; this item prints in the base currency unless, when running the report, you set the option for ‘Report Which Currencies’ to a specific currency or use ‘ALL’ in which case the values is reported in the currency of the account.  When reporting this value in the base currency the value is based on the transactions and their exchange rate, the value actually paid in the base currency may be different due to exchange rate fluctuations since transactions were originally entered. 

Note that special item ‘163-Discount Available’ is always in the currency of the account regardless of setting.

 

Generate Payments

As with the ‘Run Proposed Payment’ procedure this option will now allow processing in other currencies but will only process one currency at a time.

 As with base currency processing the system will create payments for each account set for payment, for currency accounts the system will apply the appropriate exchange rate based on the payment date and generate any exchange difference transactions if appropriate.  Again, values displayed on screen are in the currency being processed.

Installation 

No setup changes are required.


Custom Fields
  • Release ID: 6.9
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
VAT Reports
Viewed 1730 times since Mon, Jul 2, 2012
Currency Aged Analysis in Auto Period End Reports
Viewed 17960 times since Tue, Oct 12, 2021
Account Statements (Sales Ledger) - Database Profiles
Viewed 2221 times since Mon, Jul 2, 2012
Account and Transaction Pick Lists
Viewed 2157 times since Mon, Jun 11, 2012
VAT Summary – Include Out of Scope VAT Codes
Viewed 19047 times since Tue, Oct 12, 2021
System Profiles Screen 1
Viewed 1541 times since Mon, Jul 2, 2012
Additional Options on Supplier Payment Report
Viewed 2456 times since Tue, Jun 12, 2012
Account Reports - Application User Facilities
Viewed 2064 times since Mon, Jul 2, 2012
Turnover History Report
Viewed 3248 times since Mon, Jun 11, 2012
Update Saved Aged Analysis on Payment Entry (S/L only)
Viewed 1815 times since Wed, Jun 13, 2012