cancel
Showing results for 
Search instead for 
Did you mean: 

Sales order issue

prasanna_kumar4
Active Contributor
0 Kudos

Hi,

According to my Client Requirement i have to do billing , delivery and excise invoice in BALES

here the problem is at the time of Sales order we don't know bales contains how many meters and

Each bales contains different materials and price also changes

It is Order related Billing , Order related Delivery

How to Solve the Issue and how to map into SAP

I am new this scenarios

Can any one guide to solve solve above issue and also is it possible in sap ? if YES plz guide me

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

What is BALES??????????????

If you want proper solution then you have to explain business scenario,then we can guide you on proper way.

kindly explain in detail

kapil

prasanna_kumar4
Active Contributor
0 Kudos

Thanks for Reply Mr.Kapil,

My business Scenario is like this " Customer will give the program 1000 meters,

Sales order is like this 10 Material 2X2 Dyeing green 260 meters

20 Material 2x2 dyeing yelow 300 meters

30 material 2x2 dyeing medium 440 meters

its order related billing and order related delivery & Coming to Billing like this balewise and bale contains like this

10 Material 2X2 Dyeing green 110 meters

20 Material 2x2 dyeing yelow 140 meters

the above 2 they put into one bale ie there are combining more than 2 line items in sales order and put into one line item like BALE

BALE instruction we will come to know at the time of production completion and BALE Doesnt have standard meters

BALE is nothing like a Packing Instruction from the customer

Plz guide me Based on that how to solve it and how to map into SAP

In the above case Solution is there or not

Edited by: prasanna_sap on May 23, 2011 1:56 PM

Lakshmipathi
Active Contributor
0 Kudos
Sales order is like this 10 Material 2X2 Dyeing green 260 meters
20 Material 2x2 dyeing yelow 300 meters
30 material 2x2 dyeing medium 440 meters

Is the material code different in the above case ?? Since the colours are different, I feel, it should have been different in which case, you have to maintain the alternate unit of measurement (like 1000 meters is equal to one bale) in the respective material master. Of course, this should be permanent.

Accordingly, you need to maintain price in VK11 with UoM Bale. So when you create sale order for let us say 300 meters of 2x2 dyeing yellow, system will consider pricing only to that extent.

thanks

G. Lakshmipathi

prasanna_kumar4
Active Contributor
0 Kudos

Thanks for Reply Mr.Lakshmipathi,

In my Case Material Code is Different and also BALE contains different material codes

and also price maintaining in Meters not in BALE wise and also what r all the material they want to pack in BALES we will

come to know at the time of production complete so at the time of sales order we dont know the BALE packing Instructions and also if i know at the time of sales order sometimes they will change at the end of production

and also BALE contains different material codes and each material have its own price and also how we can mix into BALE wise

BALE doesnt have standard meters means one BALE contains 100 meters and another BALE contains 290.05 meters Etc.,,

I think is it clear for u to understand my problem?

Please guide me how to MAP into sap and how to solve the issue

prasanna_kumar4
Active Contributor
0 Kudos

Hi,

My Business Case is I have created my sales order with different modules codes with different line items

At the time of Production completion i know how much Qty i have to pack different material { different material code } In one BALE

i.e Example Material Codes Like this M-1890,A-8920,P-5647, W-8756

Sales order like this line item wise M-1890 Qty is 100 PC

A-8920 Qty is 200 PC

P-5647 Qty is 140 PC

W-8756 Qty is 200 PC

The Above are the Four line items in one sales order

Coming to the delivery i have to pack the above material in BALES in Like this

M-1890 Qty is 40 PC

A-8920 Qty is 100 PC

P-5647 Qty is 40 PC

W-8756 Qty is 100 PC

The above set is One BALE { The BALE Contains Different Material Codes }

can any one tell me is it possible in SAP or Not

Can we pack the material like that if yes plz guide me how to solve the issue bcoz i am new to this concept

prasanna_kumar4
Active Contributor
0 Kudos

Is there any Solution for that issues means is it possible in SAP or Not

Former Member
0 Kudos

Hi,

Sales order like this line item wise M-1890 Qty is 100 PC

A-8920 Qty is 200 PC

P-5647 Qty is 140 PC

W-8756 Qty is 200 PC

The Above are the Four line items in one sales order

Coming to the delivery i have to pack the above material in BALES in Like this

M-1890 Qty is 40 PC

A-8920 Qty is 100 PC

P-5647 Qty is 40 PC

W-8756 Qty is 100 PC

The above set is One BALE { The BALE Contains Different Material Codes }

From your above explanation it is packing related,as you want to pack different materials in 1 BALE and your BALE have different material code it meas your BALE is packaging material,

As far as my understanding it can possible to pack various materials in 1 BALE,

Kindly explore PACKING and Handling unit sections

Kapil

prasanna_kumar4
Active Contributor
0 Kudos

Thanks for Reply Mr.Kapil,

Can you please explain is it possible to get the packing details in billing level ?

and also is it possible to pick the material at the time of delivery BALE number wise and also it will follow in billing & Excise invoice level

If you Don't mine can you please send if you the material for multilevel and single level packing to my " Gmail"

Please guide me

Edited by: prasanna_sap on Jun 10, 2011 9:51 AM

Edited by: Lakshmipathi on Jun 10, 2011 2:07 PM If you continue to keep asking like this, your user id will be blocked

prasanna_kumar4
Active Contributor
0 Kudos

Sorry Mr.Lakshmipathi i wont repeat once again

Thanks you very much

If u don't Mine can you give me the solution for that issue because i have been struggling last one month and also i am not getting the proper solution to solve my issue

Lakshmipathi
Active Contributor
0 Kudos

There is no standard solution to this requirement.

You have to develop a zee table for this where you can have the following as output fields

a) Material Code

b) Bale reference

c) Quantity

Ask the production people to enter the above details via a zee tcode.

Since you have indicated that your selling price is per bale, you have to arrive a logic such that as and when an entry is made, delivery should fetch this table and accordingly populate the quantity.

Similarly for billing, I am not sure on your process since you said that different material codes will accommodate in a bale and each material will have a different unit rate. So you have to decide whether manual condition is an option.

thanks

G. Lakshmipathi

prasanna_kumar4
Active Contributor
0 Kudos

Thanks for reply Mr.G. Lakshmipathi,

we created separate BALE packing Slip screen . Once production is completed and they packed in BALES those details

they will update in the new screen which already developed that time system will generate one BALE number

But coming to the billing , At the time of Billing they want to select only BALE numbers which is relevant for those customer as well as Delivery , proforma invoice and excise invoice i.e if select the customer

One important point in all the cases like billing,delivery, proforma invoice & excise invoice they are selected the BALE numbers for particular customer for multiple sales order mixing and also how to give the link , other document flow should n't update

and stock will be updated in both manner like BALE wise as well as meters

price in Meters for that there is no problem

Lakshmipathi
Active Contributor
0 Kudos

Deliveries cannot be created based on bale number. So once the user posted the goods issue via VL01N referencing the sale order, this DA number should get updated in that table.

Similarly, for billing also, as a standard process, user can refer DA reference and do the billing. Before saving, with an user exit, you can fetch the bale number from the above zee table by cross referencing the DA number and populate in an unutilised field in billing document header table so that at a later date, you can generate a report from VBRK based on bale numbers.

thanks

G. Lakshmipathi

prasanna_kumar4
Active Contributor
0 Kudos

Thanks for Reply Mr.Lakshmipathi,

Now i am sending my entire client requirement based on that guide me how i want to solve my issue

BALE Configuration is required:

As for the Client Requirement Once they receive the Program from the Customer that time they will raise the Sale order for that Program. Sometimes Customer will give Grey material after the Program also or Before the Program also (Grey is Non Valuated Material).

For Example Sales Order for that Program is 10000 meters.

Item Material Code Description Qty

10 CO055660PL40PP 2*2 Print 40" Pro Print 2500

20 CO055660PL40DP 2*2 Print 40" Dis Print 3000

30 CO056864PL48PP 2*2 Print 48" Pro Print 1500

40 CO056864PL48DP 2*2 Print 48" Dis Print 3000

Once its goes to production Department after finished that material it should be packed into Bales as for the Customer Requirements. From the above example, 10000 meters is divided into 15 bales. Every bale doesnu2019t carry same meters i.e. meters differ from Bale to Bale. Whenever Bale is packed, say 5 Bales, that time they will raise the Commercial Invoice for 5 bales. Like this they have to raise multiple Commercial Invoices for single Order. Now i am giving example how they packed for the above sales order into BALES so based on that we will get some clarity

BALE No: 1201

Item Material Code Description Qty

20 CO055660PL40DP 2*2 Print 40" Dis Print 1200

30 CO056864PL48PP 2*2 Print 48" Pro Print 600

40 CO056864PL48DP 2*2 Print 48" Dis Print 600

BALE NO: 1202

Item Material Code Description Qty

10 CO055660PL40PP 2*2 Print 40" Pro Print 1000

20 CO055660PL40DP 2*2 Print 40" Dis Print 800

30 CO056864PL48PP 2*2 Print 48" Pro Print 400

40 CO056864PL48DP 2*2 Print 48" Dis Print 1200

BALE NO: 1204

Item Material Code Description Qty

20 CO055660PL40DP 2*2 Print 40" Dis Print 500

40 CO056864PL48DP 2*2 Print 48" Dis Print 800

BALE NO: 1205

Item Material Code Description Qty

10 CO055660PL40PP 2*2 Print 40" Pro Print 300

40 CO056864PL48DP 2*2 Print 48" Dis Print 400

Note: once they sent the Commercial invoice to the customer at the time of delivery or before delivery they want to change the Price of that particular Commercial Invoice and also in the Invoice and Delivery level they want to select the Bale number only.

According to the Above BALE example that meters will be increased or decreased due to some problem is production (elongation or shrinkage).

Note: order is not in bales but coming to the Delivery they will raise the Delivery Document Based on the Bales (as per Bale packing slip). So in that case single line item / multiple line items in the sales order is divided into multiple line items/ Single Line items as per the bales in the Delivery. After that they raise the Excise invoice Based on the Commercial Invoices (only Delivered Quantities).while they raise the Excise invoice that time they want to enter the Assessable Value manually for the grey Material.

After Completion of Production Sometimes the quantity wil be reduced or increased (elongation or shrinkage).So in that case how we are going to handle this Situation (we have to Track that is also). At the time of sales order they will check the Grey material how many meters they will receive from the Customer. That time we will come to know that whether grey we have received exactly or not. For above Example order is 10000 meters may be we received Grey 9000 meters. After production completion its goes again 8900 meters or 9100 meters

Here one more problem is there due to some problems in the production, for example out of 15 BALES they will charge 14 BALE price and remaining one BALE free in the same delivery

At the time of delivery they will select multiple sales order for those customer and they will do single delivery