How to Post SOP Invoice with No Cost and No Price

(0) Share

Report

Posted on by Jim Lines

I've got an inventory item (FIFO Perpetual - Misc Charges) on a SOP Invoice that has no cost and no price (it's a catalog). I obviously cannot post because I don't have any distribution values. Is the workaround to debit/credit the same dummy account for something like a penny? Any advice will help! Thanks.

*This post is locked for comments

All responses (6)

Answers (2)

Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at

Like (1)

Report

RE: How to Post SOP Invoice with No Cost and No Price

Thanks Mahmoud for the kind words! Frank
Jim Lines 2 on at

Like (0)

Report

RE: How to Post SOP Invoice with No Cost and No Price

OK, so it appears like the Invoice got corrupt. I removed the line items from the Invoice and then reviewed what was in SOP10100. I found that there were some dollars in some fields. I ran the following:

update SOP10100

set MRKDNAMT = 0, ORMRKDAM = 0, EXTDCOST = 0, OREXTCST = 0.

where DEX_ROW_ID = 123456

I then re-added the item and was able to post properly. I don't think the issue was with the item or the valuation method, but I believe my fulfillment people removed an actual sales inventory item from the invoice and the totals got stuck in the header. I'm sure a checklinks would have fixed it, but I can't do that at the moment.

Anyhow, I'm good now. I thank you for your time and I'll mark your answer as verified!

Thanks

Jim
Jim Lines 2 on at

Like (0)

Report

RE: How to Post SOP Invoice with No Cost and No Price

Mahmoud,

Thanks for testing that, I really appreciate it. It looks like someone forced the item to Misc through SQL and didn't update the valuation method (in case you haven't noticed from my other posts... the system here is pretty jacked up). Anyway, I changed the valuation method to 0, removed the item from the SO and attempted to re-add. I still have the same issue. It's looking for distribution accounts. I've tried to reconcile the document with no luck of fixing it. I looked at the history for this item and it's been posted before, so it's almost as if the SO is corrupt. Any ideas?

Jim
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How to Post SOP Invoice with No Cost and No Price

Additionally, as well, I believe you are looking for the best method to handle consumables. In your case, a catalog is usually considered as a consumable, posting such a transaction should affect the related expense account. In this essence, I recall a smart suggestion by Mr. Frank which was proposed long time ago, around 2007 :)

Here is the work around - Tracking consumables using inventory , here is the suggestion:

"One way you could handle this is to setup a 'Consumables' inventory account - make it a P&L account so the items are expensed when they are received. Then, when the consumables are issued to the requesting department, use the requesting department expense account as the Inventory Offset account. This way, the costs of the consumables would be charged out to the correct department and anything left in that account at period-end could be considered general consumables expense." by Frank Hamelly

I always give credit to Mr. Frank on this genius work around,
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How to Post SOP Invoice with No Cost and No Price

Hello Jim

Good to hear from you again

Let me get one thing clarified and settled, an item with a type of "Misc Charges" can not have a valuation method, since quantities of this items and current cost are not tracked on the inventory level.

As for the price, you can just leave it zero and the item will be sold at a zero price (you can simply check the "Prices are not required in Price List option", from the Sales Order Processing Setup). As a result, the invoice will be posted with no price (since it is set to zero), and there will be no cost since the item has a Misc Charges type. The bottom line, you do not need to work around any thing with a dummy account.

To be further assured, here is my testing scenario of an item type with a Miscellaneous charges type:

1- An item was defined with an item type of Misc Charges, see how the Valuation Method field is automatically blanked into none, since there will be no cost layers to track on the inventory level

2- On the sales order processing setup window, I have checked the option not to have prices required in price list, so that I can simply enter any price on the invoice level (in our case, a zero price)

3- Here is the posted invoice, with zero cost and zero price

Note,

Since there is no price, no journal entries will be generated out of posting this invoice, nothing at all.
Jim Lines 2 on at

Like (0)

Report

RE: How to Post SOP Invoice with No Cost and No Price

Additional info: The original order had an inventory item on it with a cost. Not sure if user deleted that row from the invoice, thus leaving the invoice looking for the distribution of that cost.