Asset linked to Purchase and Serialized Assets

[rmehta]

Allow non stock Serial No

• Allow user to set both asset and has serial no if is_fixed_asset=True
• Link Asset Maintenance to Serial No

Purchase Receipt

• Asset Location
• On PR submission - check auto creation of non stock Serial No and asset
• On PR cancel
  • delete Serial No
  • delete asset if in draft
  • remove PR link from asset if submitted
• Auto creation of Asset on Purchase Receipt
  • Create Asset (in Draft)
  • Naming Series field (in Item set asset series)
  • Create Serial Nos (as per standard flow)
  • Link asset to serial no
  • On deletion of asset, validate PR is cancelled
  • Create Asset Movement for Serial No
• In case asset item is a Product Bundle, create asset records for RM items if marked as is_fixed_asset.

Accounting Entry

• Debit valuation amount to CWIP (Capital Work in Progress) account and credit "Asset Received but not billed" (ARBNB)account on submission of PR
• Credit Creditors account and debit "Asset Received but not billed" (ARBNB)account on submission of Purchase Invoice and credit "Expenses "
• Make CWIP, ARBNB and Expenses Included In Asset Valuation account in standard chart of accounts
• Add account type "CWIP" and set default CWIP account in company based on account type.
• Add account type "Asset Received but not billed" and set default ARBNB account in company based on account type.
• Validate above 2 account while making PR
• Set Valuation Rate for Item (Net Amount + Tax Amount where tax category is Valuation or Valuation and Total)

Purchase Receipt
-----------------
item 100
tax1 (val+total) = 10
tax2 (val) = 5
tax3 (total) = 8

CWIP = 115(Dr)
ARBNB = 115(Cr)


Purchase Invoice
------------------

Creditors = 118 (Cr)
ARBNB = 115(Dr)
Tax = 18 (Dr)
Expenses Included In Asset Valuation = 15 (Cr)

Asset

• In Use Date (must be after submission date)
• Gross Purchase Amount (Set it from PR, based on valuation rate)
• Custodian (linked to employee)
• Insurance details
  • Policy number
  • Insurer
  • Insurance period – start and expiry date
  • Insured value
  • Comprehensive Insurance
• Post accounting entries via scheduler on in-use date
  • Debit Fixed Asset account defined in asset category
  • Credit CWIP account
• Depreciation
  • Depreciation Method, Frequency, Number of Depreciation, Value after depreciation and start date should be set based on Finance Book (Child Table)
  • Add the above table in Asset Category as well for defaulting
  • Create schedule for all finance books, add finance book column in schedule table
  • Create schedule from depreciation start date. But set depreciation amount for the first period based on put-to-use date using pro-rata.
  • Set Finance Book in Journal Entry for depreciation (auto)
  • Introduce new method WDV

Asset Category

• Add CWIP Account in default accounts child table

Location (Tree)

• Patch based on warehouse for existing customers (only run if submitted asset record exists)
• Replace Warehouse with Location in Asset and Asset Transfer document

Asset Movement

• Purpose, Date, Asset, Serial No, Qty, Source Location, Target location, From Employee, To Employee
• Either Location or employee is mandatory
• Validate serial no with asset and qty
• Update location in asset or serial no (if serialised asset)
• Allow group node of location

Asset Adjustment

• Finance Book, Asset, Date, Current Value (fetch based on value after depreciation on selected finance book), New Value, Company, Journal Entry
• Book fixed asset expenses for diff value against accumulated depr account via Journal Entry
• Reschedule for future depreciations

Sale of Asset

• Serial No in sale

#7469
#5766

[umairsy]

Could multiple Serial No. linked to one Asset, incase of large Asset item broken into multiple Serialised units?

[jma4227]

Hey, I don’t know if anyone is still following this , but has this been removed from v12?

[jimmielightner]

I'm trying to assign a serial number to fixed assets in v13 and it doesn't work. Once I tick the "is fixed asset" box on a new item, the "Serial and Batches" section becomes blank. I think this might be a regression @rmehta

[elan-k]

I'm trying to assign a serial number to fixed assets in v13 and it doesn't work. Once I tick the "is fixed asset" box on a new item, the "Serial and Batches" section becomes blank. I think this might be a regression @rmehta

The same issue identified in V12 as well.

Installed Apps :
ERPNext: v12.21.0 (HEAD)
Frappe Framework: v12.18.1 (HEAD)