Total: ₹0.00
Total: ₹0.00

Sales Report VII

You cannot view this unit as you're not logged in yet.
Prev post Invoice customisation VII
Next post How to Activate the Sample Projects in TDL

14 thoughts on “Sales Report VII”

  1. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    Sir,
    I have fetched all the data from the Voucher in my Sales report.
    It is working fine.
    Conditions in code.
    1. Title Line
    2. Body Line.
    3. Body Line Repeated over Final Collection: “MY PersonalColl” of
    [Collection: MY PersonalColl]
    Source Collection: PersonalColl
    Walk:AllLedgerEntries,Inventory Entries
    By:VchhQty:$BilledQty
    By:VchhRate:$Rate
    By:VoucherNumber:$Voucher Number
    From Source Collection: Personal Collection

    Type:Vouchers:Voucher Types
    Child Of:$$VchTypeSales
    Belongs To:Yes
    Fetch: StockItemName,PartyLedgername,
    Under the above Codes the output is fine.
    Now Iam trying to Explode the Body Line which is repeated.
    So I add a explode part in the body line, Define line Field etc.
    I have set the value in the Field belonging to exploded part as: “Exploded”
    Iam not getting the output as demonstrated by you in the next lesion.
    Please check the code as advise me

    1. Hello Giridharan,

      While, I am impressed with your progress and the way you learning and also this report you done is great. But at the same time, I am disappointed with the way you dealt with the exploded part coding. After following so many chapters, I can’t expect such mistakes from you.
      Here is your code for the exploded line and the field

      [Line:MYSRBYEXP]
      Field:MYSRBYEXPFLD

      [Field: MYSRBYEXPFLD]
      Use:name Field
      Local: Field:nameField:Set as:”Exploded”

      Localisation is always done at the parental level. Here are the line is the parent for the field MYSRBYEXPFLD but you are localising this field at the field level itself!!! also there is no name field defined at the immediate parent level e.g. at the line MYSRBYEXP!!

      Localisation is say like our nicknames where we are known locally within our homes/streets with some nick name like hey Shyam will be known as montu within the home circle.

      and this nick names are being localized by our parents.
      Also if the parent doesn’t have a child like name field then how you can add a name field in your code?
      It is something like we have a member in our family whose name is Ramesh but if we calling him as Hey Mahesh come here he will wonder whom we are calling or he will simply ignore us.
      So, here compiler is your name field because at the parent level there is no name field
      and also the localisation can be done at the parental level only.

  2. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    A great Eye Opener to me.
    I have understood that even for Explosion Depending on the situation we need two Fields one to hard code the name that we want to fetch and other to display the actual data.
    I have corrected my coding as follows.
    [Part:MYSRBYEXP]
    Line:MYSRBYEXP
    [Line:MYSRBYEXP]
    Field: Name field,MYSRBYEXPFLD
    Local:Field:name Field:Set as:”Batch /Lot No ”
    [Field: MYSRBYEXPFLD]
    Use:name Field
    Set as:$Batchname
    In my walk also I Changed coding’s as follows
    By:BatchName:$Batchname

    Fetch:StockItemname,PartyLedgername,BilledQty,Rate,Amount,VoucherNumber,date,BatchName.
    Now it is working fine. Iam able to fetch Batch /Lot Number in the Exploded Part.
    This Fine tuning is necessary. Only after making mistakes and rectifying there after I understand the basic Concept, which will be stored in my mind. We are learners having passion to Learn, learn……?
    With your Guidance we will keep on learning.
    Thank you Very much.
    I have updated my png and text files in my folder.
    Thanks once again

    1. Awesome and I am really happy you are able to make it.
      Now, try to fetch other data like, Item Name, qty, Rate, Amount in the exploded line.
      These data shouldn’t appear in the main line.
      A Main line should display only the Data, Bill Number, Party Name and Total amount

      Of course in our chapter we will do it but if you can achieve it before I upload the chapter, It will help you a lot to understand it far better.
      You have 2 days to take the challenge.
      An Image of desired output file name 123.jpeg I put in your file. Let me know if you can code that way.

      I am pretty sure, you can do it.

  3. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    Sir,
    I have completed the assignment.
    Following Files are shared in my folder.
    sales Report(3).png
    Sales Report1.txt.
    Please verify and advise me for any change

  4. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    Sir,
    we have worked Explode on data fetched from Voucher.
    Iam going to try one customized Report displaying the Group with Opening Balance and Closing Balance.
    in the Exploded part Iam trying to Display all the stock Item under Respective Group.
    In the First part Repeat Over Collection of type Group is necessary.
    To display all Default Stock Item under Group.
    I think we have to repeat the Exploded Line Over new collection of Type Stock Item.
    Am I right?
    Will it work?
    Yet Iam going to try and find out the Result.

    1. Hello Giridharan and everyone,

      I suggest you try TDL with the Demo DATa especially when you put the Screen shot in The Dropbox.
      The reason is I highly recommend the business data confidentiality.

      The student folder is accessible by every student and we have around 250 students.
      Another reason is that I use the screen shots uploaded by the students for marketing purpose at Facebook and other social media and I won’t like to put any screen shot in public which display the commercial data of a business unit.

      So, I suggest you create a demo company with some dummy name and use the dummy data only.

      Also, while learning purpose the TDL should never be used with live data to avoid any data loss or any kind of problem. Once we are satisfy with the result and everything is fine only then it should be assigned to a live business data.

  5. Giridharan Varadharajan says:

    Giridharan Varadharajan.
    I understand your Point.
    I will use Dummy data hereafter

  6. Yogesh Kanojia says:

    Hi Sir,
    Greetings…!!!
    Sir, I’d designed the sample report and it is fetching the data accordingly.
    I’ve a query in this chapter.
    Sir, whenever i’d passed the sales inventory with one or more stock item, the report shows the correct data but in any sales entry, but when I choose same item second time in the sales voucher, the report shows the item qty, rate, value of the item which stood on no. 1 position.
    For example, In sales voucher i took an item named “Laptop” and set quantity “1”, and in another line i again took the item “laptop” and set quantity to “2” then the total quantity should be 1+2=3. But my report fetching the qty “1” which is on first line of inventory entries.
    What should I do to correct the issue?

  7. Yogesh Kanojia says:

    Sir, I am putting my code file and sample data in my Dropbox folder named ShivYogesh, Dehradun
    Please check.

  8. KIRAN HIREMATH says:

    Hello sir ,
    I have completed till this chapter, Please check my dropbox

    thank you

  9. Pravin Adsul says:

    Hallo sir I am Pravin Adsul I am getting Error In C:\Users\Admin\Dropbox\TM( TDL)\Pravin Adsul\Sales Report Module 12- getting C000005 error and explode Isshue.

Leave a Reply