/
BI4 AR Aged Debtors NG

BI4 AR Aged Debtors NG

AR Aged Debtors

Debtor Ageing and Forecasting.

AR Aged Debtor Divn

Use the divisional ( tracking code, class, job ) line item value TaxExclusiveAmount / TotalLines to apportion OpenAmount, OpenBalanced etc 

StatusRevDateNotes
fix6.2008nov24Invoice lines with $0 causing AR Aged Receivable to double BIC-714 - Getting issue details... STATUS
fixNC07nov24Duplication of Invoice Values due to ARL non-Transaction Inv line. Fixed in ARL ETL BIC-713 - Getting issue details... STATUS
fix6.1924oct24Outstanding Balances can exist when Totallines == 0 BIC-712 - Getting issue details... STATUS
new6.1809aug24Referral Source in Invoice Detail BIC-705 - Getting issue details... STATUS
new6.1730Jul24Customer Tags for Xero
new6.1628jul24Cross Rate for Consolidation use CurrentDate MthEnd Rate
new6.1524feb24MYOB ARL Job (Division) Fixes BIC-681 - Getting issue details... STATUS
new6.14 08nov23Prevent NAN when sum(InvoiceLines) = 0
new6.1318nov23Create Weighted Avg Days Oustanding (WADO) deprecate DaysSinceDue
new6.1217Nov23Divn: Provide Divisional by apportion LineTaxExclusive/TotalLines on OpenAmount, OpenBalanced etc
Forked NG6.11
Forked the NG version
new6.1117may22Softcode CardIdentifcation ( Xero Account ) BIC-603 - Getting issue details... STATUS
new6.105jul19Don't show row where Open Amount = 0 BIC-209 - Getting issue details... STATUS
new6.001mar18Invoice Detail for Foreign Currency BIC-210 - Getting issue details... STATUS
new5.916feb18Days Since Invoice and Due BIC-130 - Getting issue details... STATUS
fix5.809Feb18

In Group Consolidation when dimension was Customer Amount were doubling. Needed Company Restriction in SQL

BIC-129 - Getting issue details... STATUS
fix5.724mar17Re-instate fix on SalesRep Group By ( 5.4a)
fix5.620mar17Re-instate Due Date as a filter BIC-126 - Getting issue details... STATUS
new5.516mar17
  • Introduce Total Due in Foreign Currency
  • Change to use SaleID in detail as InvoiceNumber is not unique + causes duplicates
  • Restore use of DueDate in detail
  • Show Exchange rate relative to AUD e.g. AUD 1.00 = USD 0.75

BIC-122 - Getting issue details... STATUS BIC-123 - Getting issue details... STATUS

BIC-124 - Getting issue details... STATUS BIC-125 - Getting issue details... STATUS

fix5.4a06mar17Fix bug Group By SalesPerson would duplicate Salesperson on several lines BIC-127 - Getting issue details... STATUS
new5.401mar17Introduce Category dimension to age by
fix5.314aug16Duplicate Invoice Numbers can occur in MYOB and cause calc duplication

BIC-48 - Getting issue details... STATUS

fix5.228jul16New Filter not picking up Rep Unique ID
new5.125Jul16Make Customer SalesRep available in filters
new5.019aug15Multi-Company and Consolidation
new4.203jun15Added Customer SalesRep
new4.115mar15Consistent use of SalePerson for the SalesPerson on the Invoice
new4.005nov14Rework to use IR DB
new2.622aug14
  • Calculate Avg Days for Trailing 12 Months
  • Ageing by Promise Date

new2.511feb14
  • Add Average Days to Pay, Credit Limit in Customer. Promised Date, Jnl Memo in Invoice Detail
  • Fix Foreign Currency Amount to incl Tax

new2.415nov13 Harmonise versions

new

2.330may13 Add Customer OnHold
new2.229jan13 Add Contact, Phone, Email, Customer Card ID.
new2.103dec12 Add Multi-Currency
new2.003feb12 Debut Release





Related content