Hello everyone,
I would like to create a query which detecting new customers joined every month.
New customer counts if:
Or make an Order
Or get an invoice
Sometimes the customer order and than get invoice, and sometimes get an invoice wi...
Hello everyone,
We would like to have a query that recognizes the customers who pay below a specific price list (for example 'PriceList1').
Why we need that?:
Today, we change manually the default prices of our 'PriceList1', for customers who n...
I need a Query to show me all open/printed open quotations (***per item) in the following table: (SBO)
quotation date | quotation number | card (customer) number | customer name |contact name| contact mobile num| contact email| item number | item d...
Hi Matija, If you read my question again, you will see I have written that my final goal using Special Prices for BP functionality.I need the query for dedecting those customers who pay diffrent prices than our price list - 'PriceList1'.After the que...
T1.[Price]as'Item Price', Is that the price from the item card?because I need the unit price taken from the quotation - it is not always like the original price, sometimes we change it manually in the quotation.
Another important point:A) I Need it to show 1)open quotaion 2)printed open quotaioni tried:WHERE T0.[Printed] ='Y'
and
T0.[DocStatus] ='O'
or
WHERE T0.[Printed] ='N'
and
T0.[DocStatus] ='O'.no succeed! B) I need it to show the only items have no...