Stock Creation for Two Wheeler Showroom

Discussion in 'Requests' started by Kapilgsm, Feb 28, 2013.

         
  1. Kapilgsm

    Kapilgsm New Member


    Dear sir,

    I want to maintain motorcycle stock in tally please tell me the process. I will give u the detail.

    My requirement in Invoice.

    Chassis No.
    Engine No.
    Model
    Colour

    For Example
    Model: TVS Apache RTR 160
    Colour: Black
    Chassis No: MD634KE32AD43252
    Engine No: 0E4C32232233

    STOCK REPORT FORMAT NEED AS FOLLOWS

    TVS APACHE RTR 160
    BLACK COLOUR
    CHASSIS NO ENGINE NO


    Please help me our give any suitable format or TDL to enter.
     



  2. GOURAV JAIN

    GOURAV JAIN Member


     



  3. Nirav Merchant

    Nirav Merchant Active Member


    ( Without any TDL ) U have to create Seperate Item for Different Colors - or can use Batch Nos for that
     



  4. Nirav Merchant

    Nirav Merchant Active Member


    find sample data for two wheelers let me know if more details u require
     

    Attached Files:




  5. Kapilgsm

    Kapilgsm New Member


    THANKS A LOT SIR FOR YOUR REPLY AND HELP.

    I NEED
    MODEL NAME
    CHASSIS NO
    ENGINE NO
    WHEN WE PRINT INVOICE



    I TRIED AS FOLLOWS

    I FEED CHASSIS NO IN ITEM AND ENGINE NO IN ALIAS
    IN GROUP I MAINTAIN MODEL NAME WITH COLOR

    FOR EXAMPLE I ATTACH AN IMAGE

    BUT IN INVOICE PRINTING ONLY CHASSIS NO:MD634KE45AD32432 IS SHOWN.

    IF ALIAS AND UNDER OR CATEGORY ALSO SHOWN IN INVOICE MY PROBLEM IS SOLVE.
     

    Attached Files:




  6. Gagan Jyoti

    Gagan Jyoti New Member


    Hi Friend,

    I saw your question...

    See first of all you actually need a TDL for your invoice, but in case you do not want to add any TDL to, or do not want to spend money, you may do the following steps.

    1. Treat Different Chassis number as different stock.
    2. Enter your Engine number in Part Number.
    3. Put your item name in Description.
    4. Batch may also be used.

    For Printing follow the shortcut Please press "F12", "P", "S", "S"

    Please make "Method to use for Stock Item Name" to "Name (Part No.)", as it will help you to print your chassis number with engine number and as the description of stok item is also enabled you may enter the details of your two wheeler in that.

    also check the stock summary by pressing alt + F1 (it will show you items with Batches if used)

    Actually this is one of the many methods you may use. The other method may be USE BATCHES FOR YOUR CHASSIS NUMBER. :)

    Full supporting Verticle solution for Two wheeler is also available, including inquiry follow ups and service management etc.

    Thanks

    Gagan
     



  7. Nirav Merchant

    Nirav Merchant Active Member


    hi this is the code if u want to print invoice Item with Alias or Part Number or Descrption or all together
    InvAlias : $OnlyAlias:StockItem:$StockItemName
    InvDescName : $Description:StockItem:$StockItemName
    InvNameAndDesc : $StockItemName + " (" + @@InvDescName + ")"
    InvPartNumber : $PartNo:StockItem:$StockItemName

    also u can add $parent:Stockitem:$stockitemname for ( Group - of Stockitem Name )
    and $category:stockitemname:$Stockitemname for printing Category of stockitem name
     



  8. Nirav Merchant

    Nirav Merchant Active Member


    Hi u can use following code

    [#Field: EXPINV Desc]
    set as : "Chessis :" + " " + $stockitemname + $$newline + " Eng No : " + "$OnlyAlias:StockItem:$StockItemName + $$newline + " Model No : " + $parent:Stockitem:$stockitemname
    also u can use category or description by adding another line this will print in invoice

    Chessis no : k123344
    Eng no : eng 1234
    Model No : Black pulsar 150

    i think this will help you
     



  9. Kapilgsm

    Kapilgsm New Member


    thank you very much to help me
     





  10. Hi Mr Gagan...

    Iam Looking out for the same solution..Please mail me your contact details.
     




  11. dear all, that method regarding item name with color set as item name is correct , chasis as batch no. ( tvs called as vin no ) and remaining the eng no i suggest to feed in narration ( if one purchase entry = one item with one qty ). i have developed tvs,hyundai,honda,tata gdms / dms / cbell system to tally integration like purchase, receipts,sales,workshop sales with ll taxations , spares pur / sales etc.

    if vehicle booked and not delivered then stock trf to bbnd ( billed but not delivered ) like this we used many tricks for getting correct stock as per tally vs gdms.
    many times sales persons also fake sales for target achivments then also use stock transfer for advance booking or fake booking.

    also i have batchwise detailed stock report with ageing and mfg dates.

    i have added color and veriant as new fields in master and called in all reports like invoice, stock etc.

    approx 35 developed for integration excel to tally because all DMS reports can easily export to excel.

    rbmithari@gmail.com
     



  12. Vishnu Prasad

    Vishnu Prasad New Member


    Sir, i have same kind of stock item
    But it will have Part No.+stockitemname and on the next line stock item description

    What to do sir?
     



Share This Page