web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Sell/Reserve Items w Serial Nos from items residing in "On Water" Location

(0) ShareShare
ReportReport
Posted on by 52
USECASE:
 
User wishes to create Purchase Order for Item(s) and receive Purchase Order item(s) into Location /On Water/
Location /On Water/ represents overseas shipment from EU to US.
Receiving the Purchase Order Item lines into location /On Water/ now lists the items in inventory in location /On Water/
Once overseas shipment has arrived at US shores and is received at US location, a transfer order (direct) will be performed to move inventory from /On Water/ to /Main/.
Location /Main/ represents single US shipping area of business/warehouse.
No Sales shipments will ever occur from location /On Water/.
Sales wish to create a Sales Order for Items while they're literally on the water whilst being shipped/in BC inventory located in Location /On Water/.
Added to this use case is the desire to use Serial No tracking and have the Salesperson, when creating the Sales Order, select serial no's from the /On Water/ location item(s) for the Sales Order line item reservation.
 
QUESTIONS:
 
It appears you can only perform the above Sales Order reservation if you've performed the following steps...is this accurate?
  1. Create and post/receive the PO to location /On Water/
  2. Create new transfer order (direct) from Location /On Water/ to location /Main/ and use ribbon menu - /Prepare/ - /Get Receipt Lines/ to add the PO Receipt lines to the transfer order.
  3. Do no post transfer order yet (keep it in this staged un-posted state as literal shipment if still on ship on the water.
  4. Create new Sales Order for items that exist on PO Line(s) that are currently ONLY available in location /On Water/ as location /Main/ has no stock.
  5. Leave Sales Order Item Line Location set to /Main/.
  6. Use Line ribbon menu - /Line/ - /Functions/ - /Reserve./
  7. Pop-Up windows /Reservation S-ORDXXXXX/ shows lies /Item Ledger Entry = 0/ and /Transfer Line, Inbound = XXX/
  8. You can select the /Transfer line, Inbound/ and assign/reserve the quantity needed for the Sales Order here.
 
At what stage do serial nos. get created so they persist and are made available to the salesperson to select from when creating the sales order reservations?
 
If you're still reading this I appreciate your time and equally appreciate all/any guidance to achieve this use case correctly.
 
Cheers~Peter
 
 
 
 
 
I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    6,396 Super User 2025 Season 2 on at
    Sell/Reserve Items w Serial Nos from items residing in "On Water" Location
    Your steps are correct.  The Planning Worksheet can help a lot with your process.  The demand (sales/stock level/forecast) can trigger replenishment to Main (Transfer from On Water).  The Transfer demand at On Water can trigger the PO to the Vendor.  If your Sales are using Lot-for-Lot or Order Policy, the Order Tracking will show the reservation to the supply.  This can reduce your document creation steps, but you'll still need to manage those documents.
     
    Your Sales Order would only be able to reserve against the Transfer Order, since it is what is supplying the Main location.
     
    Reservations are made to overall Quantity, not to a specific Serial Number.  Since there is a chance of damaged items, you really don't want to restrict to a specific Serial Number.  Whatever Serial Number is picked/packed/shipped is normally entered during that process.
     
    Hope this helps or at least provides some confirmation on process.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Verified answer
    Jun Wang Profile Picture
    8,182 Super User 2025 Season 2 on at
    Sell/Reserve Items w Serial Nos from items residing in "On Water" Location
    to be able to reserve against serial nos, you need to set up the item tracking code for that item.
    you won't be able to assign item tracking to an item that already has transactions posted. I'm talking about a new item. 
    once the items are received, user need to specify the serial no. to receive those into stock.
    then user creates a transfer order to move those to your main location.
    Since the transfer is an inbound supply, you'll be able to reserve a sales order against it. 
    BC knows you are reserving against a tracked item and you will be able to pick the serial no. to reserve the items.
     
    Jun Wang
  • PC-29042243-0 Profile Picture
    52 on at
    Sell/Reserve Items w Serial Nos from items residing in "On Water" Location
    @jun wang @ben baxter , Thank you both very much for your replies and guidance. Your responses help immensely in clarifying the process and my understanding.
     
    Cheers~Peter

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,327

#2
Sumit Singh Profile Picture

Sumit Singh 2,734

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,599

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans