Closed

sequel viewpoint

i need to create a report. where the column descriptions are given and need to write a query for the report using sequel. This is the description for creating the report. and attached file is to be excepted.

Filters:

Salesrep - should be required use code "LC " as your test (table MMMSTSMP)

Year - Required and Default to current year

Account - Optional - "W441A" is Walmart and a good test account

Box 1: Top accounts by shipped LY volume

Account name will be from the NAACCTP field (ACACCT and ACNAME)

Booked TY will be

the sum of the IVR00F (Field IVR$) for the current year (IVRDAT8) plus

the sum of the ivmstdtl (DTLINQ * DTSLS$) where dtpksh = "B" or "P" plus

the sum of the ormstdtl (DTLINQ * DTSLS$)

Shipped TY will be

the sum of the IVR00F (Field IVR$) for the current year (IVRDAT8)

Shipped LY will be

the sum of the IVR00F (Field IVR$) for the prior year (IVRDAT8)

Booked LY will be

the sum of the IVR00F (Field IVR$) for the prior year (IVRDAT8) plus

the sum from DTEXT$ from the fpopoh file from the nearest weekend (DTWEDT)

The FPOPOH file is a snapshot of our order file. It is taken every Saturday. You will need to take the current date, go back 1 year and then find the next freeze date. If you ran it today, you should only read the records from 2018-02-10.

Note- In the attached filed i'm looking for top accounts report.

Skills: MySQL

See more: it sales companies which help in getting the projects outsourced, small auditing firms who are looking to outsource the data to business, we are a crowdfunding website we are looking to revamp the site so its more user friendly, helpsystems, helpsystems halcyon manual, sequel systems, sequel for ibmi, sequel viewpoint silent install, sequel product, sequel software training, sequel viewpoint windows 10, looking for madoda the manager of the field marketing, looking for marketers evening and weekend, i am in grade 10 looking for machanica engineer sponsers, looking for freelance the hague portugese, The site I\ m interested in keeping, We need a creative LOGO for our company SB Software Services. The logo should be with two letters \ S\ & \ B\ and logo should , the objection is raised under s 9(1) (b) of the trade marks act 1999, what is the role of m-commerce in business, looking forward to the party

About the Employer:
( 0 reviews ) North Brunswick, United States

Project ID: #19000247

10 freelancers are bidding on average $22/hour for this job

KashirinA

Hello. How are you I have read your description carefully. Very Interesting. I have many experiences in web developing. So I can finish your project quickly and perfectly If you hire me, I will do my best. Thank More

$22 USD / hour
(64 Reviews)
6.6
CrazyWebGuru

Hi there? Please check my previous demo. [login to view URL] [login to view URL] [login to view URL] I am a full stack developer in PHP and javascript frameworks such More

$22 USD / hour
(16 Reviews)
5.1
AndrejStastny

Hi there? Please check my previous demo. [login to view URL] [login to view URL] [login to view URL] I am a full stack developer in PHP and javascript frameworks such More

$22 USD / hour
(12 Reviews)
5.3
rinabuoy13

Hello, I am experienced sql expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$22 USD / hour
(3 Reviews)
3.1
finaldragon123

Hello,sir I 'd really like to work with you on this one if possible! I have read your description with great interest. I've gone through the post description carefully and ready to start work on this project. I do More

$22 USD / hour
(4 Reviews)
2.6
anatolygenay123

Hi, I’m a senior web developer who are very confident in Mysql and Laravel, CI,Yii PHP frameworks. Your task is very exciting because my ability is very suitable. I have rich experiences in responsive website design More

$22 USD / hour
(4 Reviews)
2.5
SecureForYou

hello,dear. I have read all your requirements for 'sequel viewpoint' and I fully understood it. I am confident and I am sure that I am able to finish this project. Please come in contact with me, so that we can discuss More

$22 USD / hour
(1 Review)
2.7
pandakjm

Hello, How are you? I have just read your post and was exciting with feeling to satisfy you in your project. I have many experience in this field and thus your job likes to be very easy for me. Already i built many More

$22 USD / hour
(2 Reviews)
1.9
jayantavkumar

I am a database architect and have more than 14 years of experience in IT industry. Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years o More

$20 USD / hour
(1 Review)
0.6
Invadergroup

Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters More

$22 USD / hour
(0 Reviews)
0.0