Dear All

I am working with GP 10 SP3.

In Screen:

Inventory à Transaction à Transfer Entry

Inventory à Transaction à Transaction Entry

Sales à Transaction à Sales Transaction Entry

I want to know the sequence that GP uses when I Post a transaction in any of the above screens, what are the tables affected and what fields affected inside these tables and Lots too.

I know that tables names in SQLSERVER2005 but I don’t know the sequence and I don’t know what the effected fields inside these tables are.

So please I need you advise if you please.

Thank you

I do have a post on this site (http://vstoolsforum.com/blogs/dynamicsgp/archive/2009/04/30/postin-sequences.aspx) where I catalog what I'm observing in Dynamics, but I give this with the greatest trepidation. I've only documented what I needed, it's not at all comprehensive.

This is all undocumented, and Dynamics can/may/probably will change it without notice. If you build production code based on this info, you're asking for trouble and I don't recommend it.

Just curious, why do you need to figure out all of this information?  Are you trying to reverse engineer GP for some purpose?  It's going to include a fair number of tables and a ton of SQL statements and stored procedures, so it's a lot of work.

Dear Sir

There is a problem that I am facing in my company, sometimes when posting a transfer there is errors happened in Item Stocks/Quantities and there Lot's too, due to (Posting interruption, Power failure, etc…)

So we are forced to make reconcile to that item or check links.

Which means that we have to get all users out of the system so we can start the reconcile for this item (we have 92 users on GP)

So my idea was to know how stuff works, so I can make this fixes under the hood, without telling anyone to go out from the system.

I hope I did explain the reason, if you please I need your advice.

Well, I applaud your effort, but I'd still try hard to do it within the system. Reconciline and Checking Links are very complicated routines, they've been thouroughly tested by the people that wrote the software. If you have a power failure and something goes wrong, they're the safest way to fix something.

I'd edge toward the safer route. Wait until after hours and do a reconcile.

Rather than try and figure out how to fix the problems in GP after a transfer error, I would recommend resolving the real cause of the problem, which you indicate are the "posting interruptions and power failures."

 If your business power is failing regularly enough that it is causing this issue on a frequent basis, you really need to invest in UPS devices or backup power.  GP (and most computer hardware and software) wasn't designed to deal with frequent power interruptions.  If you can't do that with 92 users, and you can't improve the power reliability at your company, then I would migrate to a Terminal Server or Citrix model where you can put those servers on a large UPS, which will allow the GP session to stay running even if the workstation loses power.

 If you are getting frequent batch posting failures in GP for some other reason, I would open a support case and get some help understanding why those are happening, as they shouldn't happen on a regular basis.  It could be that you have some other issue that is causing them to happen.

If your postings are failing for other reasons, look to resolve those causes so that they don't fail.  It will save you much more time in the long run than trying to fiddle with tables and records for a very complex process.

To find out exactly what GP is doing under the hood, you could try using the "Debug support tool" available on the PartnerSource site (not available on the CustomerSource site)

 http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/30/support-debugging-tool-for-microsoft-dynamics-gp.aspx

 http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/03/support-debugging-tool-the-wait-is-over.aspxd

You could also use SQL Profiler to see what is happening on the DB.

I however agree with the other two people who have commented on this matter. My previous employer had a similar problem occur about once every three months. Even with extensive knowledge of the DB tables we were unable to resolve the problem and in the end just learnt to live with it.

(PS some articles in the customer source knowledge base indicate that the cause of the problem could be power flunctation, however I am 100% sure in our case this was not the cause of the problem)

Dear All

i did all what you said concering UPS.

we are still facing the same problems, we do have ot make reconcile every day.

but there is only 1 issue that is in my mind which is:

I make the Sales Invoice with eConnect.
There a lot of customization using VS Tools for Dynamic GP.
my customization are in the following:
- Transfer Entry
- Sales Transaction Entry
- Receiving Transaction Entry
- Return to Supplier

please advise me i am in a really big trouble.

 thank you,

i fotgot something we are using now "Terminal Server"

thank you

 I remember once on a development machine I was working on, the item quantities where not being adjusted correctly, thus requiring a reconcile to fix the data. I applied the lastest service pack and the problem was fixed. If you don't have the lastest service pack, try installing it and you might just be lucky and have some of your problems go away.

i already have SP3 and it is installed and there is SP later that this one

if i am not correct please advise.

and please advise me more if you have any idea that can help me on this big problem

thank you

Ramzy:

I'm not sure what you're issue is, could you restate it?

Kind of odd that you say there are a lot of customizations using VStools, but you don't know the Sales Order Procesing tables. Did someone else do the customizations?

To attempt to answer your questions...a lot of tables. I agree with everyone else, you don't want to "fix" the data yourself- it's quite complex and if you don't even know the tables, then you are probably not at the level where you can interpret the GP logic by looking at the data.

If you are just trying to research what may be the issue, I would start looking at the SOP tables and the IV tables

If you have heavily customized GP, then I would assume you would at least know to go to Resource Descriptions to get the table names. After all, to use eConnect, you need to have a working knowledge of a lot of the tables themselves.

 As far as all the fields, that is quite complex. Perhaps you should narrow down the scope of your inquiry. Are you saying items are not being allocated properly when a Sales Document is created/fulfilled/posted? Or, Items are not being updated when Inventory transactions are entered?

Let me stop right there..I agree with Steve...what is the actual problem? Perhaps an example might help? Like if you were to say that that when posting a Sales Doc, the Item Quantity Master or the Item Bin Master was not updated with the correct amount. Be specific, though, and quote some numbers.

Before asking how it all works, you should read the SDK's and familiarize yourself with the GP model. These are available at Customer Source.

Unfortunately, when you ask what "...tables affected and what fields affected inside these tables...", it does end up sounding like an attempt to reverse engineer GP and this is not the place to post a question like that. I hope that is not your intent.

Thanks

-Dan