Salesforce

Backdating Transactions

« Go Back
Article

Overview

Many of the Inventory Cost Transaction records generated in Rootstock can be backdated based on the Division's Cost Accounting Control and Cost Accounting User Control records. These records allow an Accounting Department to manage what can be backdated, to define the date that transactions will be backdated to, to define who can do the backdating and for how long backdating can occur, all on a transaction type basis.

Processing

Sales Order Fulfillment Page

Navigation

SO Fulfillment

Sales Order Issue and Reversal Transaction Backdating

Cost Accounting Control Record

Set 'Back Date', 'Sales Order Issue Backdating User ID' and 'Sales Order Issue No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Sales Order Issue or Issue Reversal operations from the Sales Order Fulfillment page. The transaction IDs are:

  • SOISS - Sales Order Issue
  • SOISSR - Sales Order Issue Reversal

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Sales Order Issue or Issue Reversal operations from the Sales Order Fulfillment page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction IDs are:

  • SOISS - Sales Order Issue
  • SOISSR - Sales Order Issue Reversal

Inventory Location Adjust Page

Navigation

Inventory Location Adjust

Inventory Adjustments Backdating

Cost Accounting Control Record

Set 'Back Date', 'Inventory Adjustment Backdating User ID', 'Inventory Adjustment No Transact Days', 'Inventory Scrap Backdating User ID', 'Inventory Scrap No Transact Days', 'Cycle Count Adj Backdating User ID' and 'Cycle Count Adj No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for adjusting quantity (UP or DOWN or SCRAP) on an inventory location from the Inventory Location Adjust Page. The transaction IDs are:

  • INVLOCADJ - UP or DOWN
  • INVLOCSCRP - SCRAP
  • INVLOCADJ & CYCLECNT (Transaction Sub Id) - CYCLE COUNTING

Inventory Location Add Page

Navigation

Inventory Location Add

Inventory Location Add Backdating     

Cost Accounting Control Record

Set 'Back Date', 'Inv Loc Add Backdating User ID' and 'Inv Loc Add No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for adding an Inventory Location from the Inventory Location Add page. The transaction ID is:

  • INVLOCADD

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Inventory Location Add from the Inventory Location Add page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction IDs are:

  • INVLOCADD - Inventory Location Add
 

Inventory Reconciliation Page

Navigation

Inventory Reconciliation Review & Processing > Physical Inventory Reconciliation Batch

Inventory Reconciliation Backdating     

If the inventory reconciliation entry needs to be adjusted (up or down), it will be done as an Inventory Cost Transaction with Transaction ID 'INVLOCADJ" and a Transaction Sub ID "CYCLECNT". The Transaction Sub ID is the reference Transaction ID for backdating setup purposes.

Cost Accounting Control Record

Set 'Back Date', 'Cycle Count Adj Back Dating User' and 'Cycle Count Adj No of Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating when processing cycle count via Inventory. 

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Inventory Reconciliation - Cycle count. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The expected transaction ID for backdating this process is:

  • CYCLECNT
User-added image  IMPORTANT In regards to Inventory Reconciliation backdate processing, settings for CYCLECNT are used and those for INVLOCADJ are ignored.
 

Location To Location Transfer Page

Navigation

Location To Location Transfer

Location To Location Transfer Backdating

Cost Accounting Control Record

Set 'Back Date', 'Loc to Loc Move Backdating User ID' and 'Loc to Loc Move No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for moving Item's quantity from one Inventory Location to another location from the Location To Location Transfer page. The transaction ID is:

  • INVLOCLOC

Work Order Issue Page

Navigation

WO Issue

Work Order Issue Backdating   

Cost Accounting Control Record

Set 'Back Date', 'WO Issue Backdating User ID' and 'WO Issue No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Work Order Issue operation from the WO Issue Page. The transaction ID is:

  • WOISS

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Work Order Issue operation from the WO Issue page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • WOISS - Work Order Issue

Work Order Issue Reversal Page

Navigation

WO Issue Reversal

Work Order Issue Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Work Order Issue Reversal operation from the WO Issue Reversal page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • WOISSR - Work Order Issue Reversal

Work Order Receipt Page

Navigation

WO Receipt

Work Order Receipt Backdating

Cost Accounting Control Record

Set 'Back Date', 'WO Receipt Backdating User ID' and 'WO Receipt No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Work Order Receipt operation from the WO Receipt page. The transaction ID is:

  • WORCPT

