My Stuff
Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!
-
Re: Need to create a saved search for daily item fulfillment totals
To filter just to the COGS account in a fulfillment search, you can use the "Account fields.." Join and use Type = Cost of Goods FYI - If you want to get the selling price from the sales or…3 -
Re: Need to create a saved search for daily item fulfillment totals
Forgot to Mention if you want the sales amount, you need to use the Account = NULL as those are the Fulfillment Lines that join back to the sales order Here is the criteria to get Empty Account Here …4 -
Re: Need to create a saved search for daily item fulfillment totals
Make sure you filter the lines to his your COGS account only (there are normally 3 lines for each Sales Order Line) then your "value" is the Amount (Debit).2 -
Re: Line Unique Key
If you are referring to the "General Ledger" report, I believe that you do not have access to that field because the line being reported is the SUM of the lines on that transaction for that…2 -
Re: Amount of itens to be received
Instead of using the Custom Field, your search can use the formula to retrieve the same value which can also be used to calculate the Amount unbilled Unreceived quantity = {quantity}-nvl({quantityshi…2
