Recent Updates

  • <p>One of the most important tasks in data management is report generation. The Quick Report Editor is one of the tools used to design reports. You use the Quick Report Editor to create reports based on a selection of records. These can be ad-hoc reports intended only for one-time use or they can be save to be used perpetually. </p> <p>With Quick Reports you can:</p> <ul><li>Produce a list of records.</li> <li>Create breaks and subtotal lines.</li> <li>Compute calculations such as sums and averages.</li> <li>Apply formatting such as fonts, font styles and borders.</li> <li>Export the report as a file that can be imported into spreadsheet software such as Microsoft Excel®.</li> </ul> <p>The Quick Report Editor will produce a report from a current selection of records. Before you print a Quick Report, set the current selection to the list of records to be included in the report <a href="58445?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="5D13E4AF-3699-46AF-9366-EF608E79EA65" data-object-manual-uuid="34AD2CF0-E3D9-012F-DD99-12313804AAC3" data-resolve-url="true" target="_blank">using one of the query methods described here.</a> The following is an example of a Quick Report.</p>
  • Updated on: Feb 02, 2023

    Cross-references

    <p>Cross-referencing is one of the most powerful tools in AcctVantage. Used throughout AcctVantage, it allows you to quickly search for a list of records in one window based on a selection of records in a related window. Cross-referencing can quickly become an indispensable part of your routine.</p> <p>For example, let’s say you are reviewing a Client record want to see all of the Sales entered for that Client. Simply highlight the Client record, in the Client List View, and then open the Sales Order List View. On the Sales Order screen, use the Cross-reference tool to find records related to the Client screen. The result will be a list of all Sales Orders for that Client! </p> <p>*See below for an illustration of this example. </p> <p>One last thing to note: If you highlight a record in the &quot;From&quot; window, the cross-reference in the &quot;To&quot; window will only display records based on that one selection. However, if nothing is highlighted in the &quot;From&quot; window, the cross-reference in the &quot;To&quot; window will assume everything in the &quot;From&quot; window is the current selection and will display corresponding records based on that.</p>
  • Updated on: Feb 02, 2023

    Power Searches

    <p>If the <a href="58445?resolve=true">Quick Search</a>, <a href="58445?resolve=true">Filter By</a> and <a href="58447?resolve=true">Cross-reference</a> tools aren’t enough to produce the desired records, the <strong>Power Search</strong> is a very powerful searching tool that gives you access to every table and field in the entire database. It also allows you to build (and save!) multi-line searches that can be used over and over again and even shared with other system users.</p> <p>Each of these search tools can be used independently to produce a list of records to work with. Also, you can combine these tools in a single search for a very focused result. </p> <p>In this article we&apos;ll look at creating and saving a Power Search that will display a list of Sales Orders that we Invoiced to our Widget Buyer Client for the last quarter of Fiscal Year 2012.</p>
  • Updated on: Feb 02, 2023

    Write a Check With No Vendor

    <p>Here's how to write a check without having to add the payee to AcctVantage as a Vendor.</p> <p>Please reference the article for basics on <a href="58433?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="E901E398-5EF4-4CF4-9C48-286877782B3E" data-object-manual-uuid="" data-resolve-url="true">How to Enter a Quick Check.</a></p>
  • Updated on: Feb 02, 2023

    Duplicate a Voucher

    <p>Do you have a recurring bill that you need to set up an identical Voucher each month for? If the answer is yes, then we have a streamlined solution for you!</p>
  • <p>Once established, the Minimum and Maximum stock values can be leveraged in the <a href="../../9730/l/58403?data-resolve-url=true&amp;data-manual-id=9730" data-object-class="article" data-object-uuid="CDB83788-11DC-4686-9934-AE440EE302C7" data-object-manual-uuid="359F41B0-6A35-0130-673C-12313804AAC3" data-resolve-url="true" target="_blank">Auto-PO</a> and <a href="58411?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="91D7512E-5C07-4253-BDDF-BB1A786733BB" data-object-manual-uuid="" data-resolve-url="true" target="_blank">MRP</a> systems for inventory planning.</p>
  • Updated on: Feb 02, 2023

    Serial Numbers

    <p><strong>Serial Numbers</strong> are formatted in the Product record and assigned (either manually or automatically) when the Products are entered into Inventory. (i.e. When they are received on a PO or if the Product is an Assembly the Serial Number will be assigned when the item is built via a Work Order.) When a Serialized item is sold, the Serial Number will be selected on the Fulfillment tab of the Sales Order. </p> <p>The Serial Numbers window allows you to track the status of each Serialized Product in your Inventory (Available or Sold). AcctVantage also allows you to see the history of each item -- the date and amount of its purchase, as well as the date and amount of its sale.</p>
  • <p>AcctVantage ERP supports purchasing from your Vendors using any available Unit of Measure. This means you can stock an item by the <em>each</em> while purchasing by the <em>case</em>, or buy a <em>foot</em> and sell a <em>yard</em><em>.</em></p> <p>In order to issue PO's using Alternate Units of Measure, you must first define and then associate these Alternate UM's with the Product you are purchasing. Please refer to the lesson on <a href="58425?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="191DE51E-686F-4DA0-9929-10902E9C6E4C" data-object-manual-uuid="" data-resolve-url="true" target="_blank">How to Setup Alternate Units of Measure.</a></p> <p>If you are selling Products using Alternate UM's, please refer to the lesson on <a href="86116?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="E17A7297-121D-4397-88C2-6D490FF24DF2" data-object-manual-uuid="" data-resolve-url="true" target="_blank">Sales Orders &amp; Alternate Units of Measure.</a></p>
  • Updated on: Feb 02, 2023

    Purchasing History

    <p>The <strong>Purchase Analysis</strong> feature provides a convenient way to analyze your company's purchasing history. This feature gives you access to the line item detail of all <em><strong>Purchase Orders</strong></em> so that you can search and report on any activity by <em><strong>Product</strong></em> or <em><strong>Vendor</strong></em>. </p> <p>Note that AcctVantage’s search engine allows you to quickly find the desired Purchase Events. Available search criteria includes <strong>Vendor Name</strong>, <strong>Part Number</strong>, <strong>Product Name</strong> and many other fields.</p>
  • Updated on: Feb 02, 2023

    Find Open Purchasing - By Purchase Order

    <p>How to find POs that have not yet been received. We will look at finding open POs by Vendor as well as by Product. In this article, we are finding the PO document that may contain several line items. You may also want to review the article, <a href="80684?data-resolve-url=true&amp;data-manual-id=" data-object-class="article" data-object-uuid="6FDCB545-21F4-4D70-9999-216E7E97D598" data-object-manual-uuid="" data-resolve-url="true" target="_blank">Find Open POs - By Line Item.</a></p>