Update de Profit field in Cust. Ledger entry

pechial

Hi everybody
Using Nav 5.0 ,my Customer need to recalculate the Profit fields located in the Customer ledger entry and also the Unit cost in the Sales invoice line.

Some purchase cost has been introduced in the product and unist cost has been increased. The unit cost was modified after the invoice was done.
Item ledger entry movements are ok, but not the cust. ledger for stadistics

¿Any idea ?
Thanks a lot
Carles

chengalasettyvsrao

pechial wrote:

Some purchase cost has been introduced in the product and unist cost has been increased. The unit cost was modified after the invoice was done.

what is the costing method of that item .?

pechial

chengalasettyvsrao wrote:

pechial wrote:

Some purchase cost has been introduced in the product and unist cost has been increased. The unit cost was modified after the invoice was done.

what is the costing method of that item .?

It's FIFO.
And this was the movements:

Purchase 1000 at 1.088,00 unit cost -> the unit cost shoud be 1,088 (the coma is decimal)
Sell 100 at 1,7 (selling prince) with cost 1.088,00
Return 50 at 1,7 with cost 1.088,00
Negative adjustment from 1.088,00 to 1,088 for (1000-50 units) Other 50 are sold.
The Item ledger entry is updated to the correct price.
The Cust. ledger entry have the 1,088.00 original price, also the invoice

¿Any idea?
Thank you
Carles

chengalasettyvsrao

pechial wrote:

Sell 100 at 1,7 (selling prince) with cost 1.088,00

Did u create the invoice for the 100 pcs ?

pechial wrote:

Return 50 at 1,7 with cost 1.088,00

Did u create the invoice against that Return order .

pechial wrote:

The Cust. ledger entry have the 1,088.00 original price, also the invoice

if you sell the item at the unit price 1.7 , then how the customer ledger entry will update the original price 1.088 ?

chengalasettyvsrao

pechial wrote:

Customer need to recalculate the Profit fields located in the Customer ledger entry

once customer ledger entry created , it is not a legal way to modify the posted entries.

pechial wrote:

the cust. ledger for stadistics

Did u check the customer statistics ?

Customer - > customer (button) - statistics . it is working fine.

check the Report customer / Item sales .

if that report does not satify your requirement then create the new report according to client requirement.