|
We're on the point of giving up on extracting meaningful accounting data from GP. I'm not sure if it's the product, or just the way the data has been created, but there doesn't seem to be any way to connect a general-ledger transaction (GL20000 / GL30000) to the corresponding entry in the customer (RM30101) or supplier (PM30200) ledgers. If we import the ledgers in isolation, it's looking like a manual process to go back over 10 years of transactions to tie them together. 
Damnit, Jim! I'm a code-monkey, not an accountant!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard,
Have you tried one of the builder tools? If you can get the result in a report or list then you can use the generated SQL View to extract the data.
I let my Accounting folks build the output tools as a) they know Accounting far better than I and b) I'm lazy! 
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
Part of the problem is, we don't have access to the front-end tools, only the SQL database.
From what we've seen, they're importing the data from several other systems into GP, and the import doesn't create any links between the ledgers. We're going to try to get access to the other systems to see if their copy of the data makes any more sense.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Good luck!
I'll ask my wife to see if she has any ideas. If I can get you some meaningful SQL, I'll post on this thread!
Did you try looking at the import batch numbers? I set the batch numbers on my own integrations (using VB Script/OLEDB) which helps with debugging/audit trails from my source data into GP. IM uses VB Script, SmartConnect uses .NET code (one reason to consider switching!)
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
I don't recall seeing any import batch numbers. I'll have a look next time I'm on the box.
PhilLenoir wrote: I'll ask my wife to see if she has any ideas. If I can get you some meaningful SQL, I'll post on this thread!
Thanks! If you manage to point me in the right direction, I'll definitely owe you a ![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif) .
Now it seems I've managed to hijack your thread for my own dubious purposes, and almost turned it into a programming question. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
You anarchist!
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
... she just dropped by to ask one of the IT crew a security question. She thinks that they're tied together using the sub-ledger "audit code" and that there's a canned report used for cross-checking. She'll have a look when she has time and send me the report name (from which I should be able to get the SQL < fingerscrossed />
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
I just wrote a new article (2nd part of two) on how to write an RSS Feed Reader using Angular and Firebase API (nosql).
Anyway, there's another urchin who has written an article on how to download a feed reader and both times I've posted my articles, then the urchin reposts an "updated" article so his article gets placed on the main feed. But look at the revisions, they are like, changed the letter 'a' to 'a'. Uh, yeah, good stuff. Yes, I'm ranting.
It thought this place was for "those who code"?
Whatever.
I know this is not the world to call people out on their bad behavior because someone's feelings may get hurt, but give me a break, man. Make CodeProject better, or get lost.
Don't just gum up the works with useless crappy articles.
|
|
|
|
|
The worst result of this would be that your article is pushed down one level on the front page. Not sure why you are all worked up about it. Or are you concerned that seeing two articles on the same topic in the front page would take some readers away from your article?
|
|
|
|
|
Okay, it's just annoying. You are right.
|
|
|
|
|
This has been going on forever when I used to submit articles people would down vote me a 1 so their article would stay on the front page and mine would fall off.
It is what it is!
New version: WinHeist Version 2.1.0 Beta
Have you ever just looked at someone and knew the wheel was turning but the hamster was dead?
Trying to understand the behavior of some people is like trying to smell the color 9.
I'm not crazy, my reality is just different than yours!
|
|
|
|
|
Okay, no problem. I'm with you.
It is what it is.
I agree, wholeheartedly.
|
|
|
|
|
Oh, that person...
There was a little talk about him in these days...Some abusing his privileges...
Do not let it bother you, just let it go...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: let it go...
I think there is a song there somewhere. (At least every kid in the US knows it).
I'll get my coat.
|
|
|
|
|
Corporal Agarn wrote: I think there is a song there somewhere.
Oh, do you mean that one by the Beatles?..what was it?..oh year, 'Letter B', one of my faves!  That song helped a lot on those tough multiple choice tests in college.
"Go forth into the source" - Neal Morse
|
|
|
|
|
Ah, thanks. Now I don't have to go to take a look. I don't read his articles. I find his writing style distracting.
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
you can always update your article. Say, change b to b. 
|
|
|
|
|
Slacker007 wrote: you can always update your article. Say, change b to b
Yes, play the game. But, I like other games.
|
|
|
|
|
The only winning move is not to play. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Take it as a compliment, move on and have a beer.
|
|
|
|
|
Nagy Vilmos wrote: and have a beer.
I've already had a 12-pack, but if you insist.
Where'd you think my belligerence came from?
|
|
|
|
|
Nagy's buying!
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
Okay, here's the other reason I was annoyed, if anyone cares...I know they don't.
One year ago I tried to publish this article (link below) and they (whoever they are) wouldn't allow it, even though it has code examples and shows how to use fabricJS to create a simple utility.
They wouldn't publish it, so I tabled it. I use the little utility all the time and it's kind of cool.
But, then these other articles get published which show how to download a feed reader. What?!
So now I'm trying to publish it again. Wonder if it will fly?
Take a read:
Easy Image Viewer: Using Fabric.js API (HTML5 Canvas)[^]
|
|
|
|
|
I'm published!! I'm published!!! w00t! w00t! I'm feeling much better now.
The belligerence has worn off. Well, wait about 5 minutes.
|
|
|
|
|
If your article is better which I am sure it is, based on the rather pathetic attempt the other person makes to bump you down the list, you will get more views anyway based on google searches and code project searches.
Just feel a little sorry for the poor sod whose only tactic is to do what he did rather than provide anything new 
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
