Jump to content

Recommended Posts

Posted (edited)

Hi All, I am attempting to duplicate a Journal Entry that posts to a UD Book from a Dynamic Allocation via a SmartEvent in Sage Intacct.

Each time an entry posts to my UD Journal "FCJ" via the Dynamic Allocation, I would like the SmartEvent to replicate the exact same entry into the Accrual Books to an Accrual Journal "FC".

I attempted to do so with the following object, conditions, and code.  But the entries that came back from the SmartEvent were:

  1. For each individual line (1 DR, 1 CR)
  2. Only looked at the CR side of the DA, and thus duplicated the amounts incorrectly.

Would you have any suggestions?  Any help would be most appreciated.  Thank you!

Owner object:  GL entry

 

  

ActionAPI
EventsAdd
Condition
{!GLENTRY.GLBATCH.JOURNAL!} == 'FCJ'&& {!GLENTRY.TR_TYPE!} === '-1'  

API BODY

<create> <GLBATCH> 
<JOURNAL>FC</JOURNAL> 
<BATCH_DATE> {!GLENTRY.GLBATCH.BATCH_DATE!}</BATCH_DATE> 
<BATCH_TITLE>Test Journal Entry</BATCH_TITLE> 
<ENTRIES> 
<GLENTRY> 
    <ACCOUNTNO>ZFCE</ACCOUNTNO> 
    <TR_TYPE>1</TR_TYPE> 
    <AMOUNT>{!GLENTRY.AMOUNT!}</AMOUNT> 
    <description>{!GLENTRY.DESCRIPTION!}</description> 
     <location>{!GLENTRY.LOCATION!}</location>

     <department>{!GLENTRY.DEPARTMENT!}</department>

      <projectid>{!GLENTRY.PROJECTID!}</projectid>

       <classid>{!GLENTRY.CLASSID!}</classid> 
</GLENTRY> 
<GLENTRY>

      <ACCOUNTNO>ZFCA</ACCOUNTNO> 
       <TR_TYPE>-1</TR_TYPE> 
       <AMOUNT>{!GLENTRY.AMOUNT!}</AMOUNT> 
        <description>{!GLENTRY.DESCRIPTION!}</description> 
         <location>{!GLENTRY.LOCATION!}</location>

          <department>{!GLENTRY.DEPARTMENT!}</department>

          <projectid>{!GLENTRY.PROJECTID!}</projectid>

           <classid>{!GLENTRY.CLASSID!}</classid> 
</GLENTRY> 
</ENTRIES> 
</GLBATCH> 
</create>

 

Edited by Roshan Darji
  • Roshan Darji changed the title to Duplicate a Journal Entry that posts to a UD Book from a Dynamic Allocation in Sage Intacct
×
×
  • Create New...