Lukket

SAP Business 1 query with link to pricelist hirtory tables

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.

Evner: Oracle, SQL, Database Administration, Programmering af database, Regnskab

Om klienten:
( 1 bedømmelse ) Cape Town, South Africa

Projekt ID: #33727781

22 freelancere byder i gennemsnit $171 timen for dette job

(26 bedømmelser)
5.4
(44 bedømmelser)
5.3
(9 bedømmelser)
4.7
(2 bedømmelser)
3.8
techplusintl

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, Inve Flere

$250 USD in 3 dage
(4 bedømmelser)
4.2
arpitrai07

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 Flere

$120 USD in 4 dage
(4 bedømmelser)
2.0
devendrathakur12

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 Flere

$140 USD in 7 dage
(3 bedømmelser)
2.6
(1 bedømmelse)
1.2
abatsis

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 fo Flere

$400 USD in 7 dage
(1 bedømmelse)
1.0
somnathbhosle787

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 Flere

$140 USD in 7 dage
(2 bedømmelser)
0.6
(0 bedømmelser)
0.0
wilfrednjorog

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 Flere

$100 USD in 3 dage
(0 bedømmelser)
0.0
Rajanjha13

I have a good experience in this , also have a good accounting knowledge and technical knowledge.....

$140 USD in 7 dage
(0 bedømmelser)
0.0
cmagreddy

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 in 7 dage
(0 bedømmelser)
0.0
GrasonM

[login to view URL] - [login to view URL] Ambitious Computer Scientist / IT Specialist that takes responsibility for technically rigorous assignments which require superior per Flere

$140 USD in 2 dage
(0 bedømmelser)
0.0
(0 bedømmelser)
0.0
adnanhaider6

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 imple Flere

$140 USD in 2 dage
(0 bedømmelser)
0.0
vadimslavinsk

********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 Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0
tahirsiddiqui190

Hello sir am expert in Crystal report i designing many reports like stock position sales,purchase and finical .

$220 USD in 7 dage
(0 bedømmelser)
0.0
TarekMYoussef

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 Flere

$170 USD in 2 dage
(1 bedømmelse)
0.0