sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Job Costing Module Changes

With each annual Sage 100 software release, Sage introduces periodic updates for their Sage 100 2018 software, which include useful improvements and bug fixes to help your Sage 100 product run more efficiently. The most recent update, Sage 100 2018.3, includes many helpful changes to the Job Costing module.

 

What’s new in the Sage 100 2018 Job Costing Module?

  • Fix “(Tax Code)” is not numeric” in version 2018 Job Billing Data Entry for a Fixed Contract job
  • No longer receive “record (report Name) is missing from SY_ReportManagerMaster.M4T.” when using the Designer button to open any report on the Job Cost > Estimating menu.
  • Cost Code Maintenance is no longer truncating alphanumeric Cost Code numbers that include a special character.
  • Job Estimate Printing *SUB and *TOT calculation is now correct if the line is deleted and re-entered to a different line on the grid.
  • New Comments or changes to Comment are now retained in Job Maintenance.
  • Corrected issue with Time & Material transactions not summarizing by Job in Daily Transaction Purge Closed Jobs Dated on or Before
  • Users are now able to enter an Actual Percent Complete greater than 9% in Job Billing Data Entry.
  • User can able to proceed the Sales Tax Calculation with J/C Job Billing selected. There is no Error 88 AR_Salestaxcalculation_bus.pvc 119 displayed.
  • Fix Error: “A missing GL account was found in Job Type: xxx” in Job Billing after converting to version 2018 and “Post to G/L for Work in Process” is unchecked in Job Cost Options.
  • A/R Invoice with a job referenced is no longer adding $1 Sales Tax Billed to the invoice in Job Billing History – Version 2018.
  •  Calculated Overhead Allocation amounts from Job Posting Entry transactions are correct.
  • Error 26 is not occurring for the Job Transaction Detail History Report & Job Transaction Detail Report when selecting Save As for the reports.
  •  Job Billing Data Entry Fixed Bill Totals tab is now displays the Job-To-Date Cost instead of the Year-To-Date Cost.
  • Transaction Date is retained in Primary Grid when exiting Job Posting Entry.
  • Trans Date in Job Posting Entry is now defaults to Module Date not System Date.
  • Cost Code Detail Unit Price and Unit Cost amount can be entered after the decimal.
  • Job Billing Data Entry line Bill Amount is recalculate correctly when Bill Rate is changed for a Time & Material job in version 2018.
  • Fix Job Billing Register update to G/L does not relieve WIP when Post to G/L for WIP is selected in Job Cost Options.
  • Added validation in Cost Types to not allow special characters. Increased size of Valid Cost Type field to 36 characters.
  • PO Receipt Register and PO Return Register update hangs when there are multiple lines which include Job Cost detail.

 

sage 100 2018.3 job costing moduleAccounting Business Solutions by JCS is a leading Sage 100 consultant offering Sage 100 support, training, and data repair services to help fix the problems you may be having with the Job Costing Module in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 ERP software. To get started with Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

The Sage 100 2018.3 download link can be found here.

Manufacturing Inventory Accounting

Manufacturing Inventory Accounting: What Happens to an Inventory Account When Materials Are Bought, Requisitioned, Manufactured, used in jobs or Sold?

If your company is a construction, distributor or manufacturing business using software and are seeking information to help understand how it should work within the software system or if you are new to these processes and are looking for better inventory control, this will help.

This document is intended to give you a high-level view and help you understand what happens to quantities on hand when items are bought, requisitioned, manufactured and/or sold. Each part of the process has its own best practices and its’ own ‘accounting under the hood’ during these various phases of inventory control. Let’s get started. Here is a simple rundown to help you understand these concepts from beginning to end.

Purchases

Individual items are often referred to as raw material or components in a manufacturing environment; products for distribution; or materials for a Job. They are typically purchased through the use of a purchase order and received at the dock. The quantity on hand is increased by the number of items received and the cost of each item is typically tracked by some predetermined costing method. Tracking allow us to see the quantity and value of our inventory as an asset. Later, that tracking will also provide the tools to assign costs when they are used in manufacturing or are used on a job. Ultimately, that tracking allow us to assign a cost when completing a sale, thus granting the ability to view the profit that has been realized. Along the way, we can keep up to date with information about quantities bought, sold, used, expended, transferred or lost to mishap. Some business requires traceability for the movement of items throughout the entire manufacturing process or from purchase to sale. Manufacturers often refer to this as “quote to cash.” The receipt of items at our dock, should increase the value of our inventory while at the same time establishing either a liability for the purchase or an accrual, pending receipt of a future accounts payable invoice.

Purchased items may also be delivered directly to a client location. Usually when the documentation for this type of delivery is recorded, it is considered a ‘drop shipment’, and we are concerned mainly with recording the increase in our material expenses. When the delivery client location is a job address however, we may rather increase an asset amount in a work in process account.

Items may also be managed as non-stock when we are either, not concerned with tracking it’s value, don’t need to worry about quantities on hand, stock availability, profitability per item or sale or where tractability and/or more exacting profitability figures are not required. Sometimes it makes sense to use nonstock items when the cost of the item is so small that managing the process of recording the information is not cost effective.

When making the purchase where a vendor ships product to you and allows you to pay on account, the accounting that occurs is an increase (or debit) to inventory with a corresponding increase (or credit) to a liability account. If an invoice is received with the materials or goods, the liability would be recorded as an accounts payable amount, but if not, it is accrued in a pending payables, purchases clearing account or Accounts payable accrual account depending on your companies terminology to be relieved or transferred to accounts payable when the invoice document actually arrives and is recorded.

When making a purchase where cash, check, debit or credit card is used to directly buy inventory, the offset to an increase (debit) in inventory value would either decrease (credit) our cash in the bank or increase (credit) in the liability to our credit card company. If you are using a credit card to make the purchases, you may also want to reconcile the credit card accounts when the statement from the vendor arrives.

When recording the completed shipment of items that were ‘drop shipped’ to our clients, we usually increase (debit) our expense for the goods we purchased unless the materials were delivered to the site of our ongoing job, the transaction would most likely increase (debit) a work in process (WIP) account. Both of these would be offset appropriately based on the terms of cash or credit purchase provided by the supplier and as already outlined above.

Material Requisition, Issues, Usage or Assembly:

The first step of production, when manufacturing, is the purchase of the items or materials needed. These materials may be purchased to stock for later use during the manufacturing process or directly to a job for a project. Material issue, is the movement of materials from stock into the production process, typically for a specific job, project or production run. The entire production process is recorded in the financial records of the company, and each stage of the process may have its own journal entries. This doesn’t always mean that the overall value of inventory actually changes. Learning about the journal entries that take place during the course of the production process can help you understand the effects of production on your overall financial position. A work in process (WIP) account, may be used to track the value of materials that have been specifically earmarked for a job to help segregate them from items that are available directly for sale, while still tracking costing and other information to allow for reporting on budgeting, management of resources, traceability and ultimately to allow for profitability reporting and budgets versus actual expenses and revenue.

Issuing materials, also known as putting materials into production, is the second step in the production process. Normally, company’s account for direct and indirect materials separately. Direct materials, meaning materials that can be directly traced to finished products, are recorded as an increase (debit) in work in process and a decrease (credit) in inventory account associated with that material at the time they are issued to a production run or job. When recording indirect materials, those that cannot be directly traced to finished products, we instead increase (debit) a manufacturing overhead account while decreasing our materials inventory. Because the process of issuing direct materials is a transfer between two inventory accounts, the overall inventory balance on the financial statements may not change during the lifecycle of any given production step.

Manufacturing of Finished Goods is closely related to job costing, but there are a few major differences.

Manufacturing typically utilizes the demands on inventory to assist in the timing of the inventory procurement process. To manage manufacturing production, we may need shop floor controls and the ability to track the status of items as the process of production plays out. Steps in the manufacturing process may need to be tracked to derive required item status information or when coupled with workstations, provide a framework to assist with capacity planning. Jobs tend to be broken into steps called phases and cost codes, but here the statuses we need to track are usually a % of completion. Specific instructions or CAD drawings needed for a production step may sometimes be more detailed than phase plans found in job costing. Both manufacturing and job costing may benefit from the ability to establish estimated revenue, estimated expenses and to track and manage change orders. Bar code capabilities may also provide a great assistance in a manufacturing environment by helping to manage item movement during the receiving, issuing, usage or consumption to the job and shipping steps.

When items are used during the manufacturing process, most often the material used in production are depleted by one of three methods.

Bill of Materials Assembly/Production:

This is a good choice if production management does not require work in process tracking and either the items you make have a consistent bill of materials or are repetitively manufactured items with only minor alterations to the materials needed. At the point where production is recorded, meaning the finished item is completely assembled and ready for shipment to the customer, the quantity of component items, defined by the bill of materials, are removed from inventory and finished items are increased by the quantity produced. The cost associated with the finished quantity is a factor of the cost of materials used. At the most basic level, the cost of the materials used is simply moved from the raw materials inventory account to the finished goods account. In more comprehensive systems, additional costs, like labor or overhead, may also be included in the cost associated with the finished product. These additions may be added as additional costs to increase the finished product inventory account, but would come out of an overhead or a labor used in manufacturing account, rather than a raw materials inventory account.

