Sage X3 : STKIS Auto Journal not picking up modification

SOLVED

Hello,

I have added a modification to STKIS auto journal, line 3 to post to a different account based on customer category instead of my regular COGS account.

I have introduced the BPCUSTOMER table under conditions of line 3 of STKIS auto journal.

(func TRTX3FNC.GETLEG([F:STJ]STOFCY)<>"USA" or [F:SDH]BETFCY<>2) or [F:BPC]BPCTYP = "1"

Under the Accounting Codes, I have added my criteria lines, like this :

But, when I post the stock journal after delivery validation, I get unbalanced journal legal error. I ran the sigma test using calculator to see what the error is, and it looks like it is not able to use the criteria in the accounting code lines of the auto journal line to find the account to post to.

I had this working one time and now it does not work. Could you please help me what am I missing?

Parents Reply Children
No Data