![]() ![]() I would suggest going the percentage route and make it 100%. Thanks again!Ī discount item can be a fixed amount or a percentage. Any suggestions? My one thought was to change the discount line 'price level' back to base price but I'm not sure you can target that column in a Sublist Action on a workflow. I'm trying to 'reset' the discount item so-to-speak but am not having success. And once I update the inventory items price to their cost via my workflow, the discount line item remains at the custom price and when the order attempts to save it bonks because it's now a negative amount. When we upload the order via web services our discount items get uploaded with a 'custom' price level. However, I am running into an issue with this approach. (Ultimately I would love for these internal Marketing folks to be able to place an order through our site and not have to work in NS directly themselves.) I have been able to successfully do this in the UI but am having issues when trying to run this workflow with a web services context. I am trying to automate the change of the item price to its cost amount via a workflow. ![]() U/Nick_AxeusConsulting Thank you so much - your reply was super helpful! We have decided to go this route.Ī follow-up question for you. In this scenario, assume that the selling price is $100 and sales tax is 8%: So because of this issue, you want the Discount Item to be AFTER sales tax, that way you can put the full retail price on the SO, and the sales tax will calculate on the full undiscounted retail price, but then the Discount item still takes the Invoice down to zero. When you setup the Discount Item, you can set it to be before tax or after tax. This is a risk you have to decide in your company because you will get popped if you get a sales tax audit. Ideally the sales tax is supposed to be ON THE FULL UNDISCOUNTED RETAIL PRICE, but you may be okay "fudging" the sales price to be the lower COGS number. The Sales Order method solves this problem, too. Your J/E to clean-up this one-time mess, is CR COGS and DB marketing expense.Īnother note, YOU owe sales tax ON THE FULL RETAIL PRICE of the item when you give it away as a promotion. So, stop doing zero dollar orders, as explained above, because that's wrong. I suspect you did a zero dollar order which means your revenue is zero but your COGS has posted from the Item Fulfillment. I need to know how the transaction was booked incorrectly. If you have to make adjustments in a closed period, then you need a J/E. The Discount Item posts to the marketing expense account.Īssuming the COGS for an item is $50 and you set the selling price to same COGS value, the G/L impact is following:ĭo not let finance complain that the $50 revenue and $50 COGS is contaminating their top line. The correct process is to setup a Discount Item for 100%. (You can see the current COGS value on the Item record for the particular Location). You can change the selling price if you want to be the COGS value. What you want to do is put the item on a sales order just like you're selling it. ![]() I yell because I see customers do this all the time and it's just wrong. Update: I ended up solving for this by using a workflow to trigger the addition of a new payment type item (that hits the appropriate expense account) that covers the cost of the order. Is there a way to automate an adjustment or a journal entry to automatically handle for the account adjustment? There is an existing SuiteAnswers Article about this from 2016 but unfortunately neither of those options work for us - we'd like it to be more automated. Also, it is possible that the item’s transactions are already in closed period.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |