SAP B1 SQL Query for Serial Numbers
$30-250 USD
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.
Project ID: #38023477
About the project
30 freelancers are bidding on average $166 for this job
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
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
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
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
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
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
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
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
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
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
★★★ 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
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
Hi , I am ABAP expert and write the queries to bring data for the following fields. Please let me know if you are interested.
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.