• Stock count custom 'Products' formula is misbehaving

    Hi there. I've created a custom Funprog that returns an integer value between 0 and 4, when an item reference is passed into it. The intended use is as a filter for the stock count 'Product' Formula, to only generate a count with items where this Func…
  • Formula Wizard - Positive Pay File

    Hey all, I'm currently attempting to replace commas with spaces in our business partner name "[F:PYH]BPANAM" using the formula wizard, but I'm encountering difficulties with the standard functions provided. If anyone has any suggestions or formulas…
  • Add a condition formula to the table of Crystal Reports in Development > Script Dictionary > Reports to activate/deactivate printing of one or group of Linked report!

    When a Report code attached to Function is a Linked report (a collection of some Crystal reports to be printed at once), it would be highly beneficial to be able to set a condition formula if they need to be printed or not. Re, Victor
  • Add "Formula" field in Payment proposal function for additional user-defined filters!

    Add a formula field in Payment proposal function to help with adding user-defined formulas. For example, run Payment proposal based on Supplier categories, or Supplier Stat group 1 to 5, etc. Re, Victor
  • Account (or Dimension) pyramid auto generation - to be able to filter inactive accounts or have a formula field for other user-defined criteria to include/exclude Accounts (or Dimension for Dimension pyramid)!

    When creating a chart of accounts, our client have some GL accounts which are inactive (not usable, for information or classification only) and every time client wants to update their Account pyramid to include new GL accounts, they have to go through…
  • Fixing "Division by zero error" in Graphical requester calculation fields!

    Hi Team, This is a suggestion to add a feature in Graphical requester creation where user adds a Calculation filed (like Margin = Price/Cost) and for some instances when the Cost is zero in this example, they get the famous error "Division by 0" error…