Tuesday, October 29, 2019

Dynamics NAV / Business Central - How to post Duties for Landed Costs before receiving goods at warehouse

https://www.navug.com/communities/community-home/digestviewer/viewthread?MessageKey=a0bc75aa-84ab-40e2-8e2a-afcc6d4946ed&CommunityKey=95503735-5a0b-4af1-8326-9bd7bb3b4d3d&tab=digestviewer



  • Create a "DOCK" location to represent stock that has not arrived at your warehouse as yet
  • "DOCK" location is connected to your Goods in transit account
  • "WH" location should be set to require receive
  • All PO's are done to the DOCK location
  • Container Lands on dock
    • Post PO>Receive and Invoice
    • PO is received to the "DOCK" location
    • This immediately receives stock, and generates the invoice for the full amount
    • PO is closed and removed
    • If you are using lot or serial tracking, this will only work if you are aware of the lot and serial information in advance. Any differences would need to be handled as stock count adjustments after completing the full receiving process at the WH.
  • Landed Costs are entered and applied to the received PO lines
  • Transfer order is prepared
    • Tick Direct Transfer to default the Qty. to Ship and Qty. to Receive
    • Actions>Functions>Get Receipt Lines>Clear Location Filter
    • Add all lines from the receipt to a transfer order
    • Transfer order is updated with actual dates when container is picked up from the DOCK and delivered to the warehouse
    • Any additional charges can added on the transfer as well if required, but for simplicity all charges should have been applied after the initial receiving if possible
    • When goods arrive at warehouse 
      • Unstuff container and count goods received
      • On Transfer order, Adjust Qty. to Ship to actual count 
      • Post Transfer
      • Overs
        • Additional lines need to be added to the original PO, Received and transferred to WH
        • OR Adjusted into stock in a separate transaction as a stock count variance
      • Shortages
        • Any shortages will be left in the DOCK location
        • Reopen and delete the transfer order
        • Purchase Return>New>Enter Vendor>Process>Get Posted doc Lines to Reverse>Select PO Lines
        • By default, the remaining quantity in DOCK will be entered on the return line
        • Enter Return Reason code "Shortage"
        • Process>Apply entries (If this should be applied immediately)
        • Post>Ship and Invoice
Otherwise, if you are not keen on the idea of receiving stock to a dock location
  • You must receive the goods first, then apply landed costs
  • You can create the separate landed cost invoices beforehand, but you cannot apply or post them until after the goods are received.
Transfer process details

No comments:

Post a Comment