Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Andrew Rutledge]

Hi All,

I noticed that an item was set up wrong in our system. The inventory posting group was filled in incorrectly.

Only a PO has been received for the item so far. Unfortunately, that means it went into the wrong G/L account. I changed the posting group, but this created problems with matching the subledgers. To resolve, I then proceeded to remove the inventory through the item journal, change the inventory posting group to the correct name and finally made a positive adjustment through the item journal.

To my surprise, it did not go into the correct G/L account when posted even though i updated the posting group before making the positive adjustment; it reverted to the incorrect G/L account in what i can only assume was based on the original (and incorrect) inventory posting group. I tried a couple different things, but kept getting the same result.

Not sure how to resolve this one. Has anyone experienced this? Any advice?

——————————
Andrew Rutledge
Staff Accountant
Marine Ingredients
Mount Bethel PA
——————————

[Jenn Claridge]

HI Andrew
Your approach should have worked. The only thing I can think of is if the Item Journal line was created before the item card was updated and then the actual “Post” was done after the item card was corrected. That would have kept the old posting group as any master record update would not update any open journal lines.

I would adjust out the inventory again under the wrong posting group, make the item card change, add the item to the Item Journal and do the positive post. I am not sure what version you have but there may be a “preview posting” button you can select from the Ribbon which will show you where the posting will hit before you actually post.

If this does not resolve the issue I would check your cumulative update version because if this doesn’t work you likely have some sort of bug.

Jenn

——————————
Jenn Morton
Manufacturing Consultant
Sabre Limited
Cambridge
——————————
——————————————-

[Andrew Rutledge]

Hey Jenn,

I definitely made sure to be careful with my steps as i went through. I first made a negative adjustment in the item journal. I then changed the posting group. Then made a positive adjustment.

For some reason the material still goes into the wrong G/L account even after i update the inventory posting group.

I’m at a loss. I think i may have to reach out to our partner on this one.

——————————
Andrew Rutledge
Staff Accountant
Marine Ingredients
Mount Bethel PA
——————————
——————————————-

[Cynthia Priebe]

Andrew, 

The Posting Group on the Purchase Line is also saved to the Purch. Rcpt. Line. 

Did you undo the Receipt as part of your “undo” process? Not certain, but could be related to this.

I would recreate the scenario in a test system and see if this could be the culprit.

——————————
Cynthia Priebe, MCTS, DCP
Senior Business Analyst and Project Manager
Liberty Grove Software
——————————
——————————————-

[Andrew Rutledge]

Hi Cynthia,

Unfortunately the PO was already invoiced. My solution was to issue the item out on the item journal, update the posting group and make a positive adjustment on the item journal. It still went into the wrong GL account, but i’m not sure how NAV would know to use that if i updated the posting group.

——————————
Andrew Rutledge
Staff Accountant
Marine Ingredients
Mount Bethel PA
——————————
——————————————-

[Ian Ray]

Andrew,

I tried this as a test. Using the item journal, the same account is used as the initial purchase. I realize you have already discovered this.

If I instead issue a credit memo to reverse the first purchase and create a new purchase with the changed inventory posting group, the new account is used for invoicing the new purchase. After this, item journals will use the new account.

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Val Gameiro]

Could be something wrong with the Inventory Posting Setup. Are all your locations set up with the correct G/L Account?

If you post a screenshot we can always eliminate that as a potential problem.

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma
Austin, Texas
——————————
——————————————-