Technology | Welcome to S-Metric

[SQL] Subquery or CTE, which one is winner?

[SQL] Should we use CTE (Common Table Expression) or SubQuery?  When we were handling Acumatica/Dynamics 365 Business Central join project, some developer just asked should we use CTE or Subquery to achive one of query in SQL procedure.   Both looks...

Tips for Implementing a Cloud ERP Solution

Tips for Implementing a Cloud ERP Software Solution What is ERP software? Enterprise Resource Planning software, more often referred to simply as ERP software, is a business software solution used by companies to: Improve the efficiency of operations Boost employee...

[Acumatica] Cannot get into my demo “admin”

Multi Tenants “Admin” in Acumatica Playing with new software is always fun; although takes a lot of time.  Acumatica has interesting way to manage multi tenants.  When admin accounts uses sames password, it groups it together naturally.  I...

Why do you need Forecast

Why we need forecasting in ERP? How we should implement it?   If you are running your business without forecasting, it’s considered as pure sin!!  “Therefore, this is what the soverign Lord says: Because you have spoken false words and...