Welcome, Guest. Please Login.
05/08/25 at 13:56:58
News:
Home Help Search Login


Pages: 1
Send Topic Print
Not all reports reflect PO $$$ changes (Read 1516 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Not all reports reflect PO $$$ changes
08/03/15 at 13:56:10
 
We entered a purchase order for 4 plates at 100.00 each, but the actual vendor invoice was correct at $101.25 each.  So there was a price change in AP-C for  $5.00
 
PO-I-E  PO Receiving         (Correct) shows $105.00
JC-A  Job cost detail            (wrong)  shows $100.00
JC-P   Material in progress  (Correct) shows $105.00
JC-S   Work Order Detail      (wrong)  shows $100.00,  however it does show an extra line for qty of zero (not a qty of 4) but it  does have a unit cost of $1.25, but 0 x 1.25 =0, not $5.00
 
What am I doing wrong?  
 
Thanks
Laura  
 
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
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Not all reports reflect PO $$$ changes
Reply #1 - 08/03/15 at 15:53:29
 
Nothing!!
 
The $5 dollars difference when into Variance. Go to ADEF-A Master Default Settings, check...."PO Purchase Price Variance"
When the "variance" is substantial, we unreceive the item and change the price, then receive it again, then invoice it.
 
It is the way EVO handles PO Price variances....
If there  is better way we are all ears...........
 
Huh
 
Kelloggs
 
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: Not all reports reflect PO $$$ changes
Reply #2 - 08/04/15 at 06:13:17
 
Kelloggs,  if you run the reports I mention are yours different also?   This may have been a bug that has been fixed, because it wouldn't make sense for the reports to be wrong.  
 
What do you call a "substantial difference" ? So far I have been reversing ALL the POs  (unreceive the item and change the price, then receive it again, then invoice it.)  
My ADEF-A purchase order variance default GL account is 99800, but my differences post to WIP Inventory account 60888. cry  But I don't see how it would better unless the differences were going to the exact same account as the majority of the Purchase Order went to.  
 
Does your financial statements print out with "purchase order variance" ? I  hope there is a better way.  I am all ears too!
 
Thanks for the response.  
 
 
p.s.  
Quote from carolg on 05/02/13 at 12:27:35:
I am looking for a Purchase Price Variance report. I found "PO Price Change" PO-I-I but....It calculates the standard cost OK, but the actual cost is incorrect. An example is a part that we buy for $12; and the last transaction is a .20 change put in when the most recent bill was processed thru AP. So now the report says standard of $12 and actual of .20 with a PPV of $11.80.  Is this a bug in the report, or is there somewhere else to get a PPV report.

Also true in IN-N-A

 
 
Quote from GasGiant on 03/05/10 at 10:56:07:
If you use Standard in DEF-H then all of your transactions are done at standard, so it makes sense that your average is always equal to standard. All of your transactions will be at standard and any variance will be post to variance accounts. By choosing standard costing you are deciding to ignore actual costs during manufacturing and inventory control, as far as I can see.

 
 
Quote from Lynn_Pantic on 03/06/10 at 09:46:44:
Colin is correct.  If your costing method is set to Standard, then any corrections to cost in AP-C as a result of the vendor price on the invoice being different from the PO will post to the Purchase  Price Variance, not change the item Average Cost.


 
 
 
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
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Not all reports reflect PO $$$ changes
Reply #3 - 08/04/15 at 06:56:56
 
I did some testing. I create a PO with a Work Order.
The system "post" the difference in price to the "Work In Progress" Account. And that is correct.
 
I checked the reports and this is the result.
 
PO-I-E  PO Receiving         (Correct) shows $105.00
JC-A  Job cost detail            (Correct)  shows $100.00
JC-P   Material in progress  (Correct) shows $105.00
JC-S   Work Order Detail      (wrong)  shows $100.00
 
The PO Received Not Invoice account is the same as PO Purchase Price Variance account on our dba.
The system works for us.
 
But the JC-S report is not showing the correct amount.
 
 
 embarrassed
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Not all reports reflect PO $$$ changes
Reply #4 - 08/04/15 at 07:56:54
 
Me again  Angry
 
We are using Average Cost on our company.
Scenery...(This time we purchase to Inventory, not to a work order)
 
Receive a PO at $10 dollars.
Invoice the PO as $12 dollars.
 
$10 and $2 are debit to our "Raw Material Account" and $12 to our "Accounts Payable".
 
Last Cost and Average Cost for that Item is $12 ( alleluia !!)
 
Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print