SAP B1 SQL Query for Serial Numbers

Closed Posted last week Paid on delivery
Closed Paid on delivery

I'm in need of an SQL query that can pull specific information from our SAP B1 database. The query will need to return Serial Numbers for the transactions in Sheet 1 of AR Invoices, AR Credit Notes and Sheet 2 AP Invoices, and AP Credit Notes, all filtered by Transaction Date.

Key Requirements:

- The query should return the following fields: Document Number, Transaction Date, CardCode, CardName, Item Code, Item Description and Serial Number.

- The data should be filtered specifically by Transaction Date.

- Transactions types to be included are AR Invoices, AR Credit Notes, AP Invoices, and AP Credit Notes.

- Should not return duplicate serial numbers per Transaction type

Ideal skills for this project:

- Strong experience with SQL, particularly in the context of SAP B1.

- Knowledge of SAP B1 database structure, especially regarding the tables related to transactions and serial numbers.

- Understanding of the different transaction types (AR Invoices, AR Credit Notes, AP Invoices, and AP Credit Notes) in SAP B1.

- Attention to detail to ensure the accuracy of the returned data.

- Ability to deliver the SQL query that can be easily run and understood by our team.

SQL Database Programming SAP

Project ID: #38023477

About the project

30 proposals Remote project Active last week

30 freelancers are bidding on average $166 for this job

noureen23

Hi There, With over 15 years of experience in relational databases, complex SQL scripting, and data analytics - I have a strong knowledge of SQL and transactional types. My attention to detail will additionally ensure More

$40 USD in 4 days
(28 Reviews)
5.0
bizmanas

I have 17 years experience in sql sever, mysql, postgresql development and performance tuning, python machine learning experience. Report building using power bi. I will be able to help you with the project. Please pi More

$350 USD in 5 days
(11 Reviews)
4.5
buchibabuabap

Hi there, I am very good at SQL scripting and SAP ERP domain, I am having over all 14 years of experience together. I can help you with your requirement quickly. If you are okay lets proceed further. Thank you

$140 USD in 7 days
(5 Reviews)
3.8
ayesha0124

Hi there, I have read the brief details of the project u posted and I believe i can help u as I have great experience doing projects with SAP, Database Programming and SQL. Please send me msg to discuss in detail. Reg More

$250 USD in 9 days
(2 Reviews)
3.4
haseeb6291

Hey there, With over 8 years of experience in SQL Server Development. I'm interested to discuss your project's timeline, budget, and detailed requirements. Let's schedule a meeting at your convenience to explore furthe More

$140 USD in 3 days
(8 Reviews)
3.5
AmazingEngr76386

As an experienced database programmer with a specialization in SQL, I’m confident that I have the knowledge and skills you need for this project. My understanding of the SAP B1 database structure, specifically in relat More

$140 USD in 7 days
(1 Review)
3.6
merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform More

$160 USD in 3 days
(26 Reviews)
3.9
ajeshjanardanan

Hi Nielle T., How are you doing? As a professional developer with expertise in Database Programming, SAP and SQL, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discu More

$50 USD in 4 days
(1 Review)
2.4
souyah

Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - SAP B1 SQL Query for Serial Numbers. I have worked with similar projects so that I can provide More

$200 USD in 6 days
(1 Review)
2.0
Lemeses

Hello, how are you doing? I've experience with SAP B1 ERP sql query development and their database structure. I developed reports that returns the serial number by SAP transactions. Also I developed many reports fro More

$130 USD in 7 days
(1 Review)
2.0
lukesanthony

I can help to create sql query for getting ☀️data (Document Number, Transaction Date, CardCode, CardName, Item Code, Item Description and Serial Number.)☀️ which you want from database It is sure to filter and include More

$140 USD in 7 days
(1 Review)
0.4
emdi85

Hello, My name is Mohamed, I am very experienced in SAP B1 SQL Query for Serial Numbers and I have done this before, let's chat more details. Best Regards, Mohamed

$100 USD in 2 days
(0 Reviews)
0.0
DeveloperStation

With 5 plus yearsof experience in SQL development and a strong understanding of SAP Business One database structures, I am well-equipped to handle this project effectively. My expertise in database programming and fami More

$130 USD in 2 days
(0 Reviews)
0.0
waheedamir

Hello, I have already read the job description and ready to do the job for you. I have strong background in SQL and delivered various projects to my clients. Looking forward working with you. Regards, Waheed Amir

$140 USD in 7 days
(0 Reviews)
0.0
TilDrexler

★★★ Hi, there ★★★ I understand what exactly you need and I can start work on the spot. I can handle your task in no time with pro work, so if you'd like to start work with me, just let me know via CHAT. Best Regards

$100 USD in 1 day
(0 Reviews)
0.0
shreyash053

I have been working in on Advance SQL since last 5 years. I have in and out knowledge in SQL. I am relatively new to this forum. That's why looking out for some help and want to work and kickstart freelancing. But, I c More

$57 USD in 7 days
(1 Review)
0.0
trm66614

Hi there,Good evening I am Talha. I have read you project details i saw you need help with Database Programming, SAP and SQL I am pleased to present my proposal, highlighting our extensive experience and proven track More

$30 USD in 10 days
(0 Reviews)
0.0
choukseykishor

Hi , I am ABAP expert and write the queries to bring data for the following fields. Please let me know if you are interested.

$250 USD in 7 days
(0 Reviews)
0.0
ArgenisBardales

I am an experienced B1 consultant and have worked on a similar query recently. I can deliver what you require within 8 hours of accepting my proposal. Looking forward to working with you.

$140 USD in 7 days
(0 Reviews)
0.0