Movement MD Fixing Incorrect Records Directly in SQL
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>
For extra information please call us: 1-866-528-0577, 1-630-961-5918 or email us: [email protected] <\p>