web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Weirdness GP 9
Microsoft Dynamics GP (Archived)

Inventory Weirdness GP 9

(0) ShareShare
ReportReport
Posted on by Deanna Oaks 240

First, let me start by saying we do not have an IT department; nor do we have someone who is an expert GP user on staff. We are currently outsourcing our database management and our "response" team has yet to respond. I have had no formal training - learning as I go and reading help manuals and blogs (if anyone has hints, please pass along).

I have several inventory adjustments which are posting as GJ transactions rather than IVADJ transactions, even though they are posting through inventory transaction entries. The references indicate the IVADJ posting, but the source document in the G/L is GJ. When these transactions post in this manner, I can not retrieve any subledger detail pertaining to the journal entry in order to trace the inventory parts used in the adjustment. Since I don't know which items were used, I can not go back to trace the part to ensure they are relieved properly. The biggest problem I have with this is that my subledger and general ledger are not balancing, and I can't easily find the source. Any ideas on this one?

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Deanna,

    Is someone manually entering the original inventory transactions, or are they being integrated automatically from another system? If they are being integrated...how?

    Best regards,

    Ian.

  • Deanna Oaks Profile Picture
    Deanna Oaks 240 on at

    They are being integrated from a secondary production software package. We found a bug. I have a work around, but as it stands right now, nothing can be done.

  • Community Member Profile Picture
    Community Member on at

    Understood.

    How are they being integrated? eConnect? Integration Manager? or a custom built integration?

     

    Best regards,

    Ian.

  • Deanna Oaks Profile Picture
    Deanna Oaks 240 on at

    I will be getting the low down Wednesday afternoon.....still learning this whole thing!

  • Community Member Profile Picture
    Community Member on at

    Good stuff. Its likely you have a GP partner or an internal resource that built the integration. Therefore its probably best to check with them first, if the data seems to be integrating not as you would expect. But definately come back to me on this one if you can't get a resolution. Let me know what you find out wednesday anyway....curiosity killed the cat!!

    Take care,

    Ian.

  • Deanna Oaks Profile Picture
    Deanna Oaks 240 on at

    From my outsourced IT: "If the Reference begins with ‘IVA’ or ‘IVV’ followed by a number, the JE originated from an inventory transaction.  For example, JE 52505 has a reference of IVA0008920, so you go to Inquiry > Inventory > Transaction and lookup transaction number 0008920 to get to the original transaction."

    Okay - here's the deal: the transactions are posting as general journal entries, not as inventory journal transactions. When I look up the "orginal transaction" - well, the transaction does not reference the accounts in question. It is like there are two transactions - one that I can see and posts correctly, one that I can't see that posted incorrectly. I can't correct the incorrect entry, because I don't know what caused it. I'm tempted to just "unpost" the transaction I can't see the underlying data and see if it helps me reconcile my inventory subledger to the general ledger.....

  • Community Member Profile Picture
    Community Member on at

    Hi, from what you're describing, the integration may not be working as intended. If in fact two transactions are being integrated, then this seems odd. It should be a simple matter to integrate an inventory tranaction and let GP handle the GL postings. I would seriously query your outsourced IT. Have them bring you through one transaction from start to finish, and map all the steps.

    I know nothing about your system or what you are trying to do, but if its just an inventory movement you are recording, then the process should be very straighforward and transparent - doesn't seem to be in your case. In fact, even if its a very complex integration, the final solution should be methodical and transparent. Does your outsourced It have experience with GP?

     I've seen people do the most horrendous things trying to integrate transactions into GP when they don't understand how the system works. They start to write code on top of code to make their integration work, rather than going back to design and figuring out why their approach is not working in the first place. GP really is a very easy system to work with once you understand how it hangs together...and there are idiot proof (from a developers view point) tools that you can use like Integration Manager and eConnect.

    PM me if you want with any specifications / functional model documents and I can advise you of the best approach. It might give you some info. so you can speak knowledgeably with your IT.

     Hope you get it sorted,

    Best regards,

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans