Skip to main content
Solved

Lot & Serial Numbers

  • Sep 12, 2024 12:58 PM UTC
  • 3 replies
  • 376 views
  • Translate All

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

3 replies

Forum|alt.badge.img+11
  • Captain II
  • Sep 17, 2024 10:40 AM UTC

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

Translate

ngerst
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • Sep 18, 2024 1:32 PM UTC

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. 

 

 

Translate

Forum|alt.badge.img+11
  • Captain II
  • Answer
  • Sep 18, 2024 2:11 PM UTC

@ngerst 

 

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

And try the join type as Inner.

 

Aleks

Translate