You’re offline. This is a read only version of the page.
145
Hello Everyone, I'd just like to ask if there's an easy way to import/create build of materials (cards) for around 3000 items. I've tried doing this through macro but it seems that the scroll grid cannot be done through macro. This doesn't seem to be available through intergration manager too. Is there a script for this I can use? Thanks!
*This post is locked for comments
Hi Mahmoud,
Thanks for the tips! I prefer using the table import as it seems to be working well (and fast). Ive already uploaded some bom items and my only problem left is the note index. I checked the note index of the bom tables and its all set to 0.00. Tried the script youve sent me but it increments to 1 whenever i run it. What table that has note index does the script update? How should i use it? Should i just run it to get the latest note index to use it as a reference and just manually update it through the backend? (Ex. Note index 1,2,3,4,5 and so on).
Thanks!
sp_getNextnote is a stored procedure which you call to retrieve the next note index. Please refer to the post below;
Just for reference, as for the Macro method, the scroll grid can be done. You need to take into consideration the "Lines" issue, Window grid is limited to a certain number of lines. Let's consider the inventory transaction window as an example, The macro should go as follows;
After Line Item (0)
After Line Item (1)
After Line Item (2)
After Line Item (3)
After Line Item (4)
After Line Item (5)
Please consider that any line after five will still have the serial (5), with the Scroll command.
Your feedback is highly appreciated in order to dig for further details if required.
I was able to read this post and it seems to be working:
community.dynamics.com/.../import-inventory-bom.aspx
However, I cannot find the sp_getNextnote stored procedure. Does this exist? Also, what parameters should I pass on?
Thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (