ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Daily Booking Report, SA-A
http://www.istechforum.com/YaBB.pl?num=1158614269

Message started by David Waldmann on 09/18/06 at 13:17:49

Title: Daily Booking Report, SA-A
Post by David Waldmann on 09/18/06 at 13:17:49

I'm wondering if it's changed in the last update. I'm getting a lot of 0.00 cost invoices reported that are really not 0. If I run a Profit by Invoice report, SA-B, for one of the 0 ones it shows total cost that looks right. However, it is showing a cost for the Parent and none for the components. When I run SA-B for an Invoice that shows a cost on SA-A, the costs show up the way I'm used to them - none for the parent and then for each component.

It only seems to be with Kit type items as far as I've checked so far, but not consistent. For instance, I have two customers with four invoices over the same date range - one of them has 3 $0.00 cost invoices and the other has one, and that one is on the date the the other has a valid costing.

BTW, the anomaly is showing up on Invoices posted before the last update, but the end of August report is the first one where I've noticed it. I don't keep old reports (I don't usually even print them) so I can't compare last months.

Title: Re: Daily Booking Report, SA-A
Post by David Waldmann on 09/19/06 at 12:06:13

Update:

This is not a reporting issue (although why SA-A & SA-B give different numbers might be cause for concern...) and it's been going on longer than I thought.

Starting November 15, 2005 I have nearly 1500 (out of 3400 kit components total) transactions that have posted at 0 cost - they don't even show up on GL-E to the COGS or Inventory Asset accounts. IN-E shows the transactions, but at 0 cost.

There is no apparent rhyme or reason to it. The same day some will post correctly and some will not. Then there are spaces of a week where everything seems to work right.

I downloaded the 9/25 update on 9/27, and the 11/18 update on 11/30, so it's not that.

HELP!!!

Title: Re: Daily Booking Report, SA-A
Post by Laura Oliver on 05/24/21 at 15:13:50

Has this problem been fixed? I still get zero on some costs. the invoices are posted but the Work Orders are R not C.
We don't use KIT type part numbers so that is not the reason i have zero costs/

Lynn_Pantic wrote:

SA (and the GL for COGS and inventory) is looking at whatever the cost was at the time the order was invoiced which has absolutely nothing to do with the Job Cost Report. If you invoiced the order before the WO-I was processed and it is a new item, the invoice will pull from inventory at $0.

Lynn_Pantic wrote:

You will never have accurate costs at the time of invoicing if you don't receive the PO's. I suggest you receive the POs and Enter Finished Production prior to invoicing so the costs are accurate (to the degree your PO is accurate). Any subsequent change resulting from a difference between the PO and Invoice will be reflected as WIP Variance but will ultimately be shown in the JC reports. If Purchasing is doing their job, it should be the rare exception that the AP Invoice is significantly different from the PO.

Karen Mason wrote:

We do not use the report because it is not really accurate. In order to post invoices, we need to enter finished production. Since all costs are not into finished production, we have to use our best educated guess as to the cost/pc. I believe that is what may get into SA-B. Once we close the job (may be months later if it is for multiple releases) we get our "good" cost.

We are kinda like Karen, Does this keep us from using SA-A and SA-B?

problem SA-A has some invoices with zero costs.
The costs do come out correctly on JC-A job costing.

Title: Re: Daily Booking Report, SA-A
Post by Lynn_Pantic on 05/24/21 at 16:02:20

You have to make it before you ship it (WO-I or WO-P before SO-G). Otherwise you have negative inventory and inaccurate COGS on the GL.

Title: Re: Daily Booking Report, SA-A
Post by Laura Oliver on 05/27/21 at 06:45:59

That makes chronological sense, But we have the same problem Karen has in that not all costs are in by the time we post invoices.

Quote from Karen Mason on Sep 15th, 2005, 7:21am:
We do not use the report because it is not really accurate. In order to post invoices, we need to enter finished production. Since all costs are not into finished production, we have to use our best educated guess as to the cost/pc. I believe that is what may get into SA-B. Once we close the job (may be months later if it is for multiple releases) we get our "good" cost.

Title: Re: Daily Booking Report, SA-A
Post by Laura Oliver on 05/27/21 at 13:37:29

One of my guys (mike) that enters finish production said he didnt think he was supposed to enter finish production if we were still waiting on vendor pricing. Example our vendor platers are notorious for not sending us a price for a couple of weeks.

Mike insists he was told not to enter finish production if there are any vendor costs outstanding.

Why can we not enter production, but hold off on posting an invoice until all the costs come in.

What do you think?

Thanks
Laura

Title: Re: Daily Booking Report, SA-A
Post by Laura Oliver on 05/27/21 at 14:46:37

Lynn_Pantic wrote:

Can we first enter finished production and then receive in the purchase order? Or do we have to rec PO and then enter finish production?
Thanks
Laura