Sage 100 Manufacturing, Sage 100 ERP Manufacturing, Sage 100 Production Entry, Sage 100 ERP Production Entry, Sage 100 Production Manager, Sage 100 ERP Production Manager

Sage 100 Production Entry

Sage 100 Production Entry Manufacturing

Sage 100 production entry for Sage 100 Manufacturing – ERP / MRP – Maximize efficiency thru all stages, increase productivity with visibility of accurate

Sage 100 Manufacturing, Sage 100 ERP Manufacturing, Sage 100 Production Entry, Sage 100 ERP Production Entry, Sage 100 Production Manager, Sage 100 ERP Production Manager

data across all operations. Sage 100 ERP is a suite that includes integrated functionality for financial management, sales, customer service, distribution, inventory, manufacturing with built in business intelligence for data analytics.

Sage 100 Production Entry

Sage 100 ERP, Sage 100, Sage 100 Manufacturing Consultant, Sage 100 ERP Manufacturing Consultant

Use Sage 100 Production Entry to record manufactured items increasing the quantity on hand for finished goods into the Sage 100 Inventory module. During Production Entry specify the component quantity, consumption or scarp for corresponding component parts before the actual manufacturing process, during or after.

Sage 100 Production Entry

1. Select Production Entry from the Sage 100 Bill of Materials Main Menu

Sage 100 Consultant, Sage 100 Manufacturing Consultant, Sage 100 Production Consultant

2. When first accessing the program Sage 100 will prompt you for an accounting date. Enter the date the production was processed on. Otherwise go to step 3.

Sage 100, Sage 100 ERP, Sage 100 Manufacturing

3. Click the # icon to get the next batch number. Although not necessary, enter a comment to identify the batch. Click Accept when done.

sage 100 barcode, sage 100 barcode reader, sage 100 barcode scanner, sage 100 barcode scanning, sage 100 barcodes

4. Click the # icon again to get the next Production Number.

sage 100 for manufacturing, sage 100 implementation, sage 100 job ops, sage 100 jobops, sage 100 manufacturing, sage 100 manufacturing consultants, sage 100 manufacturing help, sage 100 manufacturing software, sage 100 manufacturing support, sage 100 quantum, sage 100 reseller in chicago

5. Click the Magnifying Glass to look up the Bill Number you wish to post production for. Select the item from the list and either double click the item from the list or highlight the item and click the Select button.

sage 100 sellers, sage 100 software for manufacturing, sage 100 software resellers, sage 100 support phone, sage 100 training locations near me, sage 100, manufacturing,

6. After selecting the Bill Number for the item being made, enter the quantity that was made.

Sage 100 Manufacturing, Sage 100 Production Entry, Sage 100 Production Management

7. Click the 2 Lines tab and verify the component items and the quantities used. Make any necessary adjustments for scrap as needed. Click the Accept button when done.

Sage 100 Consultant, Sage 100 manufacturing Consultant, Certified Sage Consultant

8. Repeat steps 4 – 7 if there are more production entries. Otherwise you can either X out of the program and go back to the menu or you can click the Printer icon down in the lower right hand corner of the Production Entry window to update the production postings. If the Printer icon is selected to update the production postings then proceed to step 9.

Sage 100 manufacturing, Sage 100 Production, Sage 100 production entry, Sage 100 bill of materials, Sage 100 BOM

9. Select the Batch Number you want to update by clicking the Print check box shown to the right of the Batch Number. Click Proceed.

New York, City Los Angeles, Chicago, Houston, Philadelphia, Phoenix, San Antonio, San Diego, Dallas, San Jose, Austin, Jacksonville, Indiana, San Francisco, Columbus, Fort Worth, Charlotte, Detroit, El Paso, Memphis, Boston, Seattle, Denver, Washington, Nashville, Baltimore, Louisville, Portland, Oklahoma, Milwaukee, Las Vegas, Albuquerque, Tucson, Fresno, Sacramento, Long Beach, Kansas, Mesa, Virginia Beach, Atlanta, Colorado Springs, Raleigh, Omaha, Miami, Oakland, Minneapolis, Cleveland, Wichita, Arlington, New Orleans, Bakersfield, Tampa, Honolulu, Anaheim, Aurora, Santa Ana, St Louis, Riverside, Corpus, Christi, Pittsburg, Lexington, Anchorage, Stockton, Cincinnati, St Paul, Toledo, Newark, Greensboro, Plano, Henderson, Lincoln, Buffalo, Fort Wayne, Jersey, Chula, Vista, Orlando, St Petersburg, Norfolk, Chandler, Laredo, Madison, Durham, Lubbock, Winston, Salem, Garland, Glendale, Hialeah, Reno, Baton Rouge, Irvine, Chesapeake, Irving, Scottsdale, North Las Vegas, Fremont, Gilbert Town, San Bernardino, Boise, Birmingham

