4Site
Support Request System
View Request #03260
Description
Title:
Request Type:
Request for paid enhancement
Request for information
Training
Data Investigation
Bug
Other
Description:
Deficiency Report/Enhancement Request We have discovered that there are disconnects between Price Book and Stores Setup that can result in inconsistent and unexpected accounting results: Users can edit a Stores Setup item and change the expense element to be different than the natural account associated with the Commodity Code linked to the related Price Book Item. Users can change the Commodity Code of a Price Book item, which may have a different natural account code from its prior Commodity Code. However, when the change is made, the associated Stores Setup item does not have its Expense account changed to the natural account for the new commodity code. A user can change the natural account assigned to a Commodity Code in the Price Book application. However, when the change is made, the Stores Setup items that are assigned to the Commodity Code do not have their Expense accounts changed to the new natural account for the commodity code. These disconnects between Price Book Items and their respective Store Stock items allow for significant accounting problems as the items unintentionally get out of synch relative to the natural account code. It is strongly recommended/requested that a configuration option be made that will allow the user (administrator) to configure the system so that Store Stock Items are linked/synched to their respective Price Book Items by Commodity Code. This would result in the following: 1) Editing of the Expense code on a Stores Setup item is disabled. 2) Changing of a Commodity Code on a Price Book Item will also update the expense element of the corresponding Stores Setup Item (if one exists) to be the same natural account of the newly assigned commodity code. 3) Changing the natural account assigned to a given Commodity Code will update the expense account on all Stores Setup items whose respective Price Book Items have that Commodity Code assigned. As an alternative to system configuration option, the System could prompt for updating Stores Setup items when these types of events are triggered by editing as well.
Priority:
Aliases:
High
Medium
Low
accounting
assigned
change
changing
counting
different
enhancement
inconsistent
item
option
price book
prior
problem
report
request
setup
stock
stores
system
trigger
update
updating
Application:
Application Option:
Accounting
Accounts Receivable
All - system wide change
Appropiations
Asset Performance
Background Crystal Job
Background Job Requestor
Background PM Workorders
Background Queue
Background Schedule Print
Background Service
Bank
Bids
Build Picture Clips
Buyers
Check Writer
Cheque Reconciliation
Codes
Contractor Management
Control Center
Document Routes
Employees
Equipment
Filings
Financial Reports Generator
Fixed Asset Register
Format
FRx Data Refresher
GST Reports
Hotspot Editor
Installation
Interface Run Control
Journal Vouchers
Messages
Meter Readings
Mobile
New
Not Applicable
Organization
Performance Indicators
Persons
Picking
Picking Background
Preventative Maintenance Program
Price Book
Projects
Purchase Order Batch Handler
Purchase Orders
Purchase Requisitions
Query Accounts
Query Appropriations
Query equipment
Query Financial Transactions
Query Persons
Query Preventative Maintenance
Query Price Book
Query Projects
Query Purchase Orders
Query Purchase Requisitions
Query Stores Setup
Query Suppliers
Query Tool
Query Vouchers
Query Work Orders
Receipts
Receivables
Recipient Created Tax Invoice
Register
Reorder Requests
Run Job
Scheduling
Security
Service Accruals
Spares and Turnarounds
Sql Patch Script
Standing and Reallocation JV
Statistics
Stores Quick Pick
Stores Requests
Stores Setup
Suppliers
Tax Codes
Templates
Timesheets
Training
Transaction Posting
VO Approvals
VO Review
Voucher Query
Vouchers
Web Purchase Requisitions
Web WO
Wo Backlog Report
Work Orders
Work Requests
Add
Batch
Browse
Change
Close
Copy
Create
Custom entries
Delete
Detail
Email
Export
Fax
Find
Grid
Import
New
None
Open
Other
Post
Print
Query
Reopen
Reorder
Report
Save
Tree
Workflow
Current Status
Status:
Status Date:
New
In FSC Approval
In Quotation
In Customer Approval
In Analysis
In Programming
In Quality Assurance
In Documentation
In Installation
In Shipment
In Billing
Closed
Cancelled
Reference Documents:
Disposition:
Development
Request for information
Installation and Training
Data Investigation
Support
Scheduled this release
Scheduled next release
Other
Sales Support
Resolution:
History
Status:
Status Date:
Reference Doc:
New
April 14, 2010
Browse Requests
Find a Request
Return to Request System Menu