What are the quantities you are trying to match from Inventory to SOP? I think you should be able to see all of these using default SmartLists, but if you’re not comparing corresponding columns, the issue may be there.Īlso, if the problem is on the SOP side, you may need to run a Sales Reconciliation (Tools > Utilities > Sales > Reconcile – Remove Sales Documents). To dig deeper into this and look for a resolution you would most likely need to work with your GP Partner and/or GP Support. Typically, I would expect to see other issues or errors during posting if this was happening.Ĥ) You have customizations or 3rd party add-ons that are causing the system not to behave as designed. Unless you can duplicate the issue and see where it is happening, this also could be extremely difficult to track. This can be very difficult to see if the history tracking was turned on later, as there is no tracking for this kind of change out-of-the-box.ģ) Something went wrong during posting.

This can be easily seen by bringing in a column called Non IV on the Sales Line Item SmartList.Ģ) Inventory history was not being tracked for an item at the time the SOP transaction was posted. Even if an item was subsequently created in inventory, if the system did not recognize it as an inventory item at the time of the SOP transaction entry, this will not get updated. I can think of 4 possibilities for what you’re describing:ġ) You’re using a non-inventory item in SOP. = ‘1’Īnd isnull(T4., ”) IN (‘Company1PriceLevel’, ‘Company2PriceLevel’, ‘Compan圓PriceLevel’, ‘Company4PriceLevel’) INNER JOIN ~DBNAME.IV40201 T5 with (nolock) LEFT JOIN ~DBNAME.IV00108 T4 with (nolock)

LEFT JOIN ~DBNAME.IV00102 T2 with (nolock) as ‘Base U Of M’ from ~DBNAME.IV00101 T1 with (nolock) when 1 then ‘Sales Inventory’ when 2 then ‘Discontinued’ when 3 then ‘Kit’ when 4 then ‘Misc Charges’ when 5 then ‘Services’ when 6 then ‘Flat Fee’ else ” end as ‘Item Type’, as select T2.QTYONHND -T2.ATYALLOC as ‘Quantity Available’, As always thank you for providing this wonderful resource.Īny chance you can help me with the following view I am trying to create? I am really struggling with the getting the data for the two unit of measures to the correct type in line two and would appreciate any advice.Ĭreate view.

Microsoft dynamics gp cost per user