10. The next process will print a report showing you what items were made and what items were used along with their corresponding quantities. Verify that the proper printer is showing. Change the printer if necessary. Verify the date. Click Print to print the register.

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

11. Shown below is an example of the report

 

AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, AS, DC

12. After verifying that the data on the report is accurate then click the Yes button to update the Production Entry. Otherwise click no and go back to step 4 and look up the record that you need to either update or delete and renter if necessary following steps 4 through 7. After clicking the Yes button the system will update the quantities on hand for those items that were made and used. If adjustments need to be made after clicking Yes then they will have to be made in the Inventory Module using Transaction Entry found on the Main menu.

Sage 100 Accounts payable, Sage 100 accounts receivable, Sage 100 general ledge, Sage100 bank reconcilation

13. This Completes the Production Entry Process.

Once you have Sage 100 Production Manager for Sage 100 Manufacturing purchased it is easy to activate your new Sage 100 ERP module.

Registering Sage Production Management

  1. Access Library Master Setup menu > Scanco Product Registration.

Note: Registration information is obtained when Sage Production Management is downloaded from the Sage Production Management Downloads Page.

Sage 100 manufacturing software, Sage 100 Manufacturing, Sage 100 ERP, Sage 100 Production Manager

  1. Verify the correct Sage 100cloud Serial number and User Licenses displays.
  2. Select the Activate button.
  3. Select OK in the New keys activated. message.

Sage 100 ERP, Sage 100 Manufacturing, Sage 100 Production, Sage 100 Production Manager, Sage 100 Production Entry

  1. Verify Activated displays in the Status field for the J/T Production Management – MTS product code record.

Sage 100 manufacturing, Sage 100 ERP, Sage 100 manufacturing consultant, Sage 100 ERP consultant, Sage 100 consutlant, Sage 100 manufacturing consultant

  1. Select the Close button.

Retired Sage 100 Features

JobOps Make to Stock Import – no longer needed since make to stock transactions are built into Sage 100 manufacturing

Sage 100 Work Order, Sage 100 Work Order Consultant

Purchase Agent – As purchase agent / CEM will become the MRP solution in Sage 100, the purchase agent product will be retired for new sales for customers on version 2019 or higher.

  • Major new capabilities
  • Dynamic Inventorysage 100 MRP, Sage 100 MRP Consultant, Sage 100 material requirement planning, Sage 100 material requirement Planning consultant
  • Editable work order after release
  • Cost Analysis by step and work order
  • Simplified inquiry view
  • Simplified transactions and transaction entry
  • Capture costs from Accounts Payable

With the release of Production Management for

Sage 100 Version 2019

Sage 100 work order, Sage 100 Job Cost, Sage 100 Work order consultant, Sage 100 job cost consultant

the following products will be retired:

  • WO Scan – replaced with Sage 300 manufacturing
  • JO Scan – Replaced with Sage 500 manufacturing
  • WO Efficiency – replaced with Production Management Capabilities

 

Migration path from

Sage 100 Work Order

to a Business Framework Manufacturing solution Sage 100 Version 2019Sage 100 work order, sage 100 production manager, sage 100 work order consultant, sage 100 production manager consultant

  • Make to stock only
  • Major new capabilities
  • Dynamic Inventory
  • Editable work order after release
  • Cost analysis by step and work order
  • Simplified Inquiry View
  • Simplified Transactions and transaction entry
  • Capture cost from Accounts Payable

 

 

For assistance with Sage 100 Production Entry and  Sage 100 Production Manager and / or Sage 100 Manufacturing

Give our certified Sage 100 Consultant a call 800.475.1047

Sage 100 Month End Close Checklist

Sage Timeslips Consultant

Accounting Business Solutions, Accounting Business Solutions by JCS, JCS Computer Resource, JCS, JCS software, sage 100, quickbooks, sage 50, MISys, Sage 100 manufacturing

