Skip to main content
Question

Stock Items Import Scenario Issue

  • October 29, 2025
  • 7 replies
  • 98 views

Forum|alt.badge.img+1

Hi Team,

ChatGPT said:

I was working on an import scenario to create stock items and encountered the following error during processing:

“Account 400100 is a control account for PO, and posting to it is prohibited. Please select a non-control account.”

To resolve this, I updated the Chart of Accounts by adding the PO module for account 400100 and enabling Manual Entry.

After making these changes, the import processed further but displayed the following warning:

“Account 400100 is a control account for PO. Although posting to this account is allowed, we recommend that you select a non-control account.”

I’ve attached a screenshot for reference.

Could you please help me resolve this issue or suggest any configuration changes needed?

7 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@Rakshanda did you try processing one record and verifying the result?
This issue usually occurs in the import scenario when the Chart of Accounts is configured as mentioned.

Share xml file as well.

 


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • October 29, 2025

Hi ​@Manikanta Dhulipudi ,
Thanks for your response.

When I try to create a new stock item manually, I get warnings in the GL Accounts section, but I’m still able to save the stock item. However, when using the import scenario, these warnings are treated as errors.

If I set the account as a control account, it prompts me to configure it for PO, which I did, but then it shows a prohibition message.

I also tried the steps you shared earlier, but they didn’t help.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@Rakshanda could you please share your chart of account configuration and Stock items GL account.

 

Are you seeing same issue for all SKU?


Forum|alt.badge.img+1
  • Author
  • Jr Varsity II
  • October 29, 2025

Hi ​@Manikanta Dhulipudi ,

please find below screenshot for reference,

I have tried with & without Allow manual entry 

I am facing this issue with items with particular Item class 


mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

@Rakshanda Do you have any customization?


PaulMainard55
Captain I
Forum|alt.badge.img+2

Hi ​@Rakshanda,

You might want to take a step back here to be sure that your settings for this account is really what you are wanting to do.  

A couple of thoughts for you:

You appear to mapping a sales (income) account that’s flagged as a PO Control account to a stock item account field.  To which field is this account being mapped? 

I would suggest that it’s quite unusual to configure an Income account as a control account of any kind; let alone as one belonging to the PO module.  My first suggestion would simply be to remove the control module setting from this account.  Simply doing this will make this problem go away.

Control accounts are typically assigned to Balance Sheet accounts (Assets/Liabilities) so that the subsidiary ledger in question (AR, AP, IN, PO) remains in balance with the GL by restricting the system from posting to those accounts from other modules.  This is to aid in the month-end reconciliation process and to ensure that the GL and subledgers move in concert with each other.  It’s very uncommon to reconcile a revenue account to a subledger balance (it’s never done), mostly because revenue accounts are set to zero at the beginning of each year. 

The one account that I would want to set as a PO Control Account would be the “PO Accrual” (or Received not Invoiced) liability account. Beyond that, there’s not much application for PO control account assignments.  

With that said, perhaps you have a business requirement here that we are not clear about or understand.  If you could share with us what you were hoping to accomplish by assigning a control module to this account, perhaps we could provide additional guidance.  


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 6, 2025

Hi ​@Rakshanda were you able to find a solution? Thank you!