How to get Gross Profit of Sale in the Account Schedules

gala
gala Member Posts: 17
edited 2008-03-04 in NAV/Navision Classic Client
Hallo everybody.

I have one query regarding setup of Navision for Gross Profit calculation .
The scenario is like this:

I post purchase for two items
S-1 10 QTY with price 10 = 100
S-2 10 QTY with price 15 = 150

Total I have cost of purchase goods 250

Late I post some freights which I post as Item Charge. And the the actual costs of each items are increasing. For example,
S-1 increasing total on the amount 20 ( each per increase 2)
S-2 increasing total on the amount 30 ( each per increase 3)

Total I have actual cost of all items on the my location 300


Then I sale item S-1. I sale 1 qty Let’s the sale price of this items is 20.
The actual cost of this items is 10 (from first purchase) +2 (it’s my freights)

I can setup only follow Account Schedules :D

Sale 20
Purchase 12
Gross profit 8

But I would like to get the follow Account Schedules: ](*,) ](*,)

Sale 20
Purchase materials 10
Purchase freights 2

Gross profit 8

Is it possible. I use Navision 4.0 SP3 (but I think it is not matter)
Thank you in advance

Comments

  • AdamRoue
    AdamRoue Member Posts: 1,283
    The item charge is linked to a product posting group. Create a unique one for your item charge. Then in the posting setup define the approapriate accounts to split the sales element of the charge away from your geenral sales, then point the account schedule at this account for your freight.

    I guess you are putting it all in one account currently so you cannot split it out on an account schedule.
    The art of teaching is clarity and the art of learning is to listen
  • gala
    gala Member Posts: 17
    AdamRoue wrote:
    I guess you are putting it all in one account currently so you cannot split it out on an account schedule.

    I think you understand me not quit correct. :(

    When manager sales the item he know nothing about freights which was made when we did purchase. He has information only about sales price. Other entry created automatically when I run the task “post inventory cost to G/L”

Categories