Skip to main content
Solved

product Subaccount linked to inventory does not allow shipment

C
Freshman I

Hi 

I created our third subaccount segment, it’s a product subaccount ideally linked to inventory item.

When I create a sales order and sales invoice, I see all 3 subaccounts generated Channel-Customer-product. However, even though the item is invoiced, no issue was created. Usually this is an automatic process but I had to manually look up that issue and when I click release, it has an error, saying Product of subaccount does not exist.

I’m not sure where Acumatica pull the subaccount from.

Here is the screenshot of the customer and inventory ID subaccount:

 

 

Best answer by bryanb39

One time I had to uncheck the copy COGS Sub from Sales, I then ran an import scenario to just update the COGS Sub, then turn that option back on.  Alternatively, you could probably turn on mass edit from the Stock Item GI to update the COGS Sub accounts. 

I can’t remember the exact circumstances, but it was using the old Sub account even though that was selected.

 

View original
Laura02
1 person likes this
  • Laura02
    Laura02
Did this topic help you find an answer to your question?

6 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • November 9, 2023

Hello,

Please check/show us the subaccounts on GL Accounts tab of the Stock Item being sold. It seems like the Inventory posting class is configured to use subaccounts from the Item (IIII-IIIII-II).

Does the third segment shown in GL Accounts tab of Inventory Item exist in the Segment Values screen, for Subaccount segment 3?

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
C
Freshman I
  • cherlene
  • Author
  • Freshman I
  • 7 replies
  • November 10, 2023

Hi @Laura02 
here is the product GL accounts tab:

 

Laura02
1 person likes this
  • Laura02
    Laura02
Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • November 10, 2023

Thank you for posting the GL Accounts tab of the item.

We need to keep searching for where the 3rd segment of your new subaccount is missing.

Please check the Subaccount posting details of the Issues Reason Code used in Issues batch 008028 above), or the default Issues Reason Code if Reason Code is blank in batch 008028.

What is Combine Sub From set to? Depending on the setting, check the subaccount on additional items .

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
C
Freshman I
  • cherlene
  • Author
  • Freshman I
  • 7 replies
  • November 10, 2023

Hi @Laura02 

the reason code for the issue is blank,

I screenshot the below inventory preferences:

 

C
Freshman I
  • cherlene
  • Author
  • Freshman I
  • 7 replies
  • November 23, 2023

Hi @Laura02 , to follow up on this, I realised if I create an exact same copy of the inventory, the system works, and posted to the 3rd product subaccount. Does that mean I have to recreate the entire inventory list?

 

It appears to me that the inventory subaccount is not updated retrospectively, which is strange as customer subaccounts works.

bryanb39
Pro II
Forum|alt.badge.img+6
  • bryanb39
  • Pro II
  • 177 replies
  • Answer
  • November 23, 2023

One time I had to uncheck the copy COGS Sub from Sales, I then ran an import scenario to just update the COGS Sub, then turn that option back on.  Alternatively, you could probably turn on mass edit from the Stock Item GI to update the COGS Sub accounts. 

I can’t remember the exact circumstances, but it was using the old Sub account even though that was selected.

 

https://www.fiverr.com/acudatica
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved