Skip to main content
Solved

BOM Export - First Line Material ID and UOM incorrect for every assembly

  • November 20, 2022
  • 3 replies
  • 107 views

When I try to export BOM, the first line of each Assembly shows the same incorrect Material Component ID and UOM;   The second line on to the last line is correct;  It’s only the first line, and only these two fields that are incorrect with the same incorrect value each time.  I’m assuming maybe I need to use some kind of offset to fix?  Any advice would be appreciated!

Acumatica Job Setup
output file from job example

you can see the yellow highlighted blocks are always the same item ID and UOM, but the second row on is 100% correct;  Quantity on the first row is correct.   This is the same for all 9,000+ BOM Assemblies exported in this report so a manual fix would be quite difficult.

Any idea’s on what I’m doing wrong here?

This is the form for the first item in the example, you can see what I’m expecting 001-201 item id;  

 

Best answer by Laura02

Hello,

I noticed a previous post on this community that includes several export scenarios for BOMs.  Import the solution’s export scenario for comparison to yours.

https://community.acumatica.com/manufacturing-89/bom-export-scenario-3693

 

 

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • November 21, 2022

Hello,

I noticed a previous post on this community that includes several export scenarios for BOMs.  Import the solution’s export scenario for comparison to yours.

https://community.acumatica.com/manufacturing-89/bom-export-scenario-3693

 

 


  • Author
  • Freshman III
  • 4 replies
  • November 22, 2022

Thank you Laura.  The post was able to help me get a working export configuration I believe.  I have attached my XML for future reference for whoever needs it for themselves.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2759 replies
  • November 22, 2022

Thank you for sharing this with the community @pitsnake !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings