Synology RT-2600 With Etisalat.

Synology RT-2600 Router is based on the Synology SRM OS. Like Synology NAS , this OS is what makes this router really unique.

I have had it for almost a month now and this is the best router I have ever had. What I specially like is the Parental Control , internet time Restriction based on Device  ( No internet on Daughters IPad after 9 )  , Traffic Control ( Guaranteed Bandwidth to Youtube on Smart TV) and reporting.  Offcourse there is a lot more than you can do with it , which I currently don’t since I already have a dedicated NAS to do all those things.

The toughest part of configuring the router though is getting your Etisalat Settings.  To get it working for you, you would need 3 things

  1. Your PPOE Username
  2. Your PPOE password
  3. Your VLan ID

Username and passwords are easy to retreive. Call Etisalat ( 101) from your landline and choose the ‘Reset your internet password” option. It would ask for your registered mobile phone number and SMS you your username and password. Easy

Now getting the VLAN id is difficult. I tried reaching the customer care, but it takes time. First they will  run some tests for you , then tell you according to them everything should be working fine, and then put you in a queue.

In my old Router too this setting is hidden behind the asterix. And without this, you won’t be able to connect. I spent a whole day on this and even suspected that probably Etisalat does some MAC binding so your router’s MAC address is bound ( realized this is not the case when the Cloned MAC didn’t work either).

For Me a VLAN id of 30 worked ( some people on a forum said they tried 27-30 ) . For you it may be different and you would have to get it from Etisalat Customer Service if this range doesn’t work for you.

Click on ISP Settings (IPTV and VoIP). Click on Enable IPTV, select Manual mode and Enter your VLAN ID in VID under Lan1 (internet only)

Here is where you would have to enter all this information.

Click on Internet, select PPPOE as the connection type and enter your username and password

Thunderbird Stuck on “Checking inbox for new messages”

Problem :
Sporadically Thunderbird would get stuck on “Checking inbox for New Messages”. Whatever you do, the new messages are not downloaded.   It gets past the logging in so  you know it has logged to your mail server and is waiting for the server to send it the list of new mails.

Solution : None that I have found. Tried everything but nothing works.

Workaround : If you have webmail access, login with webmail. Move your inbox emails to a temp folder. then half them back to inbox and then another half to your inbox. It works

 

Quickbooks Stock Ageing Workaround

Quickbooks is so popular that it almost has a cult Following, but its not without its shortcomings. One of the featrues it lacks is the ability to generate a Stock Ageing report.  The Report that shows you which stock has been lying with you for how many days and its value. This report is indispensabel for anybody in Distribution business with inventory.

In Quickbooks Enterprise Solution 17.0, there is a workaround to get this report. However its only a workaround and as the number of items and transactions grow, it becomes more time-consuming to get this report.

  1. Enable Inventory First in First out.

a. Go to Edit > Perferences > item and inventory
b. Click on “Advanced Inventory Settings”
c. tick “Use FIFO” and a start date.

2. Under Reports > Inventory , Find the report “FIFO LOT COST HISTORY BY ITEM”.

Now this report is very interesting. It shows you the purchase date of each item, and a sales date of that item. Any item that only has a purchase date, and no sales date is in your stock. Your Ageing is the time elapsed from the purchase date.

3. Export it to Excel and Filter only the transactions that have no Sales date / Disbursment Date.

Quickbooks Stock Ageing Report Workaround
Sample Report for an Item

4. Your ageing for such stock is date today – the date of purchase.

I know its a long way , but at least you would have some idea on the items that have been with you in stock for long time.  I also wrote a python script to take in the CSV exported from Quickbooks and turn it into 0-30,30-60,60-90,+ ageing report. In my next post I will share the details of the script too.

Microsoft Surface Pro 4: SYSTEM_THREAD_EXCEPTION_NOT_HANDLED

Problem :
Ms Surface Pro4 was stuck after a critical windows 10 update. It would keep rebooting and Display the Blue screen of death with “SYSTEM_THREAD_EXCEPTION_NOT_HANDLED” message.

Solution :
For me, constantly hitting F8 ( or Fn+F8) while it was restarting finally forced the system to “Restore the previous version of windws”. It may work for someone else too.

Additional Info

  1. Error message I was getting did not have any file name ( like ClassPNP.sys)
  2. I didn’t have to go as far as booting in safe mode and then uninstalling the display driver as suggested on Microsoft Post.
  3. Instead of F8, you may have to hit Fn+F8 .
  4. No data was lost, since the problem was with windows installation alone.

 

Thunderbird shows no inline forwarded message when forwarding

Problem :

If you forward a message from your Inbox it doesn’t show the forarded message body  . you see only the header

——– Forwarded Message ——–

Subject: RE: Subject of the email
Date: Sat, 29 Jul 2017 12:52:52 +0500
From: user@user.com
To: user@user.com

<Forwarded messgae body doesn’t appear here >

Solution :
Click on View > Message Body as  as select either ” Original HTML” or “Plain Text”.
This problem occurs when you have selected “Plain HTML” in view.