Amortization Schedules

Overview

The NetSuite Amortization Schedules integration synchronizes depreciation and amortization schedules from NetSuite to Zudello for accurate asset tracking and financial reporting.

Integration Details:

• Direction: NetSuite → Zudello (📥 Inbound)
• Sync Type: Full Sync
• Sync Frequency: Daily
• API Used: SuiteQL

Key Benefits

• Accurate depreciation tracking across systems
• Supports multiple amortization methods
• Maintains complete schedule history
• Enables consolidated asset reporting

Field Mappings

NetSuite Field	Zudello Field	Description	Data Type
name	ScheduleName	Amortization schedule identifier	String
amormethod	Method	Amortization calculation method	String
amorperiod	Period	Amortization period in months	Integer
residualvalue	ResidualValue	Asset residual value	Decimal
initialamount	InitialAmount	Original asset value	Decimal
isInactive	Status	true = INACTIVE, false = ACTIVE	String
amorstartdate	StartDate	Amortization start date	Date
amorenddate	EndDate	Amortization end date	Date
recurrence	Frequency	Schedule recurrence pattern	String

API Configuration

SuiteQL Query Structure

The integration performs a full sync of all amortization schedules to ensure complete data accuracy and maintain schedule integrity.

Authentication

• Method: Token-based Authentication (TBA)
• Required Permissions:
  • Fixed Assets (View)
  • Amortization Schedules (View)
  • Lists → Accounting (View)

Sync Configuration

Full Sync Logic

Due to the nature of amortization schedules and their interdependencies, this integration performs a complete sync:

• All schedules are retrieved regardless of modification date
• Historical data is preserved for audit purposes
• Deleted schedules are identified by comparing with previous sync

Data Transformation

• Status Conversion: NetSuite boolean isInactive (T/F) → Zudello string status (INACTIVE/ACTIVE)
• Date Formatting: Ensures consistent date format across systems
• Amount Precision: Maintains decimal precision for financial accuracy

Processing Logic

1. Full Data Retrieval: Query all amortization schedules from NetSuite
2. Schedule Validation: Verify schedule integrity and date ranges
3. Method Mapping: Map NetSuite amortization methods to Zudello equivalents
4. Status Processing: Convert and apply active/inactive flags
5. Relationship Linking: Associate schedules with corresponding assets
6. Audit Trail: Maintain change history for compliance

Troubleshooting

Issue	Possible Cause	Solution
Missing schedules	Permission restrictions	Verify Fixed Assets view permissions
Date calculation errors	Timezone differences	Check timezone settings in both systems
Method mismatch	Unsupported amortization type	Review method mapping configuration
Duplicate schedules	Schedule name changes	Implement unique identifier tracking
Performance issues	Large schedule volume	Consider batching or off-peak sync

Related Documentation

• NetSuite Integration Overview
• Asset Management Guide
• Financial Reporting
• Sync Configuration