Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 Bill of Material

Sage 50 Bill of Material

I wanted to provide you with the process below which I think will help clarify how Sage 50 assemblies work. Hopefully this will be enough information to test thru the process with me or your team. The reason for my suggesting you walk thru this is to see the effort required to manage multiple level bill of materials.

When using multiple level bill of materials Sage 50 does not have the capacity to help you manage processes like scheduling, timing of demands for inventory items or shop floor routing and scanning capabilities. I bring these points up to confirm whether or not you might need those now or in the future to help your day to day operations become more efficient.

Sage 50 Bill of Material by Sage Software

Sage 50 can do multiple level bill of materials. Most often the challenge is that each sub assembly needs to be completed One at a time Before the final assembly can be completed and invoiced. Sage 50 does not have a back flush feature to allow

You to have clients request a delivery date and then manage the purchase order or build process to calculate the needed start date.

That said Sage 100 will step up to those needs. I can get a demo set up for this application so you can see the difference. The only conflict I am aware of in running Sage 50 and Sage 100 on the same serve is a potential conflict in the versions Of crystal reporting.


Once we have a discovery call on Sage 100, I can then pull together pricing. If you wish I can get this on our schedule and we can offer estimates of conversion. We have migrated many clients in similar positions.

Yes, you can have some folks on Sage 50 and Some on Sage 100. A Consideration would be consolidated financials If you are doing that now using Sage 50 consolidated financials. That said Sage Intelligence may be able to provide this with a bit of setup. During the initial discussion we can him his opinion of Sage Intacct which may be Another option.

Let me know how you want to proceed. I am here to help. 800.475.1047

This is the process To set up inventory items

Set up all raw materials as inventory item class “stock”

Example of stock item is PTWheel-6

Set up all sub-assemblies as inventory item class “assembly”

Example of sub-assembly is PTHANDLE-ASM

Set up finished item – as inventory item class ‘assembly”

the components could be raw materials and/or sub-assemblies

Example of finished item is Red Lawn Mower

Item ID Item Description Qty Needed Qty on Hand Est Cost
Red Lawn Mower Red 18″ Reel Mower w/Tracking
. PTHANDLE-ASM 4′ Handle Assembly 1.00
. . PTHANDLE-BENT4 Handle – 4 ft bent 2.00 150.00 13.18
. . PTBOLT-1.5 Hex bolt 1.5″ 4.00 1,280.00 1.32
. . PTNUT- 5/16 Hex nut 5/16″ 8.00 1,180.00 0.56
. . PTBOLT-2 Hex bolt 2″ 4.00 900.00 1.36
. PTWHEEL-6 6″ Wheel 2.00 70.00 12.00
. PTWHEEL-10 10″ Wheel 2.00 70.00 16.00
. PTBLADE-99-9 16″ 5 blade 1.00
. . PTBLADE-16-5 16″ 5 blade 1.00 56.00
. . PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
. PTBOLT-1.5 Hex bolt 1.5″ 6.00 1,280.00 1.98
. PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
Red Lawn Mower Total  Cost 103.24

In this example the highlighted items in orange are the sub-assemblies – this is the report found at

Reports – inventory – bill of materials

In the items that are sub-assemblies or final assemblies there is an option on the bill of materials file tab

Which allows you to include or exclude the component items from the customer orders.

Sage 50 Bill of Material – the process to build your finished items

You can build using one of two available methods

  • Option a. Assembly Build
    • Found under tasks – Assemblies
  • Option b. Work Tickets
    • Found under tasks Work Tickets

Either of these you would need to

Step 1. Build the sub-assemblies one at a time using assemblies or work tickets

Step 2. Build the final product

This build of the final product is the step that rolls up all costs

The thing I like about work tickets is you have a printable document

Where you can add some steps to help identify the process and give direction

Then when the build is complete a document that can be provided to the front

Office to complete paperwork and invoicing

Then when you ship/invoice the final product you would have

  • Reports by customer
  • By item
  • Sales
  • Cost of Sales
  • Profitability

The only item needed on the sales order or invoice is the finished item

+ any misc. items you may wish to include

I would recommend

As in any product you not allow the inventory to have quantities on hand

Go into a negative level.

I am here to help give us a call 800.475.1047

Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 training and Sage 100 training for Sage Software available from Accounting Business Solutions by JCS

778 West Algonquin Road

Arlington Heights – Chicago, Illinois

Specialist in Sage Software

Features Sage 50 2019

Features Sage 50 2019

