Copy Warehouse Location

Solution Categories

Automotive | Analytics | Chemical Manufacturing | Collaboration | Computer & Electronic Equip. Manufacturing | Customer Relationship Management | Construction | eCommerce | Education | Financial Management | Finance, Insurance and Real Estate | Human Resource Management | Food & Beverage Manufacturing | Integration | Government | Inventory Management | Life Sciences | Logistics | Machinery Manufacturing | Mobility | Metal Fabrication | Portals | Not for Profit | Project Management | Other Manufacturing | Sales | Other Services | Paper & Printing | Professional, Scientific, and Technical Services | Retail Trade | Telecommunications | Transportation and Warehousing | Utilities | Wholesale Distribution

Copy Warehouse Location

Proposed Solution:

An MS Access 2000 program will be written to allow the user to select the existing warehouse from which to copy and the destination warehouse into which they should be copied.. The application will copy all Item Location records, replacing the warehouse location with the destination location and setting all appropriate fields to zero in the new location records.

Detail of Requirements:

A user interface will be provided.

The 'Copy From" combo box will be populated with all Macola locations that contain Item Location records.

The 'to this location' combo box will be populated with Macola locations for which no Item Location records exist.

When the user selects 'Do It!', the application will copy all records from the 'Copy From' location. Each destination record will be identical to the source record with the exception of the following fields:

Field

New Value

Loc

New Location value

Qty_On_Hand

0

Qty_Allocated

0

Qty_Bkord

0

Qty_On_Ord

0

Last_Sold_Dt

0

Sls_Price

0

Qty_Last_Sold

0

Starting_sls_dt

0

Ending_sls_dt

0

Last_Count_Dt

0

Tms_cntd_ytd

0

Pct_err_last_cnt

0

Frz_cost

0

Frz_qty

0

Frz_dt

0

Frz_tm

0

Usage_ptd

0

Qty_sld_ptd

0

Qty_scrap_ptd

0

Sls_ptd

0

Cost_ptd

0

Usage_ytd

0

Qty_sold_ytd

0

Qty_scrap_ytd

0

Qty_returned_ytd

0

Sls_ytd

0

Cost_ytd

0

Prior_yr_usage

0

Qty_sold_last_yr

0

Qty_scrap_last_yr

0

Prior_year_sls

0

Cost_last_yr

0

Avg_usage

0

Active_ords

0

Tag_qty

0

Tag_cost

0

Tag_frz_dt

0

Upon completion the user will be informed via a standard messagebox "Process is complete!".
General Information
  • Live Implementation: 1-5
  • Customer References Available: No
  • Maintenance Plan Available: No
  • Support Plan Available: No
  • Technical Documentation: Yes
  • User Manual Documentation: No
  • Marketing Literature: No
  • Suggested Retail Price: $1,200.00
  • Available for Resale: No
  • Primary Contact Person - Sales: This e-mail address is being protected from spambots. You need JavaScript enabled to view it - Tel: 800-468-0834 Ext.2650
  • Primary Contact Person - Technical: This e-mail address is being protected from spambots. You need JavaScript enabled to view it - Tel: 978-474-4900
  • Web-Site/URL: www.exactamerica.com
  • Information Last Updated: 2006-10-16
Languages Exact Product Line
  • English
  • Exact Macola ES
  • Exact Macola Progression
Development Platform Modules Impacted
  • Other
  • Inventory Manager
Database Supported Version
  • MS SQL 2000
  • Pervasive PSQL
  • N/A
Industries Horizontal Focus
  • Automotive
  • Chemical Manufacturing
  • Computer and Electronic Equip. Manufacturing
  • Construction
  • Education
  • Finance, Insurance, & Real Estate
  • Food & Beverage Manufacturing
  • Government
  • Life Sciences
  • Metal Fabrication
  • Machinery Manufacturing
  • Not for Profit
  • Other Manufacturing
  • Other Services
  • Paper & Printing
  • Professional, Scientific, and Technical Services
  • Retail Trade
  • Telecommunications
  • Transportation and Warehousing
  • Utilities
  • Wholesale Distribution
  • Analytics
  • Collaboration
  • Customer Relationship Mgmt (CRM)
  • e-Commerce
  • Financial Mgmt
  • Human Resource Mgmt (HRM)
  • Integration
  • Inventory Mgmt
  • Logistics
  • Mobility
  • Portals
  • Project Mgmt
  • Sales