Sage 100 month end close

Sage 100 Month End Close

How to perform Sage 100 Month End Close Procedure and Checklist

for Sage 100 ERP Small Business Accounting

Month End Close Tips and Tricks

Closing Steps

In Sage 100 the most 5 basic steps include entering all deposits and checks, bank reconciliation, reviewing of financial balances, printing and saving reports and finally closing each module and then beginning entry of  transactions into the new accounting period.

Module Information

Every individual module in Sage 100 has its own steps that should be performed prior to the close. All transactions must be updated to the module and to the general ledger.  By following an organized list each month you will keep your system in balance and moving forward.

Review

Small Businesses walk thru these steps each month end to make sure financial reports are accurate. The result of completing each month in a timely manner is so that the owners can determine profitability each month during the year. The bank reconciliation which is included as a part of the month end close steps confirms all transactions for the monthly period were recorded and is a critical part of the process.

Tips and tricks

Sage 100

Five accounts to reviewed and reconciled each monthly:

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Sage 100 Small Business Month-End Close Checklist

Request Month End-Close Excel Checklist

Sage 100 Small Business Quarter End Close Checklist

View Quarter End Checklist

Sage 100 Small Business Year End Close Checklist

Review Year End Close Checklist

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit www.timeslipssupport.com

Accounting Business Solutions, Accounting Business Solutions by JCS, JCS Computer Resource, JCS, JCS software, sage 100, quickbooks, sage 50, MISys, Sage 100 manufacturing

Sage 100Cloud Software News 2019

Sage 100Cloud Software News 2019

Save while you can. The latest software offer on Sage 100Cloud until 9/30/2019.

Outgrown your current Accounting Software?

Sage 100cloud is ideal for companies that have outgrown their current accounting software or manual processes. This powerful business management solution can collect, store, manage and interpret data across one business or multiple businesses. Over the past several years Sage Software has added so many rich benefits. With so much in functionality now your company can combine modules to build an ERP system optimized for your business as it grows.

For Small to medium sized manufacturing companies

Move beyond simple accounting software with Sage 100cloud manufacturing to help you manage your manufacturing. They new Manufacturing and Production Management modules have all the power most small to medium sized manufacturing companies need.

If you are a make to order, custom manufacturer, repetitive manufacturer, assembler, or job shop this manufacturing program is worth a look. If you perform field service once the product has been installed at your customer there is a module that can handle this also. Visit Sage 50 Support.

For existing MAS 90, MAS 200 and Sage 100 users

If you are out of date on your maintenance program and now would be a good time to upgrade.

If you’re using a retired version of Sage 100, you’re no longer eligible for product updates and therefore not taking advantage of latest features and upgrades! This is a very cost effective way to get back on a current maintenance plan.

If any customization’s have been made to your Sage product there are a few special considerations that need to be reviewed prior to upgrading to the latest version such as are those previous enhancements now built into Sage 100Cloud manufacturing.

To learn more give us a call 800.475.1048

 

Sage 100Cloud

Sage 100Cloud

 

Timeslip Training

Accounting Software Training

Period-end processing in Sage 100 Sales Order

This time of year, period-end processing in Sage 100 is a useful feature to know. Learn how to use period-end processing in Sage 100 with the Sage 100 Sales Order training class from Accounting Business Solutions by JCS today!

 

Sales Order Utilities & Period-End Processing

Note: Back up your data before purging the data.

Purge Expired Orders/Quotes: Use Purge Expired Orders/Quotes to remove expired master orders, expired repeating orders, and expired price quotes.

  • All selected orders and quotes that expired on or before the date entered are permanently removed from the system.
  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.

Purge Obsolete Sales Orders: Use Purge Obsolete Sales Orders to remove all obsolete sales orders or back orders whose order dates are on or before the date entered.

  • You can also enter a selection of sales order numbers to remove.
  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.
    • This task is available only if Invoice Data Entry and Shipping Data Entry are not in progress.

Purge Order/Quote History: Use Purge Order/Quote History to remove sales order and quote history records whose order dates are on or before the date entered.

  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.
  • Other than individually deleting price quotes or sales orders, this is the only way to remove these transactions.
    • This task is available only if the Retain Sales Orders/Quote History check box is selected in Sales Order Options.