These new features included tighter Microsoft integration and we can’t wait to share them with you. We can help you understand how to use all the new and advanced features. These improved features help you run a more efficient back office accounting department, speed up invoicing, cash flow and much more. Built in accounting best practices, intuitive navigation and robust features make this a must have for small business. There are already tens of thousands of other small businesses leveraging this software.

Microsoft Outlook Connection

New features include the ability to automatically sync Microsoft Outlook contacts and Sage 50cloud contacts saving you time. Access customer balance information, credit limits, contact details, and order history even when you are away from the office.

Sage 50 Cloud Backup

Make Sage 50 Cloud backup a part of your Disaster Recovery plan. You get security and peace of mind with automated data back-ups stored offsite, in the cloud. Using Sage 50 Cloud backup you will never be stuck again without a recent backup.

Microsoft Office Business Premium

This new bundle gives you the award winning Sage 50Cloud software and Microsoft Office Suite. Stay current with your versions of Outlook, Word, Excel, PowerPoint and more. This added benefit helps you effortlessly manage your technology platforms.One convent payment covers your core business solutions, your accounting package and your office suite.

Microsoft Office Business Premium and Sage 50Cloud

Sage 50cloud leverages the power of Microsoft Office 365 freeing up key data. Access your information from anywhere anytime along with a range of integrated apps. It integrates with Office 365 Business Premium and the full Microsoft Small Business Productivity Suite, saving you time and costs and boosting productivity. Easily manage your customer information, create a quote and convert them to sales orders and invoices with a simple click.

Accounts Payable Expense management

Keep your expenses organized and up to date. Record your purchases and expenses so you never miss a payment. You stay in control of your cash 24/7.

Sage 50 Dashboards

At-a-glance dashboards instantly lets you view available cash, receivables, expenses, inventory on hand, and so much more. The Dashboard tab view is customizable.  You can access the business performance dashboard and the Trends Forecast dashboard from the desktop and is only available for Sage 50 Quantum Accounting . Instantly take the pulse of you business in one convent place.


Payroll must be accurate and on time, every time. Sage 50 payroll is affordable easy to setup and simple to use. Payroll can be added to the core Sage 50Cloud software for a twelve month period at any time. To make sure you stay compliant with your payroll taxes this service is renewed annually. It makes it easier to pay employees, track benefits, and Aatrix helps you easily report taxes.

Advanced Reporting

Standard reports include reports on sales, taxes, upcoming expenditures, commissions profits everything you and your accountant need to analyze business performance. You can take your reporting to the next level by adding the power of Sage Intelligence or Microsoft Power BI and instantly get advanced Sage 50 custom report on Microsoft Power BI. We can help you build out the Sage 50Cloud advanced reports you need to take an accurate pulse of your business. Information on Sage 50 Training Classes.


Sage 50Cloud 2019

Features Sage 50 2019

Sage Timeslips Training

Sage 50 2019

Sage 50 2019 – Is it time to make the decision to use the most versatile small business accounting software?

What are the System Requirements for Sage 50 2019

  • Processor operating frequency:
    • Pro and Premium Edition: 1.0 GHz or higher (2.0 GHz recommended)
    • Quantum and Accountant Edition: 2.0 GHz or higher (Multiple-core processor operating at 2.33 GHz recommended)
  • 4 GB RAM. Recommended 6 GB RAM
  • 4 GB hard disk space (additional 1 GB needed for installation)
  • Latest version of Internet Explorer
  • Microsoft® supported version of Windows 7, Windows 8.1 or Windows 10 (with the latest updates from Microsoft)
  • 256-colour or higher SVGA monitor, minimum resolution of 1024 x 768
  • CD-ROM drive
  • Forms that can be sent via email require MAPI-compliant email client, Internet connection, and email service
  • Sage 50cloud integration to Microsoft Office 365 requires Microsoft Office 365 Business Premium
  • Multiuser (Premium and higher) optimized for Windows 7, Windows 8.1 and Windows 10. Dedicated server recommended: Windows Server 2016, Windows Server 2012, Windows Server 2012 R2, Windows Server 2008 R2, Windows Small Business Server 2008 R2
  • Terminal Services: Windows Server 2016, Windows Server 2012, Windows Server 2012 R2, Windows Server 2008 R
  • High speed Internet connection (for subscribed Sage online services, for example, Sage Drive)

Integration with other software packages

  • Word and Excel integration requires 32-bit versions of Microsoft Word and Microsoft Excel 2010, 2013 or 2016

Conversion: Converts all data from previous versions of Sage 50 starting with Sage 50 Accounting Release 2014.0. And yes it is possible to convert to a lower-level version or edition. As a national leading provider of Sage 50 professional services we have performed hundreds of updates to the most recent version.

