Update de Profit field in Cust. Ledger entry

pechial
pechial Member Posts: 4
edited 2010-01-25 in NAV/Navision Classic Client
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

Comments

  • chengalasettyvsrao
    chengalasettyvsrao Member Posts: 711
    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
    pechial Member Posts: 4
    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
    chengalasettyvsrao Member Posts: 711
    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
    chengalasettyvsrao Member Posts: 711
    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.

Categories