Skip to main content
Solved

Printing Split Lot Code Inventory Labels from Line Detail Screen in Purchase Receipt


mike2665
Jr Varsity III
Forum|alt.badge.img

In our receiving department we print out receiving labels for ingredients used in production. We normally receive Cases, Pallets, Bags….etc. and we generate an inventory bar coed label to apply to the container. On the Purchase Receipt I have 1 line item on the PO for 4.44 kg. The product is delivered in 5 separate containers 4 - 1 kg and 1 - .44 kg. I select the Line Detail in the Purchase Receipt and add my 5 containers with the lot code and quantity of each. The current bar code Inventory Label is printing from the PO Receipt Line quantity, (ex. 4.44 kg of product) How do I set this up to print a label for each line in the Line Details screen in Report Designer? See image.

 

Best answer by lauraj46

Hi @mike2665 ,

You are on the right track as I can see in your screenshot that you have already identified the data access class which needs to be added to the Report Designer schema, namely POReceiptLineSplit. 

In the report schema, join POReceiptLine to the POReceiptLineSplit by ReceiptNbr and the LineNbr. 

LotSerialNbr is a field on the POReceiptLineSplit table which you can use as needed on the report.

Hope this helps!

Laura

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

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 564 replies
  • Answer
  • March 29, 2023

Hi @mike2665 ,

You are on the right track as I can see in your screenshot that you have already identified the data access class which needs to be added to the Report Designer schema, namely POReceiptLineSplit. 

In the report schema, join POReceiptLine to the POReceiptLineSplit by ReceiptNbr and the LineNbr. 

LotSerialNbr is a field on the POReceiptLineSplit table which you can use as needed on the report.

Hope this helps!

Laura


mike2665
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 19 replies
  • March 30, 2023

That worked, my Parent / Child join was wrong. Thank you so much for your quick response. This will now give us an opportunity to split the PO Receipt line when multiple cartons are received. This way I can have an inventory label on each carton with the correct quantity within the carton

@mike2665 


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