Find Jobs
Hire Freelancers

VBA-Excel application development project – in connection with SAP

$1500-3000 USD

Closed
Posted over 6 years ago

$1500-3000 USD

Paid on delivery
Our company is looking for experienced VBA developers with a knowledge and understanding of SAP landscape integration via SAP BAPI (Business Application Programming Interface). Our projects essentially require VBA and Excel skills as the end product is an MS Excel application designed for SAP users and/or Business Analysts. The SAP connectivity capabilities are brought by our Excel Application development tool, for which we provide an access and a training session for the selected freelancers. Our SAP experts are available for questions. You can find more information on our finished product on: [login to view URL] Product Network Analysis (Excel Application - expected timeline is 4 to 5 man days over 1 to 2 weeks): VBA Excel development within our Excel Application development environment From a "Selection" worksheet, the user selects one products and executes the application, in network, hierarchical or geographical mode via an execution button provided in a custom ribbon. The product list is directly imported from SAP database via our Excel Application Development tool. - In network mode: the result is a network display of the product structure as defined in SAP, according to the Bill of Material (BoM) and transport connections between locations where the product is stored - In hierarchical mode: the result is a hierarchical display showing the relevant locations and BoM - In geographical mode: the result is the distribution structure of the product The above-mentioned results are displayed in a "Result" worksheet. Location Master and BoM data will be read via BAPI (with the support of our development tool) and organized according to the user-requested representation (network, hierarchical, geographical). From any of the previous result display, the user can drill down a product location to access Stock position of the product by calling another existing Excel application (MD04).
Project ID: 16052624

About the project

3 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $2,980 USD for this job
User Avatar
Hello, I am Excel Expert and highly skilled VBA Developer I have basic understanding of business softwares but for that case would deeper my knowledge If interested, let me know Relevant Skills and Experience Excel and VBA specialist - years of experience, mostly in business field I can do research and acquire needed knowledge of sap just in a couple days Proposed Milestones $3000 USD - Full project and working file
$3,000 USD in 30 days
4.9 (209 reviews)
8.2
8.2
User Avatar
I am a guru in Excel, and I have experience in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's, charts and more. Relevant Skills and Experience I have strong experience in SAP Inventory and I actually prepare financial and Qnt analysis modules by uploading excel report of SAP Proposed Milestones $3000 USD - . Over 35 years I manage inventory systems by SAP including physical stock (to the COGS) and special stocks. I have extensive experience in issuing all type of forms and how they effect on the stock and the accounting (RC, SI, SO, ST, IF, PC, PD, PR, PU, PU, CN, DN, IN, IN, RE, MR, IM, JE). And I know the way to cancel or create reversal transactions without to spoil the valuation. I know the most functional fields in the database: how to use the wizard reports, how to give orders to the SAP team regarding automation of form (import), exporting to Excel, etc. Also, I have an in-depth knowledge of the SAP process like status changing (SQ >DN>IN) and how/why changes reflect on the accounting (Stock, COGS, FR/IR, GR/IR, Etc.) And of course how to manage Special stocks, IM, MR and more.
$3,000 USD in 30 days
4.9 (87 reviews)
7.1
7.1
User Avatar
I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Relevant Skills and Experience I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Proposed Milestones $2941 USD - milestone
$2,941 USD in 30 days
5.0 (90 reviews)
6.3
6.3

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jan 11, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.