Welcome, Guest. Please Login.
03/29/24 at 05:46:14
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
SALES summary help!! (Read 8044 times)
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: SALES summary help!!
Reply #15 - 01/17/12 at 10:53:46
 
Looks like I have my weekends planned.   But the weather here has been so nice.   Maybe I better make it evenings.
 
Thanks for your help.   I will start to play
Back to top
 
 

12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: SALES summary help!!
Reply #16 - 01/17/12 at 11:57:40
 
Or you could just hire me full time. I'm pretty easy to get along with and then you could have all of your evenings and weekends free!  Cool
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: SALES summary help!!
Reply #17 - 01/17/12 at 15:19:50
 
There you go,
One customer, by part, and from this date to this date
 
SELECT
BKARHINV.BKAR_INV_CUSNME,  
BKARHIVL.BKAR_INVL_PCODE,  
BKARHIVL.BKAR_INVL_PDESC,  
Sum(BKARHIVL.BKAR_INVL_PQTY) AS PQTY
FROM BKARHINV INNER JOIN BKARHIVL ON BKARHINV.BKAR_INV_NUM = BKARHIVL.BKAR_INVL_INVNM
WHERE BKARHINV.BKAR_INV_INVDTE > '2010-12-31' AND BKARHINV.BKAR_INV_INVDTE < '2012-01-01'
AND ASCII(LTRIM(RTRIM(BKARHIVL.BKAR_INVL_PCODE))) <> 0 AND BKARHINV.BKAR_INV_CUSCOD ='SCOENE0100'
GROUP BY BKARHINV.BKAR_INV_INVDTE, BKARHINV.BKAR_INV_CUSNME, BKARHIVL.BKAR_INVL_PCODE, BKARHIVL.BKAR_INVL_PDESC
ORDER BY BKARHINV.BKAR_INV_INVDTE DESC
 
Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
sknapp
Browser
*




Posts: 15
Gender: female
Re: SALES summary help!!
Reply #18 - 04/19/12 at 09:56:00
 
Can you tell me where the invoice notes go for a posted invoice?  I have to provide Invoice Number and Date based on information that is ONLY contained in the notes.  DBA Classic.  Thank you!
 
Quote from GasGiant on 01/17/12 at 05:45:53:
For open (booked) orders, the info is BKARINV (header) and BKARINVL (lines) with the notes in BKARDESC. These are keyed to the SO number, since the invoice number does not yet exist. The field for the actual ship date (bkar_invl_asd) is the requested date and the INVNUM field in BKARINVL is actually the SO num.

Invoiced orders (confusingly) are in separate tables that have the exact same field names, except for the notes, which stay where they were. The invoiced info is in BKARHINV (header) and BKARHIVL (lines), but now the INVNUM in the lines table is the invoice number.

Transaction info is also posted in INVTXN, BKARINVT, SERIAL, LOT, and to the GLs, etc., but you should not need these for your report.

If you would like help writing any of these queries, there are a couple of us here who can help. Let us know what you want included and we'll come up with something that should do the trick.

Here at FHC we have something named the "Flash Report", which lists the results of bookings and invoices by day and by month, with previous month results graphed. I've created this report in a web page so that it is available to all employees in real time.

BTW, I did receive your email and would be happy to help. My preference would be to do something that is freely available to everyone, if that will work for you.

Back to top
 
 

Shannon Knapp
North East Machine & Tool Co
Janesville, IA
Some days are just like that....
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: SALES summary help!!
Reply #19 - 04/19/12 at 10:53:44
 
in DBA Classic the Notes are stored in BKARHDSC but it is just text so filtering/sorting on it will be tricky.
Back to top
 
 

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


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: SALES summary help!!
Reply #20 - 04/19/12 at 11:24:19
 
SELECT
BK_DESC_NUM,
BK_DESC_LINE,
BK_DESC_NOTES
FROM BKARHDSC WHERE BK_DESC_NUM = 12345
ORDER BY BK_DESC_LINE
 
 Roll Eyes
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
sknapp
Browser
*




Posts: 15
Gender: female
Re: SALES summary help!!
Reply #21 - 04/19/12 at 11:49:19
 
Thanks, Lynn.  I just exported the file to excel and went from there.
Back to top
 
 

Shannon Knapp
North East Machine & Tool Co
Janesville, IA
Some days are just like that....
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print