This integration is responsible for taking Zuora Revenue Journal Entries and creating Netsuite Journal Entries. This occurs monthly at the end of the month. The integration groups and summarises journal lines into Journal Entries whereby each Entity has
n JEs depending on the grouping of the fields
GL Account Number and
Product Rate Plan Charge. Each resulting entry is summarised by summing the credit lines and separately summing the debit lines.
There are issues with rounding differences and decimal place expectations between systems so we had to solve that via the solution outlined in this issue.
When validation errors occur on the incoming data from Zuora revenue we will post to
#alerts_revenue-accounting-integration slack channel which is monitored by the Accounting Team.
When errors occur with issues downstream in Netsuite we will post to the
#finsys-integrations slack channel which is monitored by the Finance Systems Administration team.
Each journal entry has many lines
|Zuora Revenue Field||Netsuite Field||Canonical Field|
|id||Source System Reference||Batch ID|
|reference9||postingperiod||Accounting Period Name|
|segment1||Line > Account||GL Account Number|
|N/A*||Line > Department||Department|
|accounted_dr||Line > Debit Amount||Accounted Debit|
|accounted_cr||Line > Credit Amount||Accounted Credit|
|reference8||Line > Class||Classification|
|N/A†||Line > Memo||Line Memo|
* Department is calculated from the GL Account Number (relevant code)
† This is always set to
This integration handles and stores Orange Data (Accounting data)
|Development||Sandbox 1||Local Dev & Review Apps||Development||Sandbox 1|