You must assign all item charges, if you invoice everything

Let's consider this example in posting Charge (Item) partially. I will use Cronus database in this example.


1) On 01-Feb-2008, purchase 5 units of Item 80005 (Computer III 866 MHz) from Vendor 30000. Item 80005 cost $1000 per unit. $100 will be charged to Cronus as freight cost for the delivery of the 5 units of Item 80005. So, we will create a PO as shown below.


2) On 02-Feb-2008, 2 units of the Item were delivered to Cronus. So, change the Qty. to Receive for Item 80005 to 2 and Qty. to Receive for Charge (Item) to 0.4. Post receive only.

3) on 05-Feb-2008, the remaining 3 units of Item 80005 were delivered to Cronus. So, change the Qty. to Receive for Item 80005 to 3 and Qty. to Receive for Charge (Item) to 0.6. Post receive only.

4) On 12-Feb-2008, post Invoice for the first 2 units received. So, change the Qty. to Invoice for Item 80005 to 2 and Qty. to Invoice for Charge (Item) P-FREIGHT to 0.4. Post Invoice.

5) On 15-Feb-2008, post Invoice for the 3 units received. So, change the Qty. to Invoice for Item 80005 to 5.

6) Change Qty. to Invoice for Charge (Item) P-FREIGHT to 0.6.

7) Post Invoice. Ooops.... you get this error message "You must assign all item charges, if you invoice everything.".

8) As indicated by the error message, you must assign the item charges before you can fully invoice the Charge (Item). So, click on Line --> Item Charge Assignment. Click on Function --> Suggest Item Charge Assignment. Select either Equally or Amount and then click on the OK button.

9) Close the Item Charge Assignment (Purc) window. Please take note that the Qty. to Assign field has been filled with 1.

10) Post Invoice. Done.

Show or Hide Navigation Pane

Microsoft has introduced Navigation Pane in Navision version 4.0 and 5.0. By default, the Navigation Pane is visible and docked to the left of the screen. You can show / hide the Navigation Pane by pressing Alt + F1 or using View --> Navigation Pane menu.

Unit Cost used in Negative Adjustment

If you are using Average Cost, Negative Adjustment will take the average cost on the day the negative adjustment is valued (based on posting date and valuation date).

For example, when you do a Negative Adjustment in Item Journal, Navision will default the unit cost with the Unit Cost from Item Card. It doesn't matter whether you accept the default cost suggested by Navision or change the unit cost to other cost, because the Adjust Cost - Item Entries batch job or the automatic cost adjustment function will adjust the unit cost back to the average cost based on the valuation date. Therefore, no matter what cost you put in the Item Journal during Negative Adjustment will not affect the cost used in the negative adjustment.

If you are using Standard Cost, the unit cost in Item Journal will be defaulted to Unit Cost in Item Card, which is the current standard cost. Later, when the adjust cost function is executed, the unit cost posted by the negative adjustment will be adjusted to the unit cost of the positive entry which the negative adjustment is applied to. Let's consider the following example,

Jan 01, 2008 - Item A is created and standard cost is set to $10.
Jan 02, 2008 - Purrchase 10 units of Item A with $10.
Feb 01, 2008 - Change standard cost of Item A to $12.
Feb 05, 2008 - Purchase 10 units of Item A with $12.
Feb 07, 2008 - Negative 2 units of Item A.

So, on Feb 07 2008, when 2 units of Item A is entered into the Item Journal, Navision will default the unit cost to $12. Accept the cost and post the Negative Adjustment. The Negative Adjustment will be posted with $12. You can verify this by checking the Item Ledger Entries and Value Entries. Now, run the Adjust Cost - Item Entries batch job. After the Adjust Cost batch job completed successfully, check the Item Ledger Entries and Value Entries again. You should be able to see an adjustment entry with -$2 has been added to the Value Entries table to adjust the unit cost to $10.

The Negative Adjustment will take $10 instead of $12 as unit cost because the negative adjustment entry has been applied to the purchase entry created on Jan 02 2008, which is $10.

Create Vendors, Customers and Bank Accounts

Navision allow you to create Vendors, Customers, and Bank Accounts from contact and vice versa.

1) Go to Sales & Marketing --> Marketing --> Contacts

2) Click on Functions --> Create AS --> Customer / Vendor / Bank.

3) Click on the OK button to confirm the creation.

You can only create customer from contacts that are not associated to any customer yet. If the contact has been associated to a customer, Navision will throw an error message.

Create Contacts from Vendors, Customers and Bank Accounts

Navision allow you can create contacts from vendors, customers or bank account and vice versa.
1) Go to Administration --> IT Administration --> Contact Creation --> Create Contacts from Customers...

2) Click on the OK button without any filtering will caused Navision to create all contacts from all customers. If you only want to create contacts from specific customers, fill in the filtering criteria.

You can do the same for Vendors and Bank Accounts.

Users used to missed out this features because it is located in the IT Administration section, which not many users will use.