FAQ

How to install the latest SQL Client for SQL Server

Select the following link to download msoledbsql.msi https://www.microsoft.com/en-us/download/details.aspx?id=56730 and save the file to your \\servername\redant\install\SQLxxxx folder or to your desktop Double click the downloaded file and follow the install instructions. DO NOT proceed with the next instructions unless the installation completed successfully !! Locate the following file c:\redantpcs\redantpcs.txt using file manager/explorer and double click it with your mouse to open it in ...

How to setup a SQL TCP Client Connection

From the SQL server computer open the SQL Server Configuration Manager as shown below Expand the tree in the left hand window as shown below and select Protocols for Redant Double click the TCP/IP protocol in the right hand window Select the IP Addresses Tab and scroll to the bottom Under the IPAll entry remove any data in TCP Dynamic Ports and enter 1433 in TCP Port as per the screen shot above. Click Apply and then OK You will receive a message that all SQL services will ...

How to setup Redant to use Outlook to send emails

Sign in to Redant as the Admin user From the 'Main Menu' select Maintenance>Users>Login ID Locate the User to change or select New to create a new user and then change the following settings: Add a Check in the following fields: 'Outlook Email' and 'Outlook Signature' Once the new settings have been saved then select the 'Test Email' button to verify you have received an email in Outlook. To verify documents are being sent correctly, go to any module and select 'Output Document' and t...

"A program is trying to send an e-mail message on your behalf" warning in Outlook

This may occur when setting Redant to use Outlook to send emails on its behalf. Click the following link and follow the instructions on the Microsoft page to resolve this issue. https://support.microsoft.com/en-gb/help/3189806/a-program-is-trying-to-send-an-e-mail-message-on-your-behalf-warning-i Redant Support Team

Working with Plans

New Drawing / Part No. Entry You have several options when it comes to entering a drawing no. Option 1 If the Customer has supplied the Drawing / Part No. then use this reference including any issue no’s. If there is no issue enter a – Option 2 Auto-generate a drawing no. If we leave the drawing and issue no. fields empty when entering a new quotation or Job order the software will generate a drawing no for you. This is made up of a prefix and the register no. The prefix can be whatever you...

How to create an Assembly

Where a finished product has 1 or more sub parts/drawings then we can use the assembly feature in Redant. An assembly can only be created in the Register Module as follows: - From the main menu select ‘Register ‘. This is the master drawing/part no register and holds all parts quoted for and used on orders. The last register created will be shown. - Select ‘new’ from the bottom menu to create either the ‘top level’ part i.e. the part which is being delivered to the customer or a sub part....

How to Setup Foreign Currency

How to Setup Redant to use foreign currency transactions. Sage / Xero Export VAT Codes Setup - From the Redant main menu navigate to Maintenance > Setup > Defaults. - Select Vat Codes from the top menu - If using Sage accounts, enter the correct Sage VAT ‘T’ codes for Non-EU Export, EU Export and EU Purchases - If using Xero accounts enter the descriptive VAT settings as defined in the Xero accounting system for Non-EU Export, EU Export and EU Purchases. - Select Close follow...

Grid Changes

Many of the grids in Redant can be modified to hide, resize and format the columns. To do this follow the procedure below: - Login to Redant as the Admin user - Open the required module and select one of the 'tabs' which has a grid e.g. Job Orders > Process tab - Using the mouse click anywhere in the grid and then select the following keys holding each one down Ctrl + Alt + Z - A message box will appear asking if you want to reset grid settings to their default settings - Only sele...

Reports are taking a long time to print

One possible cause to this would be if there has been a recent change to a network printer or changes to a shared printer such as name or IP address. To check this do the following: 1. Make sure your default windows printer has been changed to the new/updated printer (use windows settings) 2. From the computer with the printing issue, login as Admin 3. From the Main Menu select Maintenance > Users > ID 4. Locate the redant user who is having the issue 5. Select Edit and change ...

Firewall Ports

To enable Redant to talk to the SQL datbase server the following ports will require 'opening' for both incoming and outgoing traffic on your designated SQL Server. They may also be required on workstations if the error message 'Instance cannot be found' appears when starting Redant. Port No Type 1433 TCP 1434 UDP 445 TCP 135 TCP In addition to the above internal ports we also require the following external ports open: Port No Type 1963 (Red...

Office 365 Email Settings

Sign in to Redant as Admin From the Main Menu select Maintenance>Users>Login ID Locate the User to change or select New to create a new user and then add the following settings: SMTP Port: 587 SMTP Server: smtp.office365.com SMTP User Name: your full email address e.g. fred@abc.co.uk SMTP Password: your 365 password TLS / SSL: Both Options Checked Authentication: 1 Once the new settings have been saved then select 'Test Email' button to verify