ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> JC-A vs SA-B ..... why don't they matc
http://www.istechforum.com/YaBB.pl?num=1502823733

Message started by Laura Oliver on 08/15/17 at 12:02:13

Title: JC-A vs SA-B ..... why don't they matc
Post by Laura Oliver on 08/15/17 at 12:02:13

We now make sure EVERYTHING is done before we post a invoice, ...(all labor is entered, all POs recieved in, finished production is entered) But we sstill find that JC-A does not always match SA-B.
What are we doing wrong?
Thanks,
Laura

Title: Re: JC-A vs SA-B ..... why don't they matc
Post by Laura Oliver on 08/15/17 at 13:25:25

RE: SA-B
The first six columns in SA-B are correct, but the last four are confusing,

Here is an example of where we had 4 lines on an invoice

Where do the amounts under the COST column come from? How can they all be the same?
What created the 2nd extension column>
Gross Margin and GM make no sense to me.

item qty price disc net price extension Cost Externison Gross Marg GM
WQFLATBAR 12 31.50 0 31.50 378.00 18.2562 219.07 158.93 42.04 %
WQFLATBAR 72 37.50 0 37.50 2700.00 18.2562 1314.45 1385.55 51.32 %
WQFLATBAR 72 31.50 0 31.50 2268.00 18.2562 1314.45 953.55 42.04 %
WQFLATBAR 12 37.50 0 37.50 450.00 18.2562 219.07 230.93 47.08%

The above is from SA-B

JC-A is below (For ease of understanding I have added selling price)

sell price Line Total profit profit percent
$378 1 $588 -209 -55%
$2700 2 $2317 383 14%
$2268 3 $1968 300 13 %
$450 4 $223 226 50%

JC-A is correct. I want SA-B to match JC-A . What am I doing wrong? Thanks
Laura

Title: Re: JC-A vs SA-B ..... why don't they matc
Post by Lynn_Pantic on 08/15/17 at 15:26:27

It looks like you are using the same part number on each line (WQFLATBAR) but it really isn't the same thing. The program is averaging cost together based on part number so you have to have a unique part number to define each item so you aren't averaging together apples and oranges.