Work Order Receipt Reversal Page

Navigation

WO Receipt Reversal

Work Order Receipt Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Work Order Receipt Reversal operation from the WO Receipt Reversal page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • WORCPTR - Work Order Receipt Reversal

Work Order Close Page

Navigation

Work Orders

Button

Close WO

Work Order Close Backdating     

Cost Accounting Control Record

Set 'Back Date', 'WO Close Backdating User ID' and 'WO Close No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Work Order Close operation from the Work Order Page. The transaction ID is:

  • WOCLOSE

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Work Order Close operation from the Work Order page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • WOCLOSE - Work Order Close

Work Order Close Reversal Page

Navigation

Work Orders

Button

Reverse WO Close

Work Order Close Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Work Order Close Reversal operation from the Work Order page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • WOCLOSER - Work Order Close Reversal

Purchase Order Issue Page

Navigation

Purchase Order Entry

Rootstock Quick Access Menu

PO Issue

Purchase Order Issue Backdating     

Cost Accounting Control Record

Set 'Back Date', 'PO Issue Backdating User ID' and 'PO Issue No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Purchase Order Issue operation from the PO Issue Page. The transaction ID is:

  • POISS

Set field 'Allow Date Override to PO Issue' to true on a particular Division's Cost Accounting Control Record to display the field 'Transaction Date' on the Purchase Order Issue Page.

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Issue operation from the PO Issue page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • POISS- Purchase Order Issue

Purchase Order Issue Reversal Page

Navigation

Purchase Order Entry

Rootstock Quick Access Menu

PO Issue Reversal

Purchase Order Issue Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Issue Reversal operation from the PO Issue Reversal page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • POISSR- Purchase Order Issue Reversal

Purchase Order Receipt Page

Navigation

Purchase Order Receipts

Purchase Order Receipt Backdating

Cost Accounting Control Record

Set 'Back Date', 'Purchase Order Receipt Backdating User ID' and 'PO Receipt No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Purchase Order Receipt operation from the Purchase Order Receipt Page. The transaction ID is:

  • PORCPT    

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Receipt operation from the Purchase Order Receipt page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • PORCPT - Purchase Order Receipt

Purchase Order Receipt Reversal Page

Navigation

PO Receipt Reversals

Purchase Order Receipt Reversal Backdating   

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Receipt Reversal operation from the PO Receipt Reversal page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • PORCPTR - Purchase Order Receipt Reversal

Purchase Order Close Page

Navigation

Purchase Order Entry

Button

Close PO

Purchase Order Close Backdating   

Cost Accounting Control Record

Set 'Back Date', 'PO Close Backdating User ID' and 'PO Close No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Purchase Order Close operation from the Purchase Order Page. The transaction ID is:

  • POCLOSE

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Close operation from the Purchase Order page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • POCLOSE - Purchase Order Close

Purchase Order Close Reversal Page

Navigation

Purchase Order Entry

Button

Reverse PO Close 

Purchase Order Close Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Purchase Order Close Reversal operation from the Purchase Order page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction ID is:

  • POCLOSER - Purchase Order Close Reversal

Time and Qty Booking Page

Navigation

Time and Qty Booking

Labor Booking Backdating

Cost Accounting Control Record

Set 'Back Date', 'Labor Booking Backdating User ID' and 'Labor Booking No Transact Days' fields appropriately on a particular Division's Cost Accounting Control Record to perform backdating for Labor Booking operation from the Time and Qty Booking Page. The transaction IDs are:

  • OPLAB
  • OPMACH

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Labor Booking operation from the Time and Qty Booking page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction IDs are:

  • OPLAB - Operation Labor Booking
  • OPMACH - Operation Machine Booking

Time and Qty Booking Reversal Page

Navigation

Time and Qty Booking Reversal

Labor Booking Reversal Backdating

Cost Accounting User Control Record

Create a Cost Accounting User Control Record for a particular manufacturing user to perform backdating for Labor Booking Reversal operation from the Time and Qty Booking Reversal page. Set 'User ID', 'Transaction ID', 'Today's Date' and 'Back Date' fields appropriately on this record. The valid transaction IDs are:

  • OPLABR - Operation Labor Booking Reversal
  • OPMACHR - Operation Machine Booking Reversal

SEE ALSO
 
Settings
Backdating Transactions
Backdating-Transactions

Powered by