Inventory Adjustment Journal Entry

(0) Share

Report

Posted on by Dan Bigelow

749

All,

Client is using CRM based Inventory. They are making stock counts and need the cost of the adjustment to flow to their accounting system which is QuickBooks. In SSIS I have a CRM source and using FetchXML I can pull the adjustment number, product, and quantity from the InventoryAdjustment entity. The cost is on the Product entity and I was able to link the two together in Fetch XML. Each adjustment can have multiple products so I need to group by adjustment and get a total cost: SUM(Qty*Cost) for all the lines per adjustment. I can see where you can group and sum in Fetch XML but not multiply. Is there a way to do this? Is this the best way to accomplish this?

Thank you,

Dan Bigelow

*This post is locked for comments

I have the same question (0)