Welcome, Guest. Please Login.
05/13/25 at 09:59:21
News:
Home Help Search Login


Pages: 1
Send Topic Print
Average Cost Questions (Read 463 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Average Cost Questions
06/17/13 at 11:06:23
 
Does the Average cost viewed in IN-A reflect the freight.   I know Standard Cost reflects freight.
 
I think the only two ways for AVERAGE COST to change is  through UT-K-F and through the repetitive buying and receiving in process.
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Average Cost Questions
Reply #1 - 06/17/13 at 12:04:16
 
I believe that depends on how you have DBA/Evo set up.
 
If you have a PO Freight In (POFI) GL account and enter freight separately in AP-C, then Average Cost does not include freight. Reason being, there is a single separate GL account that POFI goes into, and you can't put the same amount in two places (i.e. POFI and your Inventory Acct).
 
There is a feature in DBA/Evo that allows you to add a percentage of cost to freight, and I believe that then goes to the inventory account and would be included in Average Cost. I'm not positive about that though - we used it on a couple items some time ago and stopped for some reason.
 
The last possibility (that I can think of) would be if you include the cost of freight in the per-unit cost when entering your PO lines in AP-C. It's pretty simple if you have just a single line as you can "Edit line" and just tab to the Total where you put it in and the per unit cost will be calculated for you. You can also manually split up how much freight you want on each line and then manually add that to each line subtotal, using the above method to calculate the total unit cost. Note that if you use this method and have one of the "Use last cost" options for entering prices on POs it will use this number that includes freight.
 
I believe you are right as to how Average Cost is updated, remember that "receiving" includes Work Order receipts.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print