Welcome, Guest. Please
Login
.
04/18/24 at 16:06:18
News:
|
IS Tech Support
|
Evo~ERP
|
Evo Wiki
|
Forum
|
ISTech Support Forum
›
Evo-ERP and DBA Classic
›
Manufacturing
‹
Previous topic
|
Next topic
›
Pages: 1
JC-A vs SA-B ..... why don't they matc (Read 1011 times)
Laura Oliver
Active Member
Posts: 984
Gender:
JC-A vs SA-B ..... why don't they matc
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
Back to top
«
Last Edit: 08/15/17 at 13:26:13 by Laura Oliver
»
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
IP Logged
Laura Oliver
Active Member
Posts: 984
Gender:
Re: JC-A vs SA-B ..... why don't they matc
Reply #1 -
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
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
IP Logged
Lynn_Pantic
Administrator
evolution (n) -
gradual change to a
different form
Posts: 5681
Re: JC-A vs SA-B ..... why don't they matc
Reply #2 -
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.
Back to top
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
IP Logged
Pages: 1
ISTech Support Forum
›
Evo-ERP and DBA Classic
›
Manufacturing
‹
Previous topic
|
Next topic
›
Forum Jump:
-----------------------------
Evo-ERP and DBA Classic
-----------------------------
- User Polls
- EvoERP Flash Videos
- Problem Reports - Repeatable
- Problem Reports - Sporadic
=> Manufacturing
- Items
- Sales
- Accounting
- System Manager
- Payroll
- Bar Code & Hand Held Interface
- RTM Reports & Editing
- Evo Menu & Evo-ERP
- Installation
- Suggestions for Updates
- General DBA Topics
- DBA & Evo Local User Groups
- IS Tech Symposium & Training
- Program Offerings
- Jobs
- Source Code and Programming in TAS
- Web Storefront
-----------------------------
Windows & Network Issues
-----------------------------
- General Windows & Network Issues
-----------------------------
Pervasive SQL
-----------------------------
- PSQL General Issues
-----------------------------
Crystal Reports, ODBC & Access
-----------------------------
- Crystal Reports General Issues
- ODBC General Issues
- Access General Issues
-----------------------------
General
-----------------------------
- What is IS Tech Support?
- News
- Prizes for Active Forum Users
- EziJobz/Next Generation
- Fun Stuff
ISTech Support Forum
» Powered by
YaBB 2.1
!
YaBB
© 2000-2005. All Rights Reserved.