-1

I want to create mass PO automation. The problem is my PO quantity in my Excel file is 75, 4, 10 but in SAP ERP it rounds up to 80, 10, 10.

I have tried changing the format of the Excel column to numbers, does not work either.

I need SAP ERP to not round up the quantity.

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Harvint Raj
  • 69
  • 1
  • 11
  • 1
    What is ME21N? What data type is `80,10,10`? It doesn't look like a number with the commas placed in these odd positions. You need to provide more information, so people who can't look inside your head will have a chance to understand what you're talking about. – teylyn Jul 05 '19 at 04:09
  • @teylyn ME21N is a tcode used in SAP. The number in commas which are placed in odd positions are a series of numbers. what i meant was 75 in excel shows up as 80 in SAP, 4 in excel shows up as 10 in SAP. – Harvint Raj Jul 05 '19 at 04:42
  • We had some pretty strict rules that SAP GUI Scripting was only to be used to extract data and never to write to SAP. It came about because of these anomalies that subsequently made it really difficult to trace and correct. Is there another way you can do it like a bulk upload template? I know we had one for work scheduling and time confirmations. – Josh Jul 05 '19 at 05:51
  • I don't see the connection to Excel. You need to explain what ME21N is and how it is calculated if you want the same calculation to be performed in Excel. It seems t me that this question is more about SAP than about Excel. -- Also, please don't post answers to your own question if you don't have an answer. This is not a chat forum. You may want to take the [tour] and learn [ask]. – teylyn Jul 05 '19 at 09:40

1 Answers1

0

Well in SAP it only round up the first time when you run the script. Just add a custom code in your process to input the quantity the second time. It will be overwritten the first time, but never the second time.

Harvint Raj
  • 69
  • 1
  • 11