TPAC 2018

This past February was the Third-Party Advantage Conference (TPAC) held in Vancouver, British Colombia, Canada. I had the opportunity to visit this beautiful city and participate in the conference that brings together a great group of products and people on the Sage 300 ERP platform. Sage Business Partners, Development Partners, and customers from all over the globe were in attendance to discover what products are available on the market to enhance an end user’s Sage 300 experience.

I was in Vancouver the week before TPAC to attend a pre-conference training session for AutoSimply, one of the featured third-party exhibitors at the conference. The two-day training session discussed how to utilize the Manufacturing Order Module (version 2018) within Sage 300. The Manufacturing Order Module allows end users to create Bills Of Material (BOMs), manufacturing order entries, returns, and receipts. Other modules that were discussed, which can be added to Sage 300 in addition to the Manufacturing Order Module, includes Manufacturing Lots for lot control operations; Production Planning for budgeting and forecasting; and Shop Floor Control for tracking manufacturing operations such as runtime and operation downtime. AutoSimply also discussed their Inventory Barcode Manufacturing product which allows end users to scan compatible barcodes and automatically upload the information to their Sage 300 ERP. End users can also create Purchase Order (PO) Receipts, PO Returns, Order Entry (OE) Shipments and OE Returns from their handheld barcode scanning device.

At the end of the two-day AutoSimply training session, I was awarded a Certificate of Completion from AutoSimply.

I also attended a conference session regarding new features coming to the next version of Sage Alerts & Workflow led by Donald Farber of Vineyardsoft, a developer of the product. The next version of Sage Alerts & Workflow will be web based for convenient user access along with modern web screen designs.

Sage Alerts & Workflow is a query reporting software that notifies end users of events that users without Sage Alerts could only “wish they had known sooner.” These events include lists of: customers with open invoices due over ‘x’ days ago; customers whose credit cards expire next month; open sales orders that have not been shipped yet and are past the expected ship date; orders that have been shipped to the customer but have not been invoiced, etc. These reports can be set to automatically run on certain time intervals such as “Daily at 9am” or “Every 4th Friday of the Month,” and sent via email, text, or fax to persons of different departments and management levels internally and externally according to a business’ needs. Sage Alerts & Workflow is a great tool for users to keep track of their business from all angles.

Overall, TPAC 2018 was a successful and enlightening event to attend, to forge new relationships and learn about different products that operate alongside Sage 300. I look forward to attending again next year!

Sage 100 Success Story with Mervin Manufacturing Snowboards

WAC Solution Partners Helping Businesses to Grow Effectively

 

As providers of accounting software, implementation and support, we offer a wide range of solutions designed to fit businesses and non-profits of all sizes. Our combination of products and services allow you to better manage your accounting and to make insightful decisions about your company’s future.

EXPERTISE WITH LOCAL ROOTS AND NATIONAL REACH

This is a success story about a very fun customer Mervin Manufacturing that we began working with in 1989. It was a great partnership.

Mervin Manufacturing is home to Lib Tech, GNU, Roxy and Bent Metal Bindings and is a leading designer and manufacture of snowboarding products. We began working with Mervin Manufacturing in 1989 when they were just a 10-year-old company.

They were looking for a partner to help them grow their business to the next level. Our company provides small business bookkeeping services as well as Accounting Software system sales, implementation, support and training.

They originally called us because we were close to their Seattle office, initially it was a box of checks. The project was to reconcile their bank accounts and do monthly financial statements for them, we did all the accounting on our system.  We also did their accounts payable and payroll.

As the company grew further they asked us to provide an in-house accounting system and computer network system. We sourced an IT company for the computers and sold them Sage 100 (Formally MAS 90). Their original customer base was on an Apple Macintosh that we helped them bring over to the new Sage 100 (Formally MAS 90) system.

This was a phased in training and implementation, first the financial modules including General Ledger, Accounts Payable, Accounts Receivable and Payroll. And then the distribution modules which included Inventory, Sales Order and Purchase Order.

