Istug – The Independent User Network for Sage Line 200, Line 500 and Sage 1000

Did You Know?

CB Top Tips - Hints & Tips from Chris Blythe, Cunningham Blythe Ltd:

Dec 2003

Jan 2006

April 2006

July 2006

Change the Stock History Enquiry screen to Un-Suspend 5 fields - article from Dec 2005 Newsetter

Archiving - article from Oct 2003 Newsetter

Prevent Users Logging in at Month End by Using Security Groups

We have just upgraded to V6 from V5 and I have managed to overcome a problem I have had since upgrading from Unix and C-ISAM.  

At Period End I used to chmod the user file to prevent users from logging in.  However since upgrading to V5 on SQL neither of our support partners were able to provide a method of achieving this.  

With the introduction of Security Groups in V6 (and V5.5 I think) I have been able to overcome this.  

I have a security group called hpc_allow which points to the default of system. All users have a security group of hpc_user which under normal circumstances points to hpc_allow.  

If however I wish to prevent users from logging in, I change the hpc_allow to hpc_deny which has no access and therefore prevent users from logging in.  

I also run two scripts which change key users from hpc_users to hpc_allow and back again to enable them to login.

Show Stock Histories Enquiries transactions in descending date order

In order to show the transactions in the stock histories enquiry in descending date order, change the option st_history_enq to call the stkhst program with the R option, i.e.:

Option name: st_history_enq

Descriptions: Stock Histories

Menu/Pause: Leave blank

Command: stkhst R

Combined Enquiry for Sales and Purchase Ledger

In version 5.5 of sageline500 there are 2 menu options available which are not put on a menu by default. These options are called combined enquiry for Sales and Purchase ledger.

The enquiry will look at an archive file and the live open item file at the same time.

The options are called sl_comb_item_enq and pl_comb_item_enq.  

One problem, the Purchase ledger enquiry does not have an option to include closed items and therefore will not search closed items in the live open item file but will search closed items in the archive file, confused? This has been reported to Sage and they agree it is a bug and will be corrected.

Print Currency on Purchase Orders

This can either be done by using dbForms from Version 1 or by duplicating the default currency for local currency.   Example -  Set the default currency as STG and map this to GBP. All local currency users can now have GBP (Great Britain Pounds) printed.

Stock Take Card with empty batches.
To run stocktake card without the empty batches appearing on the cards the user needs to enter a date in the field "Cut off" under the restrictions selection of the ranges screen. This will only select batches where the stock quantity does not equal zero. You can know enter your count in only
two days instead of three!

Works Order Pick Lists and Issues.
It is possible to record the lead time of a component within a bill of material. System key MLEADTIME controls this. You can then enter the lead time into the stage field for the component. Know not only can you carry out just in time manufatcure but you can also create muliple picking
lists for each stage and carry out your works order issues from each pick list, which should save you picking through those 999 components trying to identify which ones were issued.

Works Order Picking List in Bin Sequence
You can now run works order pick lists in bin sequence:
License DA0926 and you can.

Closed Date on Accounts Receivable Transaction Enquiry
By licensing DA0167 - Interest on overdue debts you can start to record a closed date against items in the Sales Ledger, the field is then available on the transaction enquiry screen. Be careful if you use
commercial papers though as it doesn't work as expected.

Bills Of Material
Yyou can add comment lines onto bills of material in the same way that you can onto sales and purchase orders. Just enter a "d" in the warehouse field. You can then enter a code and a description line. Great for adding those build specific instructions.

you can also add comments to Works Orders in the same manner.

General Ledger Transaction Enquiry
You can enter wildcards into the general ledger transaction
enquiry posting code? You can then page through the different accounts that match your filter using F2.

Stock G/L Cross References
You can specify a short code as a valid account code for
your postings. This brings all the advantages of being able to apportion the posting to several accounts. When the journal is created the short code resolves.

AP/AR Transaction Enquiry Screens - Hidden Fields

On the AP and AR transaction enquiry screens (open_item_enquiry,main) there is a hidden field called "recent_first". If you activate this field the user can choose whether to see the oldest items firts or the newest items first.

modifying the I/O Paremeters (date,separators etc) with the GUI client.

For cs3 version 3.1: We have recently had problems modifying the I/O Paremeters (date,separators etc) with the GUI client. You either could not see the formsets, and if you could you could not modify the parameters. However yesterday we got it to work, and this is how it was done. This was when using formsever. 1. Install the L500 client 2. Use the formserver from Version 5.0 This is the SAGE recommended solution.

Previous page