Hello everyone,
I would like to request help on adding the original amount to the aging A/R report.
Ihave successfully added three columns but when I add this column I just get 0s.
This iwhat I have added
Make Excel Header
ExcelBuf.AddColumn(Customer.FIELDCAPTION(“Phone No.”),FALSE,’’,TRUE,FALSE,TRUE,’’);
ExcelBuf.AddColumn(“Cust. Ledger Entry”.FIELDCAPTION(“Salesperson Code”),FALSE,’’,TRUE,FALSE,TRUE,’’);
ExcelBuf.AddColumn(“Cust. Ledger Entry”.FIELDCAPTION(“Credit Amount”),FALSE,’’,TRUE,FALSE,TRUE,’’);
ExcelBuf.AddColumn(“Cust. Ledger Entry”.FIELDCAPTION(“Original Amount”),FALSE,’’,TRUE,FALSE,TRUE,’’);
Excel Data
ExcelBuf.AddColumn(Customer.“Phone No.”,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(“Cust. Ledger Entry”.“Salesperson Code”,FALSE,’’,FALSE,FALSE,FALSE,’’);
ExcelBuf.AddColumn(CreditLimitToPrint,FALSE,OverLimitDescription,TRUE,FALSE,FALSE,’#,##0’);
ExcelBuf.AddColumn(“Cust. Ledger Entry”."Original Amount’,FALSE,’’,FALSE,FALSE,FALSE,’’);
Thank in advance for any help I can get.