Frieght amount not loaded in material cost

[Former Member]

Hi SD Guru,

my client having a requirement for at the time of billing they want to charge a freight to customer, but the freight amount not loaded in material cost, and the freight amount should be posted in seperate G/L account .

For Example of billing scinario. my billing amount is Rs. 3500/- and freight amount is Rs. 500/-, but the freight amount not load to material cost. they want the posting in FI like this:

Customer A/c 3500.00

Sales A/c 3500.00

Freight A/c 500.00

I did the setting in pricing procedure a condition type ZFR0 and make a statical. but when i am realseing the bill document to account the frieght amount not reflecting in account due to Staticals mark in pricing procedure.

But my client want the fright amount also release in account document like above example.

point to be reqwared.

Regards,

Deepak

[Former Member]

Hi......i dont understand the requirement.

Would you like to charge the customer for the freight amount? If yes, then the entries would be

Dr. Customer 4000

Cr. Revenue 3500

Cr. Freight clearing 500.

and this is pretty much a standard process where you need not make the cond type as statistical and just assign an account key to the cond. type.

If you do not want to charge the customer, then you cannot do a freight posting the way you have mentioned since in accouting, there is always a double entry and a Credit to the Freight account has to have a matching Debit entry to the customer account.

If you want to expense the freight charges, then you can do it through controlling by making the values pass to a cost center and then posting the same to FI through an assessment run. FI-CO folks should be able to clarify that better.

[Former Member]

Hi Arijit,

Yes i like to charge the freight to customer, but the freight amount will not load the material cost and billing total amount.

For eg, my billing amount is Rs. 3500/- and i am charging the freight amount is Rs. 500/-, my client want that the Rs. 500/- should be posted in freight account not in billing amount.

they want to post in account like this,

Dr. Customer 3500

Cr. Revenue 3500

Cr. Freight clearing 500.

Please give your valuable comments, points to be rewareded.

Regards,

Deepak

[Former Member]

Dear Deepak,

You can use accrual condition type.

Regards,

PM

[Former Member]

Hi PM,

I used the accrual condtion in my Condtion type ZF00.

but when i am creating the order its giving me error for G/L account. But in VOKA i maintained the following combination.

V KOFK 9000 1000 01 01 ERF 6070100100

V KOFI 9000 1000 01 01 ERF 6070100100

ZF00 121 No G/L account found in Account determination type KOFK

Access Message Description

10 123 Access KOFK not carried out (initialized field)

20 123 Access KOFK not carried out (initialized field)

30 123 Access KOFK not carried out (initialized field)

40 123 Access KOFK not carried out (initialized field)

50 121 No G/L account found in Account determination type KOFK

still i am getting the error for G/L account.

Regards,

Deepak

[Former Member]

Hi PM,

As per instruction i maintained the accrual condition in my freight condition type ZF00, but when i am creating the sales order i am getting the error or G/L Accounting missing data. i maintain in VOKA, but still i am getting error.

V KOFK 9000 1000 01 01 ERF 6070100100

ZF00 121 No G/L account found in Account determination type KOFK

Access Message Description

10 123 Access KOFK not carried out (initialized field)

20 123 Access KOFK not carried out (initialized field)

30 123 Access KOFK not carried out (initialized field)

40 123 Access KOFK not carried out (initialized field)

50 121 No G/L account found in Account determination type KOFK

Please revert the solution.

Regards,

Deepak

[Former Member]

Hi PM,

As per instruction i maintained the accrual condition in my freight condition type ZF00, but when i am creating the sales order i am getting the error or G/L Accounting missing data. i maintain in VOKA, but still i am getting error.

V KOFK 9000 1000 01 01 ERF 6070100100

ZF00 121 No G/L account found in Account determination type KOFK

Access Message Description

10 123 Access KOFK not carried out (initialized field)

20 123 Access KOFK not carried out (initialized field)

30 123 Access KOFK not carried out (initialized field)

40 123 Access KOFK not carried out (initialized field)

50 121 No G/L account found in Account determination type KOFK

Please revert the solution.

Regards,

Deepak

[Former Member]

Hi PM,

As per instruction i maintained the accrual condition in my freight condition type ZF00, but when i am creating the sales order i am getting the error or G/L Accounting missing data. i maintain in VOKA, but still i am getting error.

V KOFK 9000 1000 01 01 ERF 6070100100

ZF00 121 No G/L account found in Account determination type KOFK

Access Message Description

10 123 Access KOFK not carried out (initialized field)

20 123 Access KOFK not carried out (initialized field)

30 123 Access KOFK not carried out (initialized field)

40 123 Access KOFK not carried out (initialized field)

50 121 No G/L account found in Account determination type KOFK

Please revert the solution.

Regards,

Deepak