Bin Contents

Inventory in GoldFinch can be tracked by Warehouse, Bin, Item, Unit of Measure, and Lot through the Bin Content records.

Occasionally, you may want to delete Bin Content records with a quantity of 0. Follow the steps below to safely delete these records.

Steps to Delete Bin Content Records

• Open the Developer Console.

• Go to Debug > Open Execute Anonymous Window.

• Run the following code:

  GFERP.CompanyMgmt.systemCall = true;
DELETE [SELECT Id FROM GFERP__Bin_Content__c WHERE Name = 'BC-0000447'];

  Replace the WHERE clause with your own filters as needed.

Important Notes

• Bin Content records can only be deleted if their quantity is zero.

• Deleting a Bin Content record also deletes all related Warehouse Entry records.

• GoldFinch allows deletion of Bin Content records even if they are linked to the following open transactions:

  • Warehouse Activities

  • Warehouse Shipments

  • Warehouse Receipts

  • Sales Invoices

  • Item Journals

  If the Bin Content is still referenced in these transactions:

  • You can exclude those records from deletion, OR

  • Proceed with deletion, but you must recreate the related transactions before posting.

Handling Large Record Associations

If you encounter the following error:

"Record has too many associations with other objects to be deleted."

This likely means there are too many Warehouse Entry records. To work around this:

• Add a custom checkbox field To Be Deleted on the Bin Content table.

• Write a script to set this field to true if:

  • Quantity = 0

  • Not referenced in any open transactions (as listed above)

• Create a formula field To Be Deleted on the Warehouse Entry table, referencing the To Be Deleted field on the related Bin Content record.

• Confirm no users are posting new transactions.

• Delete all Warehouse Entry records where To Be Deleted = true.

• Then, delete all Bin Content records where To Be Deleted = true.

Article Bin-Contents  ·  Last updated September 25, 2025 · GoldFinch ERP Help Center