Tuesday, May 22, 2018

Dynamics NAV - Modify AP Trial Balance - Vendor Detail/Summary Trial Balance

R304 - Vendor Detail Trial Balance
R305 - Vendor Summary Aging
R322 - Aged Accounts Payable

  • Vendor Summary Aging
    • Starting Date is the date to age from (should always be today)
    • Add additional aging buckets, default is 3, increase to 5
      •  Increase by 2 Columns, Increase PeriodStartDate from 6 to 8
      •  VendBalanceDue dim inc from 5 to 7
      •  VendBalanceDueLCY dim inc from 5 to 7
      •  InVendBalanceDueLCY dim inc from 5 to 7
      •  InVendBalanceDueLCY2 dim inc from 5 to 7
    • Adjust Layout, add new columns
    • Adjust total formulas
  • Aged Accounts Payable
    • Update Layout. Add 2 more aging columns.
    •       All dim increased by 2
    •       PeriodStartDate,PeriodEndDate,HeaderText,GrandTotalVLERemaingAmtLCY
    •       AgedVendorLedgEntry,TotalVendorLedgentry



No comments:

Post a Comment