AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
BOM Materials Updat...
 
Notifications
Clear all

Questions BOM Materials Update Import Scenario

 
Everything Else
Last Post by Paul Lambert 4 months ago
2 Posts
2 Users
1 Reactions
537 Views
RSS
Hazen Metro
Posts: 31
 Hazen Metro
Topic starter
November 6, 2024 9:33 am
(@hazenm)
Eminent Member
Joined: 5 years ago

Hey everyone! Hoping I can get some help with an import scenario I can't seem to get working. 

The goal of the scenario is to update the scrap factor on specific materials across our bill of materials. 
This means we have to target the BOM, Revision, Operation, Material, then update Scrap Factor. 
I am able to target BOM, Revision, Operation, but I cannot figure out how to target Material. For many of our BOMs we only have one material per operation, so in those cases I can take this scenario and run it without the @@Inventory ID line and it works perfectly. For any operation with more than one inventoryID it's only going to update line one. Has anyone had success with this before? The @@Inventory ID does not target for some reason. I tried also @@Line Nbr and Line Nbr. I tried <key: external> but nothing seems to work. 
We are running 24R1, so a lot of things in manufacturing has changed. I wouldn't be surprised if it's a 24R1 bug.. Here's my scenario as is: 

image

Again, if I remove the Materials: @@Inventory ID line, it works perfectly in those specific cases. 

1 Reply
Paul Lambert
Posts: 4
 Paul Lambert
March 17, 2025 2:43 pm
(@plambert)
New Member
Joined: 4 months ago

The error in your import scenario is, unfortunately, just a typo. Changing '@@Inventory ID' to '@@InventoryID' (no space) will work.

When using the @@<Field> to perform a lookup, the field name must match the database name exactly. 

 

I hope this helps to smooth out the process!

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,521 Topics
  • 10.9 K Posts
  • 14 Online
  • 2,321 Members
Our newest member: Courtney Wilder
Latest Post: Can UDFs be populated using an Import Scenario?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×