Work Orders or Work Tickets:

This method is most effective if you have manufacturing process where there is a significant need to manage inventory demand over time. In other words, if production takes a long time to complete and items need to be accounted for as they are used, or if your need to correlate multiple distinct production runs in order to properly manage material demand, work tickets provide an excellent tool. Work order systems often also proved tools to allow for variation on a standard bill of materials.

Work order systems may include the ability to predefine the steps needed in the manufacturing process and allow for the printing of ‘shop travelers’ or other documents to help manage the process through all of its stages. At some point, in this type of system, the cost of materials are moved from their raw materials inventory to a work in process tracking account. Once goods are completed, the costs are transferred out of the work in process account, decreasing (crediting) it’s balance. At the same time the total cost of production is used to increase (debit) the finished goods inventory. With complex bills of manufacturing involving multiple steps, the work in process account may have been increased as each step is completed and other costs like overhead or labor are recorded. Like a material issue, final assembly is often recorded as a transfer between inventory sub-accounts, and the overall inventory balance does not change. For more complex production, inventory accounts may have increased as the additional costs associated whit each completed step are recorded. The cost of goods manufactured will remain in the finished goods inventory account until the goods are sold.

Kitting

The last method is often called kitting. In this method when a finished product is invoiced, special behind the scene tools in the system, decrease the materials inventory by the quantities defined for the kit, based on their cost as tracked by the inventory system. In this instance there is a decrease (credit) in the materials inventory account with a corresponding increase (debit) in our cost of goods sold account with no intervening involvement of a finished goods inventory account.

Additional Cost of Manufacturing

Costs, other than materials, may be included as part of any of the depletion methods to increase the cost of a finished product in stock or increase the costs associated with a project or job when it is sold. These additional costs may include, labor, labor burden, subcontracted work, overhead or equipment use. Often these costs have been accounted for in other ways, so the GL accounts affected usually decrease (credit) an expense account in order to correspondingly increase (debit) the inventory account associated with the finished product. Many manufacturing systems, when the process is being tracked on Work Orders or Work Tickets, allow the definition of the operations that take place and work stations where operation steps are performed to produce a finished product. As reporting takes place on the status of these operational steps, these systems often record the the accumulation of these additional cost while allowing for oversite and management. Defining work stations and operations also provide a framework for the scheduling or available resources allowing management to identify conflicts for those resources and providing a timetable to completion. When bills of material (BOM) are combined with the management of operations and shop floor resources, it is often referred to as a bill of manufacturing. In a simple BOM assembly or kitting situation, these additional costs are often standardized and added in to the bill of materials.

Sales and Cost of Goods Sold

Deposits to jobs or manufactured items normally should be reflected as a deposit to the job, project or order. Deposits generally increase (debit) our cash in the bank while at the same time, increase (credit) our liability in a customer deposits account of some sort. The deposit should be applied to the balance due from the customer usually during the final part of the billing cycle. In a manufacturing situation, this is usually when the item is shipped while in a job cost situation where billings may be periodic or incremental, it could take place at any time up until long after the final billing when the job or project is finally considered fully complete. When the deposit is finally applied, the amount decreases (debits) customer deposits while at the same time, decreases (credits) accounts receivable, reducing the balance due from the customer.

The final step in a manufacturing environment is the sale of the items produced. The quantity being sold is shipped and recorded as such on an invoice to deplete the quantity on hand for each item being shipped. The revenue is recognized as an increase (credit) to the appropriate sales account while also increasing (debiting) accounts receivable and the balance due from the customer. Since inventory is being depleted, the inventory account is also decreased (credited) by the cost of the item and that same cost, will increase (debit) the cost of goods sold (COGS) account associated with that item. The cost associated with the sale is dictated by a costing method assigned to the product being sold.

The difference between revenues and cost of goods sold is the gross profit on the sale. If the increase (credit) to our sales account is more than the increase (debit) to our cost of goods sold account, the sale resulted in a profit.

 

Job Costing needs tend to differ from manufacturing in the following areas:

