kb:kb_item_100
Table of Contents
KB Item 100
Product
SAP BUSINESS ONE
Product Version (if applicable)
None Defined
Issue
G/L balance does not tie out to A/R Aging
Symptom
G/L balance does not tie out to A/R Aging
Cause
Business Partner marked as `Inactive`
Resolution Notes
A Business Partner checked as Inactive will not appear on the A/R aging report. Yet the balance for the customer is included in the G/L balance. The query below will indentify the BP set to Inactive:
Select t0.[CardCode], T0.[CardName], T0.[Balance], T0.[frozenFor] FROM OCRD WHERE T0.[frozenFor] = `y` and T0.[Balance] <> 0
KB Type
Solution
Item Date
25 Apr 2012
kb/kb_item_100.txt · Last modified: 2019/01/24 09:44 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