Purge Lot/Serial History: Use Purge Lot/Serial History to remove lot and serial history records whose order dates are on or before the date entered.

  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.
    • This task is available only if an option other than None is selected at the Retain Lot/Serial Item Sales History field in Sales Order Options.

Purge Sales History: Use Purge Sales History to remove sales history records based on the posting or invoice date. Records dated on or before the year-end date selected are permanently removed from the system.

  • You can only purge history that is more than two years prior to the current year.
  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.
  • The options available vary based on whether Inventory Management is set up and if Fiscal Periods or Calendar Months is selected at the Base Inventory Periods On field in Inventory Management Options.
    • This task is available only if the number of years to retain sales history selected at the Years to Retain Sales History field in Sales Order Options is greater than 2.

Purge Sales Order Recap: Use Purge Sales Order Recap to remove sales orders from the Sales Order Recap file with order dates on or before the date entered.

  • After the purge is complete, the System Activity Log is updated with the date, time, company code, user logon, purge description, and purge date.
    • If the Purge Sales Order Recap at Period End check box is selected in Sales Order Options, this task is automatically run at period-end.
  • This affects the Sales Order Recap file only. It does not affect the Open Sales Order file.

 

Create Sales Order/Quote History:  Use Create Sales Order/Quote History to create sales order history files if sales order history was not previously retained to migrate from Sage MAS 90 to Sage MAS 500.

  • When the sales order and quote history files are created, the System Activity Log is updated with the date, time, company code, user logon, and utility description.
    • This task is available only if the Retain Sales Order/Quote History check box is selected in Sales Order Options.
  • Can also run this utility from Sales Order Options by selecting the Retain Sales Orders/Quote History check box and clicking Yes when prompted to create sales order and quote history if data exists in the data entry files but not in the sales history files.
    • Note: Back up your data before running this utility.

Period-End Processing

The following actions are performed when the period is closed:

  • Prompts the user to print the monthly reports.
  • It purges Sales Order Recap based on the selection made in Sales Order Options.
  • If retaining customer sales history, all current-year sales information is updated to the Last Year fields and any sales history for customers with no current-year activity is removed based on the number entered at the Years to Retain Sales History field in Sales Order Options.
  • Increments the current period in Sales Order Options.

 

To learn more about period-end processing in Sage 100 Sales Order, call the Sage 100 experts at Accounting Business Solutions by JCS today at 800-475-1047 or email us at solutions@jcscomputer.com. Our experienced Sage 100 consultants offer Sage 100 training classes, including how to use period-end processing in Sage 100 ERP, Sage 100 Manufacturing, and Sage 100cloud.

Tracking Sales Orders in Sage 100

Learn about Tracking Sales Orders in Sage 100 in Sage 100 in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

 

Tracking Sales Orders in Sage 100

Open Sales Order Report

Use the Open Sales Order Report to view information for all or a selected group of open sales orders. A variety of options for this report make it a helpful tool for tracking and analyzing sales orders. These options include:

  • Ability to base the selection criteria on a sales order number, customer number, ship date, bill-to name, and salesperson
  • Option to include just new, open, or on hold sales orders
  • Ability to include all order types, just one order type, or a combination of order types
  • The extension calculation amount can include the amount ordered or just the amount remaining
  • You can print the report in either a detailed or summary format

Open Orders by Item Report

Use the Open Orders by Item Report to view open orders by item number or description. This is helpful for analyzing or tracking which items are needed to fill open orders. The options on this report include:

  • Ability to include all order types, just one order type, or a combination of order types
  • Choice of whether miscellaneous and special items are included
  • Options for how kit lines appear
  • Ability to base the selection criteria on item number, product line, and warehouse

Open Orders by Job Report

Use the Open Orders by Job Report to view open sales orders by job number. Print this report to track the job numbers of items on open orders, pending processing and shipment.

  • The report is sorted automatically by job number.
  • Ability to base the selection criteria on item codes, job numbers, customer numbers, product lines, and warehouse codes to print.
  • You can print this report in a summary or detail format.
  • This report is available only if Job Cost is activated and integrated with Sales Order.

Open Orders by Promise Date Report

Use the Open Order By Promise Date Report, sorted by promise date, to assist you in ensuring you are meeting obligations to your customers in a timely manner. The promise date is the date you indicate the order would ship.

