Skip to main content
Answer

Lot/Serial History Report

  • June 6, 2025
  • 4 replies
  • 79 views

Forum|alt.badge.img

Hey everyone,

Quiet some time ago I found this fantastic report that showed a lot tracked item and every transaction (sales order, receipt, production order etc) with it’s lot number. It was FANTASTIC and I can picture it but I can’t find it in ACU hoping someone can rattle off the name of it with that very vague description. I know the report lines were collapsible and expandable and there were some icons/images on the report. *sigh* Anyone have ANY ideas?

Best answer by bodiec

Hi ​@SBaldwin 

I have a GI that I created to show me similar transactions and actually have links to the receipts/production orders/adjustments.

 

However it does not have Sales Order Links on it,

 

It looks like this, with the Inventory ID filter at the top, and a date span filter:

 

Do you know how to import XML files for new Generic Inquiries?

I have attached the xml file if you would like to use it.

4 replies

valentynbeznosiuk
Jr Varsity I
Forum|alt.badge.img+3

Hi ​@SBaldwin 

Based on the first part of your description, I thought about ‘Inventory Transaction History’ [IN405000],  but I’m not sure if the second part of the description is suitable for it. Please try it and let me know if that's the one you were looking for.


Forum|alt.badge.img
  • Author
  • Varsity I
  • June 9, 2025

This could be a piece of the puzzle! But now I also need to figure out the lot/serial numbers that went into making a manufactured item.


Forum|alt.badge.img+1
  • Semi-Pro II
  • Answer
  • June 9, 2025

Hi ​@SBaldwin 

I have a GI that I created to show me similar transactions and actually have links to the receipts/production orders/adjustments.

 

However it does not have Sales Order Links on it,

 

It looks like this, with the Inventory ID filter at the top, and a date span filter:

 

Do you know how to import XML files for new Generic Inquiries?

I have attached the xml file if you would like to use it.


Forum|alt.badge.img
  • Author
  • Varsity I
  • June 10, 2025

thank you! I will upload the XML files to see if that suits our needs thanks!