{"id":31508,"date":"2025-11-28T12:43:13","date_gmt":"2025-11-28T12:43:13","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31508"},"modified":"2025-11-28T12:43:13","modified_gmt":"2025-11-28T12:43:13","slug":"how-to-fetch-data-from-fy-depreciation-plan-to-period-depreciation-plan-in-the-depreciation-plan-screen-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/11\/28\/how-to-fetch-data-from-fy-depreciation-plan-to-period-depreciation-plan-in-the-depreciation-plan-screen-in-sage-x3\/","title":{"rendered":"How to Fetch Data from FY Depreciation Plan to Period Depreciation Plan in the Depreciation Plan Screen\u00a0in Sage X3"},"content":{"rendered":"\n

Sage X3<\/a> is an enterprise resource planning (ERP) system that helps organizations efficiently manage operations and data across all functional areas \u2014 including Sales, Purchasing, Inventory, Projects, and Finance.

During one of our implementations, a client requested a customization in the Depreciation Plan screen. Specifically, the requirement was to ensure that the value present in the FY Depreciation Plan is automatically repeated in the Period Depreciation Plan grid across multiple lines whenever the user clicks on a line in the FY Depreciation Plan grid.

This article explains how to achieve this functionality step by step.<\/p>\n\n\n\n

Step 1: Add a Custom Field in the Period Depreciation Plan Screen<\/strong><\/p>\n\n\n\n

Create and add a new custom field in the Period Depreciation Plan grid to hold the fetched data value. Once added, verify that it appears properly in the grid layout.<\/p>\n\n\n\n

New Stuff :-<\/strong> Alternative to the \u201cIN\u201d Operator of SQL in Sage X3<\/a><\/p>\n\n\n\n

\"GUMU<\/a><\/center>\n
Fig. 1 for the Period Depreciation Plan grid.<\/center><\/font>\n\n\n\n

Step 2: Modify the Standard Script SUBDPP<\/strong>
Open the standard script SUBDPP and locate the Subprog AS_NBLIG1 function. Within this function, include your customization logic to copy data from the FY Depreciation Plan grid to the Period Depreciation Plan grid.<\/p>\n\n\n\n

\"GUMU<\/a><\/center>\n
Fig. 2 for the SUBDPP script.<\/center><\/font>\n\n\n\n

Step 3: Assign the Custom Field<\/strong>
Assign the field [M:DPP1]ZPAMT1(NOLIGN-1) with the ZTEST variable as shown in the example below.<\/p>\n\n\n\n

This ensures that when a user selects a line in the FY Depreciation Plan, the value from that line is captured and automatically repeated in the next grid (Period Depreciation Plan).<\/p>\n\n\n\n

\"GUMU<\/a><\/center>\n
Fig. 3 for the modified script.<\/center><\/font>\n\n\n\n

Step 4: Validate the Output<\/strong>
After making the changes, validate the results by navigating to the Depreciation Plan screen. When you click on any line in the FY Depreciation Plan grid, the corresponding value should now appear in multiple lines of the Period Depreciation Plan grid.<\/p>\n\n\n\n

\"GUMU<\/a><\/center>\n
Fig. 4 for the final output.<\/center><\/font>\n\n\n\n

Additional Notes<\/strong><\/p>\n\n\n\n