Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Darek Kawa]

Hello,

I had integrated (Integration Manager) a large amount of SOP’s ( non inventory items ). SOP posting is setup to post accounts from the customer. Before the integration, only AR and Sales accounts were inputted. COGS and Inventory were left blank. After the integration the batch edit list shows an error “Distribution account(s) are missing or invalid.”

To fix this problem and to be able to post this batch I need to update accounts for COGS and Inventory. The problem I have is: how to make this  update for a few hundred SOP without typing account numbers in a each single one?

Thanks for your help.

Darek

——————————
Darek Kawa
Cypher Systems Group Inc.
Windsor ON
——————————

[Jen Kuntz]

Hi Darek,

Here are a few options, each with their own pros and cons!

1. If nothing has been shipped/printed yet or done with the SOP documents (assuming invoices since you’re talking about posting), perhaps delete the batch and reimport after setting up the proper default GL accounts. You may be able to reset the next SOP number back so you don’t have gaps in your sequence numbers, if you want to literally reproduce the same doc numbers a second time.

2. You could run a SQL script to update those lines on the SOP Line Item table. The complexity depends on whether COGS and INV accounts are the same for every trx or different, plus whether someone has access to do this.

3. Again depending on the complexity of the accounts, you could record a macro in GP of changing a couple of documents, through all the steps, clicking on “next record” and “save” etc., and then edit the macro file to add more iterations and run a macro to run through them. Similar to #2, this isn’t super effective if the COGS and INV accounts vary between documents.

Those are the 3 I can offer off the top of my head for you.

Hope that helps,

Jen

——————————
Jen Kuntz, CPA, CGA
Microsoft MVP, Business Solutions
Kuntz Consulting Inc.
Cambridge, ON, Canada
————————————————————————-