Are you tired of asking why is it that some transactions do post through GL and why some don't? Tired of changing the posting settings to no avail? This issue outta be one of the most confusing issues for users and consultants, new or seasoned alike. If you ever struggle with one issue in GP, please tell me it's this one, because even today, I cannot claim victory over this subject. So let's walk the walk together.

What the theory says?

According to Part 3, Chapter 13, page 87 of the Microsoft Dynamics GP's System Setup guide, "If you mark the Post Through General Ledger Files option, batches posted in other modules automatically will update the module in which the transactions originated and the appropriate posting accounts in General Ledger. Your transactions will post to General Ledger and not through General Ledger when posting transaction individually (without a batch)."



Now…

I recently developed an eConnect SOP integration that needed to import up to 40,000 orders a day into Dynamics GP from an e-commerce web site.

At first this seemed like it might be a challenge due to the sheer order volume, but based on some tests I performed with sample data, I found that eConnect was able to import over 500 transactions per minute. This import speed would be more than adequate to handle 40,000 orders throughout a day.

But, there was a second challenge. Although I could easily import 40,000 orders into GP throughout the day, the client would have to post those order batches in GP. And posting a SOP order in GP takes quite a bit longer than importing the orders using eConnect. Additionally, because the orders were coming from an existing operational system, they did not need to be reviewed in GP prior to posting, so there was no need for human review and manual posting.

To accommodate the posting of the SOP batches, I searched for an auto-posting solution for Dynamics GP. I found a handful of auto-post add-ons for GP, but the one that…

Many of you automating posting jobs have come across an issue with these schedulers: you are only allowed to output reports to the same physical file setup under your posting options. If you attempt to do this via Named Printers, the MDI writer will use a generic and all too cryptic 'NoteXXXX' file name that cannot be associated to anything coming from GP.

So, I figured you could probably use a SQL Server job that would run, say 20 minutes before your habitual posting schedule to change the file name. The following example will use the General Ledger Posting Journal report as an…

Hi All I have been getting questions from many of my clients and network on the various…

For those users who enter/save transactions to a batch and then post the batch, they typically close the transaction entry window after entering/saving the last transaction, then open the appropriate batch window, then click on the batch lookup button to locate and select the…

Waqas Butt who was active the last few weeks detailed the level of posting to GL in post below:

http://waqasb.b…

One of my customers reported an issue this morning, they cannot apply a payment to its vendor invoice, the got the message shown below:

"You can't choose this document because it is part of a recovered batch or is still in the process of posting."

Well, my fast "stupid!" answer to this was "Go to batch recovery and recover your batch from there", but when I thought about it, it couldn't be un-posted if it was here to be applied!

My next advise -following the book!- was to check-links and reconcile the vendor transactions, but again non of them resolved the issue, so I did further investigations and went through the database, the transactions that couldn't be applied posted by one user, and exists in both PM10000…

Guys,

I faced allot of questions about the fact that Post Through GL does not effect posting individual transaction, in fact, I got requests to customize this feature to post through GL even if the transaction was posted individually, and the only solution I could make is to create a service…

Veeyeskay has a nice look at Posting Levels in Dynamics GP.

If you thought Post to GL and Post through GL were confusing, wait until you have to explain batch posting versus transaction posting and the implications of either to your client.…