Orders that haven't been invoiced yet

[lunchbox88]

In what table(s) would I find information on orders that haven't been invoiced yet?

 

[Dukester0122]

SOP30200(header) and SOP30300(line items)

 

[Dukester0122]

Correct me...SOP10100(header) and SOP10200(line)

 

[lunchbox88]

Ok...that's still not getting me what I'm looking for. Here's what I need:

I need the totals for orders placed within a date range. Regardless of whether or not they've been invoiced in, or out of, that date range.

I thought I could take the total from orders that haven't been invoiced (SOP10100), and add that to the total from orders that have been invoiced (SOP30200). That doesn't seem to be working. I'm using the ORDRDATE field to filter both tables. Apparently this isn't correct as my totals are not adding up to what the client shows they should be.

Can anyone think of a reason for this? Am I pulling the data incorrectly?

Thanks in advance!

 

[Dukester0122]

When you say totals, are you including taxes, freight, misc. charges? You have to ask your client what comprises their total then do your formula, not creating the report and hoping they match.

 

[lunchbox88]

I'm including every charge they are on their manual report. I was hoping I was grabbing the wrong date or something.

 

[jazgeek]

you need to make a union join on header tables
SOP10100 and SOP30200

for details you need to make a union join on detail tables SOP10200 and SOP30300

10 series is open
30 series is history



-----------
and they wonder why they call it Great Pains!

jaz