Sales Order Recap

Use the Sales Order Recap report to view all sales order numbers processed and whether they are open, completed, or deleted. The information on this report is kept indefinitely unless you indicated in Sales Order Options that it should purge at period end or it is manually purged using Purge Sales Order Recap on the Utilities menu.

Back Order Report

Use the Back Order Report to view detailed information on all back orders by item, by customer, or by bill-to name. The information for each back order includes the order number and date, the ship date, and the customer number and name.

 

Are you interested in learning about Tracking Sales Orders  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Tracking Sales Orders in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Sales Order Shipping in Sage 100

Learn about Sales Order Shipping in Sage 100 in Sage 100 in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

 

Sales Order Shipping in Sage 100

Sales Order provides a shipping entry system that warehouse personnel can use to quickly and accurately enter items to ship. The shipping entries are normally made after the order is entered but before it is invoiced. Entry is made using either the keyboard or a scanner and only the fields needed by the warehouse staff to pick and pack items for shipment are displayed. Shipping must be enabled in Sales Order Options BEFORE it can be used.

In addition to the features available in Shipping Data Entry, you can link to the power of a multi-carrier shipping program called StarShip developed by V-Technologies. This application automatically calculates freight for a variety of carriers such as United Parcel Service, the US Postal Service, and Federal Express. StarShip produces shipping labels and manifests and performs inquiries on shipments. In addition to Shipping Data Entry, you can access StarShip from Invoice Data Entry and Shipping History Inquiry if StarShip is installed. The StarShip Add-On is NOT taught in this class


Processing Shipments using the Shipping Features

 

Shipping Data Entry – Lines

 

  • Record quantities shipped and back ordered.
  • Cannot add new lines to an order.
  • Drop ship items are not available.
  • Unshipped quantities for item lines where back orders are not allowed, will be cancelled automatically.
  • Buttons are available to either backorder all remaining items or ship them.
  • Lot/Serial # items will require distribution.
  • Package number can be set to allow tracking to a specific package.
  • A barcode scanning device can be sued to facilitate rapid data entry.

 

Item Package Maintenance

  • View or change item quantities by package number.

Shipping Data Entry – Shipping

 

  • Ship Weight field is available if set to allow in Shipper ID Maintenance.
  • Entry in Sales Order Options determines if default weight appears and what is seen in Ship Weight lookup.
  • If set to calculate from weight recorded in Inventory, items on order should have the same units of measure as weight recorded.
  • The Tracking button allows entry of tracking numbers by package. This information will be automatically populated by StarShip if installed and used.
  • ISHIP Shipping Tools web site can be viewed from the Package Tracking button.

Invoicing Shipping Entries

Accepting a shipping entry stores the document in the same files as Sales Order Invoice Entry. Security settings control how invoices from shipped orders are printed. Either it print with the shipping documents or someone needs to print them through one of the other available processes. Orders entered through Shipping Data Entry can be modified from the same entry window if necessary until updated. They can also be viewed and modified as needed through the Sales Order Invoice Entry window until updated.

Packing List Printing

 

Are you interested in learning about Sales Order Shipping  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Invoicing Sales and Updating Orders in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Invoicing Sales and Updating Orders in Sage 100

Learn about Invoicing Sales and Updating Orders in Sage 100 in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

 

Invoicing Sales and Updating Orders in Sage 100

Batch Entry

Automatically Generating Invoices from Orders

  • You can select orders by order number, date, customer number, salesperson, ship date, or promise date.
  • You can select expired orders and select sales orders by cycle code when generating invoices from repeating orders.
  • After the selection criteria is defined for the orders to invoice, click Proceed.
    • The system selects the order based on the selection criteria but does not generate an invoice until you print and update the Auto Generate Invoice Selection Listing.
  • To print the Auto Generate Invoice Selection Listing, click the Print button.
  • After printing the listing, you are prompted to generate the invoice batch. No invoices are generated unless you click Yes at this prompt.
    • You can clear the orders previously selected by returning to Auto Generate Invoice Selection and clicking Clear.
  • You can modify or delete invoices generated in this task using Invoice Data Entry.
  • You can print the invoices in Invoice Data Entry or by selecting Invoice Printing on the Main menu.

Sales Order Invoice Data Entry – Default Values

