Dear All, I had done customization for the Purchase Transaction Print in Voucher Format. I am not getting the Bill Date & Due Date of Supplier. Kindly check & guide. [#Part: PDCN Title] Delete : Lines : PDCN Ref Add : Lines : PPR BillDetail [Line: PPR BillDetail] Fields : PPR InvNumber, Fields : Simple Prompt, PPR BillDt Right Fields: Short Prompt, PPR BillDueDt Local : Field : Simple Prompt : Info : $$LocaleString:"Bill Date :" Local : Field : Simple Prompt : Width : 7 Local : Field : Simple Prompt : PrePrinted: Yes Local : Field : PPR BillDt : Set as : $PartyInvDate Local : Field : Short Prompt : Info : $$LocaleString:"Due Date :" Local : Field : Short Prompt : Width : 7 Local : Field : Short Prompt : PrePrinted: Yes Local : Field : PPR BillDueDt : Set as : $BillCreditPeriod SpaceBottom : 0.03 inch SpaceTop : 0.03 inch [Field: PPR InvNumber] Use : Short Name Field Set as : "Bill No" + ".:" + " " + $Reference Inactive : $$IsEmpty:$Reference OR NOT @@Reference Width : 30 [Field: PPR BillDt] Use : Short Date Field Set as : $PartyInvDate ;; Width : if NOT $$InPixelMode then 15 else 7 Width : 15 [Field: PPR BillDueDt] Use : Due Date Field Set as : $BillCreditPeriod:Ledger:$LedgerName Width : @@VCHSmallNameWidth ;; Width : 15
For Bill Date : $Date For Supplier Date : $referencedate [#Part: PDCN Title] Delete : Lines : PDCN Ref Add : Lines : PPR BillDetail [Line: PPR BillDetail] Fields : PPR InvNumber, Fields : Simple Prompt, PPR BillDt Right Fields: Short Prompt, PPR BillDueDt Local : Field : Simple Prompt : Info : $$LocaleString:"Bill Date :" Local : Field : Simple Prompt : Width : 7 Local : Field : Simple Prompt : PrePrinted: Yes Local : Field : PPR BillDt : Set as : $Date Local : Field : Short Prompt : Info : $$LocaleString:"Due Date :" Local : Field : Short Prompt : Width : 7 Local : Field : Short Prompt : PrePrinted: Yes Local : Field : PPR BillDueDt : Set as : $referencedate SpaceBottom : 0.03 inch SpaceTop : 0.03 inch
Dear All, I think it is not coming because of Multiple Reference. Suppose in Billwise Details if more than One Reference & Due Date is given then which date it should fetch ?? So need just a logic that how to fetch the Due Date of the Reference Number given in the Billwise details.
[#Part: PDCN Title] Delete : Lines : PDCN Ref Add : Lines : PPR BillDetail [Line: PPR BillDetail] Fields : PPR InvNumber, Fields : Simple Prompt, PPR BillDt Right Fields: Short Prompt, PPR BillDueDt Local : Field : Simple Prompt : Info : $$LocaleString:"Bill Date :" Local : Field : Simple Prompt : Width : 7 Local : Field : Simple Prompt : PrePrinted: Yes Local : Field : PPR BillDt : Set as : $Date Local : Field : Short Prompt : Info : $$LocaleString:"Due Date :" Local : Field : Short Prompt : Width : 7 Local : Field : Short Prompt : PrePrinted: Yes Local:FieldPR BillDueDt:Set as:$BillCreditPeriod:Ledger:$LedgerName SpaceBottom : 0.03 inch SpaceTop : 0.03 inch [Field: PPR InvNumber] Use : Short Name Field Set as : "Bill No" + ".:" + " " + $Reference Inactive : $$IsEmpty:$Reference OR NOT @@Reference Width : 30 [Field: PPR BillDt] Use : uni Date Field Set as : $PartyInvDate ;Width : if NOT $$InPixelMode then 15 else 7 Width : 8 [Field: PPR BillDueDt] Use: Short Name Field Set as: $BillCreditPeriod:Ledger:$LedgerName Inactive : No Set Always:Yes Width: 6 [#Field: LEDCreditStr] Use : Short Name Field Storage : BillCreditPeriod Set as: #LEDCreditPer Setalways: Yes Invisible: Yes
Finally Mr. Joharfill solved my query and am Thanking him So So much for the help. The solution is :- $$String$LedgerEntries.LedgerEntries.BillAllocations.BillCreditPeriod):UniversalDate
How to Take Billedqty value in Outstanding report entory item entry I am able to take single inventory BilledQty using this code. I want total qty for the Bill I hv tried in Bills outstanding Report $Ledgerentries.Inventoryentries[1].BilledQty