JFB – Tax Consulting LLC
Effective July 1st, manufacturers in Illinois no longer have to pay sales tax on most of the supplies and consumables used in a manufacturing facility. The Department of Revenue published Informational Bulletin FY 2019-28 which covers the general rules prior to their updating the appropriate regulation.
The law recites the following as production related tangible personal property that is used or consumed in a manufacturing process: property that is purchased for incorporation into real property within a manufacturing facility, supplies and consumables used in a manufacturing facility including fuels, coolants, solvents, oils, lubricants, and adhesives, hand tools, protective apparel, and fire and safety equipment.
This addition to the law is in the same statute granting sales tax exemption for machinery and equipment used in manufacturing. While it appears to read that these new items would also be exempt if used in the production of graphic arts, clarification will have to be provided by the Department of Revenue.
IDOR form ST-587 is the exemption certificate that the manufacturer should provide to its vendor in order to document the exemption. Since this form is not yet set up to permit a “blanket” exemption for all future purchases, the manufacturer is required to provide the form for each purchase order.
I goods were delivered after June 30th, you should contact your vendor, provide a ST-587 and ask for a refund of sales tax paid (or short pay open invoices).
Joseph F. Bigane III
Mike, We own Sage 100 Accounts Receivable and Sales Order, we would like to use Credit Card Processing, is that possible?
Yes Sage 100 Accounts Receivable and Sales Order Modules are fully integrated with several payment processors and transactions can be integrated through Accounts Receivable Cash Receipt Entry and Sales Order Entry without having to go outside the Sage 100 Accounting System.
Optimize Cash Flow and Get Paid Faster
Sage 100 integrates with Paya, formerly Sage Payment Solutions, to process credit and debit card receivables quickly and conveniently? Look at all the benefits of adding payments to your Sage ERP!
- Accept all major credit and debit cards as well as PIN debit and signature debit transactions.
- Securely store bank and credit card information in the Paya vault—not your software (simplifies PCI compliance).
- Access the data you want whenever you need it.
- Reduce the risk of theft, credit card fraud, and legal action with strict adherence to the highest industry standards.
Paya was the first – and remains the best – Sage 100 direct integration, with easy onboarding and a powerful, user-friendly payments interface.
Paya offers industry leading payments solutions that can be tailored to meet the needs of any business. A provider of exceptional business solutions and customer experiences, Paya delivers future-proof value and flexibility for growth.
Let Paya handle the movement of transaction data automatically. Consolidate, control, and reconcile all internal and external payment sources in real time. For more information, visit https://paya.com/ or follow us on Twitter: @PayaHQ, LinkedIn: Paya.com and Facebook: PayaHQ.
Unfortunately, scammers to do not take off for the holiday season. In fact, it appears the scams increase! Last week a scam surfaced around the country. A number of bomb scares were reported requesting a bit coin payment. Since none of the “bomb” were detonated, this appears to have been just a scam.
Bomb scares are not the only scams during the season. Just in the last few days I received a phone call from someone that reported they were receiving information about my business computer having problems. I was too busy to play with them, so I did the right thing and just hung up. Other companies that you have no relationship with are not getting information about your computer.
Also, with tax season being just around the corner, the IRS does not notify you of any tax problems with a phone call. They ALWAYS send a letter in the US mail.
The only institutions that may call, email or text you are your bank and credit card companies. Normally you will only receive these notifications if you sign up for them. Just to be extra cautious, do not reply to the notification, but call your bank or credit card company via the number on your statement or their website. If it is a legitimate concern, they will forward you to the correct person to resolve your issue.
Again, if you get an unsolicited phone call about any computer issues, just hang up. The same goes for tax issues. If you get a strange pop up on your computer, shut it down immediately. If it will not let up shut down your computer, unplug it! and contact your IT department or a computer professional.
Unfortunately, the holiday season is a busy time for scammers. Don’t let the business of the season allow you to let down your guard. Happy Holidays and be careful!
Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to reverse a check and invoice in Accounts Payable.
Answer: Sage 100: How to reverse a check and invoice in Accounts Payable.
Steps are show below:
- First Modules>Accounts Payable>Main>Manual Check Entry, and type in the check number you want to reverse. The system will ask you “Is this a Check Reversal”, click Yes.
2. The system will them ask “Do you what to recall invoices paid by this check”, click Yes.
3. You will then see a negative check on the register, Accept and Post the Manual Check Register.
4. So now you want to reverse the invoice with an Invoice Reversal, go to Modules>Accounts Payable>Invoice Data Entry.
5. Put in the Vendor N0. and Invoice No., and you will see the Invoice Adjustment popup, click Adjust.
6. Next put in a negative amount in the Adjustment Amount and Post the Invoice Register, this will reverse the Invoice.
Question: Mike, we own Sage 100 (formerly MAS90) we recenty upgraded to version 2018 and we previously had version 2015 in the old non Crystal version of check form, all the Vacation, Sick and PTO fields were lost, how can we get them back onto the new Check form.
Answer: This is explained below:
NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at firstname.lastname@example.org and we are available to help.
- The Payroll Module Database in version 2018 has been changed from previous versions, the Vacation Sick and PTO fields were changed and they are now named TimeOff1, TimeOff2, TimeOff3. They are named HoursAccrued, UsedHours, AnnualLimitHours, AvailableHours for each of the 3 type of Accrual. You can see a picture of the Crystal Reports Field Explorer below that will show each of the fields.
2. In addition there is a new version of Crystal Report that is included with Sage 100 version 2018, Crystal 2016 and it needs to be installed so you can edit the new forms, the Payroll forms were completely rebuilt by Sage, as well as Sage Support does not support Modifications to the out of the box forms, so these instruction will help you modify the form and add the Accrual fields that to the Crystal Report. You can see a picture of the Plain from which you can start with. Click the form button from the Print Checks screen Modules>Payroll>Main>Print Checks and the Crystal Report will open.
3. Next what you need to do is drag the bottom line down from the Group Footer #2 to allow enough space to the insert the Accrual Fields, this is located just below the Net Earnings, the out of the box form from Sage does not include the accrual fields so this is a customization. You will also want to reposition all the existing fields to the bottom, and then you can open the Crystal field explorer and drag and drop the acrual fields into position as well as you can add text titles. You will need to play with this and it is mostly trial and error to get it printing in the right place. In addition you will need to reduce the stub lines on the check printing. You can also suppress the fields in Crystal and move fields that are out of position. This blog is just to give you the general idea of how to modify this form and not teach you all the details of Crystal Reports design.
We recently had a client that was on version 2016 of Sage 100, they also were on an older version of Sage Fixed Assets and needed to upgrade the Sage Fixed Assets to version 2018.1. Upon doing the upgrade they received the error “Unable to cast COM object…” in Sage 100, after install the Sage Fixed Assets Client 2018.1.
So, what is the cause of this and how can it be resolved?
The cause of this “Unable to cast COM object…” error lies in the Crystal Reports runtime version (SP21) which is installed with FAS 2018.1, SP21 is not compatible with Sage 100 versions 2017 versions and earlier.
To start with replace existing pvxwin32.exe.config located in the “2016” installation of Sage 100 Standard …\mas90\home\ with a copy of the same file from Sage 100 Standard 2018. The pvxwin32.exe.config new file can be obtained from Sage 100 Support.
Then visit all the Workstations that have Sage 100 and install the FAS client, that is the fix.
In addition, Sage Support did a great job documenting the fixes for other scenarios with different versions of older and newer Sage 100. The Knowledge Base Link is here.
Most software companies will support old versions of their software for a limited amount of time. Sage, our main vendor, only supports two prior versions of their software for Sage 300. A new version of Sage 300 comes out just about every year. This is not uncommon as most software vendors have a similar policy. Therefore, when Sage releases the 2019 version they will soon thereafter discontinue support for the 2016 version. Old unsupported versions will most likely still work fine in the short term, but they come with a risk.
Recently one of our clients was hit by a virus. Fortunately they have good backups and were able to mitigate the damage. They decided to update their server and all of their workstations. Support for their accounting software had stopped a few years back due to changes by Microsoft. When they installed all the new hardware they encountered a number of issues with the old software. They now are facing an unplanned upgrade. They were perfectly happy with the old software, but there is always the risk that it will not run properly with new hardware.
Now we do not recommend that you always have to upgrade to the latest version and we continue to support old software even when it no longer supported by the vendor, but we are limited in what we can do. Technology changes quickly and we do not want to hold a company back from using newer, faster and easier computer equipment and software, because they have an old accounting or ERP system. If you are currently using unsupported software we recommend replacing it as soon as possible. Definitely within the next year or two.
What you will find out when purchasing a new system is that many software companies are moving to a selling on a subscription basis. This will significantly reduce the first year cost of the software, but future years many have a larger cost. This is the way that Sage now sells most of its products and it is the way they sell Sage 300. Interestingly, the future yearly subscription price is about the same as the old annual maintenance fee. There is an activation fee in the first year and of course the cost of setting up the software, moving data and training users. We have not found a client that would pay more under the new pricing plan than if they were to purchase the software under the old method and keep paying for their annual maintenance.
The moral of the story is you can either plan to upgrade your software or wait for a disaster and be forced to upgrade. We prefer working planned updates. It is less stressful for you and easier too!
Acumatica customers and partners can look forward to Acumatica Summit 2019 continuing it’s yearly trend of supplying a full slate of comprehensive cloud ERP training. However, there is an update: we have a new training format. Don’t worry, we think you’ll like it.
At Acumatica, they are constantly improving their cloud ERP software. This is because they want to provide customers who use it and partners who sell it with the very best cloud ERP solution possible. They also strive to make the annual Summit better every year. And a major part of their improvement efforts stem from the feedback that they receive from you, their customers and partners. After last year’s annual Summit, you said the training track sessions (which you considered extremely insightful) and the training track format could be made even better to meet the needs of certain members of the Acumatica community. They listened, and made some updates. The new training format will be introduced at Acumatica Summit 2019, coming January 27-February 1, 2019 in Houston, Texas.
Reminder: if you register for the Summit right now, you can still take advantage of our special early bird pricing.
A variety of training is available in flexible training periods, you can check out Acumatica Summit 2019 by going to their registration website located at:
Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to run the Accounts Receivable Trial Balance and Aged Invoice Report.
Answer: The Sage 100 Accounts Receivable Trial Balance and Aged Invoice Reports are explained below:
Accounts Receivable Trial Balance Report:
This report is used to Balance against the Balance Sheet report. It is a detail by customer of all Invoices, Payments and Deposits. The report should be used to be show a customer what their balance owed to your company is. The report can print for Invoices Open, Paid or All.
The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Trial Balance, you can set the parameters and then print or preview the report.
Accounts Receivable Aged Invoice Report:
This report is used to print balances owed by customer on invoices, it can be printed with each column being Current, 30 days, 60 days, 90 days and 120 days past due. It is really a report to determine collection and which customer to called for payment.
The report can be accessed from Modules>Accounts Receivable>Accounts Receivable Aged Invoice Report, you can set the parameters and then print or preview the report.