Welcome, Guest. Please Login.
04/30/24 at 12:46:37
News:
Home Help Search Login


Pages: 1
Send Topic Print
SA-B (Read 510 times)
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
SA-B
10/18/04 at 07:26:20
 
When we run this report for  a specific date range-  a month for example, and include sales tax and shipping,
the first lines on the report appear to be the sales tax and shipping from Invoice #1.  If the report is run with just a invoice range, it runs fine.
The data in Invoice 1 apperars fine.
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: SA-B
Reply #1 - 10/18/04 at 07:39:24
 
Update-
Played with the report some more and found out that if you enter a Invoice range, and then a date range (shipping and sales tax selected), with the date range being after the date of the first Invoice selected, the generated report's first lines will be the sales tax and invoice of the first Invoice in the range selected.
Jeeze, I did a bad job of explaining this!
Example:
 
Invoice range 10-800  (Invoice 10 posted in 2003)
Date range 09/01/04 to 10/01/04
Sales Tax and Shipping - Y
 
The first  lines of the report are the sales tax and shipping from invoice 10.
 
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: SA-B
Reply #2 - 05/27/21 at 14:51:17
 
I know this is a very old thread but it may give a clue why SA-B gives line item detail in DBA and not EVO.   Tomorrow I will try to run reports using just inv#, and then just inv dates and then both to see if I can get line item detail for SA-B in EVO.
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



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: SA-B
Reply #3 - 05/28/21 at 05:28:23
 
They are now completely different reports.  The DBA version is an old text based report that has not had any programming attention since we took over the programming from DBA in 2004.  The Evo version is SA-N preset to sort by Invoice.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: SA-B
Reply #4 - 05/28/21 at 06:54:03
 
Thank you!
I got SA-N  in EVO to do what I want following this method.  There may be a better way but this works for me.  
 
 
1. Sort: User defined
2. Header Filters: as desired
3. 3rd tab User Defined Sort Break Report:  
     layout customer -sort by bill to ? Yes
     Index  1:   invoice   (sadly I cant untick the breakfield here so I have to add a a 2nd index to get the report to condense to 1 line per invoice
     Index  2:   Post date     (i have to choose a 2nd index otherwise index 1 break field remains ticked, If index 1 breakfield  circle  remains ticked then the report prints with each invoice having 3 lines of data)  
 
The results is that SA-N in Evo looks like SA-B in DBA
 
UGH.... No grand totals at the bottom of SA-M and SA-N reports in EVO   just zeros
 
 
 
note:  T6SAN1.RTM = portrait,   T6SAN2.RTM = landscape  
tag weekly, monthly job costing with invoice numbers in chronological order ....  
Also, i discovered that you can get subtotals on Customer Class Analysis  if you enter both invoice numbers and invoice date range.,  But if you only enter invoice date range you do not get subtotals.  This is what VMAN was talking about earlier in this thread.
Back to top
 
« Last Edit: 05/28/21 at 12:43:14 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



Email WWW   IP Logged
Pages: 1
Send Topic Print