Sage Accpac Community
Accpac Support Community
Search in

Why unit cost column amount is zero on Order Entry module

Last post Sat, Jan 24 2009 9:09 AM by Jay Converse. 14 replies.
Page 1 of 1 (15 items)
Sort Posts: Previous Next
  • Thu, Jan 22 2009 12:06 PM

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Why unit cost column amount is zero on Order Entry module

     i use gl ap ar oe and ic modules. the cost method is moving average and "allow negative inventory levels" box is checked on IC option.

    when i make sales invoiec or credit/debit note entry on OE module, i find under invoice tag, unit cost column Some times the amount is zero or blank; some times unit cost column shows up amount. Both of them are inventory items. I don't know why.

    (the "allow nefative inventory levels" box is checked, the reason is I receives products and make sales invoices first,  then later make purchase on ap. because issue the sales invoices every day but enter the purchase once a week).

     

  • Thu, Jan 22 2009 12:12 PM In reply to

    Re: Why unit cost column amount is zero on Order

    What costing method do you use?

  • Thu, Jan 22 2009 1:31 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amount is zero on Order

     moving average method

  • Thu, Jan 22 2009 1:39 PM In reply to

    Re: Why unit cost column amount is zero on Order

    Does that item have a total cost?

  • Thu, Jan 22 2009 2:49 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amount is zero on Order

     No there is no total cost column. but there are sales unit price, sales quantities, sales total amount columns

  • Thu, Jan 22 2009 2:57 PM In reply to

    Re: Why unit cost column amount is zero on Order

    Not in O/E, in I/C.  Run the I/C Item Valuation report and see if that item has a total cost.

  • Thu, Jan 22 2009 3:16 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amount is zero on Order

    I run the item valuation on IC and i can see each item has actual cost, most recent cost, total quautity  stocking unit, avg unit valus etc. some items quautity is zero, some are negative 

  • Thu, Jan 22 2009 3:21 PM In reply to

    Re: Why unit cost column amount is zero on Order

    If you have an actual cost and a positive quantity at the time the line item is entered, then an average cost item should have a value in OEORDD.UNITCOST.

  • Thu, Jan 22 2009 6:30 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amount is zero on Order

     So if actual cost and quantity is zero or negative, the OEORDD.UNITCOST should be zero? Does OEORDD.UNITCOST zero effect company cost good of sold acct and inventory? 

  • Thu, Jan 22 2009 6:38 PM In reply to

    Re: Why unit cost column amount is zero on Order

    Of course.  That's why you should never allow negative inventory when you use average costing.

  • Fri, Jan 23 2009 4:05 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amoutive invent is zero on Order

     my company asked accpac consultant to set up accpac program and the cost is very expenses. Acccording your expenses which method is better if i want to allow negative levels on ic modules?

     

  • Fri, Jan 23 2009 5:12 PM In reply to

    Re: Why unit cost column amoutive invent is zero on Order

    Standard cost.

  • Fri, Jan 23 2009 6:30 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amoutive invent is zero on Order

     i read the help for standard cost. it said:

    Standard costs are carefully predetermined target or attainable costs that are useful in building budgets and gauging performance. You might use this method if your item costs do not vary much.

    Now my company inventory item more that 1200 and purchase price change frequently. Do you think standard cost still is a best method?

  • Fri, Jan 23 2009 6:45 PM In reply to

    • Mike
    • Top 10 Contributor
    • Joined on Sun, Sep 28 2008
    • Posts 47

    Re: Why unit cost column amoutive invent is zero on Order

     more information about standard cost method:

    Warning!  If you ship units of an item for which you have not yet entered a standard cost, Inventory Control calculates the cost of goods sold using a standard cost of zero.

    that meaning if i received the products, shipping them and make sales invoice first, then after a fews days i record purchase on accpac program, the cost of goods sold amount will be zero on OE?

  • Sat, Jan 24 2009 9:09 AM In reply to

    Re: Why unit cost column amoutive invent is zero on Order

    Very true.  Either way you go, you need to have discipliine in the accounting department, and procedures that are followed by the users.

Page 1 of 1 (15 items)