Microsoft Dynamics NAV (Archived)

Add item charge to statistical value

(0) Share

Report

Posted on by Community Member

I am trying to increase the statistical value of an item by the item (charge) assigned to it. I am doing the following:

- Using a item (charge) with Insurance/Freight flagged = TRUE

- Enter item on PO

- Enter item (charge) on PO

- use suggest assignment to assign full amount to item line

- Receive order

- Run intrastat > get lines

The amount and statistical value are the same but do not include my assigned item charge amount

Must be missing a setting somewhere. Any help much appreciated

Thanks

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

mmv 11,471 on at

Like (0)

Report

Hi,

There's no special setting as such. Please check whether you have followed as below:-

https://msdn.microsoft.com/en-us/library/hh168616(v=nav.90).aspx

http://bcinc.net/js/NA2009_ENUS_TR_06.pdf

Was this reply helpful? Yes No
ksundeep87 800 on at

Like (0)

Report

Hi,

Can you elaborate with an example and amounts.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Example using Cronus as follows:

I raised an order to EU customer Beef House and included an item and charge (item) line for freight

S-Freight is setup as shown below

Charge item assigned as shown below

I have then shipped the order and added the line (get entries) on intrastat journal but the amount of freight has not increased the statistical value

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

It seems to be a customized screen.

Is there any customization?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

no customisation but could be local UK?

Was this reply helpful? Yes No
Suggested answer

ksundeep87 800 on at

Like (0)

Report

Hi,

What is the Costing Method on Item Card Master ?

If your Item Costing Method Standard or Specific I am sure that Item Charge will be ignored this could be one reason.

Can you try another Item with different Costing Method like FIFO.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The item is FIFO. I am looking to increase the value on the Intrastat return where there are two columns for value:

Amount uses the Unit Price ie the sales price in this case and therefore not impacted by direct costs.

Statistical Value should take the amount above and apply any freight/insurance charges allocated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I appreciate your help on this by the way!

Was this reply helpful? Yes No
Suggested answer

ksundeep87 800 on at

Like (0)

Report

Hi,

Item Charge amount will be included once you finish invoicing.

Was this reply helpful? Yes No
Verified answer

ksundeep87 800 on at

Like (0)

Report

Once you invoice the delete the existing entries on Intrastat Journal and once again do the "Get Entries".

Was this reply helpful? Yes No