ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Not all reports reflect PO $$$ changes
http://www.istechforum.com/YaBB.pl?num=1438635370

Message started by Laura Oliver on 08/03/15 at 13:56:10

Title: Not all reports reflect PO $$$ changes
Post by Laura Oliver on 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

Title: Re: Not all reports reflect PO $$$ changes
Post by Kelloggs on 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...........

:-?

Kelloggs

Title: Re: Not all reports reflect PO $$$ changes
Post by Laura Oliver on 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. :'( 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.

carolg wrote:

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

GasGiant wrote:

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.

Lynn_Pantic wrote:

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.

Title: Re: Not all reports reflect PO $$$ changes
Post by Kelloggs on 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.

:-[

Kelloggs

Title: Re: Not all reports reflect PO $$$ changes
Post by Kelloggs on 08/04/15 at 07:56:54

Me again >:(

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 !!)

:P

Kelloggs