Both Manufacturing systems and Job Cost may require that labor, labor burden, overhead, sub-contracted services or labor, and equipment costs be rolled into the cost of what is being sold. Both often want to be able to estimate or budget their work and duplicate or review prior work for to achieve more competitive sales while insuring a profit. Each has a hierarchy of applied cost. Though highly individualized for every business entity, Manufacturing tends to rank materials as their most important cost, followed by an overhead consisting of labor, equipment, labor burden and transportation while sometimes including subcontracted services. In Job Costing time (both supplied and subcontracted labor and equipment) followed by materials is the usual hierarchy followed by labor burden and other overhead costs.

They both may also want to break their work into smaller steps for better reporting and management with the added benefit of incremental reporting providing the potential for forecast possible issues in time to make changes prior to the completion of the work. For Manufacturing, those increments are often broken down into work centers or operations, while in Job Costing we see breakdowns called phases and cost codes.

In Manufacturing systems, we generally bill customers for the product that was manufactured while Job Costing might follow one of 3 main billing methods; percent of completion, completed jobs and time and material.

The term Job Costing is most often used in the construction industry. Often the project lifecycle is longer than in Manufacturing. Labor and outside service along with actual material tend to be posted to a job during the period in which the expense occurred and comparison reporting between the actual expense and budget are review on a regular basis. Some job costing applications also use a WIP (completed job) type accounting method. Most Job Costing applications are geared towards cost tracking and often do not assist a business in the procurement process or scheduling process.

In the completed jobs accounting method, actual costs are accumulated in to WIP accounts during the life cycle of the job. Once the job is completed and the final invoice to the customer is created, the accounting entry increases (debits) accounts receivable while increasing (crediting) revenues. At the same time the expenses that have been accumulated in WIP are removed (credited) from WIP and added (debited) to the appropriate expense accounts. Both these transactions are normally recorded in the same accounting period.

In percentage of completion jobs, billing is based on the percentage of actual work has been completed for a Job. This could be based on a comparison of estimated vs actual expenses as tracked in the system or on a percent complete as reported from the jobsite. For example, if $500 of an estimated $2,500 in expense costs have been spent or if the project manager has reported and had approved completion of 20% of the work, the 20% of the total sale amount can be billed for the billing cycle. This billing method may use a WIP type accounting method, where cost are accumulated in WIP and redistributed at the time of billing as in the completed jobs method, or the costs may simply be expensed as they occur. When expensed directly, each invoicegenerated for a job, will only increase (debit) accounts receivable while increasing (credit) revenues.

In Time and Materials (T&M) Jobs,  all costs are directly expensed to the job. From the tracked time costs, like labor, subcontracted services or equipment usage, and tracked material costs, are used to bill the customer. Revenue is recognized when each customer invoice is generated and expenses are recorded at they are received.

 

Accounting Business Solutions by JCS specializes in inventory control software, assisting contractors, distributors and manufacturing companies in leveraging technology. Our consultants are certified in Quickbooks and Sage software, including Sage 50 and Sage 100, as well as manufacturing add-ons such as JobOps and MiSys Manufacturing. Call us today at 800-475-1047 today!

Sage 100 Month End Checklist, Sage 50 month end checklist, Sage 100 support, Sage 50 support

Sage 50/Sage 100 Month-End Checklist

One of the main benefits of using an accounting or an ERP system is the organizational advantages offered by these products. Whether you are using Sage 100 ERP or Sage 50 software, it is crucial to keep your monthly finances accurate and up-to-date. Never fall behind with our handy Sage 50/Sage 100 Month-End Checklist!

 

Sage 50/Sage 100 Month-End Checklist:

  • Enter your sales and purchase invoices for the month.
  • Enter all monthly payments and receipts from check stubs and paying-in slips.
  • Enter direct debits, ACH transfers, checks, and so on from your monthly bank statements.
  • Reconcile bank accounts for the month, including credit cards.
  • Enter journals or run wizards for accruals, prepayments, depreciation and so on.
  • Depending on where you live and your payment schedule, calculate, file, and pay your monthly state and federal employment and sales taxes.
  • Run Aged Debtors and Aged Creditors reports for the period.
  • Run Profit and Loss and Balance Sheet for the period.
  • Run month-end wizard (Tools→Period-End→Month-End).

 

Sage 100 Month-End Checklist, Sage 100, Sage 50, Sage 50 Month-End Checklist, Sage 100 support, Sage 50 support

If you need help learning how to use these helpful Sage 50/Sage 100 month-end features, call the certified Sage consultants at Accounting Business Solutions by JCS today! Our experienced, professional staff offers a full range of Sage software consulting services, including Sage 100 support, Sage 100 classes, Sage 100 data repair, Sage 50 support, Sage 50 classes, and Sage 50 data repair for all years and versions of your particular Sage product. Our nine locations, which include Detroit, MI, Chicago, IL, Charleston, SC, St. Louis, MO, Mandeville, LA, Dallas, TX, Naples, FL, Atlanta, GA, and Sacramento, CA, are conveniently located throughout the United States to serve you better. We also offer remote assistance and in-house help. Get help with your Sage 100 or Sage 50 software by calling 800-475-1047 today, by emailing us at solutions@jcscomputer.com, or by filling out our contact form. Your success is our goal!

