Skip to main content
Question

Expense account is pulling from Vendor on bills, not inventory item

  • November 6, 2024
  • 7 replies
  • 88 views

Kandy Beatty
Captain II
Forum|alt.badge.img+17

HI All,

When entering a Bill, it is pulling the expense account from the vendor even when I put in an inventory item. I have checked the posting settings and preferences and feel like I am just missing something. Does anyone have any ideas? The client wants it to pull the expense account on for the item on the bill. My local Acumatica pulls in the item’s expense account though. Not sure what I’m missing. 

The bill with no inventory item

The vendor GL accounts

When I add the inventory item

The inventory item expense account

 

7 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 6, 2024

Hello,

What is the Posting Class setting Use COGS/Expense Account From set to? :

 

There is no setting for Vendor… but I wonder if it’s set to something other than Inventory Item and the account on Warehouse or Posting class could be missing or inactive, possibly?

Laura


Forum|alt.badge.img+1

Hello @Kandy Beatty 

 

When you add a blank line or a line without a not stock item on AP bill, Acumatica uses the Expense account and sub account from vendor profile ( based on the setting on AP preference )

 

If you select the non stock item, Acumatica uses the Expense account and sub account from inventory item.

Thanks


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Author
  • Captain II
  • November 6, 2024

Hello,

What is the Posting Class setting Use COGS/Expense Account From set to? :

 

There is no setting for Vendor… but I wonder if it’s set to something other than Inventory Item and the account on Warehouse or Posting class could be missing or inactive, possibly?

Laura

Hi @Laura02 

The posting class is for Inventory Item

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Author
  • Captain II
  • November 6, 2024

Hello @Kandy Beatty 

 

When you add a blank line or a line without a not stock item on AP bill, Acumatica uses the Expense account and sub account from vendor profile ( based on the setting on AP preference )

 

If you select the non stock item, Acumatica uses the Expense account and sub account from inventory item.

Thanks

Hi @MuthumaliDhanushika27 

That is not how it is working. Should I enter a support ticket?


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 6, 2024

One more idea: does the site have any customizations?  If yes, is the AP Bill default account behavior the same with customizations temporarily un-published?

 

Best regards,

 

Laura


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Author
  • Captain II
  • November 6, 2024

One more idea: does the site have any customizations?  If yes, is the AP Bill default account behavior the same with customizations temporarily un-published?

 

Best regards,

 

Laura

HI @Laura02 

 

No customizations 😔


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • January 22, 2025

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