Sage 50 2019


Learn how to use the software quickly and efficiently Sage 50 Training Classes.


We can help convert your lists and balances to make the transition or upgrade easy for you.

Spend more time on your business, less time on your books give us a call or visit


#sage50, #sage502019, #sage50software, #sage50nearme, #sageupgrade, #sage50upgrade

Timeslips Training

Sage 50 Physical Inventory Count

Sage 50 Physical Inventory count

EZScanIt is the Sage 50 Barcode Add-ons for Sage 50 Quantum by Sage Software

Maximize your performance With EZScanIt Inventory Management Software. This software is designed, fully integrated and made just for Sage 50cloud. This application works with all your Sage 50Cloud information. It reads inventory items, sales orders, purchase orders and comes with the ability to print barcode labels. Using this software you can get work completed quickly and manage your Sage 50 inventory in a snap. Visit Sage 50 Support to view additional information on support and training and Sage 50 barcode scanning.

This is the only barcode scanning software on the market that uses your Sage 50 data. Yes, the same data you have already set up in your Sage 50cloud software package. This Sage 50 Barcode Inventory System is an affordable inventory management software. It will help you reduce costs. You can increase efficiencies, minimize your time and efforts using sage 50cloud physical inventory count

EzScanIt Demo

This video revels how to use EZScanIt Sage 50 Barcode add-on for Sage 50. You can ship, receive, print labels and perform physical Counts. Other names for this software include:

  • 2020 Sage 50 cloud
  • 2019 Sage 50C
  • Sage 50
  • Peachtree Accounting
  • Sage 50 Bar Code Scanner
  • Bar Code Scanning Software
  • Sage 50 Inventory Management

Sage 50 BarCode add ons for Sage 50. Ship, receive, print barcode labels and perform physical inventory counts for Sage 50 software using your data from your Sage 50 company data files. No need to set up a second software application and maintain two sets of data files.


Most businesses write the counts on paper and then calculate the differences. They they manually enter the adjustments. A barcode scanner allows you to more quickly take a physical inventory count, update the inventory adjustments into Sage 50 and print a physical inventory variance report. If you want to easily finish your work you can use these features to help you get it done.

Accounting Business Solutions by JCS provides support, training and consulting for Sage 50 all versions. Put our 30 years of experience to work for you and we can share with you best practices for using Sage 50 Accounting software. For more information visit or call 800.475.1047


Sage Timeslips Training

sage 50 barcode scanner, sage 50 barcode scanning, barcode scanning sotware, sage 50 add ons, sage 50 barcode, sage 50 inventory management

Sage 50 Barcode Add Ons

#sage50barcodescanner, #sage50barcodescanning, #barcodescanningsotware, #sage50addons, #sage50barcode, #sage50inventorymanagement

Sage 50Cloud PayPal Stripe

Sage 50Cloud PayPal and Stripe

Sage 50cloud now provides payment options using PayPal or Stripe

So why not get paid faster and improve your business cash flow and leverage this feature if you are using Sage 50cloud. You can sign up now to use PayPal or Stripe for your small business. Payments can be accepted online, on a mobile device, in an app or in person using this feature. Consider this new service because it is used inside Sage 50Cloud. This new integration makes getting money from your customer simpler and adds to the current payment options just making Sage 50Cloud a better small business solution.

Recording payments in Sage 50cloud

Apply a Customer Payment to an Invoice. From the Tasks menu, select Receive Money. Enter a deposit ticket ID that can easily represent the type and source of payment. Lookup, enter or select the customer ID. Enter a check/reference number that will help identify the receipt (for example, the customer’s check number). Or you can now select PayPal.

Manage all your payments in one place and eliminate the hassle of manual data entry. Activate built-in payments and:

  • Accept credit card payments on invoices directly in software
  • Automatically post to the General Ledger —no manual entry
  • Sync online or onsite payments directly to the General Ledger
  • Feel confident payments are secure

Customers can easily signup to start using PayPal or Stripe and accept payments using  a business account. This feature makes it one of the most flexible methods of digital payment. Set up your PayPal business account, activate this in Sage 50Cloud and you are ready to go. Sage 50cloud customers can start taking for payments for new or existing invoices right away.

This new integration between PayPal or Stripe and Sage 50cloud giving your businesses more choices for accepting payments from your customers. For businesses like yours this new feature can be setup within minutes, activated and in put into action.

Review the latest versions of Sage 50Training classes

Sage Timeslip Training

Sage 50Cloud

Sage 50Cloud

Standard Crystal Reports in Sage 50 and Sage 50cloud

