Skip to main content
Solved

How to default sales/cogs account and sub based on reason codes


Forum|alt.badge.img+3

The client needs to have COGS account on a warranty sales order default to a different account.  However, entering a reason code on the sales order line does not change the account/sub on the line.

 

Best answer by Naveen Boga

Hi @dgodsill97  I just checked in the Sales Order Line level. This is based on how you configure POSTING SETTINGS at the Order Types screen.

By default, it will be a Inventory Item for the “Use Sales Account” field, if you select this field to  “Reason Code” then SO Line level, it will change the Accounts, based on the reason code.

 Please find the screenshot for reference.

 

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

12 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • March 10, 2022

Hi @dgodsill97  

Is the client using the warranty as a line item?


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • March 14, 2022

No, the client sells parts and the same part could be sold for free because it is under warranty.  When sold for warranty, the expense needs to go to a different COGS account/subaccount. 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • March 14, 2022

Hi @dgodsill97  I just checked in the Sales Order Line level. This is based on how you configure POSTING SETTINGS at the Order Types screen.

By default, it will be a Inventory Item for the “Use Sales Account” field, if you select this field to  “Reason Code” then SO Line level, it will change the Accounts, based on the reason code.

 Please find the screenshot for reference.

 


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • March 14, 2022

The problem with that is every line must have a reason code.


chrisj58
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 14 replies
  • July 5, 2022

@dgodsill97 - There is a github project that allows you to default a reason code by order type. I would definitely test in a sandbox for any compatibility issues but it should help in this use case.

https://github.com/Acumatica/SalesOrderTypeDefaultReasonCode

 


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • July 5, 2022

Thanks.  The client have one of the subaccount segments as the product line and that needs to be specified for warranty orders.  An order can have multiple lines for multiple product lines.  A customization is being developed to populate the reason codes based on the serial number of the unit.


  • Freshman I
  • 10 replies
  • November 14, 2023

We have this customization installed, and it works well.  Our Sales GL posting is perfect, with a 4-segment subaccount. The first segment pulls from the Department for the Sales subaccount. But how do you force the COGS entry on the inventory issue to match the sales subaccount?  The “Copy COGS Sub. from Sales” checkbox on the Posting Classes screen doesn’t seem to have any effect, other than to copy the Sales subaccount within the Posting Classes screen. 


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • November 14, 2023

Create a Reason Code of the ISSUE type and in the Account field specify the Account - not the Sales Account field.  The enter the reason code on the sales order line and it will pull the COGS account from the Reason Code when it does the Inventory Issue.


  • Freshman I
  • 10 replies
  • November 14, 2023

I should’ve mentioned we have a reason code of the ISSUE type for each of our order types.  Our subaccount mask is Department-Warehouse-Channel, where the reason codes are driving the “Channel” segment and working well.  The Dept segment comes from the Employee record, which we set in the Order Type screen’s “Combine Sales Sub From” screen:

 

Where EEEEE pulls nicely from the Employee’s Financial tab settings.  But we can’t set COGS at the reason code level; otherwise we would need a reason code and matching order type for every possible combination of the two (it would be hundreds). 

 

Thanks for any feedback. 


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • November 14, 2023

You have to put the Reason Code on the sales order line to affect the inventory issue. Is the customization populating the reason code for each line?


  • Freshman I
  • 10 replies
  • November 14, 2023

Yes, the reason code is populating correctly on each sales order line.  BTW, the Reason Code setup looks like this, and is working great on the sales side of the posting.  

 

However, the COGS posting is leaving the first segment as 00000, where the sales sub is combining correctly (by pulling in the department from the Employee (i.e. the EEEEE on the Order Type’s “Combine Sales Sub from” section in the first screenshot.  Thanks for any ideas!


Forum|alt.badge.img+3
  • Author
  • Varsity I
  • 205 replies
  • November 14, 2023

that would appear to require a change to the Github package I guess.


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