Skip to main content

Notifications

Microsoft Dynamics GP forum
Unanswered

New GL Account upload to GP Dynamics

Posted on by 10

 Hi All,

Can I mass upload additional (500) GL accounts in our existing chart of account using Integration Manager without overlapping the existing files? The purpose of this is to use the PSTL in migrating OLD GL to New GL.

Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New GL Account upload to GP Dynamics

    You can Cards->Inventory->Sites to link a site to one segment of your GL. Transferring inventory goes goes one asset account to another not to an expense account.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New GL Account upload to GP Dynamics

    That will be GL00100.ACTNUMBR_3 or GL00105.ACTNUMBR_3. You need to obtain the ACTINDX value for your expense account and assign it to IV00101.IVIVINDX.

    SELECT ACTINDX FROM GL00100 WHERE ACTNUMBR_3 = 'desired expenses account'

    UPDATE IV00101

    SET IVIVINDX=value of ACTINDX for the desired account

    WHERE ITEMNMBR 'specify your item number range'

    You may need to update IV00101.IVCOGSIX instead as I am not sure if you want to update the inventory or cost of goods account.

  • GRMC Profile Picture
    GRMC 10 on at
    RE: New GL Account upload to GP Dynamics

    Thanks Richard,

    Basically , when I perform a transfer of inventory, How can I default the GL account of  location from inventory to Inventory? I manually keyed In the " To Inventory" GL account cause when I clicked the distribution it was showing the GL account # 10-83800-108101 to both  " From Inventory" and " To Inventory".

    pastedimage1576123335375v3.png

    Thanks

  • GRMC Profile Picture
    GRMC 10 on at
    RE: New GL Account upload to GP Dynamics

    Thanks Richard,

    We have 3 segments - XX-XXXXX-XXXXXX, Facility, Department- Accounts,  I only want to update the account segment as supplies expense

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New GL Account upload to GP Dynamics

    You can start with a spreadsheet. In that spreadsheet you need item number and GL account. You import that spreadsheet into SQL. You can then use the GL00100 table to get the ACTINDX and then update the inventory table(IV00101) table.

    How many segments in your GL accounts?

    If you look at your item cards you will see several GL accounts. Which accounts do you want to update?

  • GRMC Profile Picture
    GRMC 10 on at
    RE: New GL Account upload to GP Dynamics

    I need to access someone,but if you have a standard script that we can replicate , it will be a good help.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New GL Account upload to GP Dynamics

    There is always SSMS and writing SQL scripts. Can you do that or do you have access to someone who can?

  • GRMC Profile Picture
    GRMC 10 on at
    RE: New GL Account upload to GP Dynamics

    Thanks Richard,

    Is there any other way aside from that, cause I have 1000 plus items that needs to be defaulted to different accounts.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New GL Account upload to GP Dynamics

    Cards->Inventory->Items and pull up an item and the the Accounts button. The Inventory account will allow you to assign the default supply account. If you use Item Classes you can make the change to the class and roll down the change.

  • GRMC Profile Picture
    GRMC 10 on at
    RE: New GL Account upload to GP Dynamics

    Hi Richard,

    I have a follow up on Item transfer Distribution entry in Inventory- How can I default an account segment when transferring to a site ID or location: Please see sample below:

    pastedimage1575939186723v1.png

    Basically, When we transfer Items to location, we want the account segment to be defaulted to " supply account". The account that was there was old set up and I want it to be defaulted in new account segment.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans