Home » Categories » Solutions by Business Process » Profiler

Configuration - Defining the Ledger Link

Datafile Software

Configuration - Defining the Ledger Link

Select ‘General Parameters’ and at the bottom of this screen are options to reference up to five custom/profiler plus points.

Enter the reference ‘9903’ against the first custom point number and press <END>. After confirming the above details are OK you will be asked if you want to change the definition for the update to the Sales Ledger – respond Yes.

Dummy Run – Does Not Update – when set to ‘Y’ would process the documents but not update the ledger. Note: this would not prevent any ‘flag’ items back to the main file from being processed.

Save Doc. Only – set to ‘Y’ no transactions will be generated but the ‘invoice’ would be saved for reprint from the sales/purchase ledger enquiry (see tips above for accumulators required).

Database (1-8) for Sales Accounts – this prompt is asking for the database number within the profiler location of files for the sales (purchase) accounts.

Purchase (not Sales) – as you may have noticed some prompts assume the invoice is to update the sales ledger – setting this prompt configures the system to update the purchase ledger.

Database (1-8) for Sales Transactions – this prompt is asking for the database number within the profiler location of files for the sales (purchase) transactions.

Save Invoices for Desktop – Days – this prompt asks for the number of days this document will be held on the sales/purchase documents file before it can be cleared.Normally set as 365/3650 etc.Note that documents are only removed if/when you run the document clear down procedure – they are not removed automatically after this time.

Save ID (def INV) – this prompt asks for a one-character identifier for the document type. If left blank assumes I – Inv. You can use any character and this will appear on the list in the Ledger Enquiry. Note that certain letters are assumed to be particular document types – A-ACKnowledgement, D-DELivery Note, Q-QUOte and S-STAtement.

OR days taken from item number – referring back to the number of days to keep the saved document on file you can select to pick up the number of days from the account file. This is not normally used.

A/C Item for Last F10 document – if you have a large number of documents per account you may have introduced a pointer file on the accounts database to speed enquiries.If this has been created then you also need to reference this item here.

Use Invoice Number Sequence (1-Inv, 3-Crd)– if producing an invoice and not using your own sequence you can set to use the ledgers invoice (or credit) sequence.

Write Type 9 for each record – usually set to ‘Y’.

On the following screens you are presented with a list of data item from the ledger transaction file and you are asked to cross reference, as appropriate, to the accumulators. Although you can set the system to blank accumulators after writing the type 9 this could have affects on any document totalling so it is normally best to leave this setting blank and use the suggested $RECORD, NOPRINT control block to clear any accumulators if required.

There are certain items you should not set – these include Transaction Type, Payment-Discount, Total, Allocated, Account Record Number, Next Transaction, Nominal Updated, Period Number, Old-Transaction, Forward Transaction or Forward Allocated. Other items can be cross-referenced as required.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
User Defined Reports – Rotate Print Items
Viewed 902 times since Wed, Jun 13, 2012
Profiler Option Types
Viewed 1376 times since Thu, Jun 28, 2012
Select Application Company
Viewed 74 times since Tue, Oct 15, 2024
User-Defined Reports - *RECCOUNT Test Condition on $Record Control Block
Viewed 2326 times since Mon, Jun 11, 2012
User-Defined Report - Multiple Email Output
Viewed 1518 times since Mon, Jun 11, 2012
Automatic (Q) Menu - Default to Email
Viewed 1531 times since Mon, Jun 11, 2012
Recall Standard Text Entries
Viewed 2228 times since Fri, Jun 29, 2012
G5 – Full Database Audit
Viewed 836 times since Thu, Jun 28, 2012
Auto Create Live Files from Base Files
Viewed 47 times since Wed, Oct 23, 2024
User Defined Reports - Email Links
Viewed 1319 times since Wed, Jun 13, 2012