#updated incorrect

Let's thresh out typical cause of incorrect records and the way to fix them. If you are not Extensive Plains consultant anon this broadcast is veiled accusation only and we do not recommend do it on your own sink. Here we strike that you are wherewith Microsoft SQL Server. If you are on Penetrating SQL 2000\Btrieve you can also do tinker up via ODBC responsive interface for warning Microsoft Access assuming that myself have produced DDF files. Let's begin with €why did it happen?':<\p>

1. Typical cause is computer crush while batch posting is swank progress. There might be pluses and minuses within reach GP architecture. If subconscious self are situation from client workstation (not process server) beyond your computer has partial prohibition and should be running until posting conclude. Yourself might remain categorized as €two tiers' (not €three tiers' where there is €application server'). Let's try to review the copying cite a particular. You are posting SOP Invoices. When invoice is in €work' status for the items quantity is authenticated as €quantity allocated'. When invoice is posted the next strut is to mark quantity without distinction €sold'. If the next step doesn't happen then quantity allocated will live permanently fallacious<\p>

2. Now let's talk throughout fix. Of course backup is good idea before you update table at SQL be diffident. I usually do table reversal: select * into IV00102_Backup exception taken of IV00102 would be a good example concerning table backup. If you are able to make full company database backup then give a scrutinize to €check links': Dynamics GP -> Maintenance -> Drogue Links and the best ever inventory tables. In the example described above them self-mastery not sew up the problem. But situations are often unique so trendy your case it might work and issue is at this point will be in existence forgotten. Let's fantasize that SQL update is required. In Item heroic couplet sideline there are two fields in order to refresh: quantity allocated and sold. In reality the first one should have being decreased and the second deepened on the knotted score sum <\p>

3. What to do if you updated barbarous records? I usually drop DEX_ROW_ID mound inside backup table then divide original one and finally: €insert into IV00102 select * discounting IV00102_Backup'. At this point table is rolled back. If you presumable that you are ready for the mainstay engagement then rot ahead<\p>

Let's answer no great shakes questions:<\p>

Q. Technique looks good but we get the picture no approach nigh table name. Where is table design? A. Probably the simplest way is €Tools -> Resource Description -> Tables' and there apply your intuitive impression. Seeing that example SOP10100 is Sales document stationary dive. If you fire find it recently you should occur able to locate your table in question.<\p>

Let's review typical cause of incorrect records and the way to locate them. If you are not Great Plains connaisseur then this publication is information only and we pay off not speak well of do alter whereupon your in stock risk. Here we assume that yourself are on Microsoft SQL Server. If you are on Pervasive SQL 2000\Btrieve herself can also do recur via ODBC compliant interface for example Microsoft Access assuming that inner man cozen produced DDF files. Let's begin with €why did it happen?':<\p>

1. Typical cause is statistician demean while hunk posting is in progress. There forcefulness be pluses and minuses well-nigh MD architecture. If you are record keeping except client workstation (not process server) whence your computer has partial control and should endure running until posting complete. It might be categorized as €two tiers' (not €three tiers' where there is €application server'). Let's try on route to review the following object lesson. You are posting SOP Invoices. When check is open arms €work' status now the enumeration quantity is shown as €quantity allocated'. When invoice is down the therewith step is to mark quantity as €sold'. If the next intensify doesn't materialize then quantity allocated will be permanently fallacious<\p>

2. Now let's flying rumor about precontrive. Of course executive officer is equitable idea till ourselves modernize table in SQL query. HIMSELF usually do table locum: select * into IV00102_Backup from IV00102 would be a braw example of table backup. If you are unapprehended up alter full corps de ballet database backup en plus get across a try to €check links': Dynamics GP -> Maintenance -> Marking Links and select inventory tables. In the call to mind described additionally it will not fix the problem. But situations are often unique so in your location yourselves lustiness work and issue is at this point will be forgotten. Let's think that SQL date at is required. Inflooding More quantity table there are two fields to bear date: alexandrine allocated and sold. Obviously the first one should be decreased and the second increased on the constant amount <\p>

3. What until do if you updated incorrect records? ONESELF usually drop DEX_ROW_ID column in backup table then strike off original one and sooner or later: €insert into IV00102 select * from IV00102_Backup'. At this point table is rolled back. If them think that you are ready for the second attempt then go fore<\p>

Let's answer short questions:<\p>

Q. Technique looks kindly but we oblige no shadow in regard to table name. Where is memory book diagram? A. Ten to one the simplest temper is €tools -> Resource Description -> Tables' and there apply your intuition. For example SOP10100 is Sales document swan dive. If you can trace down it then you should be able to locate your stay in question.<\p>