Please give me the tables and fields of Customer Outstanding Balances on particular date
*This post is locked for comments
Please give me the tables and fields of Customer Outstanding Balances on particular date
*This post is locked for comments
Customer Outstanding Amounts i want. I Am new to MS Dynamics SL. My Requirement is to get the tables of open items in Customer line item Tables. Where do i get Customer line item table and how can i identify that this particular invoice has been Cleared or not. Please Tell Me the procedure to differentiate Open and Cleared Customer Balances.
Take a look at the various reports in AR. Which ever one returns similar data to what you are after, open it in Crystal and take a look at the tables and views it uses.
You're probably looking for something in ARDoc, ARTran or ARHist though.