Daily Adjust Cost Routine

Applies toFinancial Closing Procedures

AudienceAll users

Last updatedOctober 02, 2025

The Adjust Cost Routine must be executed for the following reasons:

1. To finalize costs for the output items from finished Work Orders and posted Kit BOM journals.

2. To update outbound inventory costs due to the "timing difference" that may occur when an inventory layer is sold either before the final purchase invoice is posted or before the work order is finished and costing is finalized.

3. To update Warehouse Shipment Line costs and Sales Invoice Line costs for accurate sales profitability reporting.

4. To update the Average Base Unit Cost on the Item Card.

This routine uses the Posting Date of the Item Ledger Entries to be the Posting Date of the Cost Adjustment Entries and the General Ledger Entries.

If the Posting Date is prior to the date defined in the Allow Posting From field in the Company Setup, this routine will use the Allow Posting From Date as the Posting Date.

To have General Ledger Entries for the Cost Adjustments posted to the correct financial month, it is important to change the dates in the Allow Posting From and the Allow Posting To fields in the Company Setup to the new month after closing the previous month.

Update the date defined in the Allow Posting From and Allowed Posting To fields for users who require to post GL Entries in the previous month. Read Setup Users for more information.

Scheduling the Adjust Cost Routine

To schedule the Adjust Cost Routine, follow the instructions on the GoldFinch Job Scheduler.

• Apex Class: BatchILECostAdjustment

• Frequency: Nightly, after all posting routines have been completed.

Important: Before closing a month, go to Item Ledger Entries and click Pending Cost Adjustment to ensure no pending entries remain.

Handling Pending Cost Adjustment Item Ledger Entries

If you find Pending Cost Adjustment Item Ledger Entries that have not been cleared, follow these steps:

Manual Troubleshooting

• Re-run the Adjust Cost Routine on the Job Scheduler.

  • Unschedule the current job and click Run Now to execute it immediately.

• Remember to reschedule the job again.

• Review the Apex Job for any errors that may have occurred during the scheduled run.

• If entries still remain:

  • Submit a support ticket to the GoldFinch Support Desk for further assistance.

Proactive Monitoring

To automatically monitor for unresolved entries:

1. Create a custom report showing all Item Ledger Entries with a pending cost adjustment status.

2. Subscribe to the report to receive nightly updates after the Daily Adjust Cost routine runs.

---

Common Cause: Salesforce Governor Limits

The most frequent cause of pending entries is the Adjust Cost Routine exceeding Salesforce governor limits. This typically occurs due to custom trigger code on key objects.

Objects to Review for Custom Triggers:

• Sales Invoice & Sales Invoice Line

• Warehouse Receipt & Warehouse Receipt Line

• Warehouse Shipment & Warehouse Shipment Line

• Item Journal & Item Journal Line

• Work Order & Work Line

• Item

• Item Ledger Entry

• Product

Recommended Solution:

Implement conditional logic in your trigger code to bypass custom logic during the Adjust Cost Routine.

For GoldFinch Support Staff

Some errors may not appear in the Salesforce Apex Job.

To investigate:

1. Log in via the Subscriber Console.

2. Navigate to:
   Administration → Inventory → Run Manual Adjust Cost Routine

3. Run the process to view detailed errors to troubleshoot.

---

Article Daily-Adjust-Cost-Routine  ·  Last updated October 02, 2025 · GoldFinch ERP Help Center