JCS announces Nomination 2nd Year in a Row! – 800.475.1047 – Training – Support – Consultant – Reseller

JCS announces Nomination 2nd Year in a Row! – 800.475.1047 – Training – Support – Consultant – Reseller

We are excited to announce Accounting Business Solutions by JCS has been nominated again this year for 2018 Enterprising Women of the Year Award.

Last year, we announced receiving 2017 Enterprising Women of the Year Champion Award.

“Our success is dependent on great relationships. Our customers and our staff are the 2 best assets we have as a business. Hence, our motto ~ Your Success is our Goal” says Jennifer O’Brien, Lead Project Manager.

This year we are once again nominated for receiving this prestigious recognitions among women business owners across the country. We couldn’t be more humbled about this nomination.

Accounting Business Solutions by JCS provides customer service and support using Sage 50 Accounting, QuickBooks and Sage 100 as the base accounting systems. These systems can accommodate all size businesses effectively by offering valuable solutions for automation and detailed intelligence reporting thus creating streamlined efficiencies for businesses.  Reports are at your fingertips to manage finances, inventory, sales, purchasing, employees, payroll, and CRM databases.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

What’s New in Sage 100 and Sage 100c 2018

What’s New in Sage 100 and Sage 100c 2018?

Support – Training – Consultant – Reseller

Feature enhancements for the latest updates in Sage

Sage 100 2017.2

Accounts Receivable – Payment Setup Wizard

To help set up credit card and ACH payment processing through Sage Exchange account a payment setup wizard has been added. After setting up your Sage Exchange account, the wizard will guide you through enabling ACH payment processing and credit card processing in Company Maintenance and creating payment types.

Payroll – Sage 100 Direct Deposit Service Processing

Changes were made to the Process Employee Pre-Note and Direct Deposit Transaction Window:

  1. A warning message will appear if you select a batch that has already been sent or has an effective date that has passed
  2. The Select Sent button has been renamed to Select Batches Previously Transmitted and is now at the bottom of the column of button
  3. The Select Not Sent button has been renamed to Select Batches Never Transmitted and has moved to the top of the column of buttons

Sage 100 2017

Global Enhancements

Enhanced Auto-Complete

In previous versions this feature only considered the beginning of the text in the searched fields. Now, when using the updated feature, your search criteria is compared with all words within the searched fields. For example, if you have a customer named Allen’s Appliance Repair and a customer named Appliance Services, typing Appl in the Customer No field results in a list that includes both customers. The number of fields included in the search has been expanded to include the ability to search for vendors by phone number. Try typing the phone number (digits only) in the vendor no. field.

 

Build Search Index Utility

In order to activate the enhanced auto-complete feature, run the Build Search Index utility on the Library Master Utilities menu. If this step isn’t run, the auto-complete will run as it did prior to the enhancement. This utility can be run after creating a new customer, vendor and item records so that the records are indexed and appear in the auto-complete results. When running the utility it updates the index for all of your companies. Use the Task Scheduler to automatically run the indexing utility on a regular basis.

Full Text Search Option in Lookup Windows

A full text option has been added to the Search list in the Lookup windows. When Full Text is selected, search criteria is compared with the data in all columns available in the lookup window. The search criteria must match the beginning of a word. For example, if you have a customer named Market Supplies and another customer named Village Market, if you type Mark in the search results, Village Market will not show up.

Search for Empty Fields in Lookup Windows

Now there is the ability to search for fields that do not contain any value in the lookup windows. Select a field from the Search list then select Is Empty from the operand list then click find.

Maintain Commodity Codes for Miscellaneous and Inventory Items

