Portal
Search
Calendar
Help
Hello There, Guest!
Login
Register
Login
Username:
Password:
Lost Password?
Remember me
webERP Forum
›
webERP Discussion
›
How To ?
« Previous
1
…
7
8
9
10
11
…
34
Next »
Lost Sales Analysis
Thread Rating:
1 Vote(s) - 5 Average
1
2
3
4
5
Thread Modes
Lost Sales Analysis
01-24-2017, 02:30 AM,
#1
miguelitrojop
Member
Posts: 21
Threads: 14
Joined: Jan 2017
Lost Sales Analysis
Hi is there anyway to generate a report that show the lost sales one has between the PO of the customer and the invoice when we don't have enough to complete the PO?
Find
Reply
01-24-2017, 03:22 AM,
#2
TimSchofield
Tim Schofield
Posts: 1,318
Threads: 22
Joined: Mar 2015
RE: Lost Sales Analysis
The following SQL should provide you with a list of order numbers where the whole quantity wasn't invoiced but the line is marked as complete
SELECT orderno FROM salesorderdetails WHERE quantity<>qtyinvoiced AND completed=1;
If this is what you want then it wouldn't be hard to work that SQL up into a report,
Thanks
Tim
Website
Find
Reply
01-25-2017, 08:06 AM,
#3
miguelitrojop
Member
Posts: 21
Threads: 14
Joined: Jan 2017
RE: Lost Sales Analysis
Hi Tim:
Thanks a lot that is exactly what i need.
Find
Reply
«
Next Oldest
|
Next Newest
»
View a Printable Version
Forum Jump:
Private Messages
User Control Panel
Who's Online
Search
Forum Home
webERP Discussion
-- How To ?
-- Problems / Bugs?
---- RESOLVED - Bugs/Problems
-- Installation Issues
-- Development Discussion & Specification
---- CartwebERP
-- Development Tools
-- Market Place
-- Feature Requests
-- Project Admin
Users browsing this thread: 1 Guest(s)
Linear Mode
Threaded Mode