At a client that utilizes GP2010.
I assume they have various accounts that are incorrectly set up (my belief is inventory items) that default to 9999-999.
Is there a way to run a report to identify which items / ? are posting to the 9999-999 account without looking at everything manually
Thanks in advance
*This post is locked for comments
Hi,
In addition to the ideas already suggested.
You can create a SmartList of items with the accounts listed in columns.
You can check the Historical Inventory Trial Balance for things that have already posted to that account.
Kind regards,
Leslie
Something like this will get you started in SQL.
SELECT ITEMNMBR,ITEMDESC,GL5.ACTNUMST,GL0.ACTDESCR
FROM IV00101 IV
INNER JOIN GL00105 GL5 ON IV.IVSLSIDX=GL5.ACTINDX
INNER JOIN GL00100 GL0 ON IV.IVSLSIDX=GL0.ACTINDX
There are several other GL accounts you can go after so just pick and choose which one you would like.
Hi Stan
The first place I would look would be to go to Microsoft Dynamics GP > tools > setup > posting > posting accounts
You can look through each series and see which default accounts are setup. Change as necessary.
If nothing is there or even if you find the accounts setup there, open smartlist and use Inventory > Items
You will need to add columns for the Various account types (COGS, Inventory control, Revenue, Returns etc). this will give you the items and the GL accounts assigned to them.
You should note that the inventory items may be assigned to Item Classes and obtain their accounts from the class so you should check that as well to ensure that new items created don't get populated with the wrong accounts that may still be sitting at the class level.
Or if you are comfortable with SQL you can run a query on the Item Master (IV00101). Note that for the GL accounts it will return the GL Index so you will have to do a join to the GL master and bring the full account in that way.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
