At cash sales listing report how to change post to AR False/True to No/Yes

Created by Ariel Hoong, Modified on Thu, 21 Sep, 2023 at 4:16 PM by Ariel Hoong

Scenario: 

At Cash Sales Listing report how to change POST TO AR:False / True to No / Yes?


Solution:

How to access Report Designer:

https://support.qne.com.my/support/solutions/articles/81000390974-how-to-access-report-designer 



1) Go to report designer > at left hand side (Field List) search for Cash Sales Details Collection > right click > Add Calculated Field 


2) After click will show new calculatedField1 > right click on it > Edit Expression > Copy and Paste below script in the box > click OK


Iif([Post To AR]= 1,'YES' ,'NO' )



3) Drag the column to correct place



4) After done click save


Notes:

If you wish to save as a new format without overwrite the existing format, you may click on Save As button to save as a new format



Result:




** Learn more about Azure Cloud

** Learn more about  QNE Hybrid Cloud Software 


Refer attachment for details   

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article