Maintain a list of commodity codes and associate them with miscellaneous items. Commodity codes are included with the data send when processing level 3 credit card transactions in the Sales Order module.

  • A Commodity Code field has been added to the Main tab in Product Line Maintenance. A Commodity Code check box has been added to the Apply Product Line Information window so that you can apply the code entered in the Product Line Maintenance to the selected Inventory items within the product line.
  • There is a new Commodity Desc field displays the commodity code description in Sales Order Entry and Sales Order Invoice Data Entry.
  • Common Information Setup menu now has Commodity Code Maintenance added. This task can be used to maintain a list of commodity codes and their descriptions. Codes and descriptions are available in the lookup views for Commodity Code fields. Click the Apply button to assign a Commodity Code range of items.
  • Selecting an item in the Sales Order Entry and Sales Order Invoice Data Entry, the code entered in the item’s maintenance task is the default value in the Commodity Code field. This can be changed.
  • The Commodity Code Import Wizard which is available on the Common Information Utilities menu will guide you through importing commodity codes from tab-delimited text files.
  • On the Main tab in Miscellaneous Item Maintenance there has been a Commodity Code fields added. You can create a new code on the fly or enter an existing code.

Larger Font for Selected Reports

Font size used for selected reports has been increased to improve visibility. Reports have previously been viewed in 6 point font but now is 30-40% taller.

Prior and Next Buttons for Calendar Window

Use the Prior and Next buttons to quickly change from month to month on the calendar window.

Cancel Button Available when Printing Reports

Cancel report printing by clicking Cancel button on the message window that appears while the report is processing.

Suppress “Remove Forms” Message

There is now an option in Role Maintenance that allows you to suppress the message that reminds you to replace forms with paper after printing.

Resizable Memo Maintenance Window

Resize the Memo Maintenance window by dragging the lower-right corner of the window.

New Options on Help Ribbon

New buttons on the Help Ribbon include:

  • Create a Support Ticket
  • Access Sage 100 Knowledgebase
  • Start a chat session with Sage 100 Tech Support

Accounts Receivable

You can now enter ACH payments in the following tasks:

  • Repetitive Invoice Entry
  • Cash Receipts Entry
  • Accounts Receivable Data Entry

This feature is enabled when you have Sage Payment Solutions account that is set up for ACH payments. Enable the feature on the Payments tab in the Company Maintenance and set up ACH payment types in Payment Type Maintenance. Some fields, tasks and tabs have been renamed to reference ‘payments’ instead of ‘credit cards’. Details in the following sections.

ACH Payment Processing

ACH payments are submitted to the Sage Payments Solutions as part of the Cash Receipts Journal and Accounts Receivable Sales Journal update process. They cannot be processed individually.

Data Entry Tasks

The following changes were made in the data entry tasks

  • ACH Payment related fields have been added to the Cash Receipts Deposit window and the Cash Receipts Entry Header tab.
  • The Credit Card tab has been renamed to the Payment tab. Fields related to ACH payments have been added. The Payment ID field has replaced the Credit Card ID field.
  • The Fix button is now available on the Payment tab based on the Allow to Override ACH Payment Transaction security event in Role Maintenance.

Reports and Listings

  • Print a customers’ ACH payment information has been added to the Customer Listing task window. The last 4 digits of the bank account appear in the listing.
  • Credit Card Settlement Report has been renamed to Credit Card and ACH Settlement report to include ACH payments on the report.
  • The last 4 digits of the bank account appear for ACH payments on the Deposit Transaction Report

Maintenance Tasks

  • Now you are able to select ACH Payment as the payment method when in the Payment Type Maintenance
  • An ACH account field now displays in Invoice History Inquiry which displays the last 4 digits of the ACH payment bank account for invoices with ACH Payments. The Payment Information button has replaced the Credit Card Information button and will open a new Payment Information window to view additional details about the payment.
  • ACH payments now appear in the secondary grid on the Customer Maintenance Invoices and Transactions tabs.
  • On the Customer Maintenance Additional tab, the Payment ID field has replaced the Card ID field
  • Customer Credit Card Maintenance window has been renamed Customer Credit Card and ACH Payment Maintenance

Changing Transaction Information

Allow to Override ACH Payment Transactions has been added for security. This security event enables the Fix button on the Payments tab in A/R Invoice Data Entry and Cash Receipts Entry which allows users to update payment transaction information.

Bank Reconciliation

Following check boxes have been added to the Bank Reconciliation Report task window:

  • Keep Window Open After Preview
  • Keep Window Open After Print

Improved Export to Excel or Financial Reports

The Excel file is easier to view and manipulate when exporting Bank Reconciliation reports. Minimum font size 8 points and empty columns and rows are minimized.

Customer Relation Management

Now included with Sage 100 is Sage CRM 7.3. To obtain information on what’s new in this version, see Sage CRM 7.3 SP3 Release Notes. This document is available in the Documentation link in the Sage CRM installation program. On the Auto run screen that appears, click the Documentation link when you start the Sage CRM installation.

Library Master

