Method for accessing Line Item Amount (I.E. the ra...
# general
n
Method for accessing Line Item Amount (I.E. the rate * the quantity) on the item fulfillment record?
n
@Nbtwist Are you accessing in report or saved search?
n
Trying to set a custom field default value on the line item in an IF record
n
@Nbtwist Create a custom transaction line field and set formula in that customer field (rate*quantity)
n
{itemunitprice} shows the rate, was wondering if the amount had a field similar
n
@Nbtwist I guess, In standard amount field is not available on IF
n
yea basically when i use the standard {amount} in formula default, it doesnt show anything
same with standard {rate}
n
@Nbtwist Amount field will not show anything for IF as this field is not available on IF and also not storing any value in it that's why it is not showing anything.
n
{itemfxamount} perf ty!
gave me really good insight just talking about it
j
One thing to keep in mind: you will not get the discounted amount if you do it that way.
n
Good eye @Jesper M appreciate it ❤️
j
The {netamountnotax} field, which is available through saved searches, shows the amount including discount in base currency on the sales order record. It can be used to translate into the transactions currency with the exchange rate. However, this is not available when you source fields to a transaction. But you can use a saved search with transaction type = item fulfillment and use {appliedtotransaction.netamountnotax}. But it will not be shown on the item fulfillment record itself.
An idea is to use a script if you really need it to appear on the item fulfillment record (I guess you maybe want to show it on the packing slip or something). But keep in mind that the price can be changed on the SO after the IF is created. So it's not a crazy good idea either. There are report tools available where you can use saved searches to create a PDF from any transaction, which can help you.
220 Views