Inconsistent restriction/sort expression OR show amount due on invoice

[barbola]

I am getting this error:

Inconsistent restriction/sort expression. Please add the following restriction 'D03301SOP Type=D03301SOP Type'.

I don't know of any D03301 table to select?

I had added a relationship to join SalesHeaderWork to SalesPaymentWorkAndHistory because I want to show amount paid and amount due when I print the invoice before posting. Any other ways of showing this on a report?

 

[winthropdc]

This is Report Writer's way of saying "I'm confused". Just create a restriction with SOP Type = SOP Type. Use the main table on both sides of the restriction.

I know it does not make sense, but it will make the Report Writer work.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[barbola]

I actually found a similar solution on cust source. It said to set that restriction for the most nested tables. There are two equally nested tables with asterisks and I tried each and both and with both I get "mixed hierarchy".

I'll try the main table and see how it goes.

thanks.

 

[barbola]

OK I entered restrictions for each table SOP Type = itself but I still get the error.

Then when I add the last table, SOP_Payment_WORK_HIST, I get the error message "Mixed Table Hierarchies".

This was a relationship I had to add.

If I can't get this to work, does anyone know how to get an invoice to show amount paid before it is posted? This is new to us to have customers come in and pay the same time.

thanks
barb

 

[winthropdc]

Barb

I would suggest only adding the restriction for one table at a time until you find the one it wants.

If you have VBA registered, you can access any data in a table from any product using ADO.

I have example code you can have if you want. Please email me at David dot Musgrave at Microsoft dot com and let me know what version you need (v8, v9, v10).

Note the ADO connection methods for v8, v9 and v10 are all different.

Please see this KB article:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;942327

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[barbola]

We do not have VBA registered. I just need to show that a customer paid his invoice. You would think this would be easy.

sigh.