Sage 100

 View Only

  • 1.  Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-14-2021 13:38
    Is there any way, through scripting, to stop this annoying message from popping up in SO Entry?  My customer only uses Miscellaneous items to bill on the customer invoices - without a cost - and this message is a PITA. I already cast my vote in Sage City, but there are only 29 of us who voted for that one.

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    ------------------------------


  • 2.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-14-2021 14:37
    Sounds more like MD surgery...

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    ------------------------------



  • 3.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-14-2021 20:04
    Post the link to the voting page.  Maybe we can stuff the ballot box and get it up to 40.....

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-14-2021 22:00
    I totally agree!!!

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 5.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-14-2021 22:48
    Edited by Dan Burleson 05-15-2021 01:35
    Two simple Business scripts could be used that would trigger when the cost of an entered Miscellaneous item was found to be zero, then change it to something uniquely non-zero (like -0.001 that avoids the message) and raise a flag (using SetStorageVar). Then when the line is about to be written (PreWrite event) another script checks the flag and if it is up then the value is changed back to zero and lowers the flag.

    These will work for all versions 4.40 to 2021:

    Event: SO Detail Column Post Validate on QuantityOrdered or ItemCode
    Name: "CNX_SZC_SODtl_Bus_CPV_QtyOrd.vbs"
    Const MISC_ITEM = "5"
Const TEMP_NOT_ZERO = -0.001 ' Sufficient to bypass as not zero

sItemType = "": retVal = oBusObj.GetValue("ItemType$", sItemType)
nUnitCost = 0 : retVal = oBusObj.GetValue("UnitCost", nUnitCost)

If nUnitCost = 0 And sItemType = MISC_ITEM Then

	retVal = oBusObj.SetValue("UnitCost", TEMP_NOT_ZERO)
	retVal = oScript.SetStorageVar("RESET_TO_ZERO", True)
	
Else

	retVal = oScript.SetStorageVar("RESET_TO_ZERO", False)
	
End If


    Event: SO Detail Pre-Write
    Name: "CNX_SZC_SODtl_Bus_PrW.vbs"

    bReset_To_Zero = False : retVal = oScript.GetStorageVar("RESET_TO_ZERO", bReset_To_Zero)

if CBool(bReset_To_Zero) = True then

	retVal = oBusObj.SetValue("UnitCost", 0) ' back to zero
	retVal = oScript.SetStorageVar("RESET_TO_ZERO", False)  'Lower the flag

End If




    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 6.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-15-2021 11:07
      |   view attached
    @Jane Scanlan  In Miscellaneous Item Maintenance: Main tab - Set the Standard Unit Cost to $.01.  On the Accounts tab - Cost of Goods Sold Account field - Enter the Purchases GL account number. On the Accounts tab - Inventory Account field - Enter the Purchases GL account number. SO, the same account number will be in the Cost of Goods Sold Account field​ and the Inventory Account field.  No GL entry pertaining to the cost / inventory will be created when the sales journal is updated.


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 7.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-16-2021 11:54
    @Doug Higgs That is what I do with my clients.  Set the /Misc Item Cost to 0.0001, and no more message. ​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 8.  RE: Still annoyed after all these years ... "Warning: The item cost is zero"

    Posted 05-17-2021 08:53
    Thanks @Doug Higgs and @Madeline Stefanou, for your suggestions, but I won't be able to use this trick.  The items being billed are associated with a work ticket, and assigning a unit cost, although it small, won't use the same rules as Sage because of the work ticket class rules in place as items are assigned the parent item's COGS account, which then won't wash with the assigned Inventory account.  

    I will see if Dan's script will work --- thanks @Dan Burleson​​​

    ------------------------------
    Jane Scanlan
    Partner, Next Level Manufacturing Consulting Group
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------

    Original Message


Related Content