156
Hello, we are using an onprem BC W1 16.19 and need some spoonfeeding around the PO module particular around dates - can anyone give us some pointers on where to look for info on where/how to input the expected delivery date which comes from the supplier on order confirmation and if there is a field to input the actual delivery date/goods recvd date ? can it be done via a configuration package? thank you.
As Inge said, you should use the purchase receipt line table. Table ID 121
That depends. Normally you would use table 121 Purch. Rcpt. Line
You cannot use the configuration package to update the actual receipt date of your PO lines.
That's because once you have received the goods there is little you can change on the purchase lines.
I would use the expected delivery date in the PO header and, use the posting date as the receipt date when you receive the order.
The posting date of your purchase receipt will be copied to the Item ledger entries, therefore, that should be the actual receipt date.
There is no standard feature to copy the posting date of a purchase receipt to the PO. Mainly because quantities from one PO can be received with many purchase receipts over time.
You can get visibility of purchase orders expected delivery date and actual receipt date through a report or a PowerBI dashboard. You Only need two tables, PO lines and purchase receipt lines.
The correct sequence to use the dates is as follows.
Requested receipt date is when you are initially requesting the goods from the supplier.
Promised receipt date is the date you add when the supplier order confirmation is received.
Expected receipt date is then updated with any further changes to expected receipt.
You then have an auditable set of dates for what you requested, were promised and expected.
Note the following, Expected receipt date is the most important date as this is when the materials are usable. This date is updated on the line when you change the other dates.
There are dates on both the header and lines. Updating the header can also update the lines if you allow it to. If you have multiple delivery dates on one PO, you must manage the dates on individual lines. Amending lines dates does not update the header dates.
if you have inbound goods handling times, this will delay the expected receipt date vs the planned receipt date.
You could update these by config pack but that would be unusual. If you have large confirmations covering lots of orders and lines an integration may be worthwhile. Otherwise, doing it manually is probably as efficient as messing with imports.
Hi,
At the time of creation of PO you can easily put the difference kind of PO dates see below.
Also in the line level you have different date when you are planning or expecting goods to be received.
After putting all of those dates, when you had actually received the goods, now the time is post the PO, and After the Posting you will see that your inventory just got updated and you have actual receipt date as your Posting date in Posted Purchase Receipts.
All you dates to be modified you can use configuration pages, but make sure all the PO should be in open state and carefully, also you can use Edit in excel functionality but only in the Line level
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
