Open Purchase Order - Missing POs without any lines

Open Purchase Order - Missing POs without any lines

If you find in the View included with SmartViews called "Open Purchase Order" that you are not seeing Purchase Orders with no line-level Desired Recv Dates, this can be resolved by replacing the highlighted instance of PURC_ORDER_LINE with PURCHASE_ORDER so that it takes the Desired Recv Date from the header level instead of the line level.


    • Related Articles

    • VELogon - INI settings - delete lines using Policy Profile folder

      See attached for generic instructions for deleting lines from an INI file using the Policy Profile\VMFG folder in a VEScripts/VELogon environment.
    • Copied Order shows original lines in SRI_TaxOrderLine

      An order was copied with lines \ Order Lines removed and Tax recalculated  Here No Tax and no Total which is correct But the SRI_TaxOrderLine table still has records from when the order was copied this will be resolved in the REST update to Synergy ...
    • SSMS Slow to Open

      The default installation of SSMS has a launch sequence of: Open splash window Open SQL Management Studio window Open Object Explorer This third step may be what’s slowing down your start-up. You can change the default to skip the third step. To do ...
    • SmartViews Error - Missing FilterCriteria token, Add: FilterCriteria = @FilterCriteria

      If you encounter the above error in SmartViews, you need to add the Filter Criteria to the WHERE clause of the query. Open up the Designer and navigate to SQL Designer -> SQL. If the query already contains a WHERE clause, append "AND FilterCriteria = ...
    • Usage Type on Customer Order

      Starting with v908.2400, users will be able to set the Usage type on a per Customer Order basis.  This will take precedence over any usage type(s) that may be set on a Customer (or it’s alternate shipping address if one is being used).  In Customer ...