Browse By Tags

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…

Is there any place to look at sample formulas? It seems you have to be a programmer to create a report.

Is there somewhere that I can find details on the formulas used by sage to calculate deprecation? We are moving from Lawson Fixed Assets to Sage Fixed Assets and our calculations are not coming out correctly. Thanks

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…

Bom Dia, Temos um sistema de pontos que é baseado na quantidade que é gasto pelo cliente nas lojas no anto anterior. passo a explicar, O cliente para ter direito a pontos tem que ter comprado pelo menos 250€ em artigos no ano anterior, se assim…

Hi All, I was wondering if it is possible to build a value by combining a charachter and variable. We have site codes for each rep, and I have built a report but instead of duplicating it for each reps site code I just want to use the below formaula,…

How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…

Hey All, I am customizing our Bill of Lading (Picking Ticket) so that it will calculate and print the Net and Gross weight of each item on the ticket. I have just about everything worked out. Where I'm stuck is when there is an item that is repeated…

Hi, I am trying to export my sage spreadsheet to excel with the stipulation that all relevant cells populate with the spreadsheet formula as it is set up in the sage spreadsheet (i.e. an item's total amount contains a formula that is the sum of all…

We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…

Hola. Tenemos Sage200c y usamos un campo calculado para que en la factura salga la cuenta del cliente (cuando la forma de pago es "recibo domiciliado") o nuestra cuenta propia (cuando la forma de pago es es transferencia previa). La fórmula del campo…

Trying to do a simple formula combining the PR Employee last name with the suffix. Both fields are PII fields. When I run the report data formula only works if employee has a suffix so I had to place the last name field in the report and then cover it…

We are trying to use sales order to manage our laybys in store Is there a way/formula we can use that will do the following : Subtotal - Balance = Total outstanding So basically it would take the Sales Order total subtract the total receipt of the…

A V11 chegou e com ela uma serie de novidades e também uma serie de "trejeitos" Uma das mudanças e referente a formulas, sejam elas na VTAX ou Sugestões do sistema e que agora não é necessário aspas ou espaços. Ou seja na Tela de sugestão de CFOP…

I know there's a way to do this, but nothing I've tried is working. Trying to make a formula to calculate/post work comp expense/liability with payroll that is run each week. In TN, 1/3 of overtime is exempt; and consider in this example that the…

I am trying to add a Barcode to our Pick Tickets, we are on MAS v 4.5. we have a Formula Field that is called BarcodePrice the formula is: formula = BarcodeC128B(ToText({SO_PickingSheetWrk.UnitPrice})) but when i add the field to my report i get…

Hello, After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'. I want to know how can I get to know…

Hi, we have 1 employee that we would like to simply deduct $2.00 for each hour s(he) works. This is her way to reimburse us for a small portion of her benefits. We need this to print on her paystub and I assume we will print this to box 12 or box 14 of…

I called Sage support, but got nowhere, as my request was deemed "too complex" by the "subject matter expert". Note to Sage, if you're going to charge people for support, at least train your support reps on using Functions. Can anyone tell how to create…