Scott Anderson
Forum Replies Created
-
I was able to find a reasonably good way to translate the monster JSON dataset sent by the event into a manageable dataset for use in Logic Apps or Power Automate. I accomplished this using the Transform JSON to JSON action in logic apps and using the following DotLiquid template to do the transformation. This will pluck the resulting data table record from the event and return a JSON object with all of the columns in the table. The template is suitable for any table since it Dynamically gets the column names.
{
{%- assign inputparameters = content.InputParameters -%}
{%- for target in inputparameters -%}
{%- if target.Key == “Target” -%}
{%- for attribute in target.Value.Attributes -%}
{%- if forloop.Last == true -%}
“{{attribute.Key}}”:”{{attribute.Value}}”
{%- else -%}
“{{attribute.Key}}”:”{{attribute.Value}}”,
{%- endif -%}
{%- endfor -%}
{%- endif -%}
{%- endfor -%}
}
-
We have a product that we inventory in the UOM of Boxes (BX) and the primary Sales unit is BX. However, we also allow the customers to place their orders in pallets (PF). When the order is released to the warehouse and the shipment is generated it places the demand in the UOM of the order rather than the inventory UOM.
This is not usually a huge concern but in cases when we have to short ship we often have issues posting the packing slip because the quantity we are shipping matches only a fraction of the order UOM.
For us, our preference would be to always release to the warehouse and create the shipment demand in the INVENTORY UOM rather than the order UOM because we actually ship by inventory UOM.
-
Thank you. We can achieve the affect we are looking for by using the project categories to write the expense back to the originating P&L account. However, we have noted that when doing this the expenses do not appear in the budget performance calculations unless you added each project category as a budget line – which at the time the project is created and the budget is set is unknown. If we add the project category at a later date – even with a budget of $0 – the budget performance and control calculations work normally. Is anyone aware of a way to automatically create a budget with all project categories?
