What date fields NAV gives you for transfer orders
NAV (Microsoft Dynamics NAV, now called Business Central) stores several date fields for transfer orders, and which one you use depends on what you're tracking: when the order was created, when it's supposed to ship, when it actually shipped, or when it's supposed to arrive at the receiving location. The main fields are Document Date, Posting Date, Shipment Date, and Receipt Date. Each one controls different parts of your inventory and financial records.
Understanding which field does what matters because using the wrong date can throw off your stock counts, your general ledger, and your ability to find orders later. If you're moving inventory between locations on a wired network (which you arrived here to learn about), the dates you set in NAV determine when that movement shows up in each location's records.
Key Takeaways
- Document Date is when you create the transfer order in NAV and is mainly for record-keeping and sorting.
- Posting Date is the date NAV uses to record the movement in your general ledger and inventory, and it controls which accounting period the transaction belongs to.
- Shipment Date is when you physically send the goods from the sending location, and NAV uses this to reduce inventory at the source.
- Receipt Date is when the receiving location expects to get the goods, and NAV uses this to add inventory at the destination.
- You can set these dates independently, so a transfer ordered on Monday can ship on Wednesday and arrive on Friday, with each date recorded separately.
Document Date and what it controls
Document Date is the date you assign when you first create the transfer order. NAV defaults it to today's date, but you can change it to any date you want. This field is mainly for your own reference and for sorting — it's the date that appears on the transfer order printout and in your document lists.
Document Date does not affect inventory counts or the general ledger. It's purely a label. You might set it to the date you physically counted the goods, or the date a manager approved the transfer, or the date you received the shipping request. The choice is yours and won't break anything downstream.
Posting Date and its effect on accounting
Posting Date is the date NAV uses to record the transfer in your general ledger and to determine which accounting period the transaction belongs to. If you post a transfer order with a Posting Date of March 15, that transfer shows up in your March financials, even if you actually ship the goods in April.
This matters because your accountant relies on Posting Date to close out each month. If you post transfers with dates from the wrong month, your inventory and cost of goods sold will land in the wrong period. Most companies set Posting Date to the date they actually post the order in NAV, which is usually the date they ship or the date they process the paperwork.
You can post a transfer order with a Posting Date that's in the past or future, as long as that period is still open in your fiscal calendar. If the period is closed, NAV will reject the post and ask you to choose an open period instead.
Shipment Date and when inventory leaves the source location
Shipment Date is when the goods physically leave the sending location. NAV uses this date to reduce the inventory balance at the source location. If you set Shipment Date to tomorrow but post the order today, the inventory disappears from the sending location today, even though the goods don't leave until tomorrow.
In practice, most companies set Shipment Date to the same date they post the order, or they leave it blank and NAV defaults it to the Posting Date. If you need to track goods that are packed but not yet shipped, you can set Shipment Date to a future date and post the order now — the inventory will stay in the sending location until that future date arrives and you post the shipment.
Receipt Date and when the receiving location gets the goods
Receipt Date is when the receiving location expects to receive the goods. NAV uses this date to add inventory to the destination location. Unlike Shipment Date, which removes inventory from the source, Receipt Date adds it to the destination.
If you set Receipt Date to three days after Shipment Date, the goods will be in transit (not counted at either location) for those three days. Once Receipt Date arrives and you post the receipt, the inventory appears at the receiving location. This is useful if you want to account for goods that are physically moving between locations and shouldn't be counted as available at either end until they arrive.
How these dates work together in a real transfer
Here's a concrete example: you create a transfer order on Monday to move 100 units from Warehouse A to Warehouse B. You set Document Date to Monday (the day you created it), Posting Date to Wednesday (when you'll actually process it), Shipment Date to Wednesday (when the goods leave Warehouse A), and Receipt Date to Friday (when Warehouse B expects them). When you post on Wednesday, NAV records the transaction in Wednesday's accounting period, removes 100 units from Warehouse A's balance, and adds them to Warehouse B's balance on Friday. Until Friday, those 100 units are in transit and don't show up in either location's available inventory.
If you're using a wired network to sync inventory between locations in real time, these dates become even more important because the network will push the inventory changes to each location's system as soon as you post. Setting the dates correctly ensures that each location's records stay in sync with the physical goods.
Common mistakes with transfer order dates
The most common mistake is setting Posting Date to a date that's already closed. If you try to post a transfer with a Posting Date from last month and last month's books are already closed, NAV will reject it. Always check your fiscal calendar before you post.
Another mistake is leaving Receipt Date blank when you mean to track goods in transit. If Receipt Date is blank, NAV defaults it to Shipment Date, so the inventory appears at the destination location on the same day it leaves the source. If you need a gap between shipment and receipt, you have to set Receipt Date explicitly.
A third mistake is setting Shipment Date or Receipt Date to a date before Posting Date. NAV allows this, but it creates confusion because the inventory movement appears to happen before the order was posted. Most companies avoid this by setting all dates to the same day or in chronological order (Document Date, then Posting Date, then Shipment Date, then Receipt Date).
Frequently Asked Questions
Can I change the dates after I post the transfer order?
No. Once you post a transfer order, the dates are locked in. If you need to correct a date, you have to reverse the posted transfer (which creates an offsetting entry) and post a new one with the correct dates. This is why it's important to get the dates right before you post.
What happens if Shipment Date is after Receipt Date?
NAV will let you set Receipt Date before Shipment Date, but it creates a logical problem: the goods arrive before they ship. Most companies avoid this by keeping dates in order. If you do set them out of order, the inventory behavior depends on which date you post first, so check your inventory balances carefully.
Do I have to use the same date for Posting Date and Shipment Date?
No. You can post a transfer order (Posting Date) on one day and ship the goods (Shipment Date) on another. This is useful if you want to record the transaction in accounting before the goods physically leave, or if you're preparing the order in advance and will ship it later.
What if my fiscal period is closed and I need to post a transfer from last month?
You'll need to ask your accountant or system administrator to reopen the period, or you'll need to post the transfer with a Posting Date in an open period and accept that it will show up in the wrong accounting month. Most companies have a policy about this — check before you proceed.
Does the date format matter, or can I use any format NAV accepts?
NAV accepts dates in whatever format your regional settings specify (MM/DD/YYYY in the US, DD/MM/YYYY in the UK, and so on). As long as you use a format NAV recognizes, it will convert it correctly. The important thing is to be consistent so you don't accidentally enter a date in the wrong month.