Registry Inventory Adjustments Journal (sys-viewer-vinvntryadjstmnt)

Testing Your Registry Entries
The system does not verify the validity of registry entries. Be sure to test your registry entries after completing them to verify that they are functioning correctly.

Setting Values are Uppercase-Lowercase Sensitive:
The Setting Value is case-sensitive: be sure that you enter the value exactly as specified in the documentation. If the documentation specifies a value of true, do NOT enter True or TRUE.

Id:  sys-viewer-vinvntryadjstmnt

See the Standard Registry section in Registry Viewer for additional Registry Id formats to allow entries for specific Users, Branches, Security, or User Groups to override the main entry.

Warn if Exceeding Quantity / Unit Cost Thresholds  

Id: sys-viewer-vinvntryadjstmnt  

Setting Key: QuantityNotToExceed   Setting Value: threshold quantity

When this option is set and the quantity entered exceeds the value,  a warning will display: 'Warning: Quantity entered exceeds limit entered in Registry'

Setting Key: UnitCostNotToExceed   Setting Value: threshold cost

When this option is set and the unit cost manually entered exceeds the threshold cost value a warning will display: 'Warning: Unit Cost entered exceeds limit entered in Registry.'

Default Quantity Billable in Return to Inventory  and Fill Lines Wizards

If an Inventory Adjustment is generated as a result of running the Work Order's Return to Inventory Wizard or the Inventory Adjustment's Fill in Lines Wizard, the Quantity Billable will only default from the Quantity if the following registry entry is enabled.

If this registry is enabled, when you import costs in the Work Order that were generated via this function, the line will specify a negative quantity AND a negative billable quantity. If this registry entry is not set, the billable quality will be zero when it is imported.  In either case, the user may adjust the billable quantity on the imported line.  

Id:  sys-viewer-vinvntryadjstmnt

Setting Key: QtyBillableEqualsQtyReturned   Setting Value: true

Enable Creation of Serialized Items

This enhancement enables the entry of new Serialized Items in the Inventory Adjustments Journal. A registry entry is required to enable this functionality:

Id:  sys-viewer-vinvntryadjstmnt

Setting Key: CreateNewSerialNumber Setting Value: true (default is false)

To ‘create’ a new serialized item in the Inventory Adjustments Journal:

Enter the Period Id and Effective Date, and set the Entry Type to ‘Adjustment’.

Enter the Inventory Item Id the serialized item.

Enter the new Serial Number: when you tab out of the field the system will prompt that the serial number does not exist, click Yes to create it.

Enter a Quantity of 1 and the appropriate Unit Cost.

Select the ‘To’ Location (on the bottom line) where you want the new Serial item to be created.

When you save the journal entry, the new item will be available at that Location.

Prevent Use of Completed Job Cost Code or Billing Items

Setting Key: CostCodeDateCompletedValidation Setting Value: error

Setting Key: BillingItemDateCompletedValidation Setting Value: error

Currently, the system warns you if you enter a billing item or job cost code whose Date Completed exceeds the effective transaction date. These options change the current warning to an error.

It's also important to note that the validation logic implemented by this registry entry only applies when either a Cost Code Id or a Billing Item Id field's value is explicitly changed by the data entry user.  The Cost Code and Billing Item registry entries are independent from one another.  Note that these options may be specified in Registry Entry Global Settings registry entry for a more far-reaching implementation.

Require a GL Entity for Income / Expense Accounts

Setting Key: ValidateGLEntityIE Setting Value: Error or Warning (pick one or the other)

Specify Error if users should be prevented from saving the entry without specifying a GL Entity (if the GL Account is an Income or Expense account) or Warning if the user should simply be warned of the situation.

Deny a GL Entity for Balance Sheet Accounts

Setting Key: ValidateGLEntityBS Setting Value: Error or Warning (pick one or the other)

Specify Error if users should be prevented from saving the entry with a GL Entity specified for a Balance Sheet Account, or Warning if the user should simply be warned of the situation.

Option to warn or error if no default billing item

This registry option will generate an error or warning if the user selects a Job Cost Code without a default Billing Item. This corrects a problem that occurred when the used picked a cost code without a default billing item resulting in the entry not having a billing item in history, and therefore was not imported into Record Billing Adjustments. The following registry option is needed to report either an error or a warning:

Setting Key: NoDefaultBillItem Setting Value: error OR warning

The default billing item is displayed in the Magnify view of the Inventory Adjustment Journal child tab.

Technician Material Pickup Wizard

The Material Pickup function creates an Inventory Adjustment Journal entry, but does not provide access to the Effective Date and Accounting Period fields so the defaulted values are always used.  This means that sometimes (for example, at the beginning of the month) the default Effective Date (today) and the Accounting Period flagged as Default may be out of sync. A registry entry is now available to adjust either of the values to keep them in sync. 

When the defaulted Date and Accounting Period are NOT out-of-sync, NO adjustments are made to the defaulted values.  The rules noted below are used only when an adjustment is necessary.

Id:  sys-viewer-vinvntryadjstmnt

Setting Key: AdjustDefaultDateOrPeriod  

Setting Value: period

The Accounting Period table is queried for eligible Accounting Periods.  To qualify, the period must be Active and its date range must include the defaulted Effective Date.  When multiple periods are eligible, the one with the smallest Period Id is chosen to become the new Accounting Period for the current transaction.  If no eligible period is found, nothing is changed.

Setting Value: date

The Effective Date is adjusted to be either the Start Date or the End Date of the defaulted Accounting Period.  The Start Date is chosen when the current date is less than the Start Date.  The End Date is chosen when the current date is greater than the End Date.

NOTE: the current SAMPro behavior does not change unless the registry setting is turned on.  The Material Pickup function is the one exception to this.  It in the absence of this setting, it uses the 'adjust period' behavior described above.

Job Cost Burden Applied to Inventory Costs

SAMPro provides for an option job cost burden to be applied to inventory costs when Inventory Adjustment Journal transactions are generated. To do so, the Burden Rate % field would be completed in one or both of the following places:

In the Inventory Item record

In the Location Rate record (the Apply Location Burden field must be flagged in the applicable Inventory Item Groups)

In addition, the following registry entry is required to specify the income account to be credited with the burden.

Registry Id: sys-viewer-vinvntryadjstmnt

Setting Key: AppliedBurdenGLAccountId   Setting Value: gl account id

where the Setting Value specifies the GL Income Account that will be credited with the applied burden.