Inventory / Stock table info

GT9

Well-known member
  • Jun 22, 2013
    1,564
    167
    63
    [email protected]
    මචංල ඔයාල inventory / stock තියාගන්න සිස්ටම් හදල හෝ භාවිතා කරල තියෙනවනම් stock / inventory table එකේ තියෙන්න ඕන දේවල් ඔක්කොම කියන්න පුලුවන්ද?

    උදා-

    product name
    product category
    buying price
    sell price
    tax %
    ..........etc......

    ඔය මම කිව්වේ කීපයක් විතරනේ.

    මට දැන ගන්න ඕන හැම සිස්ටම් එකකම වගේ තියෙන කොමන් දේවල් ටික. Users වැදගත් වෙන දේවල්.

    උදව්වක් දෙන්න. ඉක්මනට මේක කරල දෙන්න ඕන. :baffled::dull:
     
  • Oct 17, 2012
    451
    110
    43
    Client
    Material Number
    Plant
    Storage Location
    Batch Number
    Deletion Flag for All Data on a Batch Stock
    Created On
    Name of Person who Created the Object
    Date of Last Change
    Name of Person Who Changed Object
    Fiscal Year of Current Period
    Current period (posting period)
    Sales Order Number
    Sales Order Line Item Number
    Physical Inventory Blocking Indicator
    Valuated Unrestricted-Use Stock
    Stock in transfer (from one storage location to another)
    Stock in Quality Inspection
    Total Stock of All Restricted Batches
    Blocked Stock
    Blocked Stock Returns
    Valuated unrestricted-use stock in previous period
    Stock in Transfer in Previous Period
    Stock in Quality Inspection in Previous Period
    Restricted-Use Stock in Previous Period
    Blocked stock of previous period
    Blocked Stock Returns in Previous Period
    Physical inventory indicator for whse stock in current year
    Phys. inventory ind. f. stock in qual. insp. in current year
    Physical inventory indicator for restricted-use stock
    Physical inventory indicator for blocked stock
    Physical inventory indicator for stock in previous year
    Phys. inventory ind. f. stock in qual. insp. in prev. period
    Physical inventory ind. for restricted-use stock, prev.pd
    Phys. inventory indicator for blocked stock in prev. period
    Country of origin of the material
    Date of Last Posted Count for Unrestricted-Use Stock
    Fiscal year of current physical inventory indicator
     

    Elysium

    Well-known member
  • Sep 18, 2007
    21,317
    870
    113
    Horizon!
    Requirement eka anuwa oka wenas wenaava nedha :)
    Apitanam model, serial number, quantity, location, date of purchased, warranty, transferred to wage dewaluth ona wenava
     

    GT9

    Well-known member
  • Jun 22, 2013
    1,564
    167
    63
    [email protected]
    උක්කුං බබා;20347601 said:
    Client
    Material Number
    Plant
    Storage Location
    Batch Number
    Deletion Flag for All Data on a Batch Stock
    Created On
    Name of Person who Created the Object
    Date of Last Change
    Name of Person Who Changed Object
    Fiscal Year of Current Period
    Current period (posting period)
    Sales Order Number
    Sales Order Line Item Number
    Physical Inventory Blocking Indicator
    Valuated Unrestricted-Use Stock
    Stock in transfer (from one storage location to another)
    Stock in Quality Inspection
    Total Stock of All Restricted Batches
    Blocked Stock
    Blocked Stock Returns
    Valuated unrestricted-use stock in previous period
    Stock in Transfer in Previous Period
    Stock in Quality Inspection in Previous Period
    Restricted-Use Stock in Previous Period
    Blocked stock of previous period
    Blocked Stock Returns in Previous Period
    Physical inventory indicator for whse stock in current year
    Phys. inventory ind. f. stock in qual. insp. in current year
    Physical inventory indicator for restricted-use stock
    Physical inventory indicator for blocked stock
    Physical inventory indicator for stock in previous year
    Phys. inventory ind. f. stock in qual. insp. in prev. period
    Physical inventory ind. for restricted-use stock, prev.pd
    Phys. inventory indicator for blocked stock in prev. period
    Country of origin of the material
    Date of Last Posted Count for Unrestricted-Use Stock
    Fiscal year of current physical inventory indicator

    මචං මේ මොනවගේ දේවල් stock තියාගන්න system එකක ටේබල් එකක්ද?

    තෑන්ක්ස් :)
     

    GT9

    Well-known member
  • Jun 22, 2013
    1,564
    167
    63
    [email protected]
    Requirement eka anuwa oka wenas wenaava nedha :)
    Apitanam model, serial number, quantity, location, date of purchased, warranty, transferred to wage dewaluth ona wenava

    ඔව් කස්ටමර්ගේ අවශ්‍යතාවය අනුව වෙනස් වෙන්න පුලුවන්. common table fields ටික දැන ගන්න තමා ඕන.

    :)
     

    rox2030

    Well-known member
  • Oct 11, 2010
    9,234
    2,307
    113
    elakiri pot එක - කාමරේ
    උක්කුං බබා;20347601 said:
    Client
    Material Number
    Plant
    Storage Location
    Batch Number
    Deletion Flag for All Data on a Batch Stock
    Created On
    Name of Person who Created the Object
    Date of Last Change
    Name of Person Who Changed Object
    Fiscal Year of Current Period
    Current period (posting period)
    Sales Order Number
    Sales Order Line Item Number
    Physical Inventory Blocking Indicator
    Valuated Unrestricted-Use Stock
    Stock in transfer (from one storage location to another)
    Stock in Quality Inspection
    Total Stock of All Restricted Batches
    Blocked Stock
    Blocked Stock Returns
    Valuated unrestricted-use stock in previous period
    Stock in Transfer in Previous Period
    Stock in Quality Inspection in Previous Period
    Restricted-Use Stock in Previous Period
    Blocked stock of previous period
    Blocked Stock Returns in Previous Period
    Physical inventory indicator for whse stock in current year
    Phys. inventory ind. f. stock in qual. insp. in current year
    Physical inventory indicator for restricted-use stock
    Physical inventory indicator for blocked stock
    Physical inventory indicator for stock in previous year
    Phys. inventory ind. f. stock in qual. insp. in prev. period
    Physical inventory ind. for restricted-use stock, prev.pd
    Phys. inventory indicator for blocked stock in prev. period
    Country of origin of the material
    Date of Last Posted Count for Unrestricted-Use Stock
    Fiscal year of current physical inventory indicator
    :)