We trained the customer staff from the ground up as they had never had much experience with Sage 100 (Formally MAS 90) or other accounting systems.

Upon completion of the Software Implementation we continuing as their outsourced accounting company. We provided monthly financial statements, did their payroll for them, closed all the accounting and distribution modules monthly. We remained their accounting company for over 10 years.

Eventually Mervin Manufacturing was sold to Quiksilver and in recent years the company was repurchased and now operates as an independent standalone company under Altamont. They are home to many snowboard enthusiasts and many Olympic snowboard athletes.

NetSuite – Reopening Accounting Periods

Welcome to part two of WAC Solution Partners’ series on closing periods! Today we will cover how to reopen and edit accounting period.

What is reopening a closed period and why would you want to do it?

In NetSuite, when a period status is “Closed” no transactions can be posted to any date within the period by anyone (including administrators).  There are times when you find a transaction that was overlooked or there is a transaction that your accountant recommends entering in a previous period or fiscal year.  If these periods are closed you must reopen them.

  1. Here is how to reopen an accounting period.

a. Go to Setup>Accounting>Manage Accounting Periods

b. The Manage Accounting Periods page allows you to close and open periods or to set up new fiscal calendars. Closed periods will be marked with a green check under “Period Close” and will indicate that AP, AR, and GL are all locked.

c. Click the checklist button of the period you would like to reopen.

d. Click the green arrow on the “Close” line

e. From here you can click the “Reopen Period” button. Note that the system will ask you for a justification for reopening the period. Fill in your reason.

f. The system will also require that you reopen all periods after the one you are opening, though they will remain locked. You will also have to go through the checklist again.

In the example below, July 2013 was opened for editing. As you can see, all subsequent periods were opened, but they remain locked.

g. Before editing a period, you will have to go back through the checklist…

h. …and unmark the items which were marked for locking.

i. Hit Submit.
j. Depending which checklist item you unlock first, items which were dependent upon it may become unlocked as well.
k. All periods after the unlocked period will also become unlocked. You may now make your changes.
l. To re-close the edited period, repeat the closing steps described in part one of this blog.

2. You may be wondering whether you have to go through the checklist all over again for each of the periods you opened. You do not.

Because re-closing any open, intervening periods which did not need editing was a tedious chore, NetSuite created Quick Close. Because this feature can close any period, it is not recommended that you use it to close periods where the checklist was never followed. The feature merely marks items as locked and complete—it does not actually perform the closing tasks.
a. To use this feature, go into your Manage Accounting Periods page.
b. Click “Close Multiple Periods”. There is no button marked “Quick Close” at the time of writing.

c. The system then asks you to select a period. Quick Close will close all periods dated before the one you select.

d. Click “Submit”.

The system will display this warning. Again, we do not recommend using this feature to close periods which were not closed properly by completing all items in the closing checklist.

e. If you are sure, click “OK”.

As you can see, NetSuite makes reopening and reclosing periods a fairly simple task and offers several tools with which to manage them.

We hope that this blog was useful to you. If you have any questions about closing or reopening periods, the Quick Close routine or any other NetSuite topic, please contact us by Clicking Here!

Sage 100 Consultant Tip: Paperless Office Won’t Print

Sage 100 ERP consultant, we had a client who had a technical issue with Paperless Office hanging up. Do you know how to stop this from happening?

NOTE: Consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system.

Question: We are a Sage 100 user, we are using the Paperless Office and the printer hangs up forever.

Answer: Here’s what to do when Paperless Office hangs up…

1)  Check permissions on Sage PDF Converter:

Run, Regedit

Sage 100 ERP consultant paperless office

Click on: HKEY_CURRENT_CONFIG, Software, Sage PDF Converter, right click select permissions and set full rights to everyone. Apply and OK.

2)  In Sage 100, File Run PL_AdvancedOptions_UI

Sage 100 ERP consultant paperless office 2