Which standard Crystal Reports are included in in Sage 50? 

Standard Crystal Reports included in Sage 50 include:

  •       Aged Payables v9
  •       Aged Receivables v9
  •       Customer Balance Graph v9
  •       Customer Detail List v9
  •       Customer Sales by Item v9
  •       Customer Sales by Month v9
  •       Inventory Labels v9
  •       Items Sold by Month v9
  •       Purchases by Unit Price v9
  •       Vendor Balance Graph v9
  •       Vendor Detail List v9
  •       Void Check Register v9

If you would like to learn more about standard Crystal Reports in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class, as well as a Crystal Reports for Sage 50 class. For Sage 50 support and training, call us today at 800-475-1047 or email us at

Create Purchase Orders from Work Tickets in Sage 50

Create Purchase Orders from Work Tickets in Sage 50

How do you autofill or auto create Purchase Orders from work tickets in Sage 50? 

Sage 50 allows you to set up Inventory Item Defaults to auto create purchase orders in Sage 50 behind the scenes. The Ordering tab of this window has options that let you enable the auto-creation of POs for:

  1. drop-ship transactions
  2. non-drop-ship transactions
  3. work tickets

Important:For auto-creation of purchase orders to work, your company must be using the real-time posting method.

You can treat each auto-created purchase order just as you would a manually created one. You can edit the purchase order, print it, or e-mail it to a vendor in the Purchase Orders window.

Note: Even if your company is set up for auto-creation of purchase orders, Sage 50 will not automatically create POs for recurring customer invoices. Instead, you will have to manually generate POs for any inventory that you need to reorder as a result of recurring invoices.

To auto create purchase orders from work tickets in Sage 50, the following criteria must be met:

  • Each item must be set up in Maintain Inventory Items with a preferred vendor.
  • The user who is entering the transactions listed below must have access rights to add Purchase Orders.
  • The quantity ordered of one or more of the items must cause the quantity available as of the transaction date to fall below minimum stock levels.

If these conditions are met and your company is set up to auto create purchase orders in Sage 50. Sage 50 will automatically create a purchase order each time a work ticket is saved. In addition, to ensure that auto-creation works most effectively, each item in Maintain Inventory Items should be set up with a minimum stock level and minimum reorder quantity. Sage 50 will auto-create purchase orders from Work Tickets for inventory items that fall into the following item classes only

  • stock
  • substock
  • serialized stock.

If you would like to learn more about how to perform this smart function using Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class. For Sage 50 support and training, call us today at 800-475-1047 or email us at Sage 50 Training Class. 

Sage Timeslips Support

Update Work Tickets in Sage 50 and Sage 50cloud

How do you update work tickets in Sage 50? What are work tickets in Sage 50 used for?

From time to time, you will need to update work tickets with your progress. Follow the steps below to update a work ticket.

  1. From the Tasks menu, select Work Tickets. The Work Tickets window appears.
  2. Click the Open button and select the ticket that you want to update and click OK. The selected work ticket information appears in the Work Ticket window.
  3. Update any of the information that has changed on the work ticket.
  4. If you have finished or received items in the component list, select the corresponding Finishedcheck box and enter the Act Hours, if you are tracking hours.
  5. Then, click Save. After you have marked one item in your component list as finished, your work ticket is given a status of In Progress.

If you would like to learn more about how to update work tickets in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class. For Sage 50 support and training, call us today at 800-475-1047 or email us at

Print a crystal report in sage 50, sage 50 crystal report, crystal report sage 50, sage 50 intelligence reporting

Print a Crystal Report in Sage 50

Print a Crystal Report in Sage 50

How to use SAP Crystal Reports with Sage 50

How to print a Crystal Report in Sage 50 – For older versions of Sage 50 to print a Crystal Report in Sage 50, you must preview the report and print using a Crystal Reports license. If you currently have a license for Crystal Reports and Sage 50 then follow these simple steps to print a Crystal Report in Sage 50:

  1. In Sage 50, select ReportsCrystal Reports from the main menu.
  2. Highlight Vendor Detail List and click the Preview button or double-click Vendor Detail List.
  3. Click OK to continue. The report opens in Crystal Reports.
  4. Select Report, Refresh Report Data to ensure that the report is displaying the most recent information.
  5. Ensure that Use current parameter values is selected and click OK. The report refreshes.
  6. Select File, Print, Printer.
  7. A message appears, asking if you would like to use the default printer. Select Yes. Then, click OK to print the report. One page of the report is shown on the next page

Crystal Reports

