Salesman report

Discussion in 'Requests' started by Johar, Sep 11, 2018.

         
  1. Johar

    Johar Member


    Dear Amit Sir,

    done !!
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Well done Johar....beautifully done.

    Keep innovating............
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Add percentage and commission amount due to salesman.............
     


  4. Johar

    Johar Member


    commission done!!!
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What is the username and password??
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Function : RcptCObject : at 020 reports error.............collection "ledger entries" could not be found
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your salesman report shows GROSS sales....

    Correct reporting would be Sales, (-) Discount, (-) C/Note and receipts collected........ commission %age should be applied on the receipts collected by the salesman. That is the business model followed commonly.

    You need commission %age to be put in salesman master.
     
    Rajsrisrimal and Jaydeep Shah like this.


  8. Systecg

    Systecg Member


    how to add % in Sales Man
     


  9. Venkat1433

    Venkat1433 New Member


    Hi Experts,

    i need help on salesman wise total qty & Amount report.

    can you please help me
     

    Attached Files:



  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please refer to the original code from where you have copied it............. the totals are already defined....you need to un-comment it.......
     


  11. Venkat1433

    Venkat1433 New Member


    Hi Amit Sir,

    Actually i need salesman wise summary.. After coping the original code from this forum i have tried for Salesman wise summary but i am not getting summary without expanding.... attached the screen shot what exactly iam trying for... Salesman Summary.png please help me
     

    Attached Files:



  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    As per your screenshot.... it is working fine.... that the way it should be...... because a Salesman A might have made 10 sales, so the details of 10 sales voucher are coming in the explode part....... however if you want the summarized details in non-exploded part then you must put the total of all sales invoices made against that salesman name.
     


  13. Venkat1433

    Venkat1433 New Member


    Thanks for your quick replay Amit Sir...

    Actually i need "summarized details in non-exploded part" but i am not getting how to get summarized details... please guide/Help me.
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have already explained....please read again.... you need to total up..........

    Compute the values in the collection on non-exploded part.....right now your totals are coming at the bottom in the exploded part. Instead put the total of respective salesman against their respective names.
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do the following :

    [Field: PQRQUANTITY]
    Use : Qty Primary Field ;InventoryEntries.BilledQty

    [Field: PQRPartyAmount]
    Use : Amount Forex Field

    Set as : $Amount ;$GROSSREVENUE
     


  16. amit g

    amit g New Member


    thanks alot sir it worked..
    kinldy help in fetching bags total also..
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Share the code.... without looking at your code......how can I check?
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also, try on your own....am sure you have made similar error in that field also........

    So learn from above solutions and try doing on your own first...............
     


  19. amit g

    amit g New Member


    a

    amit sir bags total also
    thanks for help
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: PQRBAGS]
    Use : Number field
     
    amit g likes this.


  21. amit g

    amit g New Member



    thanks alot sir ji
    you made my working so fast and effecient
     


Share This Page