Jump to content

Creating Script in Printing Official Receipt


Recommended Posts

  • Newbies

Hello Ma'am/Sir!

Please help me create a script that will print only the filled out field in my Official Receipt layout when I click the Print OR  button.

Here is my client's info in Layout Mode:

Print-OR.jpg

and this is it in Browse Mode

Print-OR1.jpg

What I need is that in OFFICIAL RECEIPT Layout will be like this that the empty fields will not be printed:

Print-OR3.jpg

THANK YOU VERY MUCH in advanced in helping me.

P.S.: I have only little knowledge in scripting.

Link to comment
Share on other sites

I would not put fields on your receipt in this case I would write the following script that sets a global variable. And print that, by using tab stop. 

List (

Case ( not IsEmpty ( sample::FCCT ) ; "Fire Code Construction Tax" & Char (9) & sample::FCCT );
Case ( not IsEmpty ( sample::RealtyTax ) ; "Fire Code Realty Tax" & Char (9) & sample::RealtyTax );
Case ( not IsEmpty ( sample::PremiumTax ) ; "Fire Code Premium Tax" & Char (9) & sample::PremiumTax );
Case ( not IsEmpty ( sample::SalesTax ) ; "Fire Code Sales Tax" & Char (9) & sample::SalesTax );
Case ( not IsEmpty ( sample::ProceedsTax ) ; "Fire Code Proceeds Tax" & Char (9) & sample::ProceedsTax );
Case ( not IsEmpty ( sample::FSIF ) ; "Fire Safety Inspection Fee" & Char (9) & sample::FSIF );
Case ( not IsEmpty ( sample::StorageFee ) ; "Storage Clearance Fee" & Char (9) & sample::StorageFee );
Case ( not IsEmpty ( sample::ConveyanceFee ) ; "Conveyance Clearance Fee" & Char (9) & sample::ConveyanceFee );
Case ( not IsEmpty ( sample::InstallationFee ) ; "Installation Clearance Fee" & Char (9) & sample::InstallationFee );
Case ( not IsEmpty ( sample::AdminFine ) ; "Administrative Fine" & Char (9) & sample::AdminFine );
Case ( not IsEmpty ( sample::OthersFee ) ; "Total Other Fees" & Char (9) & sample::OthersFee )

)

Screen Shot 2021-05-13 at 5.17.07 PM.png

Screen Shot 2021-05-13 at 5.17.51 PM.pngScreen Shot 2021-05-13 at 5.17.33 PM.png

Link to comment
Share on other sites

Consider changing your structure and turning all those taxes and fees into individual payment records in a related table, with fields for Category and Amount. Then create records only for applicable categories and print from the related table in list view.

This will not only solve your printing issue but also allow you to produce a report on payments by category.

 

Link to comment
Share on other sites

  • Newbies

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)

On 5/14/2021 at 8:22 AM, Ocean West said:

I would not put fields on your receipt in this case I would write the following script that sets a global variable. And print that, by using tab stop. 


List (

Case ( not IsEmpty ( sample::FCCT ) ; "Fire Code Construction Tax" & Char (9) & sample::FCCT );
Case ( not IsEmpty ( sample::RealtyTax ) ; "Fire Code Realty Tax" & Char (9) & sample::RealtyTax );
Case ( not IsEmpty ( sample::PremiumTax ) ; "Fire Code Premium Tax" & Char (9) & sample::PremiumTax );
Case ( not IsEmpty ( sample::SalesTax ) ; "Fire Code Sales Tax" & Char (9) & sample::SalesTax );
Case ( not IsEmpty ( sample::ProceedsTax ) ; "Fire Code Proceeds Tax" & Char (9) & sample::ProceedsTax );
Case ( not IsEmpty ( sample::FSIF ) ; "Fire Safety Inspection Fee" & Char (9) & sample::FSIF );
Case ( not IsEmpty ( sample::StorageFee ) ; "Storage Clearance Fee" & Char (9) & sample::StorageFee );
Case ( not IsEmpty ( sample::ConveyanceFee ) ; "Conveyance Clearance Fee" & Char (9) & sample::ConveyanceFee );
Case ( not IsEmpty ( sample::InstallationFee ) ; "Installation Clearance Fee" & Char (9) & sample::InstallationFee );
Case ( not IsEmpty ( sample::AdminFine ) ; "Administrative Fine" & Char (9) & sample::AdminFine );
Case ( not IsEmpty ( sample::OthersFee ) ; "Total Other Fees" & Char (9) & sample::OthersFee )

)

Screen Shot 2021-05-13 at 5.17.07 PM.png

Screen Shot 2021-05-13 at 5.17.51 PM.pngScreen Shot 2021-05-13 at 5.17.33 PM.png

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)

On 5/14/2021 at 1:18 PM, comment said:

Consider changing your structure and turning all those taxes and fees into individual payment records in a related table, with fields for Category and Amount. Then create records only for applicable categories and print from the related table in list view.

This will not only solve your printing issue but also allow you to produce a report on payments by category.

 

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.