Item wise GST Analysis invoice

Discussion in 'Requests' started by Mohan.S, Jun 18, 2022.

    
  1. Mohan.S

    Mohan.S Member


    Dear Sir,
    one of our customers uses 3 datas in 1 tally. But in 1 data the invoice format is required below(Item GST Analysis invoice). Other 2 companies need default normal comprehensive invoices. but i will try with below code but not working properly, any one give solution for this.

    [​IMG]
    see my code below: if company name contains vignesh ineed the invoice format above/

    [#System: Variables]
    SATaxAnalysisWithItem : if ##SVcurrentcompany Contains "Vignesh" then Yes else No


    [#Field: SATaxAnalysisWithItem]
    Use : Logical Field
    ; Set as : if ##SVcurrentcompany Contains "Vignesh" then Yes else No
    Set: if ##SVcurrentcompany Contains "Vignesh" then Yes else No
    Set Always: Yes
    Modifies : SATaxAnalysisWithItem
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [Object: SATaxAnalysisWithItem]
    
        Use         : Vch Output Configuration
        Name        : @@SATaxAnalysisWithItem
        Value        : ##SATaxAnalysisWithItem
        IsInVisible : NOT @@IsGSTOnAppl
       
        Action        : ConfigAction :  Set   : SATaxAnalysisWithItem    : NOT ##SATaxAnalysisWithItem
        Action        : ConfigAction :  Do If :  ##SATaxAnalysisWithItem : Set    : SAGSTWithIGSTRate    : No
        Action        : ConfigAction :  Do If :  ##SATaxAnalysisWithItem : Set    : SAGSTHSNWiseAnalysis : No
        Action        : ConfigAction :  Do If :  ##SVcurrentcompany Contains "Vignesh" : Set    : SATaxAnalysisWithItem : Yes
    
    
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I do not have access to my tally data, hence not tried the above code............ Take backups before trying.
     


  4. gangstar

    gangstar Member


    ;;I tried like this.

    [System:Formula]
    CmpCtrl1:$CompanyName Contains "Vignesh Estimate"
    CmpCtrl2:$CompanyName Contains "Vignesh GST Billing"

    [#Form:Sales Color]
    Option:CtrlInvEst1:mad:@CmpCtrl1
    Option:CtrlInvBll2:mad:@CmpCtrl2

    [!Form:CtrlInvEst1]
    Set:SASimple:Yes
    Set:printWithAddress:No
    Set:SABuyersGSTIN:No
    Set:pUGSTMRPRate:No
    Set:SAGSTWithHSN:No
    Set:SAGSTWithIGSTRate:No
    Set:SADeclaration:No
    Set:SAGSTAnalysis:No
    Set:SAPartNo:Yes
    Set:SAEcoPrinting:Yes
    Set:DNoteEcoPrinting:Yes
    Set:CNEcoPrinting:Yes
    Set:SASMPHeight:12.5
    Set:SASMPWidth:9.5
    Set:SVConsigneedetails:No

    [!Form:CtrlInvBll2]
    Set:SASimple:No
    Set:printWithAddress:Yes
    Set:SABuyersGSTIN:Yes
    Set:pUGSTMRPRate:No
    Set:SAGSTWithHSN:Yes
    Set:SAGSTWithIGSTRate:Yes
    Set:SADeclaration:Yes
    Set:SAGSTAnalysis:Yes
    Set:SAPartNo:Yes
    Set:SAEcoPrinting:Yes
    Set:DNoteEcoPrinting:Yes
    Set:CNEcoPrinting:Yes
    Set:SAHeight:12.5
    Set:SAWidth:9.5
    Set:SVConsigneedetails:Yes
     


  5. Mohan.S

    Mohan.S Member


    O
    Ok Sir Thanking you.
    i will try
     


  6. Mohan.S

    Mohan.S Member


    Dear Sir,
    we are trying with the above code. that is working with all the company data. The variable can't be changeable if using this code. I need the Gst item analysis invoice only the Company name Contains "Vignesh". For other companies, I need only comprehensive invoices.

    but this code works with all companies. and also cant change the variable.
    upload_2022-6-21_12-51-45.png
    Show Item-Wise GST Details=yes <---- This is readonly now not changed
     


  7. Mohan.S

    Mohan.S Member


    Sir this code not working
     


  8. gangstar

    gangstar Member


    Kindly change the company name as well as formula Name.
     


  9. Mohan.S

    Mohan.S Member


    i will changed

    but below code is check correct or not:

    [#System: Formulae]
    IsGSTTaxAnalysisWithItems : If NOT @@IsGSTRegularcompOnAndAppl Then NO Else If @@IsPurchase OR @@IsDebitNote Then ##PUTaxAnalysisWithItem Else +
    If @@IsSales And $CompanyName Contains "Vignesh" OR @@IsCreditNote OR @@IsDelNote OR @@IsReceipt OR @@IsPayment Then ##SATaxAnalysisWithItem Else No
     


  10. Mohan.S

    Mohan.S Member



    This code works for invoice change
    But the Body part Alignment problem appeared. please check the below code correct for GST ITem analysis invoice or not.


    [#Line:EXPINV InvDetails]
    ;;[#Line: EXPINV GSTTaxDetails]
    Option: Vignesh Invdetails : ##SVcurrentcompany Contains "Vignesh"
    [!Line: Vignesh Invdetails]
    Add: Right Field: At Beginning: VigBatch, VigExp
     


  11. gangstar

    gangstar Member


    Share the full code i can't able to see the field of VigBatch, VigExp....
     


  12. Mohan.S

    Mohan.S Member


    Dear Sir,
    Here in we are opening 2 Companies. Here need to print the Default comprehensive invoice in Renga fertilizer
    and
    we need to print the GST Item Tax analysis invoice in the Company name Containing Vignesh.
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Now renga fertilizer company print Default comprehensive invoice --- That is Correct
    Here the company "Vignesh Enterprises"
    Print GST Tax Analysis Invoice"
    Here the Title column is printed correctly
    But in the Inventory column Item details; The GST DEtails have not appeared.
    That is our problem. So kindly solve this issue.
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    /*
    See the below code the company name contains vignesh then print automatically GST Item Analysis Invoice.But Tax
    Details shoult not come on "ExpInv Details". other companies automatically print default comprehensive invoice"
    what is the solution for print tax details on GST item Analysis invoice
    */
    [#System: Formulae]
    IsGSTTaxAnalysisWithItems : If NOT @@IsGSTRegularcompOnAndAppl Then NO Else If @@IsPurchase OR @@IsDebitNote Then ##PUTaxAnalysisWithItem Else +
    If @@IsSales And $CompanyName Contains "Vignesh" OR @@IsCreditNote OR @@IsDelNote OR @@IsReceipt OR @@IsPayment Then ##SATaxAnalysisWithItem Else No

    ;;;;;;;;;;;;;;;;;;llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
     

    Attached Files:



  13. Mohan.S

    Mohan.S Member



    Item wise GST Analysis invoice

    sir pls refer the link for my requirement.
    Tanks in advance
     


  14. Mohan.S

    Mohan.S Member


    Dear Sir,
    Finally achive this with an simple command

    [#Report: VCH Print Configure]
    Set: SATaxAnalysisWithItem : if ##SVcurrentcompany Contains "Vignesh" Then "Yes" Else "No"


    Thanks for your reply and support
     


Share This Page