another post for dgillz

[kris0517]

dglillz thank you for your help on the last question i asked about sales year to date from may 13, 01-02 and may 13, 02-03. however, i don't know where i can find a table that is strictly a date, ie. {table.Date} and no table with strictly {table.SalesAmount}

everything with a date is connected to something else. Everything with a Sales amount is connected to something else..

does that make sense?
how does it break down in details. i just took a crash course so my crystal skills aren't that phenomenal.

the only sales tables are ytd, ptd, etc. what's the breakdown. there is no simples sales field. there is no simple date field.
help!

thanks!!!!

 

[dgillz]

There should be a transaction table with every single line item on the invoice. Every single line item should have a sales amount, or you should be able to calculate a sales amount, from that table.

Similarly, there should be an invoice date somewhere.

If you cannot find these I recommend asking your software vendor where they are on a transactional level.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

I would also suggest asking them for an ERD and a database schema if you need to write reports against their database.

-k