HELP NEEDED - PLEASE CORRECT MY CODES FOR PO NO IN OUTSTANDING REPORT PRINT

Dear ,

help needed - please correct my codes for po no & po dt. in outstanding report - payment reminder , my codes is not fetching po date & also title po dt. is shown twice in title. so please correct my codes

Code:

[#Line: BILLWithDates]
[#Field: BILLFixed]
Add :    Fields : After :  BILLRef : BillLPONo
    [Field : BillLPONo]
    use : namefield
    Width:16
    Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:PolyfabSales
    My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
 
[System: Formula]
    Polyfab Sales  : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName
 
[#Line: BILLCol1]
Local:Field:BillLPONo:Setas:"Po No."
[#Line: BILLCol2]
Local:Field:BillLPONo:Setas:""

[#Field: BILLFixed]
Add : Fields: After: BillLPONO : BILLPODT

[Field : BillPODT]
use : namefield
Width: 12
Set as : $$FilterValue:$BasicPurchaseOrderDT:LedgerEntries:First:PolyfabSales1
My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderDT

[System: Formula]
    Polyfab Sales1  : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName

[#Line: BILLCol1]
Local:Field:BillPODT:Setas:"Po Dt."

[#Line: BILLCol2]
Local:Field:BillLPOdt:Setas:""


[#Object:Voucher]

 

Please check this


[#Field: BILLFixed]
Add : Fields : After : BILLRef : BillLPONo,BillPODT
[Field : BillLPONo]
use : namefield
Width:16
Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:FirstolyfabSales
My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo

[System: Formula]
Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName

[#Line: BILLCol1]
Local:Field:BillPODT:Setas:""
Local:Field:BillLPONo:Setas:"Po No."
[#Line: BILLCol2]
Local:Field:BillLPONo:Setas:""
Local:Field:BillPODT:Setas:"PO DT"



[Field : BillPODT]
use : namefield
Width: 12
Set as : $$FilterValue:$BasicPurchaseOrderDT:LedgerEntries:FirstolyfabSales1
My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderDT

[System: Formula]
Polyfab Sales1 : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName



[#Object:Voucher]

 

sir,

not working . still po date is not fetching

 

Dear ,

help needed - please correct my codes for po dt. in outstanding report - payment reminder , my codes is not fetching po date , so please correct my codes

Code:

[#Line: BILLWithDates]
[#Field: BILLFixed]
Add :    Fields : After :  BILLRef : BillLPONo
    [Field : BillLPONo]
    use : namefield
    Width:20
    Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:PolyfabSales
    My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
 
[System: Formula]
    Polyfab Sales  : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName
 
[#Line: BILLCol1]
Local:Field:BillLPONo:Setas:"Order"
[#Line: BILLCol2]
Local:Field:BillLPONo:Setas:"No."

[#Field: BILLFixed]
Add : Fields: After: BillLPONO : BILLPODT

[Field : BillPODT]
use : namefield
Width: 12
Set as : if $$IsSysName:$BasicPurchaseOrderNo then "" else $$FullList:InvoiceOrderList:@@BasicOrderDateUniversal

[#Line: BILLCol1]
Local:Field:BillPOdt:Setas:"Order"

[#Line: BILLCol2]
Local:Field:BillPOdt:Setas:"Dt."

 

Order Date Syntax is the problem.....

Correct one is BasicOrderDate not BasicPurchaseOrderDT

Code:

[Field : BillPODT]
use : namefield
Width: 12
Set as : $$FilterValue:$BasicOrderDate:LedgerEntries:First:PolyfabSales1
My Value:$$FullList:InvoiceOrderList:$BasicOrderDate

 

thankyou sanjeev sir

 

No more than one po and date is visible.

 

No more than one po and date is visible.

 

No more than one po and date is visible.