How to change post status at Cash Sales Listing report?

Created by Ariel Hoong, Modified on Fri, 1 Aug at 11:35 AM by QNE Software Sdn bhd

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