by William Tom | Jul 6, 2023 | How To
(Advanced knowledge of SQL programming stored procedures, setup of SQL jobs is required) Example we have two SQL jobs. The first SQL Job Intraday Transactions Refresh (SJITR) is an intraday transaction tables, that refresh data to a local database from a linked server...
by William Tom | Dec 9, 2021 | Meet MIBAR
It’s been over a year and few months working from home. During this time, I was able to do my work from home using my computer to remote to the office. There I was able to work on my programming assignments and provide support to clients. It was kind of fun to work...
by William Tom | Dec 9, 2021 | Acumatica
We no longer use the Automation Steps for reports after 2020R2 and up. But I got this error in version 2021 R1 v21.110.0032 in the Customization. An error while publishing the database item Actions#SO302000 with the message: Error: Inserting the...
by William Tom | Jul 23, 2021 | Technology
(Advance knowledge of c++ and sql is required) Say you had a requirement to create a c sharp program to upload a csv file to a SQL database table and manipulate the data and put it into another table. The client gives you a sample csv file. You create the program to...
by William Tom | Mar 31, 2021 | How To
A client reported an issue when updating a customer item price. (Note the Customer Inventory Maintenance form was not customized) It was taking too long to update a price. First, I check to see how many items that this customer had. It had 2778...