Freight Issue

[Former Member]

Hi All,

I have a query regarding freight. When I give freight at footer level with Tax code the freight amount including tax is going to rounding account. when I give freight at row level it is working fine. Whats was wrong?

Regards

Shashi

[Former Member · Accepted solution]

Hi Shashi,

Check the accounts set-up for freight under Administration\set-up\general\Freight to reconfirm if you have specified the Revenue/ Expense accounts.

Regards,

Hamsa

[Former Member · Accepted solution]

Hi Hamsa,

At the time of A/P invoice we dont need to assign G/L account. So I not not assigned any G/L account at the time of freight setup.

I have assigned freight at the time of GRPO level so it will credit to freight clearing account and once we do the A/P invoice expense clearing account will get debited and nulifies.

See My requirement is I need the freight amount including the tax to be added to inventory.

How this can be done?

Regards

Shashi

[Former Member · Accepted solution]

Hi Shashi,

As you want to Inventories the freight amount then you need to define the Freight Expenses account in Administration setup of freight. After assigning account to freight, you need to select the Inventories option in the footer level. This will automatically debit the Inventory Account with the freight amount.

Now, about the tax amount on freight, you need to define non-deductible percentage in tax code itself.

Hope this will help.

Regards,

Abhishek

[Former Member · Accepted solution]

Hi Abhishek,

Please give me clear picture when the freight amount need to be added I mean at what stage (GRPO or A/P invoice) to get the freight amount with tax to be added to inventory.

I have given for TAX type CST as non deductable 100% and did not select any account to get the inventory effect. And I want to add freight at A/P invoice level and need to affect the inventory valuation with CST.

What changes should I do?

Actually when I am giving it in row level it is working fine. But only when I give in footer level. the problem araises.

Regards

Shashi

Edited by: shashi mantripragada on Dec 1, 2008 8:56 AM

[Former Member · Accepted solution]

Hi Shashi,

You can add freight at any level i.e GRPO or A/P Inovice but if you add Freight at footer level then System ask for Non-deductible account for the CST otherwise its works fine at row level as you said.

So, its better if you add freight at row level only because I think your Non-Deductible account cannot be same for every transaction and in footer level freight scenario you need to define non-deductible account in the tax code.

Hope this will help you.

Regards,

Abhishek

[Former Member · Accepted solution]

Hi Sashi,

To add freight amount: In Freight Set up you have to check the option stock

To add freight tax amount: In Tax codes Set up you have to give 100 for Non Deductible % and acount for Non-Deductible Acct.

But the Account give for Non- Deductible Acct have no effect. The tax amount also posted to inventory account.

Try this.

Thanks & Regards,

Poonkodi. K

[former_member583013]

In the Document Settings..there is a setting for Round tax amount in rows.. is this checked?