Kapalı

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.

Beceriler: Oracle, SQL, Veri Tabanı Yönetimi, Veritabanı Programlama, Muhasebe

Müşteri Hakkında:
( 1 değerlendirme ) Cape Town, South Africa

Proje NO: #33727781

Bu iş için 22 freelancer ortalamada $171 teklif veriyor

(26 Değerlendirme)
5.4
(44 Değerlendirme)
5.3
(9 Değerlendirme)
4.7
(2 Değerlendirme)
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 Daha Fazla

$250 USD in 3 gün içinde
(4 Değerlendirme)
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 Daha Fazla

$120 USD in 4 gün içinde
(4 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(3 Değerlendirme)
2.6
(1 Yorum)
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 Daha Fazla

$400 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$140 USD in 7 gün içinde
(2 Değerlendirme)
0.6
(0 Değerlendirme)
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 Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Rajanjha13

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

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 2 gün içinde
(0 Değerlendirme)
0.0
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$170 USD in 2 gün içinde
(1 Yorum)
0.0