Auto Journal Based on Tran Code Not Working via Import

Posted By Denise Hartman over 5 years ago

We create multiple entry transaction codes for the SMO (Misc Issue) object. We have auto-journals to create different GL entries based on the entry type code. We have verified that the auto journal works properly when entering a Misc receipt using the Sage EM Interface screen, but when we use an import template for Misc Issues, and specify the entry transaction code in the import file, it looks like it defaults to use the "ALL" transaction regardless of what entry type we provide, so the auto-journal doesn't work properly. Has anybody else had this experience? Is this a bug in the import template for the SMO object?

0 Girts Mazais over 5 years ago

I don't have experience with a solution as you described - would suggest to check values after import in STOJOU table - my guess - probably some fields are not imported as wished and it causes to mislead in posting.

We are using Stock movement groups (assigned to stock movement transactions as default values) to control postings in auto-journals.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Esfahani over 5 years ago

Hello,

What patch and version is this on?

Regards,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Denise Hartman over 5 years ago in reply to Esfahani

It's V11 patch 4. Just to clarify, we are setting the value of TRSCOD in the import, but it doesn't seem to do the auto-journal associated with that transaction code. It seems to always default to the ALL transaction.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Esfahani over 5 years ago in reply to Denise Hartman

Hello,

Just a simple question, when the import finishes, does [F:SMH]TRSCOD has the right entry transaction you set?

Regards,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Auto Journal Based on Tran Code Not Working via Import

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING