I am trying to copy the item No from excel, word or google etc etc and paste in sales line (No) and item lookup dont work. When I put the item no manualy the item loopkup work. Can you help me please ?
Dirk,
I copied the number below from a PDF and pasted into the Item Search and it works.
Do you have the PDF I can test?
Thanks,
Steve
Steven,
I have the same issue for purchase orders:
I get a PDF where I can copy 1 article number from the PDF and want to paste it in the search box for the Item number
This works fine in the desktop version but does not work in the web client version.
In the web client I have to type manually the item number.
It is no option for me to copy the item number from the PDF,
paste it into an excel that has mimics the item line
and then copy the excel line
to paste it as a line in BC.
Is this a bug?
Best regards,
Dirk Verliefden
Besian,
I think I follow but could be lost here... I can create a Copy/Paste from Excel with dozens of rows of Item Numbers and copy them all in at once and it populates the description field automatically on insert. Your video shows you copying an Item No. missing the last few fields and yo are expecting the No. field to open the list up. Yes? I think yes. I don't think this is possible since copy/paste is more fixed meaning it does not expect one wanting to pop-up the list to select.
Maybe you can create an Excel spreadsheet with the Item List full number and then copy the complete number.
Hope this helps.
Thanks,
Steve
Steven,
This is a solution if I have only one item with No. 1100 , but if I have many items that start with 1100 and have this inside the code., this does not work. So when I paste the item no 1100 in sales line need to open the lookup and to see all items items that start with 1100 and have this inside the code
I am showing you an example in attach:
[View:/cfs-file/__key/communityserver-discussions-components-files/758/2311.8e92ea19_2D00_29ef_2D00_486b_2D00_a2de_2D00_c1b4609fe4a7_5F00_oa3bl4uS_5F00_8bJF.rar]
I have many items that start with OX153 and have this inside the code. In the photo is when i write the code manually the lookup is ok, I see all the items that start with OX153 and have this inside the code.
Thanks,
Besi
Besian,
OK, I see. You want to copy an Item No. into the No. field on a Sales Quote. This is possible and it will populate the Item Description on paste.
I copied the 1100 from Excel.
Hope this helps.
Thanks,
Steve
95e73b17_2D00_9222_2D00_40d3_2D00_839f_2D00_e012df96da43_5F00_QrE2jA91_5F00_D0Wy-_2800_1_2900_.rar
Steven this is whatI want, to open item lookup when I paste item No in sales line.
[View:/cfs-file/__key/communityserver-discussions-components-files/758/Test-Copy-Paste.mp4:320:240]
Besian,
I am going to show you a video of this working using my Cronus Sandbox and Excel.
Hope this helps.
Thanks,,
Steve
Hello Steven,
thank for your answer but I am trying to copy only the item No from excel, word or google etc etc and paste in sales line (No) and item lookup dont work. When I put the item no manualy the item loopkup work.
Hello,
Let's say I want to Copy/Paste into Sales Lines whether 1 row or many, make sure the columns in Excel are the same as your Sales Lines:
Now on the Sales Line, you right click on the Type Item (shown below) and choose Paste:
Hope this helps.
Thanks,
Steve
#1
YUN ZHU
374
Super User 2025 Season 1
#2
Mansi Soni
247
#3
Gerardo RenterÃa Ga...
231
Most Valuable Professional
Share
Report
All responses (
Answers (
