Contact us to schedule a demo or ask a question to learn how AdvantageCS can help you.

The Molly Minute

  • >>

    "Move Order" at MSTDAT

       Starting at 2011R1, a new right-click action is available at MSTDAT/FST, MSTDAT/MST, SVCDAT/MST, and the Master Orders tab at MSTDAT/CTG.  The action allows you to move one or more orders from any closed control group, or any control group you have open, to any other closed control group, or to any other control group that you have open. One effect of this change is that if you are closed out of Advantage while at MSTDAT/FST, you no longer need to go to MSTDAT/CTG to close and reopen your control group.  Instead, go to MSTDAT/FST and press the Current Control Group button, where the list will contain the control group you were just in.  Select this control group and click the Open button, and you will be presented with the option of reopening the control group. …



  • >>

    Scripted Request System

    ACS has developed a Scripted Request System to aid clients in requesting processes and/or jobstreams from scripts which run outside of Advantage.  Capsules have been created to allow users to communicate with the Advantage Monitor from the command line, wait until a process finishes and then return a success or failure code. This is not intended to replace the request screens but rather to give clients a way to interface with an enterprise scheduling system for selected processes or jobstreams. The processes still run under the control of the Advantage Monitor and the monitor notifies the scheduling system when the process or jobstream is complet The interface to the scripted request system is a powershell named advantage_submit.ps1 that is …



  • >>

    ARP 310 and Last Bill Date

    When ARP310 runs, it updates the last billing date (ARPPDH.LST-BIL) and effort# (ARPDH.LST-INVS) of the invoice being billed. The ARP310 select sets can then be based on the current effort number of the customer's invoice and when it was last billed. However, there are times when the ARPPDH.LST-BIL is not set during a billing run, even though the effort number may be incremented. When the ARP310 select set is set up, you have the option of incrementing the effort number and sending a notice to the customer. When you increment the effort number, after the billing run, the ARPPDH.LST-INVS field will reflect this. For an invoice that has never been billed, the effort number would change from blank to 1. For an invoice that has been sent effort # 1, …



  • >>

    Analysis of Select Sets

    Advantage batch processes that use select criteria produce statistics that reflect the number of database records that were a) evaluated and b) selected (or deselected) at each level of the select logic.  The location of the directory that contains the statistics is environmentally defined by SELECTSTATLOC=<directory>.  Statistics reports are written to that directory if the environment variable is defined and the directory exists.  The default location is a subdirectory of the ProcLogs directory called Select_Stats.   This may be changed by the user. The process log file contains a message similar to "Selection analysis statistics in <pathname>", so that you may move from a particular log file to its statistics.  Similarly, the actual statistics …



  • >>

    How to Easily Enter Product Returns

    Typically, Advantage product returns are entered at MSTDAT/FST, using an order type of "C".  There are numerous methods of entering the return, including specifying the invoice number only, specifying the item number only, etc.  The steps for entering the return in these different scenarios vary slightly.  As of 2009R1, users can enter applied returns at SVCDAT/PRO (or MSTDAT/PRO). Locating the order at SVCDAT/PRO Users locate the order at SVCDAT/PRO using normal search methods: Bill-to Customer Order Number Control Group Status (although only posted orders can have returns entered against them) PO Number Ship-to Customer Docket Number Return Steps Once the order is located, the user …



  • >>

    Order Inserts

    You may wish to include promotional/informational material with certain of your inventory items.  For example, if someone buys a book on starting a business, you may wish to insert your catalog on small business products.  You may even wish or need to tie the shipment of the main inventory item to the availability and inclusion of the insertion--and have the main item go on backorder if the insertion is out of stock. The Order Inserts feature allows you to accomplish all of this.  Inclusion of the order inserts, which are created as separate Advantage inventory items, is based on rules that you maintain.  System Option This feature is activated by a system option, INSRTSEL.  This PRO-level option specifies the default (active) insert select …



  • >>

    How to Force a Shipped Order into Backorder

    Although it's a rare occurrence, sometimes when you place an order, there will be a quantity in stock that is no longer there when the order finally posts via PRO205. In these cases, the shipped quantity on the order is set, but since the warehouse does not have enough stock to fulfill it, the PRO205 will not post the order. The PRO205.REPORT will give the error message "Not enough quantity available to fill this order." The steps below illustrate how to force these order lines into backorder. Forcing an order line to backorder Route to MSTDAT/PRO. Search for the order. Use the CS function to change the order status from I to P. Highlight the line in error and use the CQ function to change the shipped qty to 0. Answer …



  • >>

    Using Related Items

    There may be times when you have an item that cannot be purchased separately, but must be included with another item, for instance personalization services, shrink-wrapping, or logos.  Advantage uses the related items feature to handle cases like this, and prohibits the entry of a related item.  It must be added with another item. Set-up of related item Related items are set up at INVDAT like any other item.  However, the related item check box must be checked.  You must also set up a warehouse record for the item.  Depending on the nature of the related item, it can either be stocked in inventory or set up as a non-stocked item. Adding Related Item to Order After adding the primary item to the order, you …



  • >>

    Promotion-Exclusive Items

    With the 2008R1 release (and later), you can set up an item to be valid for only those promotions under which it has been specifically defined as a promotion item at CPNPMO/ITM. When this setting is used, the item cannot be added under a different promotion, even when the promotion is set up to allow additional items.  This would allow you, for example, to protect an item from being sold under the wrong promotion---one intended for another owning organization, for example. Defining the item at INVDAT Order Entry The order entry edit that prohibits addition of promotion-exclusive items to "non-participating" promotions is in place at the following places: Order entry views (e.g., MSTDAT/FST, /CIR) …



  • >>

    Using Search Filters

    Smart Searches allow users to restrict the display of table entries to those of most interest to the user. Using the "Search For" field, you can enter a search string that would limit the display to only those entries that satisfy the string.  Using the "Search For" field There are different ways you can enter your search string, which will then result in different entries appearing: Entry of a string returns matches on the exact string (e.g., ZA will return all matches on that string). Entry of strings separated by spaces returns matches that satisfy all strings (e.g., Z(space) A will return all matches that contain both a Z and an A). Use of double quotes will perform an exact (literal) search on the string (e.g., "Z( …



  • 1
  • 2