Posts

Sage 100 Tips and Tricks: How to enable and setup ACH in Sage 100

Image
     LLBPartners.net info@llbgroup.com 215-654-0800 How to enable and setup ACH in Sage 100 Enable ACH in AP Options Click the ACH tab, and select the Enable ACH Electronic Payments check box. For more information, see Accounts Payable Options - Fields. Use the remaining fields to define options for electronic payments. Make sure the necessary users have access to the payments folder you choose. Click Accept. Set Up Your Bank for ACH Payments   Obtain your banks' requirements for how ACH files must be structured. Many banks accept the default selections in ACH Interface Maintenance, but some require you to manually modify the settings. Select Accounts Payable Setup Menu > ACH Interface Maintenance. Select the bank code to set up. On the Main tab, enter the information about your bank account. Select the Pre-Note Approved check box only after the bank has approved your pre-note submission. Click the Records and Additional tabs to select options that determine how the ACH file is

Sage 100 ERP Tips and Tricks: Set up and transfer balances to a CC Vendor

Image
    LLBPartners.net info@llbgroup.com 215-654-0800 Set up and transfer balances to a CC Vendor Cut down on data entry by using the built in ‘Transfer Balances’ feature to making paying with a credit card a simple part of your accounts payable workflow. Set up and transfer balances to a CC Vendor Open Accounts Payable, Main, Vendor Maintenance Enter the vendor number used to pay the credit card company or add the vendor if it does not already exist. On the Main tab, check the box for Credit Card Vendor and accept. Create the invoices that were paid by credit card on the vendor account by processing an Accounts Payable, Invoice Data Entry or Purchase Order, Receipt of Goods with an invoice number or Receipt of Invoice. Open Accounts Payable, Main, Invoice Data Entry, select the Credit Card Vendor account and enter an invoice number  (ie. Jan 2016) to create for payment on that account and enter the total amount to transfer. On the Lines tab, click the Transfer Information button to open

Enhancement: Automatically Create Cash Receipt for Sales Order Deposit

Image
  LLBPartners.net info@llbgroup.com 215-654-0800 Enhancement: Automatically Create Cash Receipt for Sales Order Deposit Sage 100 out-of-the-box requires a cash receipt to be manually entered when a deposit is recorded in a Sales Order. This customization automates this process, creating a new deposit in cash receipts for a GL distribution against the customer deposit account listed in S/O Options. When a deposit amount is entered, the user is prompted asking if a cash receipt should be created.    If they click yes, a deposit is created in the batch SODEP (if enabled). Each sales order deposit goes into its own AR Cash Receipt Batch. The batch information is brought back to the sales order. If the sales order has a deposit number associated with it already then, the user will not be prompted to create a cash receipt if the deposit information on the sales order is changed. Note: Any changes to the sales order deposit will need to be manually changed to the cash receipt deposit. For e

Visual Cut by Millet Software: Streamlining Operations, Boosting Productivity, and Gathering Insights for Sage 100 Cloud Users

Image
LLBPartners.net info@llbgroup.com 215-654-0800 In today's fast-paced corporate climate, staying ahead of the competition requires effective operations, increased efficiency, and precise business analytics. That's where Visual Cut by Millet Software comes in as a game-changer for businesses using Sage 100 Cloud as their ERP solution. This robust reporting and document management solution offers a range of features that can significantly improve Productivity, efficiency, and well-informed decision-making within your company. How Visual Cut Enables Businesses Utilizing Sage 100 Cloud: 1. Streamlined Reporting: Visual Cut streamlines and automates the reporting process, saving your team time and effort. I t offers a user-friendly interface for creating, customizing, and scheduling reports, ensuring timely and accurate information for important stakeholders. With Visual Cut, you can easily develop and publish comprehensive financial reports, sales analytics, inventory summaries,

Sage 100: Sage Cloud Portal Tips and Tricks

Image
LLBPartners.net info@llbgroup.com 215-654-0800 To access the Sage 100 Cloud Portal, use the following address: https://sage100na.sagepartnercloud.com There you will be promoted to enter the username and password you used to sign up for the Sage Cloud. Once logged in you will have access to standard published apps, as well as any custom apps for your system. ·          Sage 100 – Launches just Sage 100. ·          Data Drive – A windows explorer giving you access to the Sage 100 folders. ·          Virtual Machine Access – Launches a complete remote desktop, giving you access to Sage 100, data drives, and any other programs installed on your cloud. If you are using Microsoft Edge to access the portal you will have the option to chose Windows Mode, or Browser mode for your apps. If you use other browsers such as Chrome or Firefox then Browser mode will be the only available option. ·          Browser Mode - any app you launch will be opened inside a webpage. ·          Windows Mode

Sage 100: Custom Shipment Tracking Button

Image
LLBPartners.net info@llbgroup.com 215-654-0800 As you may have recently noticed the standard tracking button in Sage 100 is no longer working. It was recently announced that UPS discontinued the iShip service at the end of 2022. LLB has created a replacement button so users can still easily get updated tracking information on shipments. With this custom button you have the option to chose which website you are tracking your packages through, such as: UPS FedEx Google Parcelsapp.com Contact LLB today for more info! LLBPartners.net info@llbgroup.com 215-654-0800

Sage 100 ERP Customization: Send Custom Emails To Vendors or Customers with the Click of a Button

Image
LLBPartners.net info@llbgroup.com 215-654-0800 Communication between your company and your Customers/Vendors is constant. Often times you are asking the same questions or relaying the same information over and over again.  What is the status of this purchase order?  When can we expect payment?  Here are the tracking numbers for your shipment. Searching your system for this information, compiling it, then composing an email takes time away from more productive work! With a simple button added to a Sage 100 screen you can automate the compiling and composing of these emails and let Sage send the email for you!  It should be noted that emails like this could be set on an automated schedule as well, rather than the click of a button. To demonstrate lets take the following scenario: You want to be able to quickly and easily ask your vendor for an update on open purchase orders you have with them. A button added to the Vendor screen allows you to trigger an email to be sent to the vendor, au