Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Additional Options on Supplier Payment Report |
Article Number: 181 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 4:31 PM
|
Datafile Software Additional Options on Supplier Payment Report This new feature allows you to print sub-totals on the
supplier payment report and to include extra items from the accounts file. In addition if set to sub-total on a new
‘priority’ payment flag on the account record the final page of the report
includes a summary of payment totals. If sub-totalling on the priority flag then a payment
summary is printed on the final page. Note The Pay-Priority flag allows values from 0-9 and A-Z and when used is sorted on the standard alpha-numeric sequencing. Installation Database Changes If wish to use the new PAY-PRIORITY data item then you need to restructure the purchase ledger accounts database to include this new item. To restructure the database select Installation from the main menu followed by Application Manager and Restructure A Database. Select to update a Purchase Ledger database, update the live files and select the accounts file, move down to a blank entry and add the item below. Item Name Type Description PAY-PRIORITY X (1) Holds the payment priority for the account. Enter the item name in the first input and then press
<Enter> to set the item type (F4 is available), enter the size required
and press <Enter> to complete the entry. If prompted to ‘Carry Out the Same Restructure on the "BASE” File as well?’ respond as required.The BASE file is used if/when you create a new company based on the existing structure, if this is likely to happen respond ‘Yes’ and repeat the entry of new items above taking care to ensure you create at the same item positions and with the same type. Database Profiles If adding the PAY-PRIORITY item to the Purchase Accounts file it needs to be referenced within the Datafile Database Profiles for the Purchase Ledger. Select, from the main menu, the Installation option followed by Application Manager and Set Database Profiles. Choose the Purchase Ledger application followed by the parameter screen Account Optional 4. The new item should be referenced against the ‘Pay
Priority’ label. If using the new PAY-PRIORITY flag then this option needs to be added to the supplier accounts maintenance screen. From the main menu select Installation followed by Application Manager, Application Screen Layouts, Purchase Ledger and then the Add New Accounts screen. To add the text label to the screen use the mouse to click where the start of the text is to appear and then type the required text. To add the data item position the cursor where the item is to be input and then press <F4-Select>, highlight the pay priority item on the database and press <Enter>. Within the item parameters set for ‘Upper Case Input’ and set ‘Mandatory Input’ if required. Once complete choose ‘File’ on the main toolbar and then ‘Save and Exit’ Application User Facilities To set the report to sub-total on the PAY-PRIORITY
flag or any other item, and to set the extra account display items, you need to
amend the report configuration within the Application User Facilities. From the main menu select Installation followed by Application Manager and then Application User Facilities. Select the Purchase Ledger application followed by Account Reports and Payment
Report. New parameters allow: Sub-total on item – set the item you require sub-totals based on change of value. This item would also usually also be set as the first sort item Acc Info – select up to three items from the accounts file for display. Items display after the account name on the total line for each account.Note that any extra items will ‘cut-off’ if needs to total a value so you may wish to ensure any total values are at the end of the list of items. |
Attachments
![]() There are no attachments for this article.
|
Set Application Code Formats
Viewed 1771 times since Mon, Jul 2, 2012
Year End Reporting
Viewed 1813 times since Wed, Jun 13, 2012
Update Saved Aged Analysis on Payment Entry (S/L only)
Viewed 1979 times since Wed, Jun 13, 2012
Configuration
Viewed 1710 times since Mon, Jul 2, 2012
Reports
Viewed 1796 times since Mon, Jul 2, 2012
Include Debtor Memo on Aged Analysis Report
Viewed 2485 times since Tue, Jun 12, 2012
Automatic Payments – Set Transaction Description from Account
Viewed 26 times since Wed, Oct 16, 2024
Account and Transaction Pick Lists
Viewed 2334 times since Mon, Jun 11, 2012
Record Statement Dates on Account (S/L Only)
Viewed 1883 times since Wed, Jun 13, 2012
Expand Data Files
Viewed 1678 times since Mon, Jul 2, 2012
|