Home » Categories » 02. Shop Management 5.9 Legacy

Merge Inventory Master Record

Problem:

How to determine which Inventory record will be the Master when using the Merge Inventory option.

Versions:

OnDemand ManagerPlus SU/MU, SK5 Managerment v5.8.x

Solution:

The "Last Sold" record and the Stk No fields must be considered when determining the Master Record.

The Stk No determines which was in the database first. The lower Stk number would be the older record.

Theolder record will be the Master if theolder record has"Last Sold" populated and the newer record doesNOT have the "Last Sold" populated.

If any of the following are true than the newer record will be the Master:

If both records have "Last Sold" populated

Ifboth records do not have "Last Sold" populated

If the original record does not have "Last Sold"populated and the new record does have "Last Sold"populated

5.7.A.8ACDelco ManagerPlusalso behaves the same way.

Also some Developer Notes on what records are updated:


In reviewing the Merge Inventory option for ManagerPlus V5.8, I found there is no place where we describe what fields are actually being merged. I assume your people will need to know.

When we merge two parts with the same part number, the values for the following fields are accumulated into the values in the ‘Master' record: Total Cost, On Hand, On Order, Committed, Core Quantity, Month-to-Date Quantity, Month-to-date Sales, Year-to-date Quantity, Year-to-date Sales, and the Monthly quantity for 12 months.

In addition, any parts on open orders or open purchase orders are updated with the new line code.

There are a number of fields that are not affected. This was done with the assumption that the ‘Master' record, which was created more recently, has correct values.

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
Related Articles RSS Feed
Windows 7 PC NAPA Catalog button DAX Error
Viewed 5660 times since Fri, May 25, 2012
Enable Integration to use OnDemand5.com or ShopKey5.com
Viewed 3891 times since Tue, May 26, 2009
Posted Orders ’Grand Total’ Differs From ’Sales Receipts Summary’ Total
Viewed 3364 times since Wed, Jun 11, 2008
Winhelp32 (winhlp32.exe) Missing / Training Videos not working
Viewed 4326 times since Mon, Oct 8, 2012
Install Customers Marked Non-Tax Report
Viewed 2404 times since Tue, Dec 30, 2008
Why Don’t Report #s Match?
Viewed 2603 times since Sat, Mar 7, 2009
How to Remove License Plate
Viewed 2242 times since Fri, Feb 10, 2012
Restoring Mgmt Training Videos
Viewed 2570 times since Wed, Oct 15, 2008
Change Vehicle Ownership
Viewed 13226 times since Sat, Oct 31, 2009
Posted Order Report Totals Higher Than Totals On Cash Receipts Report
Viewed 10328 times since Wed, Jun 11, 2008