4Site
Support Request System
View Patch #60.000.079
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03486 -
Stkbyown problems - doesn't match acct total after dataload
Symptoms:
Stock By Owner didn't balance with GL and some stock values. Some stock information was duplicated or didn't appear under the correct warehouse.
Solution:
case 1 - added check that i.owneracct = " & .Quote(sAccount) commented out check for i.whseid = w.whseid If I didn't check that the stinitval (sttotals) account was the same as the account I was running for, then the transactions actually duplicated if the stock was in sttotals for both ABEL and TASMAN and in stockwhse for both warehouses. I commented out the whseid check because I don't think we had to check that it was in the same warehouse as the stinitval(sttotals). It missed some records if we checked. The stock might now exist in both ABEL and TASMAN yet was never setup for that warehouse or only one of them. case 3 - added check for account being run <> sttotals account changed OR for period to AND. In AccountDataInsert: - rounded value for acactual - if the value for: curvalbal, qoh or issueprice is blank, set it to 0 so it calculates correctly.
Browse Patches
Find a Patch
Return to Request System Menu