Happy Business Starts Here

Zuora Staff

Why Invoice Item Date Source Export Shows Blank Values on Accounting Period Columns?

Problem Statement: when exporting report via Data Source Invoice Item and clicking Accounting Period (AP) fields, the columns that represents the AP values returns blank values. 

 

 

II blank value.jpg



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Staff

Re: WHY INVOICE ITEM DATA SOURCE EXPORT SHOWS BLANK VALUES ON ACCOUNTING PERIOD COLUMNS?

Solution: there are two things to check to identify why certain Invoice Items are producing blank AP values:

 

a) AP date (start and end) should be < = invoice Posted date. This means, you need to verify if there is an AP created that for the questioned invoice.

 

b) Journal Entry is tied to AP. Rerun the same data source export and this time, tick the Journal Entry object and check the Journal Entry Number. When the file is generated, any invoice item that has Journal Entry Number confirms that this is the expected behavior.

 

JE with AC.jpg

 

Supporting Reference(s):

Journal Entry

Journal Entry Item Data source



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √