Structrue With two charges

Madhavi_Pandey
Madhavi_Pandey Member Posts: 124
edited 2010-07-10 in NAV/Navision Classic Client
Hi All,

I am using Navision 2009 sp1 and I want to create this type of structure for Forwarding Charges -



Item Qu. Rate Value
10 100 1,000.00
+ Packaging Charges 20.00
@ 2% 1,020.00
+Excise@ 105.06 10.30%
1,125.06
+VAT@ 45.00 4%

Value(including Excise & Vat Tax) -> 1,170.06
+Forwarding Charges (Fixed Value Rs. 200) 200.00
Total Value -> 1,370.06
Madhavi Pandey.

Answers

  • abhaydalal8722
    abhaydalal8722 Member Posts: 27
    Madhavi Pandey wrote:
    Hi All,

    I am using Navision 2009 sp1 and I want to create this type of structure for Forwarding Charges -



    Item Qu. Rate Value
    10 100 1,000.00
    + Packaging Charges 20.00
    @ 2% 1,020.00
    +Excise@ 105.06 10.30%
    1,125.06
    +VAT@ 45.00 4%

    Value(including Excise & Vat Tax) -> 1,170.06
    +Forwarding Charges (Fixed Value Rs. 200) 200.00
    Total Value -> 1,370.06

    Structure will be like this I believe

    Type Tax/Charge Group Tax/Charge Code Calculation Type Calculation Value Base Formula Include Base
      Charges PACKAGING Percentage 20 Yes Excise EXCISE Percentage 1 Yes Sales Tax SALES TAX Percentage 1+2 Yes Charges FORWARDING Fixed Value 200 No
    I strongly suggest you test it in a test database before using it
  • Madhavi_Pandey
    Madhavi_Pandey Member Posts: 124
    abhaydalal8722 wrote:
    Madhavi Pandey wrote:
    Hi All,

    I am using Navision 2009 sp1 and I want to create this type of structure for Forwarding Charges -



    Item Qu. Rate Value
    10 100 1,000.00
    + Packaging Charges 20.00
    @ 2% 1,020.00
    +Excise@ 105.06 10.30%
    1,125.06
    +VAT@ 45.00 4%

    Value(including Excise & Vat Tax) -> 1,170.06
    +Forwarding Charges (Fixed Value Rs. 200) 200.00
    Total Value -> 1,370.06

    Structure will be like this I believe

    Type Tax/Charge Group Tax/Charge Code Calculation Type Calculation Value Base Formula Include Base
      Charges PACKAGING Percentage 20 Yes Excise EXCISE Percentage 1 Yes Sales Tax SALES TAX Percentage 1+2 Yes Charges FORWARDING Fixed Value 200 No
    I strongly suggest you test it in a test database before using it



    When i posting the Sale Invoice using this structure an error msg has come, "Gen. Posting Type must not be in Gen.Journal Line Jounral Template name =",Journal Batch Name=',Line No.='1000'.
    Madhavi Pandey.
  • ssingla
    ssingla Member Posts: 2,973
    Check that no Gen. Buss. Posting Group or Gen. Product Posting Group has been defined on the G/L accounts used in Charges of the structure.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Madhavi_Pandey
    Madhavi_Pandey Member Posts: 124
    ssingla wrote:
    Check that no Gen. Buss. Posting Group or Gen. Product Posting Group has been defined on the G/L accounts used in Charges of the structure.


    Thanku,its working. :)
    Madhavi Pandey.

Categories