WHEN T0.TransType = 182 THEN 'BOE Deposit' WHEN T0.TransType = 166 THEN 'AR Corr Inv Rev' WHEN T0.TransType = 165 THEN 'AR Corr Inv' WHEN T0.TransType = 164 THEN 'AP Corr Inv Rev' WHEN T0.TransType = 163 THEN 'AP Corr Inv' WHEN T0.TransType = 132 THEN 'Correct Invoice' WHEN T0.TransType = 76 THEN 'Posted Deposit' WHEN T0.TransType = 69 THEN 'Landed Costs' WHEN T0.TransType = 68 THEN 'Work Instruct' WHEN T0.TransType = 67 THEN 'Inv Transfer' WHEN T0.TransType = 60 THEN 'Goods Issue' WHEN T0.TransType = 59 THEN 'Rcpt frm Prod' WHEN T0.TransType = 58 THEN 'Inv Bal Adj' WHEN T0.TransType = 56 THEN 'Chk for Payment' WHEN T0.TransType = 46 THEN 'Outgoing Pay' WHEN T0.TransType = 24 THEN 'Incoming Pay' WHEN T0.TransType = 23 THEN 'AR Sales Quote' WHEN T0.TransType = 22 THEN 'AP Purch Ord' WHEN T0.TransType = 21 THEN 'AP Goods Ret' WHEN T0.TransType = 20 THEN 'Goods Receipt PO'
WHEN T0.TransType = 19 THEN 'AP Cred Memo' WHEN T0.TransType = 17 THEN 'AR Sales Order' WHEN T0.TransType = 16 THEN 'AR Goods Ret' WHEN T0.TransType = 15 THEN 'AR Delivery' WHEN T0.TransType = 14 THEN 'AR Cred Memo' WHEN T0.TransType = -3 THEN 'Year End Closing' WHEN T0.TransType = -2 THEN 'Open Balance' WHEN T0.TransType = -1 THEN 'System Generated' DESCRIPTION: SQL lists out all Journal Entries by SAP B1 Drawer and identifies what type of transaction the JE is. B-FN Journal Entry List by Date Range Ver 1 ZP 2011 04 22 Here is a screen print of the SQL results:ī-FN Journal Entry Detail by Date Range Ver 1 ZP.png Copy and Paste this SQL: If you find this SQL helpful, copy and paste it into your system.
Another special note about the "Segment_X" entries - make sure you include all of the Segmentation fields for your company (this Customer only had 2).
#Balance closing transtype sap b1 update#
When you first start using this SQL, always use the SAP B1 Filter function on the results to see if there are any entries of "RESEARCH" - add them to your SQL, but make sure you come back to the Wiki and update the list. The TransType list might not be complete and that is why there is a default of "RESEARCH" in the results. You will probably notice there are several TransTypes included in the SQL which will never make it to the General Ledger - that was done on purpose to get all of the TransTypes together in one spot. A special note about the WHERE statement - in this example, the TransType of -3 is not included in the results - make sure you check with your Financial Personnel to ensure they also want this type of transaction excluded from their results. The results are good for checking out discrepancies and researching journal entries at month-end. This SQL lists out the journal entries restricted by the date range and SAP B1 Chart of Account "Drawer" entered by the End User. PURPOSE AND BACKGROUND: This SQL was created in 8.8 PL15. (Back to B-FN Financials Module SQL Posted to Wiki Listing - B-FN Financials Module SQL Posted to Wiki )