where can I get expiration get from?
where can I get expiration get from?
Thanks Alfredo. I'll try this and update on the forum.
Thanks ZHU YUN I appreciate that.
Thanks for checking.
I have tested a couple of scenarios and it looks like the reservation entry does not include the expiration date when the source is a sales line.
In my example I was looking at the reservation entry for a purchase line.
I guess it's because of the Late Binding design. learn.microsoft.com/.../design-details-item-tracking-and-reservations
The only option then is to use item ledger entries and lookup the expiration date based on item number, location and lot number.
Hi, I tested it, and it is the same as Dipika, the expiration date is empty.
I'm not sure if this is a bug with the standard or only in the BC22.1 version. Hope other experts can give you better advice.
Thanks.
ZHU
Expiration date should be populate on the reservation entry table.
Maybe you have an extension installed that affects that field? If you have inventory with an expiration date for that lot number you might want to use the Item Ledger Entry table as a lookup in your report. You should have the expiration date there.
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156