Sage 100

I'm at a place right now where I can't be on the phone with Sage, so I thought I'd start here first. Sage 2013, PU 5-8, Custom Office. I created a SO_InvoiceDetail UDF to feed the current IM Standard Cost in with the line and through to AR Invoice History so that we could compare FIFO costs to Standard costs later on. This works fine when keying an invoice through Invoice Data Entry, but the UDF does not get populated for an invoice line that is generated via Shipping Data Entry. Does this sound like it is working as designed? Or does anyone else have a trick to try?

Amber, when you create an invoice through Shipping Data Entry you are probably copying Sales Order details, right? Is the UDF in the SO_SalesOrderDetail table? If not, you'll need to capture it there so it can be copied to the SO_InvoiceDetail UDF. In order to copy from the CI_ITem (inventory item) record, the item code has to be entered new on a detail line, but in shipping data entry that rarely happens. It *always* happens in Sales Order data entry. So you add the UDF to the sales order and make it flow from the item. You also add it to invoice detail and make it flow from both item and sales order. That should take care of it. If you're saying that you are adding a new detail line in shipping data entry and the UDF isn't being populated, then that sounds like a malfunction. - Phil

Thanks, Phil. The reason I did not originally map from the SO Detail table too was because it is possible for the item's standard cost to change between the time of order and fulfillment, so the mapping (and history) wouldn't be 100% accurate or real-time. But it sounds like that may be the only option because of the way the business objects are programmed. Thanks again.

Amber, did you look at the Data Sources tab on the UDF? I believe you need to check the box for SO_InvoiceDetail_bus:CopyFromSalesOrder and select your source, like it should show on the first line (SO_invoicedetail_bus).

If it is important enough to always have the latest Standard Cost at the time the invoice is created, it could be done with a script. That's a little more trouble and it requires someone that knows both the business objects and scripting, but it's quite possible. In this scenario, when you save the invoice, for example, the script could run through all the line detail, retrieve the standard cost from CI_Item and write it to the line record. - Phil