You can save default values for just the current Sales Order Invoice Entry session or for future sessions as well. Values saved for future session are stored by user logon or workstation. You can change this information for each invoice if necessary.

Sales Order Invoice Data Entry – Standard Invoice – Header

 

  • An Invoice number is required.
    • Enter an Open Sales Order number to invoice an order.
  • Master and Repeating orders cannot be invoiced directly. They must first be opened as a standard order.
  • Invoices do not require an order. The can be entered from scratch.

Sales Order Invoice Data Entry – Addresses


Sales Order Invoice Data Entry – Lines

 

 

  • When first entering the lines tab a prompt will allow for all items to be shipped.
  • Any line item or field may be modified.
  • Any item form the original order not flagged as shipped when the invoice is saved will automatically be placed on backorder and the order type changed to Back Order.
  • Lot/Serial # items will require distribution.

Sales Order Invoice Data Entry – Totals

 

  • Options for Payment Type are the same as in Sales Order Entry – Totals.
  • A deposit reduces the invoice balance and the GL debit account assigned to that payment type is debited.
  • Quick Print.

Sales Order Invoice Data Entry – Other Tasks

  • Customer Data review or maintenance.
  • Customer Credit History Checking

Sales Order Invoice Data Entry – Cash Sales

  • This is a specific Invoice Type.
  • The cash sales account is debited instead of the AR account. It is defined in A/R Division Maintenance.
  • Customer balance will not be increased.
  • Must still record the actual receipt of cash through A/R Cash Receipt Entry to affect the cash account.

Sales Order Invoice Data Entry – Debit Memos

  • Select the invoice type of Debit Memo to enter a debit memo and follow the same procedures as entering an invoice to increase a customer’s balance.
  • Debit memos are normally issued to a customer for billing errors, freight not billed, or other miscellaneous charges.
  • Enter all amounts as positive amounts.

Sales Order Invoice Data Entry – Credit Memos

  • Select the invoice type of Credit Memo and follow the same procedures as entering an invoice to track sales returns, reduce a customer balance or return inventory to stock.
  • For open-item customers, you can apply the credit memo to a specific invoice or after the fact in Cash Receipts Entry.
  • For balance forward customers, credit memos are automatically applied to the customer’s balance.
  • Enter all amounts as positive amounts.
  • You can return assembled kits to inventory assembled by clicking Yes to ship from stock or disassembled by clicking No to ship from stock.

Printing Invoices

Generating COD Labels

 

Are you interested in learning about Invoicing Sales and Updating Orders  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Invoicing Sales and Updating Orders in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Settling Credit Card Payments in Sage 100

Learn about Settling Credit Card Payments in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

Settling Credit Card Payments in Sage 100 – Printing Daily Sales Reports and Updating

Sales Order Gross Profit Journal

  • The Sales Order Gross Profit Journal is used as an audit trail. It details net sales, cost of goods sold, gross profit, and associated general ledger accounts for each invoice line item.
  • This is an optional report and is available only if you selected to print this report in Sales Order Options. You cannot reprint it after the invoices are updated.
  • Use this report to track commission on gross profit or by inventory item.

Daily Back Order Report

  • The Daily Back Order Report lists all back orders generated in Invoice Data Entry.

Daily Sales Recap Reports

  • The Sales Recap Reports provides information about your daily sales.
  • The reports printed at this time are selected in Sales Order Options.

Daily Deposit Recap Report

  • The Daily Deposit Recap Report provides a recap by payment type of all deposit payments applied against invoices for the current Sales Journal.
  • This report is only printed if the Print Daily Deposit Recap Report check box is selected in Sales Order Options and if a credit card transaction exists.
  • This report summarizes all credit card, check, and cash deposits received for the Sales Journal.

Sales Order Batch Authorization

Sales Order Batch AuthorizationReport

  • The Sales Order Batch Authorization report provides a log of credit card batch authorizations performed on sales orders and their results.
  • Print this report to begin the credit card batch authorization process on sales orders.

Note: This report is available only if the Enable Batch Authorizations check box is selected in Library Master Company Maintenance.

S/O Job Transaction Report

  • The S/O Job Transaction Report provides all job cost information updated from Sales Order.
  • Printing the journal does not automatically update to the permanent fields.

Note: This report is only available if Job Cost is activated and integrated with Sales Order and a job number is entered on the invoice.

