• Any Easy way to exclude weekend from date calculation in 4GL?

    Is there any easy way to exclude the weekend from my date calculations in X3? For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…
  • How import assembly doc?

    Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…
  • Field error "Reversal date" Change of fiscal year prohibited

    Good Morning, We are getting an error message when we try to set the reversal date to 01/01/2021. (The accounting date is 12/31/2020). This is only happening to some of our journal entries. Would anybody be able to tell me why this error message…
  • How can i hide a row of a table in sage x3?

    Hello, I have to hide a row of a table. I have tried with: CHGFMT [M:YYY]NBLIG(nolign-1) WITH "-K:10", but this action hides the entire table I have tried whit: CHGFMT [M:YYY]FIELD1(nolign-1) WITH "-K:10" : CHGFMT [M:YYY]FIELD2(nolign-1) WITH "…
  • How to Post Purchase Invoice via Code

    Hi, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…
  • Sage 4gl command that reads weekdays only

    Has anybody found a way to do calculations for a date that will only take into account weekdays, and ignore the weekends via 4gl?
  • Post AP / AR invoices from Code

    Hi, We need to post invoices from code after having imported the invoice via importsil function. I see that the normal functions use the BISVAL & BICVAL but these scripts are closed source. Thanks Duane
  • How to get Batch task attached to a script to WORK in X3?

    Hi There, Would anyone help me? I am trying to run a simple batch task to generate a log file, but i can't get it to work. It seems to be executing ,but no trace file is generated. This code work fine on the script editor, but doesn't work when i…