@sdelong84,Can you give me a bit more to go off of? Like what have you tried, what GIs are you looking at, do you have a good example. etc.? I don’t live in the finance world so a bit a direction is helpful.
I agree and think a sub report would be the best option. Another option could be to add another group. If it works the way I’m thinking, it would loop and through display all of the item’s HS codes.
@bernadeth58 are you looking for the Acumatica field name or the BigCommerce?
@mna10 The Average Cost on Price/Cost tab of the Stock Item screen should have all of the calculations done and rolled into it.If you are looking for something historical reference, i.e., what was the landed cost for an item for a specific purchase receipt, I don’t have anything and would love the same thing for our company.The problem I run into when to use the landed cost amount vs the billed amount and the creating a system that “knows” how landed cost valuation method. Then, there is still the challenge of linking everything together.
@Michael Hansen While I haven’t tested, I would start by looking at the actions availible to that screen. The quickest way I know of to get that list is to look at the screens Actions in the customization editor.
I’m looking into doing the something similar but with the copy actions on the SO301000 screen.Could a different approach be to modify the action in the screen’s workflow to set that field to Null?
@bdrake14 I would take a look at @yoelb’s comment. While I haven't done it and couldn’t speak the the particulars of configuring it, it looks like the you could create a comma delimited list. The only other option, would be to create a new SQL view that comma delimits the values into a new column which you can map and pull into the report as a custom field. While I can’t find it, Tim Rodman over at AUG Forums had a write up about it.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.