Custom Layaway Report

hi Amy, here is the code: Begin Column FieldName = "Balance" DrillDownFieldName = "" DrillDownReportName = "" Title = "Balance" VBDataType = vbCurrency Formula = " [Order].Total - TenderEntry.Amount" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1110 GroupMethod = groupmethodSum ColFormat = "" End Column

But the above code better to make > I have download the custom layaway payment report. I feel like it is missing

this code didn't work. the layaway balance didn't add up correctly. I took the layaway summary report and added at the end the following: Begin Column FieldName = "[Order].Deposit" DrillDownFieldName = "" DrillDownReportName = "" Title = "Balance" VBDataType = vbCurrency Formula = " [Order].Total - [Order].Deposit" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1056 GroupMethod = groupmethodSum ColFormat = "" End Column

thanks

"Akber Alwani" wrote:

hi Amy, Please apply this

Begin Column FieldName = "[Order].Total" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Layaway Total" VBDataType = vbCurrency Formula = "[Order].Total" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1605 GroupMethod = groupmethodSum ColFormat = "" End Column

Begin Column FieldName = "Balance" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Balance" VBDataType = vbCurrency Formula = "[Order].Total - TenderEntry.Amount" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1605 GroupMethod = groupmethodSum ColFormat = "" End Column

"Amy" wrote:

Hi Amy, I'm looking for something similar- some sort of layaway report that includes the balance remaining. I'm not having any luck with either of the scripts that yourself and Akber have provided. Did you get anything to work? I've tried adding to Detailed and Summary Layaway reports. Haven't tried the custom Layaway Payments report yet. I'd appreciate your advice.

Thanks

"Amy" wrote:

Hi Tara, did you have any luck makng it work?

Thanks -- Fabien

"Tara" wrote:

Amy, what version do you use?

--fabien

"Amy" wrote: