Author: David Kwo

The fundamental ability to organize and keep track of supplier payments is a crucial characteristic of a successful company, and one that QAD makes accessible with its array of tools and flexibility that accommodate a wide range of complex needs. QAD offers two main tools to leverage for supplier payments: Supplier Payment Create (used for manual AP payments) and Supplier Payment Selection Create (used for electronic AP payments). Within both...

In any business, there is a need for a system to open and settle customer accounts. However, the makeup and size of company may necessitate different systems with varying levels of complexity. QAD’s Enterprise Edition Accounts Receivable module provides a couple of programs that allow users to apply customer payments with varying levels of complexity. This blog will walk through these tools and explain their distinct capabilities. Customer Payment Create...

Daybooks in QAD, commonly known in accounting as journals, are categorical distinctions that group general ledger transactions based on a mutual characteristic. They relate to specific menu programs that created the financial transactions, and are therefore helpful when it comes to viewing and analyzing specific types of transactions within the GL. Daybook codes must be included in all transactions written in QAD. Though they may vary based on a company’s...

QAD’s Excelerator allows users to easily and efficiently load data from Excel into QAD. It can be particularly helpful when data needs to be transferred between QAD applications. However, in order to leverage these benefits, users must be able to load Excelerator sets, or templates, into Excel. This blog will walk step-by-step through that process. Step 1: Selecting Template a. Go to Inbound menu b. Enter username and password c....

When handling intercompany orders and transactions, QAD’s Evaluated Receipt Settlement, or ERS, offers an efficient automated process for comparing receipts with purchase orders. ERS creates a low-risk system for ensuring accurate intercompany transactions while bypassing the wasted effort of matching receipts, invoices, and purchase orders. The specific benefits of QAD’s ERS include: Does not require any development Runs automatically, reducing risk of user error and increasing accuracy Supports fiscal receiving...

QAD’s Configurator allows users to configure a custom product in any way they desire while ensuring it is a valid and feasible combination. Configurator is a great solution to the ever-rising demand of customizable and complex products and reduces the risk of lapses in communication between Salespeople and Engineers that may lead to sales your company cannot fulfill. This tool allows users to create a set of defined rules and...

QAD’s Global Tax Management (GTM) tool makes it simpler for companies of any size or complexity to accurately calculate taxes. Users can designate taxes assigned to suppliers, customers, and items; tax zones based on ship-to and ship-from locations; choose when to calculate taxes; and many more accommodating variables. With the capability to accommodate any number of tax rates or legal reporting requirements for multiple countries within a singular database, GTM...

In this fast-paced, largely computerized world, breaches of cybersecurity can have serious impacts on businesses. Automating intercompany material transfers and transactions both increases efficiency and reduces manual errors. The benefits of such automation include: Increased efficiency due to automation of processes Reduced user errors Immediate data synchronization between business units Elimination of double entries Real-time updates of order status The advantages of automation are easy to realize when using QAD’s...

In this fast-paced, largely computerized world, breaches of cybersecurity can have serious impacts on businesses. As a result, the segregation of duties has become increasingly crucial aspect of cybersecurity. Segregation of Duties (SOD) creates a system of checks and balances that protects businesses from fraud and manual errors. Making multiple individuals responsible for different aspects of a transaction makes it more difficult to commit and conceal fraud, and has the...

The process of building a financial report using FRW can be broken down into two main steps: Cubing data Creating reports This blog will focus on the second step, generating reports. If you want to learn how to create cube data using FRW, read our other post on this topic here.   Creating Reports Once you have created your cubes, you are primed to create any and all reports using...