I have a BAQ which lists unposted transactions (where PartTran.GLTrans = 1 and PartTran.PostedToGL = 0) and even after running the Capture COS/WIP process I see many transactions that haven’t posted. These are all historical and all have the MFG-VEN transaction type, so they appear to be related to subcontract jobs.
Their extended cost is $0 so they don’t actually affect the GL, but I’d like to know if they can be cleaned up and if there’s something we should be doing to prevent these.
Post your BAQ please.
Here’s the query phrase I’m using; you can season to taste:
select
[PartTran].[Company] as [PartTran_Company],
[PartTran].[SysDate] as [PartTran_SysDate],
[PartTran].[SysTime] as [PartTran_SysTime],
[PartTran].[TranType] as [PartTran_TranType],
[PartTran].[TranNum] as [PartTran_TranNum],
[PartTran].[PartNum] as [PartTran_PartNum],
[PartTran].[WareHouseCode] as [PartTran_WareHouseCode],
[PartTran].[BinNum] as [PartTran_BinNum],
[PartTran].[TranClass] as [PartTran_TranClass],
[PartTran].[InventoryTrans] as [PartTran_InventoryTrans],
[PartTran].[TranDate] as [PartTran_TranDate],
[PartTran].[TranQty] as [PartTran_TranQty],
[PartTran].[UM] as [PartTran_UM],
[PartTran].[MtlUnitCost] as [PartTran_MtlUnitCost],
[PartTran].[BurUnitCost] as [PartTran_BurUnitCost],
[PartTran].[MtlBurUnitCost] as [PartTran_MtlBurUnitCost],
[PartTran].[ExtCost] as [PartTran_ExtCost],
[PartTran].[PackType] as [PartTran_PackType],
[PartTran].[PackNum] as [PartTran_PackNum],
[PartTran].[PackLine] as [PartTran_PackLine],
[PartTran].[PONum] as [PartTran_PONum],
[PartTran].[POLine] as [PartTran_POLine],
[PartTran].[PORelNum] as [PartTran_PORelNum],
[PartTran].[WareHouse2] as [PartTran_WareHouse2],
[PartTran].[BinNum2] as [PartTran_BinNum2],
[PartTran].[OrderNum] as [PartTran_OrderNum],
[PartTran].[OrderLine] as [PartTran_OrderLine],
[PartTran].[OrderRelNum] as [PartTran_OrderRelNum],
[PartTran].[EntryPerson] as [PartTran_EntryPerson],
[PartTran].[GLTrans] as [PartTran_GLTrans],
[PartTran].[PostedToGL] as [PartTran_PostedToGL]
from Erp.PartTran as PartTran
where (PartTran.GLTrans = 1 and PartTran.PostedToGL = 0)