cancel
Showing results for 
Search instead for 
Did you mean: 

Invoices data in Inventory Reports

Former Member
0 Kudos

Hi Experts,

I need ur help in Inventory Reports.

I am not able to see all AR and AP invoices in all inventory reports like Inventory Postign list and Inventory Audit report.

Is there any settiing in administration module for the same.

I have two databse in my server and My other database is showing proper report with AR and AP Invoices.

Pls. help me out from this

regards

Kamlesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kamlesh,

You may need to check all configuration details between two db to find the differences. Pick any examples to find the root cause of the problem.

Thanks,

Gordon

Answers (2)

Answers (2)

Former Member
0 Kudos

For the inventory posting list - check the "Expanded" button - sometimes there was a previous setting that restricted which documents would be shown, and the setting is retained in the system. Be sure nothing is checked on this screen.

For the inventory audit report - check the button next to "GL Accounts" - again, restrictive settings might have been left over from a previous session.

Marcia

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Check the dates of the AR and AP Invoice.

As if you right click on the Item Master Data and see the Inventory Posting List it only shows for current fiscal year and not all.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hi Jitin

Thanx for the reply,

I tried but still not getting the same.

Regards

Kamlesh

Former Member
0 Kudos

Hi!

Click Expand Button on the Report and Select Clear Selection

Now try to run the report.

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Check the Inventory Reports if the same is appearing or not.

Also, check whether the AR and Ap Invoices which are not appearing are created for Inventory items or not

And check whether the Invoices are service type or item type.

Kind Regards,

Jitin

SAP Business One Forum Team