Sage 100

 View Only
Back to discussions
Expand all | Collapse all

How to remove zero qty cost tiers with values

  • 1.  How to remove zero qty cost tiers with values

    Posted 07-16-2019 14:27
    Customer has zero qty cost tiers with values, e.g. zero on hand but a negative .01 value. I know you're supposed to do an adjustment in and then an adjustment to remove the .01 but the issue is, the quantity is actually -.003 even though they only use two decimals for quantities. I cannot get rid of them!! What am I missing??

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


  • 2.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 14:41
    Temporarily increase the decimal precision for quantities?

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 3.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 14:49
    Agree with @Eric Lunceford.  Increase the decimal places, make the entries, reduce decimal places.  ​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------

    Original Message


  • 4.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 15:05
    What a pain! Do you think they at one time used more decimals or is it simply a rounding issue??

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

    Original Message


  • 5.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 15:10

    Not sure how they would have get the values in the system with the decimals set at 2.  Maybe a user forced a quantity based on cost/price and the system rounded it.

     

    Michelle Taylor, MBA | ERP Consulting Manager | CS3 Technology

    Creating Order from Chaos with Software, Strategy and Skills

    direct dial 918.388.9772 | toll free 877.496.1600 

     



    ------Original Message------

    What a pain! Do you think they at one time used more decimals or is it simply a rounding issue??

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


  • 6.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 15:26
    I've seen BIlls and WOs do that before...

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 7.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 15:45
    Yes, I know about BM and WO causing it but they have neither module.

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

    Original Message


  • 8.  RE: How to remove zero qty cost tiers with values

    Posted 07-17-2019 08:52
    Therese,
    This happens a lot in Sage with miniscule rounding errors.  If you run the *utl Balancing utility, see if those show up (do in a test company) as items that the utility will correct.  If not, then what I do is process an adjustment transaction a quantity of 1 at zero cost into inventory to the cost tier, post it, then process an adjustment transaction out and the cost will relieve.

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

    Original Message


  • 9.  RE: How to remove zero qty cost tiers with values

    Posted 07-17-2019 13:22
    *utl doesn't do the trick and I cannot do a correcting adjustment as it says it has .003 on hand but I can only add one and adjust out one, still leaving .003 on hand. I changed the quantity decimal to three and voila - they actually have four!! Changed it to four and now I can just adjust in or out the fractional quantity.

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

    Original Message


  • 10.  RE: How to remove zero qty cost tiers with values

    Posted 07-17-2019 13:25
    What @Jane Scanlan said. Also, since you know which records are off, as another option, you can import into IM_ItemCost to zero out these particular values to fix it that way. This is possible because you are editing existing records (not adding new ones) which that business object allows. You would need to do a quick read up on any past post on how to remove the ReadOnly attribute in the dictionary (where you ultimately DFDM Providex.dde) so you can import into numeric fields like ExtendedCost, UnitCost, etc.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


  • 11.  RE: How to remove zero qty cost tiers with values

    Posted 07-16-2019 15:14
    I look back for the original transaction with the extra decimal place.  If you can't find one, perhaps try *utl?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



Related Content