Saturday, July 21, 2018

Helping traditional Retail chain for Automation through Software tools

Retail industry is growing very fast and it is ultimately competitive. Retailers experience a number of challenges every day. As such, it is essential to help retail chains for automation through software tools.  LS retail software is a complete management system that assists a business owner to manage the business form a single software platform. LS helps handle multi-channel operations in a business as different platforms cannot communicate efficiently leading to inconsistent data, uncontrolled costs and waste of time. Apparently, incorporating your business with LS, you will be in a position to meet all the challenges that arise from the multiple channels in use in your business presently, in future and beyond.

Microsoft Dynamics Navision helps you run your retail business operations to automate across sales management, replenishment of stock and managing the warehouse to maximize profits, increase efficiency and create an excellent client experience. Other benefits include tracking profitability. Usually, you benefit from enhanced business skills that lead to performance and increased profit margins. Fraud detection is also possible with Microsoft dynamic Nav for retail. There is better transaction tracking that makes it possible to detect abnormal purchases. Also, you have improved supplier analysis with correct reports on supply performance and delivery.

ERP systems for retail industry combines all software used throughput the business into a single system. The unified system incorporates all that you need in your business coming from one end to another. An ERP solution in retail is the easiest system to help manage your inventory information. Consequently, with a good ERP retail solution, you will get the best chance to relate with your clients as well develop the best customer relationship management in your business. As such, business proficiencies augment as the business benefits from daily control retail operations.

Barcode integration is an integral constituent of retail operations. Embracing barcode technology ensures that your inventory management as well as tracking is accurate. In fact, barcodes give better data. Usually, one barcode can be used for both stock and pricing selective information making it efficient to access information on both. Barcodes provide quick, reliable and a wider scope of applications.

Embracing an implementation partner for LS retail, is significant as it helps you to expand the business portfolio with certified products which creates new opportunities as well as becoming the go-to partner for loyal and prospect clients. Also, being a LS implementation partner helps you benefit from license discounts and high business margins.

In conclusion, automating retail industry through software tools is a significant part of today’s business. In fact, clients all over the world desire to access favorite brands, information as well as shop in a number of channels. As such, mobility is essential through automation of traditional retail chains worldwide.

Tuesday, July 17, 2018

How to schedule a job in Microsoft SQL Server

Microsoft SQL Server Management Studio, which is an integrated environment to manage a SQL Server infrastructure, provides us the feature to schedule a job in SQL. We can achieve the scheduling task through SQL Server Agent.

Let’s see how we can achieve our task through SQL Server Agent.

First, open your SQL Server Management Studio. As you open you will find the following screen.

Here you can see the Object Explorer tab which includes your Server Name. Expand it and you will find the various options (also called objects) in it like Database, Security, Server Objects, Replication, etc. The last option is SQL Server Agent and this is where we need to do our scheduling.

Click on the + sign in front of SQL Server Agent to expand it. See the above image. Right click on Jobs and then on New Job…  . A new window will appear as shown below.
SQL Server Agent - Jobs - New Job… 

Fill the General details like Name and Description.

Select Steps on left hand side of the window and then click New which is at the bottom.

The Steps window will open, enter the Step name. Next, in type, select Transact-SQL script (T-SQL), choose the database against which the query will run and write the query in the space provided for command.

Select on the schedules option on the left side of the window and click on New.

A new window will appear where we have to set the name, Frequency, time and Start date as per which the job will run.

Once set, click on OK and our scheduling process is completed. Now the schedule will run as per the date and time mentioned.

You can also see your job status from Job Activity Monitor

