Dynamics NAV - Recurring Methods

• Fixed
• Amount does not change after posting
• The value is split based on the rules set in the Allocations page in the Allocations button
• Variable
• Amount is reset to 0 after posting
• You need to manually re-enter a new value after every posting
• The value is split based on the rules set in the Allocations page in the Allocations button
• Balance
• Journals the balance of the account
• The value is split based on the rules set in the Allocations page in the Allocations button
• Reversing Fixed
• Same as Fixed, but reversal entry is also automatically posted to the next day after posting date
• Reversing Variable
• Same as Variable, but reversal entry is also automatically posted to the next day after posting date
• Reversing Balance
• Same as Balance, but reversal entry is also automatically posted to the next day after posting date

Document Description Formulas

• %1 – The current day number
• %2 – The current week number
• %3 – The current month number
• %4 – The current month name
• %5 – The current accounting period name
• Eg. RENT-%4

Date Formulas

https://www.clientsfirst-us.com/entering-date-formulas-in-microsoft-dynamics-nav/

• CM+1D first of next month

Dynamics NAV - How to reconcile Inventory to GL

https://www.archerpoint.com/blog/Posts/inventory-general-ledger-reconciliation-microsoft-dynamics-nav

https://dynamics-consultants.co.uk/blog/posts/2017/june/reconciling-inventory-in-microsoft-dynamics-nav/

NAV-Configuration Package Import Error-Posting date must have a value in Gen. Journal line: Journal template = GENERAL, Journal batch = XXX, Line number = 10000. The field cannot be zero or empty.

It looks like the TESTFIELD command on the Posting Date field causes this error.

The true cause of this error is a bad configuration package.
Redo the configuration package in the current version of BC/NAV.

Dynamics NAV / Business Central - What happens to assigned charge items if the original received quantity is partially returned?

• Scenario
• 100 items are purchased for $1 each
• Vendor Invoice is for $100
• duty item charge of $1 is added
• Customs Invoice is for $100
• Cut a cheque and pay customs to clear container
• Final Landed Cost
• $200
• Upon opening the container, we find 20 items damaged
• We contact the vendor, and he gives us a credit for $20
• Problem
• We cannot request a credit from Customs for the $20 duty we have paid on the damaged items
• The $20 value is still sitting in our inventory account
• Solution
• Pass a manual journal to move the value from Inventory to Damages/Writeoffs, (but not applied to any specific line item, as this will affect existing item costs)
• Debit Inv $20
• Credit Damages/Writeoffs $20
• Add original po,receipt,credit numbers as reference on journal

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

https://docs.microsoft.com/en-us/dynamics-nav-app/design-details-transfers-in-planning

eOne Smartconnect - Calculate current Year for Batch Name

Create calculated field

IF _CREDITHOLD > "0" THEN
 return  "CREDITHOLD"
ELSE return "ORDER " + Convert.ToString(fn.YEAR(_RECEIVEDDATE))
END IF

NAV Business Central CAL/AL - nav could not find a part of the path

It is looking on the local server for the path.
Use network paths instead of local paths.