Dynamics Community Forum Thread Details

Record new Expected Receipt Date in PO lines and keep a record of the original date

Hi,

In the Purchase order lines on a PO we want to record the following...

The order date
The anticipated delivery date - that's my terminology not BC terminology (we currently use the BC field "expected Receipt Date")
If the anticipated delivery date passes (without receiving the Item or GL line), then we want to allow the user to enter a new anticipated delivery date, without loosing a record of the original date.

I am not sure which date field/s to use to achieve this (Order Date, Promised Receipt Date, Planned Receipt Date, Expected Receipt Date, Requested Receipt Date)

Note we always want to forward calculate the date/s

At present...

We have Vendors setup with a "Lead Time Calculation" and a "Base Calendar" (some also have a “Customised Calendar”)

We don't use "Safety Lead Time" or "Inbound Warehouse Handling Time" and therefore "Planned Receipt Date" and "Expected Receipt Date" are the same date.

To achieve point 3 above, I tried overtyping the automatically populated "Expected Receipt Date" but BC is then backward calculating the "Planned Receipt Date" along with the (purchase order line) "Order Date" I don't want this to happen (or maybe I need to use other date fields to achieve the same result???)

In short I don't want to lose a record of the original Order Date or the original anticipated delivery date (point 2 above)

Is there a way to achieve this???

Any help will be greatly appreciated. Thanks.

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS