I received many emails asking why I have stop posting new articles in navision-girl.com. The reason for the inactivity in navision-girl.com is because I no longer work in Navision field since i resigned from my previous job.
Thank you for browsing navision-girl.com and thank you for readers who have sent me encouragement email. I hope this website is useful and helpful to you.
Tuesday, 18 January 2011
Tuesday, 22 September 2009
Gen. Posting Type must be Specified when posting journal entries.
When you try to post a journal entry to selected G/L Account, the following error message prompt up:
Gen. Posting Type must be specified.
This problem occurs because you have specified Gen. Prod. Posting Group for the G/L Account selected. To solve this problem, you can either:
1) Remove the Gen. Product Posting Group from the journal lines
OR
2) Remove the Gen. Product Posting Group from the G/L Account Card and then reselect the G/L Account in Journal lines.
Gen. Posting Type must be specified.
This problem occurs because you have specified Gen. Prod. Posting Group for the G/L Account selected. To solve this problem, you can either:
1) Remove the Gen. Product Posting Group from the journal lines
OR
2) Remove the Gen. Product Posting Group from the G/L Account Card and then reselect the G/L Account in Journal lines.
Monday, 9 March 2009
Steps to calculate Average Cost in Navision
The following steps are not foolproof but it has helped me solved many average cost issues.
1) At item card, click on Item --> Entries --> Value Entries to open the Value Entries screen.
2) Copy all records in the Value Entries screen to Excel.
3) In the Excel worksheet, sort the records by Valuation Date.
4) Add a new column called Cost Amount to the Excel worksheet. Cost Amount = Cost Amount (Expected) + Cost Amount (Actual). Use Excel formula to populate the Cost Amount column for all records.
5) Add another column called Cost Amount (Accumulated). As indicated by the column name, it is the accumulated value of Cost Amount from first record to the last record. Again use Excel formula to populate this column.
6) Add a new column called Quantity (Accumulated). Quantity (Accumulated) is the accumulated quantity from first record to the last record. Use Excel formula to populate this column.
7) Add a column called Avg. Cost. Avg. Cost = Cost Amount (Accumulated) / Quantity (Accumulated).
8) Now, look for the last inbound entry record for each Valuation Date. The Avg. Cost for the last inbound record for each valuation date is the average cost for the day.
1) At item card, click on Item --> Entries --> Value Entries to open the Value Entries screen.
2) Copy all records in the Value Entries screen to Excel.
3) In the Excel worksheet, sort the records by Valuation Date.
4) Add a new column called Cost Amount to the Excel worksheet. Cost Amount = Cost Amount (Expected) + Cost Amount (Actual). Use Excel formula to populate the Cost Amount column for all records.
5) Add another column called Cost Amount (Accumulated). As indicated by the column name, it is the accumulated value of Cost Amount from first record to the last record. Again use Excel formula to populate this column.
6) Add a new column called Quantity (Accumulated). Quantity (Accumulated) is the accumulated quantity from first record to the last record. Use Excel formula to populate this column.
7) Add a column called Avg. Cost. Avg. Cost = Cost Amount (Accumulated) / Quantity (Accumulated).
8) Now, look for the last inbound entry record for each Valuation Date. The Avg. Cost for the last inbound record for each valuation date is the average cost for the day.
Saturday, 7 March 2009
You must assign all item charges, if you invoice everything
Let's consider this example in posting Charge (Item) partially. Cronus database was used to illustrate 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.
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.
Thursday, 19 February 2009
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.
Subscribe to:
Posts (Atom)