Stop double receiving of items

Business Central/NAV
1

Hi All,

First time post so go easy on me.

Our current process to receive goods requires us to receive goods into an Intransit location so that we can transfer order out and display an Intransit qty on the system. We are also using clever landed containers for costing so receive goods via a warehouse receipt. We as a company pay for goods upon receiving a B/L so we need to raise a purchase invoice before receiving the goods from the transfer order. The issue comes with creating a purchase receipt from receipt lines, posting to the G/L and Item Ledger now means we are receiving the same goods twice.

Is this a posting setup error?
How can we fix this?

2

Hi Brad,

This is a really common requirement. Here is the set of transactions that I would recommend.

  1. Create a PO with a Location Code that is a “Virtual” location at the port of origin (eg: Singapore)

  2. Post the receipt of goods on the PO with a Purchase Shipment to Virtual Location

image
image609×248 10.3 KB

  1. Use a Transfer order to ship those goods from the Virtual Location to your real facility.

  2. Post the invoice against the same PO.

image
image581×226 7.14 KB

Now the inventory only shows up once on the first posting (The Receipt posting) and the invoice posting will not double the inventory.

You would post The Transfer Order shipment and it would remove inventory from the Virtual Location and it’s now on a boat heading towards you.

Does that help?

Thanks,
Rob

1 Like
3

Perfect, thanks Rob.

This is our process. Turns out item lines were manually entered onto the purchase invoice not through ‘Get receipt lines’.

Thus causing the error to occur.

Thanks for the response!

4

Glad I could help!

Apparently I have to write a bit more to send … :smile: