Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lewis Rosenberg]

?Hello Everyone,

I was testing out the Whse. Reclass. Journal and the Item Reclass. Journal  to change Lot Expiration Dates using #NAV2013R2 and discovered that all of the inventory for the Item/Lot combination MUST be in the same bin.

I just wanted to check in to see if I am missing something or if this is really a prerequisite for changing a lot expiration date.

#Warehouse Manager
#Inventory Management

????

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————

[Allen Hoover]

I have never used the Reclass journal in this way.  We had our partner create a report that will allow changing of expiration dates for lots of any item.  Get in touch with me perhaps we can provide you some information on the report we had created.

——————————
Allen Hoover
Supply Chain Material and System Manager
Jason Pharmaceuticals (Medifast)
Owings Mills MD
——————————
——————————————-

[Kirk Southcott]

Hi Lewis. That’s apparently ‘by design’ when I reported the Issue to the NAV Dev team.  We ended up creating a report to change the date in the various tables.

——————————
Kirk Southcott
Project and Customer Engagement Manager
Beck Consulting
Los Angeles CA
——————————
——————————————-

[Lewis Rosenberg]

?Thanks for the replies.

and , our partner provided us with a page a while back that enables me to go in and manually change expiration dates in the item ledger entries.  I prefer to let our users do it in a more standard way, but then discovered the bin issue.

I also noted that changing the expiration date using the Whse Reclass Journal and Item Reclass Journal (and also my special page from our partner) only change the item ledger entries, but not the warehouse entries.  That has never seemed to cause a problem, although my obsessive compulsive tendencies make me uncomfortable whenever data in two different areas on the system do not match.

???

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Kirk Southcott]

Hi Lewis, The expiration date also needs to be updated in warehouse entries, tracking specification entries, and reservation entries (along with item ledger).

——————————
Kirk Southcott
Project and Customer Engagement Manager
Beck Consulting
Los Angeles CA
——————————
——————————————-

[Val Gameiro]

A report to update both tables may be your best bet!

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma
Austin, Texas
——————————
——————————————-

[Lewis Rosenberg]

?I just took a close look at our customized page and it is updating Warehouse Entries also!  It is not, however, looking at Tracking Specification or Reservation Entries.  I don’t think my license will allow me to change that, so I will discuss that with our NAV partner.

Thanks!

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-