|
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.
-
Thu, Jan 22 2009 12:06 PM
|
|
-
Mike


- 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).
|
|
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
Re: Why unit cost column amount is zero on Order
What costing method do you use?
|
|
-
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
Re: Why unit cost column amount is zero on Order
Does that item have a total cost?
|
|
-
-
Mike


- 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
|
|
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
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.
|
|
-
-
Mike


- 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
|
|
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
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.
|
|
-
-
Mike


- 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?
|
|
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
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.
|
|
-
-
Mike


- 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?
|
|
-
-
-
Mike


- 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?
|
|
-
-
Mike


- 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?
|
|
-
-
Jay Converse


- Joined on Wed, Apr 16 2008
- Location Location
- Posts 1,142
|
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)
|
|
|