Yes, Crystal Reports is one way to extract data from Sage 50 and we can train you on the process. You would not need to have the product prior to the  training. However, we have found that on-line training without the ability to immediately practice what has been demonstrated has a lower retention rate. You will also need to gain experience by practicing. The final element is to be able to find the appropriate data tables and fields to retrieve the data for use within those reports.

Please note, that although Crystal Reports can still be used with Sage 50, Sage has not included Crystal Reports as part of the Sage 50 product since 2014. A license has to be purchased separately. It is generally not recommended as the external report writer of choice unless reports were created prior it’s being removed from the product. It is most often required when these reports are still needed or new reports are required that cannot be created using the currently support Sage Intelligence external report writer.

Sage 50 Advanced Reports Options

  • Crystal Reports
  • Financial Designer
  • Sage Intelligence

Choose printing preference

The first step is to confirm the types of reports that you are expected to produce. This will confirm that Crystal Reports in the most appropriate choice for those reports. Other reporting options include

  • The built in report designer
  • Financial statement designer
  • Built in forms designer
  • Sage Intelligence

Print a Crystal Report in Sage 50

If Crystal is the most appropriate choice for an external report writer, I would be glad to set up an online training session for you. It is always helpful to know the reports you wish to produce, so I can choose one as example during training to give you experience in determining the tables and fields to create a specific report.

Learn More

Give us a call 800.475.1047

Print a crystal report in sage 50, sage 50 crystal report, crystal report sage 50, sage 50 intelligence reporting


Sage 50 data tables for use with Crystal Reports

Journal Header Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.


JRNLHDR.DAT has one record for each transaction entered in Sage 50. There is a one-to-many relationship between header records and row records. Each header record can have any number of related rows.

Note: Memorized Transactions are stored in StoredTransHeaders.DAT. All the field names are the same as in JrnlHdr.DAT.

Indexes and Their Uses

JRNLHDR.DAT has 22 keys, as follows:

0 = By JournalKey (Shadow, Journal, Period, TrxNumber, Partner.

1 = By PostOrder

2 = By Posted and then by PostOrder

3 = By LedgerKey (Module, CustVendEmpID, Date, and then by PostOrder

4 = By Reference

5 = By Date

6 = By Journal, then by Date, then by Reference, then by LedgerKey.RecordNumber, and then by PostOrder..

7 = By JournalKey_Journal, then by JrnlKey_Per, and then by Reference.

8 = ByGUID

9 = By Journal, then by Reference.

10 = By Journal, then by Completed Date

11 = By ReceiptNumber

12 = By Journal, then by MainAccount, then by Deposit Ticket, and then by Date

13 = By Journal, then by Extended JournalType, then by Date, then by Reference, then by CustVendEmpID, and then by PostOrder

14 = By Journal, then by Date, and then by PostOrder

15 = JrnlHdrByJrnlCVEReference

16 = JrnlHdrByElectronicDateSent

17 = By Recur Number, By Date

18 = By JournalEx, then by Date, then by Reference, then by LedgerKey.RecordNumber, and then by PostOrder

19 = RecurNumber

20 = JrnlHdrByElectronicDateSent

21 = By JournalKey_Journal, then by CustVendId, and finally by Date

22 = ByLedgertKeyModule, then by CustVendEmpID and then by Date

If you would like to learn more about how to print a Crystal Report in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing / Sage 50cloud Manufacturing training class, as well as a Crystal Reports for Sage 50 class. For Sage 50 support and training. Sage Timeslips Training

email us at

Previewing Crystal Reports in Sage 50

Previewing Crystal Reports in Sage 50

Previewing Crystal Reports in Sage 50 is easy!

Crystal Reports can be previewed from Sage 50 when the report is displayed in the Crystal Reports Viewer. The viewer automatically refreshes a report when opened, but refreshing the report ensures that the most recent data appears on the report preview. Follow these steps to see how easy previewing a Crystal Report in Sage 50 using the Crystal Reports Viewer is!

  • In Sage 50, select Reports, Crystal Reports from the main menu. The Select a Report window opens.
  • In the Report List, highlight Vendor Balance Graph v9and click the Preview button or double-click Vendor Balance Graph v9. Crystal Reports for Sage 50 starts.
  • Refresh Report Data to ensure that the report is displaying the most recent information by selecting the Refresh Icon (lightning bolt).
  • Once you have finished previewing the report, select Closeto close the Crystal Reports Viewer window and return to Sage 50.
  • Click Close to return to the Sage 50 desktop.

Learn More about crystal Reports

If you would like to learn more about previewing Crystal Reports in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class, as well as a Crystal Reports for Sage 50 class. For Sage 50 support and training, call us today at 800-475-1047 or email us at