Hi all. I'm working on optimizing a report I created that includes Value Entry records with a column sales amount, actual costs and a column for the sum of non inventoriable costs from the Item Ledger Entry table. Just wondering - has anyone else worked on a similar report? The trick is that the non inv costs show up as a purchase in Value Entry so I can't link those costs to the original sales invoice just by pulling the non inv costs from Value Entry. I can get the sum from the ILE to work but it runs very slowly.
The goal of the report is to show all the non inventoriable costs associated with a posted sales invoice.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi
Non-inventorable cost are normally associated with cost incurred on the sales side, usually cost of shipping to the customer. As a result, the cost is linked to the Item Ledger Entry (ILE) linked to the sales shipment. Just find the ILE linked to the invoice Value Entry and the on- inventorable cost are shown in a flow field
Please sign in to leave a comment.