After selecting a role in Role Maintenance, you can click the Search button and enter search criteria. Matching security events, tasks and module options appear and you can select one to go to its location on the applicable tab.

Sales Order

Enter ACH payments in Sales Order Entry and S/O Invoice Data

A Sage Payment Solutions account is set up you can enable this feature.

 

For more information on Sage 100, Sage 100c give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

 

TAGS: Sage 100, Sage 100c, Sage 100 Support, Sage 100c Support, Sage 100 Consultant, Sage 100c Consultant, Sage 100 Reseller, Sage 100c Reseller, Sage Features, Sage 100 Features, Sage 100 Enhancements, Sage 2017, Sage Training, Sage Consultant

Accounting Business Solutions by JCS Nominated for 2017 Entrepreneurial Excellence Awards – 800.475.1047 – Support – Training – Consultant – Reseller

Accounting Business Solutions by JCS Nominated for 2017 Entrepreneurial Excellence Awards 

FOR IMMEDIATE RELEASE
Lauren LaMantia
800.475.1047

Arlington Heights, IL September 2017– Accounting Business Solutions by JCS the nation’s leading premier provider of technical support and training for Sage Software, Intuit QuickBooks, MiSys, JobOps, Point of Sale, Timeslips, Advanced Reporting and Barcoding announced their nomination for 2017 Entrepreneurial Excellence Awards presented by Business Ledger. The Entrepreneurial Excellence Award recognizes and builds entrepreneurship in suburban Cook County, DuPage County, Kane County, Lake County, McHenry County and Will County Illinois.

“Accounting Business Solutions by JCS always strives to provide highest quality training and support to its customers”, said Jennifer O’Brien, President, Accounting Business Solutions by JCS “Our commitment to growth for our clients is what really sets us apart”.

About Accounting Business Solutions by JCS

Accounting Business Solutions by JCS provides software technical support and training for Sage Software products including Sage 50 (formerly Peachtree), Sage 100 (formerly MAS 90/200), Sage 100 Advanced, ACT!, Timeslips, and Intuit QuickBooks. In addition, JCS specializes in integration between accounting applications and 3rd party add-ons including e-commerce shopping carts, point of sale and barcode systems and customer relationship management applications. Accounting Business Solutions by JCS provides installation, training – online, your site or our training center, technical support, online, on-site or by phone.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

Scanco Software announces acquisition of Sage Manufacturing/JobOps Modules – 800.475.1047 – Training – Support – Consultant – Reseller

Scanco Software announces acquisition of Sage Manufacturing/JobOps Modules – 800.475.1047 – Training – Support – Consultant – Reseller

FOR IMMEDIATE RELEASE
Lauren LaMantia
800.475.1047

SARASOTA, FL – August 8, 2017 – Scanco Software LLC, a leader in Manufacturing Automation Solutions and Warehouse Management announced the acquisition of Synergistic Software LLC, developers of Sage Manufacturing/JobOps Modules for Sage 100 and Sage 100c ERP Software. Synergistic Software founded in 1983 outside of Minneapolis, MN delivers Sage 100 users the best-of-breed manufacturing technology through its JobOps and comprehensive Field Service and Dispatch Module. Sage Software chose Synergistic Software’s manufacturing technology for Sage 100c under the Sage Manufacturing Brand. Synergistic Software has always been among selected few of a group for Master Developers for Sage and the Sage Partnership Community.

We are thrilled to welcome the Synergistic team to our company” says Tess Boros, Partner at Scanco. “Scanco was recently recognized as a ‘Top 25 Logistics Technology Solution Provider’ for 2017 by CIO Applications and this acquisition is consistent with our strategy of combining world-class technology and service companies. This acquisition strongly strengthens Scanco’s position as the premier provider of manufacturing software for the entire sage 100 market” says Boros.

After our 2016 acquisition of JDB Solutions, our next step was to incorporate Sage Manufacturing/JobOps into our manufacturing suite of products,” says Shaun Boros, Partner at Scanco. “This acquisition cements Scanco’s position in the Sage 100 market space for all things distribution and manufacturing. We really have built an amazing portfolio of products for the Sage 100 community and look forward to growing all of them with Sage well into the future. This is a key acquisition for Scanco and more importantly, the Sage 100 users.”

“We are very excited about this acquisition and the future of Sage Manufacturing/JobOps under Scanco,” comments Joe Bisaha, Director of Manufacturing for Scanco. “I have worked with JobOps for the last 20 plus years and they are a perfect fit for us moving forward. We have implemented and developed some incredible mobile and shop floor solutions for the Sage channel. This acquisition enables us to provide so many more new and exciting integrated solutions for both mobile and Sage Manufacturing/JobOps customers. Our customers have always been our top priority, and this is going to allow all of the Sage Manufacturing/JobOps customers access to expand their operations with top-tier apps and services from Scanco.”

