Sales Order - Display Attributes

[cmalai]

If you click on Sales Orders menu. It displays

1. Date, Ref, Customer, Description.
   I would like to even display the End Date of the Sales Order.

Based on the Sales Order we would also like to know how many Sales Invoices are raised against that Sales Order
And know the Balance Left.

Any help would be highly appreciated.

[sharpdrivetek]

please search the forum before posting a new topic. this has already been discussed. read the below

Status of quotes, Sales Orders and Purchase Orders Idea

I currently use a custom column field to set status of quotes for open, closed or successful, failed etc. However, this is not desirable as the default view should be to view only open quotes and to click a drop down to view only closed/failed or successful quotes etc. yes I can do this by typing open or closed etc, but I cannot do closed quotes client name to give an example. The secondary problem is that when you convert the quote to a sales order or sales invoice it does mark the original …

[cmalai]

Hey There

Please read the question before replying. Inside the View of Sales Order there is an End Date.
But when I display all the Sales Orders, I want to see the End Date and not just the Order Date.

I dnt seem to find a reply for this question in your post that you have already shared.
But thanks for the trouble of looking into it.

[sharpdrivetek]

@cmalai

Based on the Sales Order we would also like to know how many Sales Invoices are raised against that Sales Order

And know the Balance Left.

the end date was not the only question you asked.

what i was pointing you to was you should post any similar question in the already available topic rather than create a new one.

@cmalai

Inside the View of Sales Order there is an End Date.

But when I display all the Sales Orders, I want to see the End Date and not just the Order Date.

if you read the guides and forum for ideas you will already know that this can be easily implemented using custom fields.

[cmalai]

Hello There

When the field for End Date is already available in the Sales Order table, why would I create a Custom Field. Isnt that unnecessary. It is just being able to customise the display of existing fields.

And could you help me the Custom Query to access the SalesOrders table.
select * from SalesOrders is not working
select * from SalesOrder is also not working. Probably that would give me the END Date also in Display and solve my problem.

Thanks for all your support.

[sharpdrivetek]

@cmalai

When the field for End Date is already available in the Sales Order table, why would I create a Custom Field.

If you are referring to Delivery Date as End Date, this is not available at present.
you should be clear about what you are asking.

@cmalai

And could you help me the Custom Query to access the SalesOrders table.

Custom reports are still a work in progress. there is no documentation for it yet.