Skip to main content
Solved

Import PO receipts with Lot numbers

  • Jul 20, 2026 9:30 PM UTC
  • 8 replies
  • 135 views
  • Translate All

jbuddecke71
Varsity I
Forum|alt.badge.img

I have a working import scenario that imports purchase receipt, but when there are multiple receipts for the same PO line number with different lot numbers then only the last receipt for that line is imported.

Any ideas?

 

Best answer by mohammadnawaz51

​@jbuddecke71 See the below steps.

 

View original

8 replies

  • Freshman II
  • Aug 10, 2026 2:05 PM UTC

In your statement, you are referencing that you are doing multiple receipts against the same PO line but if you are importing a receipt, the line reference is to the receipt and should be different.  You may need to reference the PO line and the receipt line so the import scenario sees there is a 1 to many relationship  

Translate

bwhite49
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Aug 10, 2026 4:46 PM UTC

Try an import similar to this one. You need to update the line split table

 

 

Translate

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@jbuddecke71 

You can use the below information to import lot serial details using the below article.

 

 

Please let me know if you need for purchase receipt.

Translate

jbuddecke71
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • Aug 10, 2026 5:36 PM UTC

​@mohammadnawaz51 That would very helpful if you have it for PO receipts. Attached is desired import file format.

Translate

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@jbuddecke71 See the below steps.

 

Translate

jbuddecke71
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • Aug 11, 2026 8:22 PM UTC

Thanks. That is very helpful. It is very close to what I need.

Translate

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@jbuddecke71 Thank you for the confirmation.

Translate

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@jbuddecke71 do you see any issues? 

Translate