About Accounting Business Solutions by JCS

Accounting Business Solutions by JCS provides software technical support and training for Sage Software products including Sage 50 (formerly Peachtree), Sage 100 (formerly MAS 90/200), Sage 100 Advanced, ACT!, Timeslips, and Intuit QuickBooks. In addition, JCS specializes in integration between accounting applications and 3rd party add-ons including e-commerce shopping carts, point of sale and barcode systems and customer relationship management applications. Accounting Business Solutions by JCS provides installation, training – online, your site or our training center, technical support, online, on-site or by phone.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

Sage 50 Sage 100 QuickBooks – Accounting Business Solutions by JCS Expands adding a new office in Charleston, South Carolina 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50, QuickBooks Sage 100 Expands to Charleston, South Carolina

FOR IMMEDIATE RELEASE
Lauren LaMantia
800.475.1047

Charleston, South Carolina  – Accounting Business Solutions by JCS the nation’s leading premier provider of technical support and training for Sage Software, Intuit QuickBooks, MiSys, JobOps, Point of Sale, Timeslips, Advanced Reporting and Bar coding announced the addition of a new office in Charleston, South Carolina. A drastic increase in demand for the company’s training and services to the small-medium business market necessitated the addition of the new office.

“Accounting Business Solutions by JCS always strives to provide highest quality training and support to its customers”, said Jennifer O’Brien, President, Accounting Business Solutions by JCS “Our new Facility in Charleston, South Carolina will provide expanded consulting services to our South Carolina based clients”.

About Accounting Business Solutions by JCS

Accounting Business Solutions by JCS provides software technical support and training for Sage Software products including Sage 50 (formerly Peachtree), Sage 100 (formerly MAS 90/200), Sage 100 Advanced, ACT!, Timeslips, and Intuit QuickBooks. In addition, JCS specializes in integration between accounting applications and 3rd party add-ons including e-commerce shopping carts, point of sale and barcode systems and customer relationship management applications. Accounting Business Solutions by JCS provides installation, training – online, your site or our training center, technical support, online, on-site or by phone.

QuickBooks Sage 50 and Sage 100 Charleston. With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

User Interface Modernization

Sage 50 is calling this a Facelift which has been long overdue. They have updated the Navigation Centers to ease use while keeping the functionality that we all know.

Sage 50c and Traditional:

AP Automaton provided by Beanworks

Beanworks offers a cloud-based accounts payable automation solution that helps companies streamline their invoice to payment process. Invoice routing is automatic and provides the ability to review and approve online. Also pay invoices via automated check, wire, EFT/ACH or virtual credit card.

This feature add-on and partnership will be available to Sage 50, Sage 100 and Sage 300 customers. Sage 50 Quantum customers with 25 or more users will get an immense amount of satisfaction and see increased productivity using the AP Automation.

For more information on Sage 100 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

 

Purchase Agent 2017 Now Available – 800.475.1047 – Training – Support – Consultant – Reseller

Purchase Agent 2017 Now Available – 800.475.1047 – Training – Support – Consultant – Reseller

Sage 100, Sage 100c 2017 Versions 5.40.0 & 5.40.1.0

This module allows for identifying items that need to be purchased over a given planning period providing an easy method for buyers to quickly view shortages and generate purchase orders. This module evaluates the following information to determine recommended quantities to be purchased:

  • Material Requirements Planning projections
  • Work Order material requirements
  • Current on hand inventory
  • Sales Order item demands
  • Purchase Order incoming quantities
  • Work Order finished products and subassemblies
  • Reorder point quantities and the minimum order quantities defined in Inventory Management

Benefits of the Purchase Agent:

  • Only order what is needed to satisfy Sales Orders to optimize cash flow
  • No missed promise dates with material shortages
  • Have inventory ordered when needed and avoid expedite fees
  • Maximize purchase power with the ability to consolidate items/orders
  • Capture accurate costing with automatic generation of purchase orders
  • View all pertinent data
  • Streamline purchasing
  • Retain full control with flexible options that fit your business

Modules needed to use the Purchase Agent Module

  • Library Master
  • Inventory Management
  • Accounts Receivable
  • Sales Order
  • General Ledger
  • Purchase Order
  • Accounts Payable

The Work Order, Bill of Materials and Material Requirements Planning modules may be installed and activated but not required to use the Purchase Agent Module.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

 

X