About Author
Kumar Ankit is a BI Consultant at Prudence Technology. He is B. Tech from Chandigarh Engineering College and has started his career with Prudence Technology. He own a technical blog as well named (
 He can also be reached at: [email protected]

Friday, July 13, 2018

Challenges in Digitization of traditional core sectors Example Farming, Dairy, Livestock Farming

Digitization entails procedures that aim at converting information into a computer-readable format. Usually, the information is well organized in bits. Consequently, analogue material sources are changed to numerical formats. Digitization is fundamental in data processing, storage as well as transmission to avoid omission or losing its quality. Digitization is a perfect way of preserving data in many sectors. However, digitization of traditional sectors such as farming, dairy, livestock, suffers major challenges such as poor internet connections, lack adequate support for integration and implementation of digital software among farmers.

Poultry software and its challenges
Poultry software or ERP for Poultry makes it possible to collect information in real time on poultry health and the same information reaches the manager instantly. In spite of the success associated with poultry software, very few modern poultry farmers embrace this kind of technology. In fact, few farms are in a position to collate and analyze data from their farm due to lack of sufficient time and knowledge including other obligations. Consequently, information that is fundamental to farmers; as it provides insight goes to waste.

Livestock management and its challenges
Livestock management software tools are significant in every livestock farm. These livestock management software tools impacts trans-formative changes. For instance embracing precision livestock farming(PLF). This is entails advances in sensors and data algorithms that shape animal performance including well tailored health and nutritional solutions. PLF is a paradigm shift towards commercialization for instance use of hi-tech tools such as robotic dairies where you use the information the dairy robots generate. Primarily, many users and even producers inadequately understand how to make use of the generated information. This is a major challenge.

Mobile application for farming and its challenges
In this era of civilization, the use of mobile and cloud-based apps is essential. In fact, mobile and cloud based applications help farmers to address any sustainability challenges as well as creating a financial value for all farms. It is primarily used in delivering information and enabling farmers make sound land management choices. Reuters Market Light (RML) is a good example of a mobile application for farming which utilizes. However, mobile application for farming faces challenges including cloud computing, integration of IT systems as well as limited inadequate education and low mobile phones proliferation among farmers especially in the rural areas.

Dairy management and its challenges
Dairy management faces a number of challenges. The farm inputs are expensive minimizing incorporation of mechanization in dairy farming. Another challenge is early detection of mastitis in dairy cows. Essentially, conducting milk conductivity errors helps detect and treat potential mastitis early in your herd. Mastitis is tested using a strip cup. Apparently, mastitis leads to low milk production.

In conclusion, the vast benefits of digitization of traditional core sectors aims at reducing transactional, transportation as well as product traceability, storage and pest and disease control, tracking, and for commercial benefits. Apparently, digitization of traditional core sectors heightens the overall farm performance. There are tools such as NAvfarm which helps farms in adopting digitalization of the farms.

Sunday, July 8, 2018

How to upload AR invoice using FBDI

Download FBDI for auto invoice:-

Fill the data in Excel Template Format and don’t change the sequencing of the column.

Click on Generate CSV.

Save the file.

Go to Schedule process in Tools tab:

Search for process(Load Interface File for Import)

Upload Create ZIP file in the system:

Click On Submit:

Your request is running and you need to wait till it got status ”Succeeded”

Now run the process(Import Receivables Transactions Using AutoInvoice)

Enter your “Business unit” and your “Transaction Source” then click on submit

Report is running and wait till report is succeeded:

Two more requests  are running (Once they completed successfully, AR Invoice data will be

Noe:- You can get the status of data by getting the output of request (Import AutoInvoice: Execution Report)
You can also check error in the data by the spreadsheet:


PRAKHAR SAXENA is Oracle Fusion Technical Consultant with overall 2.5 years of Experience. He is B. Tech from Amity University and has started his career with Prudence Technology as a Graduate Trainee. He is part of Oracle COE. He can be reached at: [email protected]

Wednesday, July 4, 2018

E-commerce Portal Integration with Microsoft Dynamics Nav

As we know market and businesses moving on the e-commerce portal which provide the direct customer interaction with companies. Electronic commerce, commonly known as E-commerce, is trading in products or services conducted through computer network such as internet. There are lots of leading companies which leading the Indian e-comm. market for example Amazon, Flipkart, Lime road, Snap deal, Wish etc. Those company have online shopping facilities where the customer can buy provided Goods & Services from e-commerce portal. There are six type of e-commerce in Market.  Those are:

  1. B2B (Business To Business)
  2. B2C ( Business To Customer)
  3. C2C (Consumer To Consumer)
  4. C2B (Consumer To Business)
  5. B2G (Business To Government)
  6. G2C (Government To Consumer)

Merchant Challenges in working with E-comm Portal:

  • Order Management
  • Inventory Management
  • Customer Management
  • Return Management
  • Sales V/s Collection Reconciliation
  • Payment Reconciliations
  • Data Punching
  • Data Accuracy

Top 5 Benefits of E-Commerce Integration with ERP:

  • Control the inventory and operational costs
  • Reduce data redundancy, human involvement and error
  • Boost the productivity
  • Enhanced control over business
  • Exceptional customer experience
  • Help in Decision Making and planning
  • Reduce the user dependency

ERP Solutions to handle above issues:
As all are aware about technology which growing day by day. E-commerce companies provide the merchant portal for getting all the above information where will be chance of human error in data transferring.  In way of solution is API (Application Programming Interface) integration with ERP System for Automate the Manual processes, API is a software inter-mediator that allows the two different application talk to each other. For example when you use an application on your mobile phone, the application connects to the Internet and sends data to a server. The server then retrieves that data, interprets it, performs the necessary actions and sends it back to your phone. The application then interprets that data and presents you with the information you wanted in a readable way. This is what an API is - all of this happens via API.

Microsoft Dynamics Nav have the option to integrate with E-commerce portal through Rest and SOAP API’s. The ERP integration with e-commerce portals has transferred the day-to-day business operations, altogether on a unique fast-track path, of many manufacturers. It has completely eliminated the scope of manual errors and reasons for sluggish progress. Along with relishing numerous benefits, ERP-integrated e-commerce businesses have discovered efficient and effective ways to outrun tough competition and deliver satisfactory customer services. If you too want to be successful with your online business and long to keep up with the increased online demand and supply, your e-commerce strategy should include integration to an ERP without a miss. And one such ERP is Microsoft Dynamics Nav. It gets seamlessly integrated with online stores.

About the Author:
Kunj Bihari Agrawal is a senior functional consultant for Microsoft Dynamics Nav. Kunj has a rich experience of over 11 years in finance domain & India statutory in MSD NAV. He has a passion for exploring possibilities of easing the entire ERP migration for corporate and is currently working with various government and private focus groups in ironing out the creases & roadblocks for GST migration on various technology platforms. He can be reached at: [email protected]