ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> PO-I-E Reflects PO-I-A....no it shouldn't
http://www.istechforum.com/YaBB.pl?num=1115229836

Message started by Laura Oliver on 05/04/05 at 10:03:56

Title: PO-I-E Reflects PO-I-A....no it shouldn't
Post by Laura Oliver on 05/04/05 at 10:03:56

Since there is no JC report that includes both rec'd and unrec'd PO costs, we print both PO-I-A and PO-I-E to get a complete job costing. Up until now we have never had a PROBLEM with this (other than it awkward and slow to print 2 reports) But today one of my folks said that she was getting the same data on PO-I-A as she was on PO-I-E. At first I wrongly assumed that we had rec'd exactly 50% on the original order. Then I wondered if we had not closed the PO when it was rec'd in. That appears to be the case, and then I am guessing that someone went thru the PO,kinda rereleasing the order items....I think??? I am not sure....but this makes me wonder about some of my pas t job costing.
Q1) is there any other possibilty?

We often do not receive a vendors invoice until weeks after our job is invoiced.

Q2) How do other folks deal with unrec'd costs when job? costing.

Title: Re: PO-I-E Reflects PO-I-A....no it shouldn't
Post by aricon on 05/04/05 at 10:26:32

Well, I can tell you that for THIS reason for a former client that did a LOT of job costing, that is why we ended up creating an Access application that would gather all these costs and projected costs into a single report that could then be printed in summary or detail.

Title: Re: PO-I-E Reflects PO-I-A....no it shouldn't
Post by lmk223a on 05/05/05 at 05:21:52

If your definition of "unreceived costs" is material received, but not yet invoiced at the time the work order is about to be closed, we create a temporary invoice (usually the packing slip will reference the true invoice number) in DBA based upon the purchase order costs. Then final production is entered, the work order is closed and we invoice the customer for the final shipment and know our COGS.

When the vendor's original invoice arrives, there may only be small differences like a handling change (as we have all our vendors bill our UPS account for incoming freight charges).

Title: Re: PO-I-E Reflects PO-I-A....no it shouldn't
Post by Laura Oliver on 05/05/05 at 07:06:32

Thank you.
that would work.....but Gosh...that seems like a lotta work. And we are like a few other folks on the forum. We don't receive in until the Vendors invoice is attached to the packing slip.

If only a JC report could include items on a PO that is not yet rec'd.....
or ....If only there was another report in PO that included both rec'd and not yet rec'd.

Lorne did a program for a former client...but we are not that big and it really has not been a problem until now...and this may just be a little quirk..... But I am still concerned about it (see Q1). I cant let that happen again.

Title: Re: PO-I-E Reflects PO-I-A....no it shouldn't
Post by Lynn Pantic on 05/05/05 at 07:16:50

Why don't you receive in until you have the invoice? Your purchasing people should be getting quotes before you place purchase orders so you can receive based on the PO Costs and any defference when the invoice comes in should be minor.

Particularly if you buy for stock (rather than a work order) it is important to receive as soon as parts physically com in so they can in turn be issued to jobs or shipped out without taking inventory negative.

Title: Re: PO-I-E Reflects PO-I-A....no it shouldn't
Post by Laura Oliver on 05/05/05 at 08:34:28

Even if you receive from the packing slip, unreceived items do not show up on JC- B (profit projection)

"receiving from the pack slip alone" gave us several problems. I can't remember them all, but the main one was is that our purchasing guys would go dyslexic or the vendor would swear up and down that he gave them a different price, or a PO should have been updated and it never happened. This was discussed on one of the DBA forums a few years back and several folks joined the bandwagon.

Receiving fron pack slips may be a bigger problem for us than most because we dont use AP-C. We pay everything thru AP-B. AP-C may have a built in check and balance?

Anyway running both PO-I-A and PO-I-E has always worked ... until now....I am still trying to figure out what happened , so I can keep it from happening again.

thanks

99% of everything we buy is for a specific WO.