Edit Data and Microsoft Excel & Quickly Export back into Business Central

Many businesses already rely on Microsoft Excel to view and analyze their sales data. With Business Central’s integration with Excel you can use the two programs to their fullest potential. Quickly edit data depositories from Business Central in Excel! View/edit reports in Excel before printing or sharing!

With Business Central’s integration to Microsoft Excel you can:

• Export sales data, customer info and more to Excel
• View custom layouts from your Business Central database in Excel
• Edit information in excel and quickly publish those changes back to Business Central
• Export data with one click – Quickly view, manipulate, print or share any data from your Business Central database
• And much more!

Once you’re done making changes to your data you can save it as an excel workbook or as a CSV file. You can also publish your changes back to Business Central. Those changes will be quickly reflected with one refresh of Business Central. This powerful integration allows you to get even more out of Business Central while programs you’re familiar with!

Contact sales@syssolutionsllc.com to learn more about Microsoft Dynamics 365 Business Central.

Manage your finances in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central has built in financials allowing you to manage your entire business in one easy to use software. Preferences, reports, and views can be customized to fit your requirements. Using the Account Role Center allows you to quickly switch roles to view key financial figures in real time. You can grant permission to access this data to whoever needs it, including external accountants. Without that permission your financial data is kept safe and hidden.

Manage the following anywhere on any device with Business Central:
• Accounts Payable and Receivable
• Invoices and Purchase Orders
• Bank Account Reconciliation
• Inventory and Business Costs
• General Ledger
• Recurring Revenue
• Expenses and Revenue Deferrals
• Cash Flow and Cash Flow Forecasts
• And More!

Keeping your finances, point of sale and CRM all in one program saves you time and money. Business Central’s tight integration with Microsoft Outlook, Excel and Power BI allows you to streamline your financial processes even more. View your payment history with a vendor right from your inbox or view/edit open invoices for your customers.

Built in financials is one of many features that gives Business Central an edge over all other retail management softwares. Improve your business processes today by contacting sales@syssolutionsllc.com to learn more about Business Central and all the features you could be taking advantage of.

Mobile Inventory Scanning App for Microsoft Dynamics 365 Business Central

Are you looking for a quick and easy way to track your store’s inventory? Do you have multiple stores or warehouses with inventory? Looking for an inventory solution that allows multiple users to scan simultaneously?


The Mobile Inventory Scanning App allows your staff to quickly take a physical count of items on a handheld scanning device. Barcodes can be scanned, or item numbers can be entered. Mobile item counts populate to the Item Journal across all devices.

With System Solution’s Mobile Inventory Scanning App you can:


• Scan barcodes or enter item numbers
• Have multiple users scanning at the same time
• Manage multiple stores or warehouses
• Post inventory results across all devices
• View all adjustments on the ledger entry page
• And more!

If you’re ready to quickly inventory your items, you can download the app here. Questions? Contact sales@sysolutionsllc.com or call (888) 816-8002.

Get work done without leaving your inbox with Microsoft Dynamics 365 Business Central

Save time and get more work done Business Central’s integration with Outlook. Provide sales quotes for customers, add new contacts and even more without ever leaving your inbox. You already spend a lot of time in your email, use that time wisely and get more done. With Outlook and Business Central accomplish the following without switching screens!

  • Add new contacts to your Business Central CRM
  • Create, update and send quotes and invoices
  • Business Central intelligently suggests items based off the contents of the email when creating quotes and invoices
  • Open up customer and company information to view order history and current opportunities
  • Create, manage and adjust purchase orders
  • Access financial data and statistics for customers and vendors
  • View complete customer profile for any contact
  • Search for and edit documents
  • And much more!

Ready to increase productivity and streamline your business processes? Contact sales@syssolutionsllc.com to learn more about the incredible integration between Outlook and Business Central.

Selling and Tracking Items with a Serial Number in Microsoft Dynamics 365 Business Central

Many businesses need to track serial numbers of items they sell. Microsoft Dynamics 365 Business Central allows businesses to manage those serial numbers before, during and after a sale.

With Business Central, serial numbers can quickly be added during a sale. You can enter or scan in the serial number associated to the item. When an item is set up to log a serial number it cannot be sold without entering or scanning a serial number. Serial numbers can be logged at time of purchase, sale, transfer assembly and more.

Similar capabilities exist for recording lot numbers. Track specific lot numbers on outbound units or record the lot number once purchased. Both lot numbers and serial numbers can be required for positive or negative journal entry adjustments for that item.

Business Central can also manage warranty and expiration dates for items. Once set up you can restrict the sale of expired items or require warranty data to be entered when processing a sale. You can set a warranty formula for your items that will automatically calculate the warranty terms once sold.

After a completed sale the serial number or lot number can easily be searched in Business Central. Quickly search by item, lot number or serial number to pull up that unit. Your report will show you the sales order, customer and item associated with that search.

Contact sales@syssolutionsllc.com to learn more about how Microsoft Dynamics 365 Business Central can streamline your business processes.

Managing Multiple Units of Measure in Microsoft Dynamics 365 Business Central

With Microsoft Dynamics Business Central you can set up different units of measure for any item. Receive chain by the pallet and sell it by the foot or the roll. Effectively sell different lengths of lumber using Units of Measure. Below you can see an example of a pine board with different units of measure set up for the lengths it is sold at.

You can easily set up an item with multiple variations with its own barcode to quickly sell and track that variant with just a scan. Add a specific unit of measure to that barcode to quickly sell the right unit of measure; one piece, a box, a case etc. Buy and sell in unlimited Units of Measure with Dynamics 365 Business Central.

If you’re interested in streamlining your business processes with Microsoft Dynamics 365 Business Central contact sales@syssolutionsllc.com to learn more.

Recurring Reports with Microsoft Dynamics 365 Business Central

Dynamics 365 Business Central has a powerful feature to automatically run reports on a regular basis. You can run a sales report every day at 8:00 PM or an inventory report every Friday afternoon. This recurring report feature can be set up with any report you run; Sales Reports, Job Queue Entries, Item Reports, Salesperson-Sales Reports and more!

Automating your reports saves you time and allows you to focus on growing your business. Combine the recurring reports feature with Business Central’s adaptability and you will receive exactly which reports you need to see, when you need to see it. The possibilities are endless! Contact sales@syssolutionsllc.com or call (888) 816-8002 to learn more about Microsoft Business Central.

Combine Microsoft Dynamics 365 Business Central with LS Express for a Powerful Point of Sale Solution

Combining the power Microsoft Dynamics 365 Business Central and LS Express allows your business to have a powerful, custom and efficient POS process. Make your system seamlessly fit your business; From custom receipts to POS screens everything can be modified to fit your needs.

With LS Express and Microsoft Dynamics 365 Business Central you can:

• Access your POS screen anywhere on any device: PC, Apple, Android or iPhone! Access product information or perform transactions from your sales floor, trade shows, garden shows or anywhere your customers are.
• Unlimited number of stores, warehouses, POS, and currencies.
• Modify screen layout to hide or add fields to increase efficiency and ease of use.
• Customize receipts using Microsoft Word including pick tickets, kitchen printing and more.
• Provide customer service with quick access to sales history, easy returns, product replacement or issue store credit as needed.
• Track returns with the returned item log.
• Block customers when credit limit is exceeded until manager approval
• Easily edit reports or create custom reports for your business.
• Sell and track serial numbers.
• Set unlimited sales prices and discounts for unlimited items with unlimited customers and groups of customers.
• View sales numbers in item lists.
• Set items with unlimited units of measures, special prices and barcodes for each unit.
• Sell item variants with user created attributes: year, make, colors, sizes, type, etc.
• Enter items through search, scanning barcodes or entering item numbers.
• Out of stock warnings.
• Prevent negative inventory.
• Pay on House Account and Pay to House Account.
• Sell and redeem Gift Cards.
• Sell price or weight embedded barcode items from scale labels.
• Quickly find and sell items without barcodes with unlimited search and filter combinations.
• And so much more…

If you’re ready to save time and money by optimizing your POS process contact System Solutions at (888) 816-8002 or sales@syssolutionsllc.com. You can learn more about LS Express on their website.

Microsoft Dynamics 365 Business Central – The Next Generation of Retail Management Software

Microsoft Dynamics 365 Business Central is a complete business management solution that automates and streamlines business processes and helps you manage your business. Highly adaptable and rich with features, Business Central enables companies to manage their entire business with one solution, including Point of Sale, Financials, Inventory, E-Commerce, and much more. You can easily add or customize functionality through extensions, allowing you have the perfect solutions for your business. Business Central also integrates seamlessly with other Microsoft products. Send invoices through outlook or create a sales forecast using Microsoft’s Power BI all without leaving Business Central.

Business Central is fast to implement, easy to configure, and simplicity guides innovations in product design, development, implementation, and usability. You can learn more about Dynamics 365 Business Central here. Contact System Solutions at sales@syssolutionsllc.com or call (888) 781-8002 to find out how Business Central can improve your business.

Tight integration between Microsoft Dynamics 365 Business Central and Shopify.

Easily setup an e-commerce online store for your business while managing your brick and mortar store, all with one system. Microsoft Dynamics 365 Business Central’s integration with Shopify allows you to efficiently manage your online store, items, customers, orders, customer pickup, shipments and deliveries. Then optionally extend your selling electronically to Amazon, eBay, Houzz, Wayfair and many more.

Shopify is the largest e-commerce provider, is easily customizable and is simple to use. Chances are you have been making many of your own purchases from Shopify e-commerce stores all over the world. Synchronization with Microsoft Dynamics 365 Business Central is bi-directional. Add thousands of 365 Business Central items to your Shopify store electronically and electronically download Shopify orders into 365 Business Central for fulfillment.

Integrating Business Central with Shopify will allow you to manage your online sales, delivery or customer pickup from the same system where you manage the rest of your retail or wholesale business. To view a sample store, click here! Contact System Solutions today to learn how to get started using Microsoft Dynamics 365 Business Central and Shopify.

If you would like to learn more about Microsoft Dynamics 365 Business Central, please email us or call 860-781-7136.