Skip to main content

Hi,

 

We are having repeat problems when creating receipts for Inventory Parts over the month end period.

 

Often raw materials arrive over the weekend, and sometimes the last day of the month is a Saturday or Sunday, but they are not booked until Monday. When trying to backdate the receipt, it says it cannot be done because of the Inventory Statistics period being incorrect.

 

Prior to Transferring Inventory Transactions, I tried going into the Inventory Transaction Details to change the applied date and had the message: “The new date must be equal to or greater than the start date of the latest period in the inventory value statistics”

 

There has to be a way to allow this to happen. Can anyone help please?

 

Thank you,

 

John

Hello @JohnP 

Most probably you have scheduled task to aggregate inventory transactions per period. Please find it and see if the execution offset is set to 0? In that case all inventory transactions until the date of task is run (sysdate) will be aggregated and you cannot enter any backdated transaction. 

If you set an execution offset for the task, say 2 days, then it will aggregate transactions until sysdate- 2 days. So you will have 2 days gap to complete backdated receipts.

 

Here is help description for the field

 

Execution Offset:
Number of days prior to the specified scheduled date. Each time the scheduled task is processed, inventory transactions that have not been aggregated previously and have transaction dates prior or equal to the number of days specified, will be aggregated.
 

 

Hope this helps

Reply


Terms & ConditionsCookie settings