3)  Uninstall Converter, then Install Converter.
4)  De-install Workstation Setup and then Re-Installed Workstation and run Update.
5)  Find Sage PDF Converter from printer properties, install Sage port if not there, on the security tab set full permissions to everyone. Apply and OK.

Sage 100 ERP consultant paperless office 3

6)  Back to Sage 100, File Run PL_AdvancedOptions_UI and test Sage PDF printer.

This should solve the problem in most cases, Paperless Office printing is done on a machine by machine basis so it is necessary to check these steps on each machine.

If you have questions please contact us at www.caserv.comemail or 760-618-1395. Please stay tuned for more helpful Sage 100 ERP tips!

NetSuite – Closing Accounting Periods

Hello again from WAC Solution Partners! We are back with a two-part blog about closing accounting periods in NetSuite. In this first part, we will cover how to close a period, and in part two, we will cover how to reopen and edit a closed period.

So what is closing a period and why would you want to do it?

In most software packages, “closing” a period means roughly the same thing, but they do differ slightly. With some packages it may be a simple process, and in some packages it may be complex.

In NetSuite, closing a period changes its status from “Open” to “Closed” and locks it so that no transactions can be posted to any date within the period by anyone (including administrators). It also prevents editing. For these reasons, closing a period should only be done after all posting to a period is complete. It should also only be performed after review and reconciliation to ensure correctness and balance.

For some companies this is a simple procedure and for some it is complex. However, no matter what the size, closing in NetSuite is relatively simple compared to many other software packages.

NetSuite gives you a “Period Close Checklist” to walk you through the closing procedure. Its contents are affected by what modules and features you have active in your system. For instance, Multi-Currency would add a step to the list regarding currency evaluation.

1. Let’s see how to close a period.

a. Go to Setup>Accounting>Manage Accounting Periods

b. The Manage Accounting Periods page allows you to close and open periods, or to set up new fiscal calendars. Closed periods will be marked with a green check under “Period Close” and will display a locked icon to indicate that AP, AR, and GL are all locked.

Open periods will not have a check and transactions will appear unlocked. Because periods are closed sequentially, this means that any checked period before the latest checked period is closed.

c. The first step in closing the period is to click on the checklist.

d. This brings you to the checklist for that period. Please note that because we are using a demo environment and reopening previous periods for demonstration purposes, the status is listed as “Reopened”.

e. Begin clicking through the items on the checklist. The first item, Lock A/R will bring you to this page.

f. Check the boxes and hit “Submit” to save your work. This locks AR for the checked companies for the selected period. Note that our demo company has multiple subsidiaries. If you only have one entity in your system, you will only see that entity.

g. You will be sent back to the checklist. A/R will now be marked as locked.

h. You may then close the items listed before “Close” in any order you like. However, certain items may have prerequisites that need to be completed before they may be closed. These items are greyed out, and hovering over them with your cursor will tell you what needs to be done in order to close them.

i. Lock All” is a misnomer, as it actually means the GL.
j. “Resolve Date/Period Mismatches” allows you to correct transactions that are dated wrong. For instance, if an invoice is posted to the wrong month. Clicking this will cause NetSuite to look for mismatches in the transactions for the period. You can then click the Edit links to resolve these discrepancies.

k. Note that when you create transactions, those transactions will not automatically post to the proper period if that period is not set up in a fiscal calendar. This means that if you are trying to post in 2018 but have not created any 2018 periods in NetSuite, then the transactions will post in the wrong period.

l. The final step is to click “Close” at the end.

m. After this, click “Close Period”.

n. The period is now closed.

o. If you go back to the main list, you will see the closure reflected there, as well.

As you can see, NetSuite makes closing periods a fairly simple task and offers several tools with which to manage them.

Please read our next blog on reopening accounting periods and the use of the “Quick Close” routine.

We hope that this blog was useful to you. If you have any questions about closing periods or any other NetSuite topic, please contact us by Clicking Here!

 

 

New Tax Law Changes for 2018

