Skip to main content
Solved

Lot & Serial Numbers

  • 12 September 2024
  • 3 replies
  • 87 views

ngerst
Freshman II
Forum|alt.badge.img

I am trying to generate a list of lots or serial numbers that are currently on the Production Order. I have AMProdItemSplit in the Production ticket at this time but I can only seem to get one Lot or Serial number to print. 

This is my first time trying to print a collection of data and I am try to determine the best way. Anyone have any pointers or help articles for this? Attached is my rpx as well. 

Best answer by aiwan

@ngerst 

 

For your join on your schema, try joining on OrderType = OrderType, ProdOrdID = ProdOrdID.

And try the join type as Inner.

 

Aleks

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

3 replies

Forum|alt.badge.img+7
  • Captain II
  • 292 replies
  • September 17, 2024

hi @ngerst 

 

Looking at the DAC schema browser, it doesn’t use a lot number until the production order is moved & inventory consumed at which point the lot nbr is allocated.

 

Aleks


ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 37 replies
  • September 18, 2024

They are assigned on a Production Order on the Line Details tab. I can capture the first lot or serial that is listed but I can’t seem to figure out how to get the full list pulled into my Production Ticket. 

 

 


Forum|alt.badge.img+7
  • Captain II
  • 292 replies
  • Answer
  • September 18, 2024

@ngerst 

 

For your join on your schema, try joining on OrderType = OrderType, ProdOrdID = ProdOrdID.

And try the join type as Inner.

 

Aleks


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