Skip to main content
Question

Automation Schedule History showing empty column

  • Nov 5, 2026 2:20 PM UTC
  • 3 replies
  • 22 views
  • Translate All

Forum|alt.badge.img+2

I have Automation Schedule and in the Automation Schedule History i have empty column. Have any idea why? Automation Schedule working with my custom processing screen

 

3 replies

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7

I think the most likely explanation is that the record that is being processed lacks NoteID field. If there is no noteID field, the history of the processing is not saved for that record types.

Translate

Forum|alt.badge.img+2
  • Author
  • Captain I
  • Nov 5, 2026 3:11 PM UTC

I think the most likely explanation is that the record that is being processed lacks NoteID field. If there is no noteID field, the history of the processing is not saved for that record types.

I have Projection 
 [PXProjection(typeof(Select2<SKUIngredientMapping,
             InnerJoin<InventoryItem, On<SKUIngredientMapping.inventoryID, Equal<InventoryItem.inventoryID>>,
                 LeftJoin<INItemCost, On<SKUIngredientMapping.inventoryID, Equal<INItemCost.inventoryID>>>>,
             Where<InventoryItem.itemStatus, Equal<InventoryItemStatus.active>>>), Persistent = false)]
public class SKUIngredientMappingProcess : PXBqlTable, IBqlTable

An I have 
#region NoteID
[PXNote(BqlField = typeof(SKUIngredientMapping.noteID))]
public virtual Guid? NoteID { get; set; }
public abstract class noteID : PX.Data.BQL.BqlGuid.Field<noteID> { }
#endregion

In Process Screen I restrict this view by curyID

 public PXFilteredProcessing<SKUIngredientMappingProcess, SKUIntegrationProcessFilter,
     Where<Current<SKUIntegrationProcessFilter.action>, Equal<SKUIntegrationActionAttribute.updateIngredientCosts>,
         And<SKUIngredientMappingProcess.curyID, Equal<AccessInfo.baseCuryID.FromCurrent>,
         And<SKUIngredientMappingProcess.avgCost, Greater<Zero>>>>,
     OrderBy<Asc<SKUIngredientMappingProcess.inventoryID>>> Items;

I saw that in AUScheduleHistory filed RefNoteID not Equeal my field NoteID in SKUIngredientMapping.
I think i have it problem, NoteID is not unique in PXProjection because INItemCost not restrict by curyID in Projection

Translate

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7

​@bihalivan15  yes, that  looks like the cause of the issue

Translate