Summary Package Tracking

  • Use Summary Package Tracking to view and track packages shipped. Click Tracking in Shipping History Inquiry or Invoice History Inquiry to open Summary Package Tracking.

You can also use Customer Maintenance if a customer calls to inquire about their shipment by selecting the invoice on the Invoices tab, clicking the Invoice History button, and then clicking Tracking to open the Summary Package Tracking window.

 

Are you interested in learning about Settling Credit Card Payments  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Settling Credit Card Payments in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Sales Order Reports in Sage 100

Learn about Sales Order Reports in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

Sales Order Reports in Sage 100

Sales Order Reports in Sage 100

Accounts Receivable Invoice History Report

  • Use the Accounts Receivable Invoice History Report to view a detailed listing of invoice information using Invoice Data Entry. If Sales Order or Job Cost is integrated with Accounts Receivable, you can also access invoice history information for invoices entered in these modules.
    • This report is only available if you selected Yes or Summary at the Retain in Detail field in Accounts Receivable Options.
  • Both Accounts Receivable and Sales Order invoices appear.
  • You can print a detailed listing of invoice information recorded in Invoice Data Entry.
  • Line item detail information is also provided for each invoice if you selected Yes at the Retain in Detail field in Accounts Receivable Options.

Invoice History Printing

  • Use the Invoice History Printing report to reprint multiple invoices after they are updated.
    • You can reprint invoices only if you selected Yes at the Retain in Detail field in Account Receivable Options.
  • You must print the different types of invoices separately.
  • You can choose to reprint only unpaid invoices for open item customers (for collection purposes).
  • Unlike Invoice History Inquiry, you can reprint more than one invoice at a time.

Accounts Receivable Trial Balance

  • Use the Accounts Receivable Trial Balance report to view a complete recap of the Accounts Receivable invoices.
  • The report details receipts and adjustments and other activities which affect Accounts Receivable balances.
    • This report is based on the posting date and it is the suggested report for reconciling to General Ledger.

Deposit Transaction Report

  • Use the Deposit Transaction Report to view a list of deposit payment transactions recorded in Sales Order. This report is available only if an option other than None is selected at the Retain Deposit Transaction History field in Accounts Receivable Options.
    • You have the option of including a range of payment types, customers, and transaction dates.
    • Information on the report includes the payment type, invoice number, date, and amount.
    • When the report is printed, you have the option of purging the data included on the report.

Monthly Sales Report

  • Use the Monthly Sales Report to produce a recap of sales activities for the period entered in Accounts Receivable. If using divisions, the report sorts by division.
    • You cannot change the period ending dates on this report.
  • You should print the report before closing the period.

Sales Analysis by Salesperson

  • Use the Sales Analysis by Salesperson report to produce a recap of: total sales, cost of goods sold, and profit percentages for each salesperson.
    • You can select which fiscal year and period to include on the report.
    • You can also determine if period to date, year to date, and prior year totals are provided for the period and year selected.
  • The information detailed in this report allows you to compare accounts receivable activity by salesperson and customer. You should print this report before closing the period.

 

Are you interested in learning about Sales Orders Reports  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Sales Order Reports in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Sales Order Entry in Sage 100

Learn about Sales Order Entry in Sage 100 in Sage 100 with Sage 100 training classes from Accounting Business Solutions by JCS!

 

Entering Sales Orders

Pricing Hierarchy

 

Sales Orders Types

  • Standard Order
  • Master Order
  • Repeating Order
  • Price Quote
  • Back Order

Sales Orders Entry – Default Values

You can save default values for just the current Sales Order entry session or for future sessions as well. Values saved for future session are stored by user logon or workstation.


Sales Orders Entry – Header

 

  • Customer information comes from Accounts Receivable.
  • Order Type may not be changeable after entry on the Line tabe has taken place.
  • Order Status
    • New: This is the default status assigned to a Sales Order when entered. The status is automatically updated to the status of Open when it is printed.
    • Hold: When status is changed to Hold, the Reason field becomes available. You cannot print Sales Orders with the status of Hold until the status has been changed to Open.
    • Open: You can assign the status of Open at any time, whether the order is printed or not, but the status will change to Open automatically when it is printed.
  • Other Fields.
  • Commission Options.
  • If MAS is linked to Sage CRM, additional fields may appear.

Sales Orders Entry – Address

Sales Orders Entry – Lines

