Find Jobs
Hire Freelancers

SAP Business 1 query with link to pricelist hirtory tables

$30-250 USD

Cerrado
Publicado hace casi 2 años

$30-250 USD

Pagado a la entrega
We need a report which will indicate differences between the selling prices of products on sales orders at the time sales orders have been added to SAP (therefore approved and added by the creator of the sales orders) vs the selling prices of those products at that point in time on the price lists related to the customer being sold to. This will therefore require referencing the history tables of the pricelists and comparing to the price list and prices related to the customer at the point in time of adding the sales orders. The query should therefore compare the final selling prices of the products on the sales orders (closed sales orders) and compare it to the selling prices of those products which was applicable at the point in time the sales order was originally added to SAP.
ID del proyecto: 33727781

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 2 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers están ofertando un promedio de $171 USD por este trabajo
Avatar del usuario
Hi there, ★★★ Database Design & Development Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to build a report . I have completed multiple projects across various domains like Manufacturing, Inventory Management and Vehicle Monitoring System. I do have strong SQL and Excel expertise, through which I will be able to provide you standard and professional way of solutions to your requirements. Services I offer: ✔️ ER, EER Diagrams ✔️ Database creation(Tables, Views, etc) ✔️ Database Design(Normalization, Constraints, etc) ✔️ Programming(Joins/Triggers/Sub queries/Functions/Operators/Views/Sequence) ✔️ Database Modeling, Standardisation ✔️ Bug Detection & Fixing ✔️ Data Security ✔️ Group and sort ✔️ Excel macros, formula ✔️ Data import/export/backup/restore (any format) Databases I work on: ✔️ Oracle ✔️ MySQL ✔️ MS SQL Server ✔️ MS Access ✔️ Sqlite ✔️ NoSQL ✔️ MongoDB I'll be glad to discuss project before start so let's chat. Thanks for your consideration. Best Regards, TechPlus Team
$250 USD en 3 días
4,2 (4 comentarios)
4,2
4,2
Avatar del usuario
Hello, I went through the details of the project you posted. I can do the required work accurately. I presume Sales Order details & prevailing prices of products at point of time can be made available in Excel. Please ping me to discuss further. Thanks & Regards!
$120 USD en 4 días
5,0 (4 comentarios)
2,0
2,0
Avatar del usuario
Hello, Greetings! I read your job description completely and I found my skills relevant to your project. Specializing in SAP Business One, SAP ByDesign, S/4HANA, SAP SD/MM and SAP ECC Consulting and Development. SAP Business One | SAP ByDesign | SAP ECC | SAP SD/MM | S/4HANA Application Expert with more than 15 years of experience in design, configuration, writing functional specifications. Advanced knowledge of implementations, development and system configuration through the entire life cycle, from project preparation to Go live and Support. - Software Integration - Custom addons - Database management - Data Migration - Customization of print layouts - Dashboarding and Report Tools I would love to know more about your project, send me a message so I can have more details and we can start working on it as soon as possible.? Thank you
$140 USD en 7 días
3,8 (3 comentarios)
2,6
2,6
Avatar del usuario
Hello, I read your requirements and I can create such a query. I suppose that you have MS SQL Server as the database for SAP. If so then I will be able to do tests and create the query because in the company I work for we have SAP and I am able to query the database. So during the testing phase I will be able to test without longing in to your SQL Database. After that phase I can give you the query to test yourself or you give me access to the SQL Server and query directly. Concerning the SAP tables I can search them myself, but I you know them, that would be helpfull. Then I can create a View or a Stored Procedure that you can call from an Excel file and have all data there. I will create a button to Excel that will refresh the data. You can contact me to discuss further about your project. If you finally decide to accept my offer then I will create milestones in order for you (and me) to followup the project implementation. Regards, Alexandros
$400 USD en 7 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hello I Am Somnath Bhosle COMPUTER AND SYSTEM KNOWLEDGE: –  Sap Module : MM,SD,HANA S/4,C/4-: IRN Creation , GRN Creation, Inward, Outward, PO Creation, STO Creation, MRP and CP Changes, Set Margin Calculation, Sales Order Creation ,Delivery Notes, Making Invoices,  Warehouse Daily Reports, Inventory Control, POS, IDOC's Generation ( Update) • Knowing what inventory, the store has, when stock is running low and High, which items are requested.  Keeping detailed inventory records when products are purchased and returned and store transfers Details.  Daily Replenish-Picking-Distribution & Dispatching Products to all 21 showrooms with timely and correctively  Contract Creation and Contract management and Negotiation with the Logistic vendors.  Manage the warehousing and storage of all materials with following FIFO  Building strong working relationships both internally and with key suppliers.  Timely Distribution of Products to customer/Locations as per requirement.  Recommend optimal transportation modes, routing for timely deliveries and cost control logistics.  Maintain metrics, reports, process documentation, safety records & Shrinkage and Damage control.  Working as Team with Managing 150000Sqft Warehouse & Inventory of 850000 Qty and min 25000 SKUs.  Verifying accurate standard costs.  Monitoring inventory transactions.  Reconciling inventory accounts to the general ledger.  Preparing monthly journal entries as needed. Reds, Somnath Bhosle
$140 USD en 7 días
4,8 (2 comentarios)
0,6
0,6
Avatar del usuario
Hello! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Database Administration, SQL, Oracle, Database Programming and Accounting. In the two years I've been freelancing, I have written countless projects related to yours. I am confident that I can produce high-quality work for you. My rates are very reasonable, and I am available to start immediately. If you would like to see some of my previous work, I can provide you with a portfolio of my writing samples. I'm sure that you will be impressed with the quality of my work, and I look forward to hearing from you soon. Thank you for your time Wilfred
$100 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have a good experience in this , also have a good accounting knowledge and technical knowledge.....
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Please contact me i have 13 years experience in accounts and finance field 9449983720. I can handle accounts, finance, costing, Taxation etc.. Regards
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can assist you and I will do quality work for you in SAP B1 and ERP Projects. I can assist you as a Functional and Technical consultant for SAP B1 or ERP. I have vast experience in SAP Business One and I have implemented and go-live many SAP B1 projects. My expertise are in the following fields. I am an analytical and hardworking professional equipped with professional knowledge & skills, having multi-dimensional experience of Consulting. ERP Consultant Core competence in SAP Business One Implementation and support end to end Database Management (Experienced on SAP Hana management and MS SQL) Accounting & Finance (Certified & Practical Exposure of Accounting Standard and local practices)
$140 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
********I have a good logic and good knowledge about SQL**************** Dear client. As I'm a database expert, I can handle your project perfectly. I have a good logic and good knowlege about Oracle and SQL, so I can satisfy your demand with optimized code. I can show you my portfolio if you want. Thank you for your job posting. Kind regards!
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello sir am expert in Crystal report i designing many reports like stock position sales,purchase and finical .
$220 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I read the description of your project and I understood what you need to do, where you need report get the data for closed sales orders (which converted to AR invoice) and get the prices of the items each sales order and the prices of these items in the price list related to these items and BP code in the creation date of the Sales Order, and also the history of the prices for each item in its price list. I can provide that report for you where I'm SAP BI developer for 4+ years of experience in SAP B1 and reporting. Kindly contact me if you have any questions or discussion. Best Regards,
$170 USD en 2 días
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
Hi, I am working as SAP ABAP developer. Hope I may helpful to your project. I have skill set on RICEF Development in SAP ABAP, SQL server, Cloud Computing. Thank you.
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
With 8 years experince in BI/ reports( Dashboards,Visualization) creation that is designed and meet the small to big companies reporting needs. - Lead in creating business reports ,visualization and dashbpards using Crystal Reports,SSRS ,Tableau and Power BI. -Spearheaded on enhancing bulk report generation by using complex SQLstored procedure,functions ,views and etc. -used complex tsql queries and DAX queries to create business reports such as vendor/customer ageing reports , sales , inventory and Financial reports . -Creation of visualization and dashboards using BI tools. - In depth knowledge on ERP sunch as SAP B1. -passed the Microsoft SQL-70- 461 Querying data using Transact SQL Certification
$250 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SOUTH AFRICA
Cape Town, South Africa
5,0
1
Forma de pago verificada
Miembro desde abr 23, 2020

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.