Browse By Tags

I need to do a Mass Update to one specific benefit. I need to update the expiration date from Jan 1, 2024 to December 31, 2024. The benefit plan code is DENTAL. We have updated the actual plan but need to update all employees that are assigned to the…

I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…

Hi all, I've been trying to create a simple SumIf expression, which references an expression earlier in the report that I've created to add a small value of 0.50 to invoiced items that come in at 0 value. Here's the referenced expression: SOPInvoiceCreditLines…

Hi, I am trying to set up an expression for a layout whereby if field 1 on the report contains an order number then field 2 should be blank and if field 1 contains no information then field 2 should populate. Field 1 gets it information from SALES_ORDER…

Hello, I need a report for Customs now that we have left the EU within Sage 50 Accounts I need to add the weights per commodity codes imported to a Purchase order. I have an individual weight of a qty line shown shown as POP_ITEM.QTY_ORDER*STOCK.UNIT_WEIGHT…

I am new to complex expression and functions My client has attendance plans that employees are eligible for based on belonging to a certain group (I have used Pe.p_level3 to identify the 2 groups) PLUS Either years of service >= X or salary range…