Only certain types of line item entries can be made.

  • Inventory Items
  • Sales Kits
  • Miscellaneous Items and Charge Codes
  • Comments
  • Special Items

 

 

  • Choose the Alias Item button to view alias item codes
  • Item Inquiries (item status, price lookups and alternates are available)
  • On-the-Fly Inventory items can be entered if allowed in Options.
  • Extended Descriptions button
  • items and comment codes are selected by using a forward slash (/) prefix.
  • Special Items are designated by an asterisk (*) prefix (can distribute sales and cost of sales directly to a GL acct, will drop ship automatically is set to do so in Options).
  • Sales Kit button
  • Customer Last Purchase
  • Secondary Grid fields
  • Exceeding Available Quantity Options

 

  • Available Quantities are automatically checked if told to in Options.
  • Accepting an exceeded quantity will over distribute resulting in a negative qty. available.
  • Quantity on Sales Order field in inventory is updated when the line entry is accepted.
  • Lines for Back Orders
    • Are generated automatically during normal processing whenever quantity shipped is less than quantity ordered
    • When entering manually, enter both quantity shipped and quantity ordered.


Sales Orders Entry – Totals

 

  • Amounts subject to tax are automatically calculated. View from Tax Detail button
  • Freight can be calculated based on ship code if selected in Options.
  • Deposits for complete payments may be entered. There however no posting for deposits or balance until order is invoiced.
    • Deposits reduce the amounts that get posted to the AR account, posting instead to customer deposits.
  • Selecting the CREDIT CARD payment type will result in a request for Credit Card information..
    • New authorization codes are required each time the deposit amount increases.

Sales Orders Entry – Other

  • Customer Data review or maintenance.
  • Customer Credit Checking
  • Quick Print
  • Copy From

Master Orders

  • ‘Blanket’ Order.
  • on SO field in Inventory is not updated when original Master Order is created.
  • New Standard Orders are issued against Master Orders for shipping and invoicing.
  • A cycle code may be assigned on the Master Order to use as selection criteria for automatic order generation by using Auto Generate Order Selection.
  • Cumulative quantities ordered and received are tracked on the Master Order.
  • Quantity remaining is defaulted for new order based on Master Orders.
  • Expiration (expired Master Orders are purged from Utilities)


Repeating Orders

  • Use as a template for routine standard orders.
  • All order data is stored with the order.
  • on SO field in Inventory is not updated when original Repeating Order is created.
  • Copy to Use or apply a standard order against.
  • A cycle code may be assigned on the Repeating Order to use as selection criteria for automatic order generation by using Auto Generate Order Selection.
  • Repeating Orders track last standard order date and number issued against it.
  • Original order quantity is defaulted for new order based on Repeating Order.
  • Expiration (expired Repeating Orders purge automatically during period end processing or can be manually purged from Utilities)

Automatically Generate Sales Orders

  • For Master or Repeating Orders.
  • Expired or on hold orders may be optionally selected.
  • Selected orders are not generated until the Listing is printed and updated.

Price Quotes

  • Customers may be added On-the-Fly.
  • Item pricing, discounts, freight, and other calculations take place just as they would on a Sales Order.
  • Quantity on hand checking is performed, but nothing is updated inventory.
  • Can be printed individually or in groups.
  • Can be easily converted to a Sales Order.

Printing Sales Orders

Printing Picking Sheets

  • Picking sheets for orders with drop ship or back order items cannot be printed.
  • Picking sheets can be reprinted.
  • If activated, Bill of Material bill options can also be printed.
  • Use Clear to remove previous selections.

Printing Shipping Labels

Entering Customer Deposits

  • Cash Receipts Entry in Accounts Receivable is used to record the receipt of either a deposit (prepayment) or payments against outstanding customer balances.
  • Deposits by cash, check or credit card are enterd in C ash Receipts Entry.
  • Only record credit card deposits when you want to recognize cash at the time of the order.

Daily Drop Ship Report

  • Only items designated as drop ship will appear on this report.
  • Report is sorted by Vendor and Item Number with totals for each.
  • Information can be optionally cleared after printing.
  • The Daily Drop Ship file can be cleared at any time.

 

Are you interested in learning about Sales Order Entry  in Sage 100? Accounting Business Solutions by JCS offers Sage 100 training classes, including Sales Order Entry in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

X