Recent Updates

  • Updated on: Mar 16, 2022

    Process a Sales Return (Credit Memo)

    There are two types of Credit Memos in AcctVantage - Associated or Unassociated (with an original Sales Order.)

    Associated Credit Memos:

    • Are linked to the original Sales Order.
    • Contain a reference to the original Invoice Number.
    • Returns can be processed only for line items that were entered on the Original Order.
    • Inventory items will be automatically returned to the Lots they were drawn from.
    • The cost used will be the same as the original Lot cost.

    Unassociated Credit Memos:

    • Are NOT linked to any Sales Order.
    • Returns can be processed for any items.
    • A new Lot is created for returned Inventory items.
    • The cost that will be used for the new Lot is dependent on a setting in Administration ➤ System Configuration. Under the Sales Document heading there is a setting for Unassociated Credit Memo Cost.
      • There are 3 options to choose from:
      • Current Average Cost: the system will use the Current Average Cost for the new Lot only if the cost is > $0.00 in the return Warehouse.
        • If the cost equals $0.00 in the return Warehouse, then the system will use the Default PO Cost instead of the Current Average Cost. The reason for this is so you don't end up with Inventory items carried at $0.00 value.
      • Default PO Cost: the system will always use the Default PO Cost for the new Lot, regardless of how many units are on-hand or what the average cost is.
      • Use Script: - this option would necessitate a special project. The logic as to 'what cost to use and when to use it?' would be determined by the specifications of the project.

    Other notes:

    • The line items on a Credit Memo are treated as a reverse of Sales Orders. Saving the Credit Memo in Picked status creates inventory transactions and results in the units being available for resale. These units will appear on the Product record as Qty In Non-Posted until the Credit Memo is Posted.
    • By default the units will be automatically returned to the Warehouse they were drawn from. However, there is an option to change the Warehouse on each line item of a Credit Memo. To return a line item to a different Warehouse, make this column visible (in System Configuration under the Line Item Detail tab) and then enter a different Warehouse in this column. (See Step 3 of this article.)
  • Updated on: Mar 08, 2022

    Print a Client Refund Check

    Introduced in: AV 2015.1.0.5

    You can now print a refund check for your Client AR Credits! This applies to credit memos, client deposits, etc...any type of AR credit.

  • Updated on: Feb 28, 2022

    Modify an A/P Document Date

  • Updated on: Feb 28, 2022

    Modify an A/R Document Date

  • Updated on: Feb 14, 2022

    Fill a Back Order

    If you issued and posted a Sales Order with a Backordered Qty of an Inventory Product, then you've come to the right place. This article will detail how to fulfill those backordered items. You can't fill the original Sales Order because that has been posted, but you're in luck. This is why we have the Backorder feature!

    Note: If you want to generate multiple Invoices from the same Sales Order, then the Order must be posted. This process only works with posted Orders.

  • Updated on: Feb 08, 2022

    EasyPost - Return Labels

  • ***Our recommendation is that Data Maintenance should be performed on (at least) a monthly basis for optimal performance of your system.***

    ***DO NOT RUN ANY OF THE OTHER UTILITIES IN THE MAINTENANCE & SECURITY CENTER UNLESS EXPLICITLY DIRECTED TO DO SO BY ACCTVANTAGE SUPPORT.***

    The Data Maintenance process was greatly simplified in AcctVantage 2012 (and beyond) from previous versions and is now completed with a simple click of a button. Follow the steps below to complete this process.

  • Did you receive a bill for freight from a Vendor other than who you made the Purchase from? If so, you will need to account for these Landed Costs to this 3rd party.

  • AcctVantage supports the ability to export financial reports to an XML file that is readable by Microsoft Excel®.

    You can design financial reports using what are called tokens in place of GL account codes, account names, actual or budgeted dollar amounts and reporting periods. When the report is generated, AcctVantage replaces these tokens with the requested data and exports an XML file. You can include formatting, formulas, logos, etc. in the template as in any Excel® spreadsheet. At this time, only single worksheet XML files can be processed. In a multiple page workbook, pages after the first page will be ignored.

    We will detail the token definitions below. When designing your financial report, you will use a token in place of the indicated value. If the token represents a range of GL accounts, AcctVantage will automatically expand it to include a row for each account within the range. Any formulas will be adjusted as necessary to accommodate the rows added for a range of accounts.