Skip to main content
Solved

Is there a way to have the Inventory ID control the Sub Account?


When I create a Purchase Order, I use inventory Items to fill out basic information, like account and sub account. However, I’ve notice that while the Account does match the Inventory Item. The system pulls the Sub Account from the Vendor’s profile.  

This creates a problem because while the Vendor’s sub account is the most likely to be used, it doesn’t mean that it always be the same. 

My Inventory Item has the correct sub account.

Posting class is set to pull the information from the Inventory Item ( II-III-I )

 

Is there a way to fix this?

 

Best answer by Alin Para

If you try to put non stock items on PO Order, first you have to enabled “Require receipt” on General info tab on Non stock items form. After that you will configure the account and sub account for PO Accrual Account/ PO Accrual Sub (in Inventory GL accounts tab)

For stock items is the same , except the Require receipt option (this is not applicable).

Also check that you have mask II-III-I configured for “Combine PO Accrual Sub from” in corresponding posting class.

ps. this behavior is for 2020R1 , i’m not sure if this is the same on lower versions.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+1
  • Jr Varsity III
  • 16 replies
  • Answer
  • August 24, 2020

If you try to put non stock items on PO Order, first you have to enabled “Require receipt” on General info tab on Non stock items form. After that you will configure the account and sub account for PO Accrual Account/ PO Accrual Sub (in Inventory GL accounts tab)

For stock items is the same , except the Require receipt option (this is not applicable).

Also check that you have mask II-III-I configured for “Combine PO Accrual Sub from” in corresponding posting class.

ps. this behavior is for 2020R1 , i’m not sure if this is the same on lower versions.


  • Author
  • Freshman I
  • 2 replies
  • August 24, 2020

Thank you for reply. I checked and I do have those settings active. But It’s not working. I guess I’ll have to wait for the upgrade. We are running 2019R1. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings