Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Sales Order Allocations

  • A new object "GF Item Allocation Summary" is created to store summarized item allocation by warehouse, by item, and by unit of measure.

  • Trigger "GF_ItemAllocationTrigger" is added to detect Insert, Update, and Delete operations against the GFERP's Item Allocation object. The system will increase or decrease the quantity count in the summarized table base based on the operation type/or the quantity change detected by the trigger.

  • A nightly job routine is scheduled to recalculate the allocated quantity in the summarized table.

    Night

    The night job will

    runs

    run the

    bataches

    batches in the following order

    .

    :

  1. Empty the summarized table - GF_DeleteSummarizedItemAllocationBatch

  2. Prepare the item allocation table - GF_UpdateItemAllocationBatch

  3. Generated Generate summarized item allocation records - GF_SummarizeItemAllocationBatch

...

GF_SOAllocationAndWhseShiptCreationSched

How to Schedule to Routine

To schedule the routine, run this:

Code Block
String cron = '0 0 0/1 1/1 * ? *'; //hourly 
GF_SOAllocationAndWhseShiptCreationSched sched = new_GF_SOAllocationAndWhseShiptCreationSched(); 
String jobId = System.schedule('Sales Order Allocation and Whse. Shipt. Creation Job', cron, sched); 

...

To look at all sales orders with Document Status = Open, sort by Order Date Date.

Then it calls GF_CreateWhseShipmentBatch with Batch Size = 1?

Info

Two fields were created to record errors. (

...

The system will write the error msg to all records if one record

...

fails in the batch) 

  • Allocation_Processing_Error__c 

  • Whse_Shipt_Processing_Error__c