Tag: General Ledger
Based on a reader’s request, I have created a variation on my SQL view for Dynamics GP open year GL trial balance. This version will show you the month end balances instead of the net change for each month
No, my post title it’s not an official slogan for the conference, but the reIMAGINE 2014 conference in Fargo promises to be just what Microsoft Dynamics GP partners had been expecting for years: and all out sales, technical consulting, and software developer extravaganza that combines the likes of the former Great Plains Software’s Stampede to Fargo and the Microsoft Dynamics GP Technical Airlift. But there’s a caveat: as a partner, YOU get to provide feedback on the content and topics you want to see and learn about
Granted, MVP Mark Polino hates Report Writer (RW), but even he will admit he loves a good RW nugget when he sees one. Several times I’ve been asked “how do I visualize long Report Writer calculated field expressions?”
A multi-company client recently encountered a situation where a newly created company produced no data in their consolidated financials. After much digging, I found the answer. It lies in the way the Account Segments were named in the Account Format Setup window. In this particular company, the GL Account segment name was abbreviated: Note in the first image that ‘GL Account’ is abbreviated, while in the other image, it is spelled out. The segment names must be identical across all companies to return results properly in MR. Also, in this case, the Main Segment ID didn’t match the other companies, which is a problem as well.
How do we find transactions that were voided in the Receivables Management (RM) module, but not in Sales Order Processing (SOP)? This question has come up few a times on newsgroups and also with our customers. Most recently there was a question on the Dynamics GP Community Forum about this. The script below is a slightly cleaned …
It’s been a long stretch of time since my last post but I tend to only post those things that I think are truly useful to users. Here’s one that heretofore, I never knew existed. I’m implementing the Inventory (IV) and Purchase Order Processing (POP) modules for a client. Their business model calls for the use of only Drop-Ship POs and they asked if there was any way to limit the PO Type that users can enter. I initially told them it would require a slight customization to accomplish that. However, I was reviewing the POP training materials supplied by Microsoft this morning, and lo and behold, I ran across a paragraph in Chapter 1 – Overview and Setup, that discusses this very topic