Recent Updates
-
Updated on: May 12, 2022
GL Account Reconcile
A useful tool for managing corporate credit card, expense and other accounts that need to be watched closely. Much like the Check Register Reconcile, The GL Reconcile process keeps track of beginning balances, uncleared transactions and reconcile sessions. (New AV 2017)
Manual Accounting / General Ledger -
Updated on: Apr 22, 2022
Pay for Non-inventory PO Items
-
Updated on: Apr 21, 2022
Print an A/P Aging Report
-
Updated on: Apr 21, 2022
Import Wizard - MRP - Forecast
Important: Please execute a database backup prior to starting any import process!
Notes about special fields:
- Part Number: This field is required when creating new records. It can also be used as a key when choosing the Update Existing Records option.
- Product Name: This field is required when creating new records.
- Product Class: This field is required when creating new records. It must match an existing Product Class.
- Once a Product record is created, the Product Class can not be changed.
- Navigate to Administration ➤ Product Classes and click Show All to find the Product Classes that you can use on your import file.
- Default Type Override: This field is not required, however, if you don't designate a Product Type then all of the new records from the import file will be created as Inventory Products.
- Once a Product record is created, the Product Type can not be changed.
- If you want to import specific types of Products, you can do so by using one of these five Product types here:
- Assembly
- Freight
- Inventory
- Kit
- Non-Inventory
- ID: This field is not used for creating new Product records. It can be used as a key when choosing the Update Existing Records option.
-
Updated on: Apr 21, 2022
Inventory Levels for Warehouse Transfers
-
Updated on: Apr 14, 2022
Foreign Currency Setup
*NEW FEATURE for AV 2015*
Acctvantage now supports Foreign Currency (FC) for Purchasing and Accounts Payable. These FC amounts are tracked in parallel to the normal amounts in US Dollars. The General Ledger will always carry the transactions stated in USD. This article details how to define the Foreign Currencies in the system.
----------------------------------------------------------------------------------------------------------------------------------
Here is the basic outline of how to set up and use FC in AcctVantage:
- Install the Foreign Currency View Definition and the check form with FC support.
- Define the FC's that you will be using (i.e. the subject of this article).
- Tag your Vendor records with the applicable FC.
- Issue a Purchase Order (FC info is tracked alongside USD).
- Enter a Voucher for the Vendor's Invoice (FC info is tracked alongside USD).
- Pay the Vendor via Quick Check (FC info is tracked alongside USD).
----------------------------------------------------------------------------------------------------------------------------------
Manual Accounting / General Ledger -
Updated on: Apr 13, 2022
Add Default Expense Accounts for Vendors
This lesson will describe how you can add default expense accounts for Vendors. This is extremely handy if Purchases from a particular Vendor always are charged to the same expense account(s). Once established, the default accounts will be used for new Quick Check and Voucher entries.
-
Updated on: Apr 11, 2022
Promotions / Discounts
There may be times when you want to offer Discounts off of an entire Invoice as opposed to the line-item discounts that the Price Break system offers or the incentive-based discount that AR terms offer. AcctVantage allows you to setup Promotion-style Discounts that can be applied on the Sales Order level.
You can have Promotion/Discount types that are applicable...
- ...at any given time.
- ...only during a specific date range.
- ...only for the first order a Client places.
- ...only for a single use by each Client.
Other Notes:
- Discounts that have no date range and are not one-time use only can be set to apply by default to specific Clients that you wish to give discounts to.
- Discounts are posted as debits to a GL income account (set in System Setup).
- Discounts are taken off the Sales Order subtotal (i.e. before Tax and Freight).
- Once a Promotion/Discount has been used on a Sales Order it can not be modified (with the exception of the Date Range).
Manual Accounts Receivable / Sales -
Updated on: Apr 08, 2022
Credit Hold
The Credit Hold function of AcctVantage allows you to set parameters that will trigger Credit Hold status for Clients. By default, a status of “on Credit Hold” will trigger warnings when opening Client records or opening a Sales Order for a Client. Credit Hold can be enabled or disabled globally or for individual Clients.
By default, AR charges are blocked for Clients who are over their credit limit. This block can be over-ridden only by users specifically given that access in User Access Levels. AR charges are not blocked for Clients who are past due, but still within their credit limit.
Manual Accounts Receivable / Sales -
Updated on: Mar 29, 2022
Pick and Pack (LAN Client)
AV 2017 introduces bar code scanner, web browser and handheld device picking/packing of Sales Orders. Refer to this article for more information!
Pick and Pack Sales Order line items from within a specialized view into the Sales Order record. Now your order fulfillment team can use a barcode scanner to pull up the order in AV from a pick ticket and then scan the items as they are picked for shipment.
Before you begin:
- If you want to use our basic Pick Ticket Custom Form that already includes barcodes: Download the Pick Ticket with Barcodes here.
- If you want to add barcodes to your existing Pick Ticket Custom Form: Download our standard recommended barcode font here.
- You should be able to use any barcode font that can be read by your barcode scanner but the font included above has been tested and confirmed to work by AcctVantage Support.
- This method will require some further customization of your Pick Ticket Custom Form. Please contact AcctVantage Support for more information.
*Scroll to the end of this article for a video demonstration of this feature.
Manual Accounts Receivable / Sales - If you want to use our basic Pick Ticket Custom Form that already includes barcodes: Download the Pick Ticket with Barcodes here.