By now we are all aware that there are new tax tables coming due to tax reform. While most everyone will see a difference in their paycheck by February 15, there are still some details that aren’t quite ready. As the tax law is written, there will be no personal exemptions for 2018. So, what are we supposed to do with those W-4 forms that we have from our employees?

The IRS recently released a notice with additional information regarding those W-4 forms. The notice extends the effective period of the current Forms W-4 until February 28, 2018 and does the following:

• Temporarily suspends the requirement that employees must furnish their employers new Forms W-4 within 10
of changes in status that reduce the withholding allowances they are entitled to claim;
• Extends the use of the 2017 W-4 Form until the 2018 W-4 Form is available;
• Provides that the withholding rate on supplemental wage payments is 22 percent for 2018 through 2025; and
• Provides that, for 2018, withholding on periodic payments when no withholding certificate is in effect is
based on treating the payee as a married individual claiming three withholding allowances.

Basically, it is going to take the IRS quite some time to redesign the W-4 so it reflects the changes in the new tax law, so to minimize the burden on employees and employers, the IRS and the Treasury Department designed the 2018 withholding tables to work with the Forms W-4 that employees have already furnished their employers. Once the newly designed 2018 Form W-4 is released employees will have 30 days to submit the new forms to their employers.

Sage 100 ERP (MAS 90): How to Import ADP Payroll to Sage 100 GL

Question: Mike, we own Sage 100 ERP (formerly Sage MAS90); we also use ADP for our Payroll. How can we import the ADP Payroll information into the Sage 100 ERP General Ledger? We spend many hours manually typing this data into Journal Entries now.

Answer: You can import ADP Payroll into Sage 100 ERP, using the General Ledger Data Exchange Utility that is a part of the General Ledger module.

 

First Step:  You will need to ask your payroll company to provide you with a CSV file of the General Ledger data. In the example below we have used the Alternate Exchange Format .

Sage 100 ERP Payroll resized 600

Sage 100 ERP Payroll

Second Step:  You will need to setup the Data Exchange, General Ledger>General Ledger Exchange. This will open up a wizard as shown, and follow comments and screen shots below:

Sage 100 ERP Payroll

Click Next

Sage 100 ERP Payroll 2

Select Import Data, and Click Next:

Sage 100 ERP Payroll

Select Transactions and Click Next:

Sage 100 ERP Payroll6 resized 600

Enter Name and Click Next:

Sage Payroll

Set Duplicate Procedure to: Do not import new entry, Click Next:

Sage 100 ERP Payroll8 resized 600

 

Click Next:

Sage 100 ERP Payroll9 resized 600

Click next:

Sage 100 ERP Payroll10 resized 600

Make sure the file has been saved as a CSV file, set Exchange File Type to CSV, set  Exchange File Name, Click next:

Sage 100 ERP Payroll11 resized 600

 

Select Alternate File Name, click next:

Sage 100 ERP Payroll12.png resized 600

Click Finish:

Sage 100 ERP Payroll13 resized 600

Proceed, and test first, once this is complete then you can go into

General Journal Entry and review the Journal is correct and then Update.

Sage 100 ERP Payroll14 resized 600

You can then do Payroll Journal Entries each period from General Ledger Exchange shown in the second to last screen shot and save many hours in Journal Entry processing.

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services 

 

Sage 100 – How to Use Customer and Crystal Reports to Add a Custom Field and Run Reports – WAC Solution Partners – Palm Desert

Question: Mike, we own Sage 100 (formerly MAS90) and we would like to know how to add a new field to the Accounts Receivable Cash Receipts Entry screen. Is it possible to add a field to enter the number of customers that come our office daily?  We’d like to collect this data and build a report to show this information with different date ranges.

Answer: The Sage 100 Custom Office Module allows you to add a user-defined field to any screen in Sage 100 and report on it from the database. You simply add the new field to the Custom Office and create a simple Crystal Report. You will also need to properly link the UDF to History.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us at info@caserv.com and we are available to help.

Sage 100 Consultant Tip – How to Create Calculations with Crystal Reports

