Daily Sales Columner Report

Discussion in 'Tally Developer' started by Mahesh Sethi, Jul 22, 2021.

    
  1. Mahesh Sethi

    Mahesh Sethi Member


    Resp. members,

    If any one develop the report (file att.) i am ready to pay pls whats up me on 9826026109.

    Awaiting for your replay's.

    Thanks WhatsApp Image 2021-07-02 at 6.02.25 PM.jpeg
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  3. Mahesh Sethi

    Mahesh Sethi Member


    Amit Sir,

    Till now No replay from Mr. Damania . So i Try to Work on this report. I have almost done. Screen shoots is att.
    This report is working on Tally Prime.
    there is issue Qty is not coming GGRV SALES REPORT.png and when i print or export in excel columns will mess up . pls help me sir.


    [Field: IE Qty1]
    USe : Number field
    Set as : InventoryEntries:$BilledQty
    Width : 9
    Align: Right
     

    Attached Files:



  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is no reply ... because the photo you shared earlier.....entails......manual column caclculations i.e. hardcoded columns.

    As for your other query....How are we expected to solve it without looking at the code. The snippet you have shared is not enough to understand or solve. The collection and structure also matters.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your explode part is perfect.....
    As envisaged, it would not have been possible as per your initial Photo shot.......... as explode Part comes in a separate LINE.
     


  6. Mahesh Sethi

    Mahesh Sethi Member


    Sir,

    Can you pls give me your mail id i am sending you the file & demo data.
    & i want only export the report in excel format . Not print nor export in pdf or any other formats.

    Thanks
     


  7. Mahesh Sethi

    Mahesh Sethi Member


    Sir,

    can i sap rate this report in two part one is left part and use first 4 column & last 5 columns from Basic Amount to Total Amount And in Right part explode the inventory details. along with respective tax details.
    For Example if invoice belongs 2 items one is 18% & another is 5% then in explode details as under:

    Item No. 1 | 10Qty | 100Rate | Basic Amount | Cgst9% | Sgat9% | |
    Item No. 2 | 5 Qty | 54 Rate | Basic Amount | - | - | - | Cgst2.5% | Sgst 2.5%

    Can It Possible .
    EXCEL FILE IS ATT. I WANT EXACT THIS KIND OF REPORT.
    Pls Guide me .

    Thanks
     

    Attached Files:

    Last edited: Jul 24, 2021


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Possible in a way..........But SYNC will be a problem..... as both PARTS are separate with different data collection.
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    do you mean like this........??

    Capture.PNG
     


  10. Mahesh Sethi

    Mahesh Sethi Member


    Sorry Sir by mistaken wrong file uploaded. now i upload the right format exactly what i want.


    Sorry for inconvenience.

    Thanks for your replay.
     

    Attached Files:



  11. Himanshu-2002

    Himanshu-2002 Active Member


    Sir I think Initial Photo report is also possible.. We can use list variable concept..
     


  12. Himanshu-2002

    Himanshu-2002 Active Member


    If you think There will be any issue then Let me know... I will try to solve it
     


  13. Bipin Damania

    Bipin Damania Active Member


    Maheshji
    Your 1st Image shows Itemise Taxwise and TaxRatewise Columns which is little difficult, so I asked you to wait...
    As we discussed....
    And to get report we have to Map ItemTaxRate with Party State to get IGST/CGST/SGST and with Taxwise Column amount...
    I hope you understand...
     


  14. Bipin Damania

    Bipin Damania Active Member


    Brijeshji

    Please create separate query for post not related to topic...
    It will be easy to understand and reply...
     


  15. brijesh thacker

    brijesh thacker New Member


    ok sir
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Why are you creating a new report when a ready made is available in Tally?
    Capture.PNG
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  18. Mahesh Sethi

    Mahesh Sethi Member


    Res. Sir,

    One of my Customer required this report (daily MIS report), and he wants stock item,qty ,rate Basic amount in column . so that i made this report.

    My humble request to you pls guide me how its possible.

    Thanks & Regards,
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Look at Image 1 ---- required fields are there..........but as per structure, it will be on a separate line.

    As per your EXCEL format....... and as per my knowledge... not possible...... but as others said..it is possible .....so you can try that way.
     


  20. Mahesh Sethi

    Mahesh Sethi Member


    Dear Himanshu,

    Can you help me for the same.

    Awaiting for your replay.

    My Whats-up No. 9826026109.
     


Share This Page