Showing posts with label Item Charge. Show all posts
Showing posts with label Item Charge. Show all posts

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.

Sunday, 14 October 2007

When to use Item Charge ?

Item Charge is used to record the cost for distributing, handling and transportation of items, such as:
1) Insurance
2) Freight Cost
3) Custom Duties

These costs will add to the direct unit cost of the item purchased or sold, thus will affect the cost of goods sold and proft calculation. For example, transportation agent who delivers items from supplier bills you on the transportation charges. You can use Item Charge to assign the transportation charges to the items received. When the Item Charge is posted, it will be added to the cost of the items received, thus make the cost of the item more expensive. The same concept can be applied to the Sales Transaction.

Navision allow you to post the Item Charge seperately from the purchase or sales document. You can post the purchase or sales documents first and post the Item Charge later when you have receive the relevant documents to incur more charges to the purchase or sales. In other words, item charges can be assigned to the items that have been posted as receipt and invoice, or even after the item has been sold.