Question:  Mike, we own Sage 100 (formerly MAS90) and use Crystal Reports. How can we do a summary calculation at the bottom to add up multiple lines on a Sales Order using Crystal Reports. We follow your Sage 100 Consultants Tip blogs and find your series of tips on Crystal Reports very useful!

Answer:  The Sage 100 Crystal Reports calculation feature has many applications.  In this case, we’ll review the 3 steps to add multiple lines in Sales Order.  If you think you are not taking advantage of the power of Crystal Reports, please add your comments at the end of this blog.

NOTE: We advise that you consult with your certified Sage 100 ERP consultant before making any changes to your Sage 100 ERP system. If you don’t currently work with a Sage 100 consultant, contact us, call 760-618-1395 or email us and we are available to help. Sign up for more helpful Sage 100 consultant tips & tricks below!

Sage 100 Consultant Tip: 3 Steps to Create Crystal Reports Calculations

STEP 1 – In Crystal Reports, use the Running Totals Fields from the field explorer. On the Crystal Reports field explorer right click on Running Totals Fields and select New.

Sage 100 consultant tip

STEP 2 – Enter in the Running Total Name, from the left side scroll down and select the field to summarize and click it to the right. You can leave the defaults, and click OK.

Sage 100 consultant tips and tricks

STEP 3 – The new Running Total Field will now be available and you can insert into the report, please note you must insert the field into a footer for the Summary calculation to work.

Sage 100 tips

We hope this was helpful. There are many other applications to help save time throughout Sage 100 for Crystal Reports calculations. If you have any questions, please contact us, call 760-618-1395 or email us and we will be happy to help.

Check out other related Sage 100 Crystal Reports blogs:

Written by Mike Renner:  Partner of WAC Solution Partners – Greater Los Angeles, a Sage 100 ERP consultant and support provider based in Indio, CA.

Mike is an expert on ERP and fund accounting and supports Abila Fund Accounting and Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.

Specialties:  Sage 100 ERP (formerly Sage MAS90 / MAS200), Abila MIP Fund Accounting™, Acumatica, QuickBooks Pro Advisor

 

Abila MIP Fund Accounting™ Consultant Success Story with CVEP

October 26, 2017/in Abila MIP Fund Accounting™, Non Profit /by Mike Renner

Coachella Valley Economic Partnership (CVEP) is a nonprofit economic vitality organization devoted to attracting, retaining and expanding business and developing a high-skilled workforce to enhance the economy and quality of life in the region.

Albia consultant nonprofit MIP.pngWAC Solution Partners Greater Los Angeles – Helping Businesses to Grow Effectively

As providers of accounting software, implementation and support, we offer a wide range of solutions designed to fit businesses and non-profits of all sizes. Our combination of products and services allow you to better manage your accounting and to make insightful decisions about your company’s future.

EXPERTISE WITH LOCAL ROOTS AND NATIONAL REACH

This is a success story that embraced persistence, partnership and always working with and looking out for our customers best interest.

We are very involved with the Coachella Valley business community. In 2014, a local CPA named Kelli Cox, was working with CVEP on their financial statements. CVEP had laid off their Controller. Kelli didn’t have time to do many of the accounting tasks they were requiring. She knew we were Abila MIP Fund Accounting™ Certified Consultants and brought us in to meet with Lesa Bodnar, Chief of Staff of CVEP.

Kelli recommended us to take over many of the accounting tasks due to our knowledge and expertise. CVEP also wanted additional training on Abila MIP Fund Accounting™ software for their staff. Mike Renner trained the staff on General Ledger, Accounts Payable and Accounts Receivable. Laurie Renner went onsite weekly to work on the Abila MIP Fund Accounting™  software, to make accounting entries and at the end of the month reconciled their bank statements. She also worked with Kelli to make sure the financial statements and board reports were ready for the board meetings. Laurie has been working with this client ever since. It’s an ongoing success story for 3 years now.

Some of the comments from the Chief of Staff – Lesa Bodnar are: