Released on: 18, April 2007
, Author: Alba Spectrum Group
, Audience: Computers related
Alba Spectrum Group, http://www.albaspectrum.comhe lp@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP has pretty robust inventory control and purchasing modules. When you track your inventory items by lot numbers, you may come to the situation,when lot numbering becomes inconsistent due to either power failure during postingor if you use third party custom modules, participating in lot tracked transactions. Below we would like to give you brief excurse to lot number tracking and providefixing scripts: Item Lot Number Master table, IV00300. This table gets record when lot isreceived at the specific date, please familiarize yourself with its primary key toget an idea. Now we should come to the complication of GP business logic, relatedto the fact, that lot number tracking is optional. This is why lot numbers refer togeneral table: Inventory Purchase Receipt Work  this table participate in regularlogic, when we donÂ't use lot numbering Inventory Purchase Receipt Work, IV10200. This table gets record when itemsarrive to GP via Purchase Receipts, Inventory Adjustments or Inventory transfers (inthis case items are simply moved from one IV site to another)
We provide you fixing scripts, however you should analyze and try them first in testenvironment, as your specific case is now known to us and you should be responsiblefor SQL data repair.Below please see script repairing missing IV00300 when IV10200 record is present:
insert into IV00300(ITEMNMBR,LOCNCODE, DATERECD,DTSEQNUM ,LOTNUMBR,QTYRECVD ,QTYSOLD ,ATYALLOC,UNITCOST ,RCTSEQNM,VNDRNMBR,LTNUMSLD ,QTYTYP ,BIN,MFGDATE,EXPNDATE)sel ect a.ITEMNMBR,a.TRXLOCTN,a.DAT ERECD,1,e.SERLTNUM,a.QTYREC VD,0,0,a.UNITCOST,a.RCTSEQ NM,'',--VNDRNMBR0,a.QTYTY PE,'','01/01/1900','01 /01/1900'
from IV10200 ajoin IV30200 b on b.DOCNUMBR
Source: Express-Press-Release.com
Related downloads
SpamSource is an addin for Microsoft Outlook 2000/XP/2003/2007.SpamSource helps collect information from messages for use in reporting unsolicited junk email.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven sound-topics with different listener-positions and changing backgrounds gives a long prolonged motivation.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven game-accompanied sound-topics and changing backgrounds gives Blocker Plains a long prolonged motivation.
With jk-ware Theater Blocker Plains, Color LIFE Sound and Perpetuum mobile can be started multiple times and run simultaneously. Think and purpose of jk-ware Theater is to test the capability of modern computers playfully.
Have more than 1 set of lottery numbers? Running a
syndicate? Getting fed up with checking them all
manually? 'Lottery Checker Plus' can help you, easy
to use and tells you how many matching numbers you have.
You are a pilot of the plane, your goal is to destroy the city, erase it from the surface of Earth. Game control is not easy, but very easy! The bomb hatch is always open, simply press ANY key and the bombs will start to fall.
Real-time OscilloScope + FFT Spectrum Analyzer of data accepted from sound card or other ADC you will want.
CD/Spectrum Pro is a CD/MP3 Player with Graphical Spectrum Analyzer for Windows. It comes with CD Audio player, Spectrum Analyzer, Mixer, the MediaFiles (MP3/WAV) Player, Synchronized Visuals Window, etc.
This sophisticated piece of software turns your computer into a modern, State-of-The-Art spectrum analyzer giving you features that go far beyond the possibilities of any stand-alone hardware unit.
The program is based on the model-free method of time series analysis Caterpillar-SSA (Singular Spectrum Analysis). It allows identification, analysis and forecast of the time series structure. The program can be applied to multivariate analysis.
