Posting Issue with Sales Order and Inventory

(0) Share

Report

Posted on by kpw

935

I am having trouble with the posting accounts for a sales orders. In the setup we have to take accounting distributions from inventory item. It should be hitting cost of goods sold, accounts receivable, inventory and inventory offset. But when we create the sales order it is not taking from the inventory item account distributions

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

How do you know it's not taking the correct inventory account? Those accounts aren't hit until the invoice is posted. Are you seeing the wrong account in the Line Item Detail?

Was this reply helpful? Yes No
kpw 935 on at

Like (0)

Report

Yes we are seeing the wrong accounts or no account in the line item detail and the accounts are not posting to the GL accounts.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

KPW, distribution account fetched based on the below SOP setup Posting Accounts From option. Do you setup item/Customer in that window? If customer then changed to item and reenter the SOP transactions. This time it will takes the inventory distribution accounts.

Hope this help!

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

The blank distribution accounts are a result of accounts not being listed in the items. When you create an item you must fill in those accounts. Most firms put a list of the accounts, including the 4 you listed, in an Item Class and assign the class to the items. The system does not pull accounts from the class but, either when you change data in the classes or create a new item, the class information is copied to the items.

Check your items to make sure the accounts are included in the accounts screen of the items.

All of this, including how to chase the source of accounts and other posting issues, can be found in our Inventory Flow and Posting manual. It is available on our web site listed below.

Was this reply helpful? Yes No