Okay, I'm sneaking this one in just under the wire today but here it is.
A client ran into a posting issue today on an SOP Invoice. This issue seems common to users who only occasionally process non-inventory sales invoices. Although everything on the invoice appeared to be correct, she kept getting a missing distribution account error on the posting journal and couldn't recall how to resolve it. Here's the key -
When entering a non-inventory item on an SOP invoice, you must check the distributions at the line level to make sure there are accounts for
- Inventory (yes, even for non-inventory items, believe it or not)
- Cost of Sales
- Sales
or the transaction will not post. Even if the distributions look fine at the document level, any of these accounts missing at the line level will prevent the transaction from posting.
* click image to enlarge
To view the Line Item distribution accounts, click the blue arrow above the Item Number field, then click the 'Distributions' button at the lower right corner of the Sales Line Item Distribution Entry window. Enter your accounts and you're good-to-go.
10/2/09 - An update from Marianela, which I failed to point out in the original post - go to Tools>Setup>Posting>Posting Accounts, and choose 'Sales' in the drop down box. Scroll down to the 'Non-inventoried Item' line and insert an inventory account there. This account will default into the Sales document and your worries about this issue are over!
Thanks again Marianela!
10/2/09 - An update from Marianela, which I failed to point out in the original post - go to Tools>Setup>Posting>Posting Accounts, and choose 'Sales' in the drop down box. Scroll down to the 'Non-inventoried Item' line and insert an inventory account there. This account will default into the Sales document and your worries about this issue are over!
Thanks again Marianela!
5 comments:
Wow, this just popped on to my to-do list in the past week. Is there a way to have default accounts for non-inventory items? Thanks.
Unfortunately not Chris. However, you could setup an item as a Service Item, set the accounts in the item card, use that as your default 'Non-inventory' item number and change the description in the SOP document to describe what you're selling. That way the accounts would default in.
You could default the Inventory account from Tools|setup|Posting|Posting accounts select sales and scroll all the way down, and enter a generic default account in the Non-Inventoried items Posting account, for the COS account use (on the same Posting Accounts setup) Inventory and enter a generic account (could be the same account used above) in the Cost of Goods Sold posting account. as for the Sales account, you dont need it in the Sales Item Detail entry window, as long as you provide this on the Sales Distribution Entry window, you could allocate your revenue manually or again set this up on the Posting account setup.
Thanks for the clarification Marianela. I forgot all about that setting!
I just remembered why setting the non-inventory account in Posting Settings doesn't work in all cases. What if you have more than one Finished Goods inventory account, for example? I would prefer leaving the account empty and forcing the user to select the correct account at SOP processing time.
Post a Comment