Cannot send journal to Sage 50 US via SDK importer

Posted By seanzcan over 8 years ago

I am trying to use the SDK (COM) to transfer a journal entry to Sage 50 (Peactree) but cannot make it work. I can see the import status screen flash out and there is no error occurs during the import; but nothing appears in the sage 50 journal entry report. I have manually created a same journal entry within sage 50 and export it out to compare the differences. The only difference I can see is the transaction period, but even if I changed mine to be the same 35 as the exported version, it still does not work.

this is my version of XML:

<PAW_GLJournal_Entries xmlns:paw="urn:schemas-peachtree-com/paw8.02-datatypes" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2000/10/XMLSchema-datatypes">

<PAW_GLJournal_Entry xsi:type="paw:gljournal_entry">

<Date xsi:type="paw:date">05/13/2015</Date>
<Reference>099-1084</Reference>
<Number_of_Distributions>5</Number_of_Distributions>
<Transaction_Period>19</Transaction_Period>
<Consolidation_Entry>FALSE</Consolidation_Entry>
<Recur_Number>0</Recur_Number>
<Recur_Frequency>0</Recur_Frequency>
<Transactions>
<Transaction>
<GL_Account xsi:type="paw:id">1030</GL_Account>
<GL_Account_GUID>{CC2FE715-4724-44E6-A232-BF8AAAC5384D}</GL_Account_GUID>
<Description>Cash</Description>
<Amount>45.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">2310</GL_Account>
<GL_Account_GUID>{E94EB81B-827E-496A-80AB-34E557FDF8DB}</GL_Account_GUID>
<Description>VAT Charged on Sales</Description>
<Amount>-7.50</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">4500</GL_Account>
<GL_Account_GUID>{B977C64A-C6B9-4E55-A7F5-A93FD0887B98}</GL_Account_GUID>
<Description>Sales: 099-1084</Description>
<Amount>-37.50</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">1212</GL_Account>
<GL_Account_GUID>{1E8D3803-2482-4D23-B07E-BFED9802E91C}</GL_Account_GUID>
<Description>099-1084</Description>
<Amount>-18.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">5402</GL_Account>
<GL_Account_GUID>{676A063A-9FDF-47AF-A657-B0932C5A2C3C}</GL_Account_GUID>
<Description>ACE C/O 099-1084</Description>
<Amount>18.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
</Transactions>

</PAW_GLJournal_Entry>

</PAW_GLJournal_Entries>

Below is the exported xml from the manual journal inside Sage 50:

<PAW_GLJournal_Entries xmlns:paw="urn:schemas-peachtree-com/paw8.02-datatypes" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2000/10/XMLSchema-datatypes">

<PAW_GLJournal_Entry xsi:type="paw:gljournal_entry">

<Date xsi:type="paw:date">5/13/15</Date>
<Reference>099-1084B</Reference>
<Number_of_Distributions>5</Number_of_Distributions>
<Transaction_Period>35</Transaction_Period>
<Transaction_Number>1</Transaction_Number>
<GUID>{9FEBEDBF-DF70-4EF6-9D23-DAF60FD6B538}</GUID>
<Consolidation_Entry>FALSE</Consolidation_Entry>
<Recur_Number>0</Recur_Number>
<Recur_Frequency>0</Recur_Frequency>
<Transactions>
<Transaction>
<GL_Account xsi:type="paw:id">1030</GL_Account>
<GL_AccountGUID>{CC2FE715-4724-44E6-A232-BF8AAAC5384D}</GL_AccountGUID>
<Description>Cash</Description>
<Amount>45.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">2310</GL_Account>
<GL_AccountGUID>{E94EB81B-827E-496A-80AB-34E557FDF8DB}</GL_AccountGUID>
<Description>VAT Charged on Sales</Description>
<Amount>-7.50</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">4500</GL_Account>
<GL_AccountGUID>{B977C64A-C6B9-4E55-A7F5-A93FD0887B98}</GL_AccountGUID>
<Description>Sales: 099-1084</Description>
<Amount>-37.50</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">1212</GL_Account>
<GL_AccountGUID>{1E8D3803-2482-4D23-B07E-BFED9802E91C}</GL_AccountGUID>
<Description>099-1084</Description>
<Amount>-18.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
<Transaction>
<GL_Account xsi:type="paw:id">5402</GL_Account>
<GL_AccountGUID>{676A063A-9FDF-47AF-A657-B0932C5A2C3C}</GL_AccountGUID>
<Description>ACE C/O 099-1084</Description>
<Amount>18.00</Amount>
<Used_for_Reimbursable_Expenses>FALSE</Used_for_Reimbursable_Expenses>
</Transaction>
</Transactions>

</PAW_GLJournal_Entry>

</PAW_GLJournal_Entries>

The accounting periods in Sage 50 are like this:

01 - Nov 1, 2013 to Nov 30, 2013
02 - Dec 1, 2013 to Dec 31, 2013
...
19 - May 01, 2015 to May 31, 2015 (this is the current accounting period)
...
24 - Oct 01, 2015 to Oct 31, 2015

The Sage 50 version is here:

Release: Sage 50 Accountant Edition 2015
Build: 22.2.00.0196
Serial Number: C2E7A-E85D-CA71-343C
Customer ID: 4000312912
Installed Tax Service: 20140201
Plan Level: None

Other transactions like purchase and sales receipts are imported fine.

Can someone please give me some advice why it does not work? Also why is the exported version showing the 35 as transaction period? When I call the function GetAccountingPeriods(PeriodsPerYear, CurrentPeriod, FromDate, ToDate), trying to get the current accounting period, the returned value in CurrentPeriod is 35. Yet inside the Sage 50 the current period is 19 (for May, as shown above). Can someone explain why the current period is 35? For purchase or sales receipts, I was using 19 as the transaction period and the import works, I can find the entries imported in Sage and everything looks fine for me.

Any suggestions appreciated,

Sage 50 US

Cannot send journal to Sage 50 US via SDK importer

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING